B 0H[u @sdZddlmZddlmZddlmZddlmZddl m Z m Z ddl m Z mZddlmZdd lmZdd lmZdd lmZdd lmZGd ddeZGdddeeZdS)z SQL functions reference lists: https://web.archive.org/web/20130407175746/https://www.gaia-gis.it/gaia-sins/spatialite-sql-4.0.0.html https://www.gaia-gis.it/gaia-sins/spatialite-sql-4.2.1.html )BaseSpatialOperations)SpatiaLiteAdapter)SpatialOperator) aggregates) GEOSGeometryGEOSGeometryBase)wkb_rwkt_r)Distance)ImproperlyConfigured)DatabaseOperations)cached_property)get_version_tuplecseZdZfddZZS)SpatialiteNullCheckOperatorcs"t||||\}}d||fS)Nz%s > 0)superas_sql)self connectionlookupZtemplate_paramsZ sql_paramsZsqlparams) __class__xC:\Users\HIRONO~1\AppData\Local\Temp\pip-install-6bm3nxem\django\django\contrib\gis\db\backends\spatialite\operations.pyrsz"SpatialiteNullCheckOperator.as_sql)__name__ __module__ __qualname__r __classcell__rr)rrrsrc@sReZdZdZdZeZdZdZdZ dZ dZ e dd e d d e d d e d d e d d e dd e dd e dd e dd e dd e dd e dd e dd e dd e dd dZejfZeddZdddddddd Zed!d"Zed#d$Zd%d&Zd'd(Zd)d*Zd+d,Zd-d.Zd/d0Zd1d2Zd3d4Zd5d6Zd7d8Z d9d:Z!d;d<Z"d=d>Z#d?S)@SpatiaLiteOperations spatialiteTZCollectZExtentZMakeLineZGUnionZ GeomFromTextZEquals)funcZDisjointZTouchesZCrossesZWithinZOverlapsZContainsZ IntersectsZRelateZ MbrWithinZ MbrContainsZ MbrOverlapsZ PtDistWithin)equalsZdisjointZtouchesZcrossesZwithinoverlapscontainsZ intersectsZrelateZ containedZ bbcontainsZ bboverlapsZsame_asexactdwithincCs|jdkrdSdS)N)rzCAST (AsEWKB(%s) AS BLOB)z AsText(%s))spatial_version)rrrrselectBszSpatiaLiteOperations.selectZ ST_LengthZST_Line_Locate_PointZ ST_NPointsZ ST_ReverseZ ScaleCoordsZ ST_TranslateZST_Union)ZLengthZLineLocatePointZ NumPointsZReverseZScaleZ TranslateUnioncCs&dddh}|s"|ddddhO}|S)NZBoundingCircleZForceRHRZMemSizeZAzimuthZGeoHashZIsValidZ MakeValid)lwgeom_version)rZ unsupportedrrrunsupported_functionsPs z*SpatiaLiteOperations.unsupported_functionsc Csdy|dd}Wn:tk rN}ztd|jjdf|Wdd}~XYnX|dkr`td|S)z0Determine the version of the SpatiaLite library.Nz}Cannot determine the SpatiaLite version for the "%s" database. Was the SpatiaLite initialization SQL loaded on this database?NAME)r%rrz|dkr6td|j}q\t|t||j}n|}|gS)zu Return the distance parameters for the given geometry field, lookup value, and lookup type. rr$zNOnly numeric values of degree units are allowed on geographic DWithin queries.) isinstancer Zgeodeticr ValueErrormgetattrZ unit_attnameZ units_name)rr5valueZ lookup_typeZ dist_paramrrr get_distanceys  z!SpatiaLiteOperations.get_distancecCs8|j}z|d||}Wd|X|dS)z Helper routine for calling SpatiaLite functions and returning their result. Any error occurring in this method should be handled by the caller. z SELECT %sNr)rZ_cursorexecuteZfetchoneclose)rrcursorrowrrr_get_spatialite_funcs    z)SpatiaLiteOperations._get_spatialite_funccCs |dS)z:Return the version of GEOS used by SpatiaLite as a string.zgeos_version())rA)rrrr geos_versionsz!SpatiaLiteOperations.geos_versioncCs |dS)zSpatiaLiteOperations.get_geometry_converter..convertercs(|dk r$t|}r |_|SdS)N)rsrid)r;rNrZgeom)rOrPrSrrrQs )Z output_fieldrOr'rrPr rS)rrNrQr)rOrPrSrget_geometry_converters z+SpatiaLiteOperations.get_geometry_converterN)$rrrnamerrZAdapterZcollectZextentZmakelinerFZ from_textrrZ gis_operatorsrZExtent3DZdisallowed_aggregatesr r(Zfunction_namesr+r'r4r6r<rArBrCr*rDr.rHrKrMrTrrrrrs^     rN)__doc__Z.django.contrib.gis.db.backends.base.operationsrZ1django.contrib.gis.db.backends.spatialite.adapterrZ$django.contrib.gis.db.backends.utilsrZdjango.contrib.gis.db.modelsrZ django.contrib.gis.geos.geometryrrZ%django.contrib.gis.geos.prototypes.iorr Zdjango.contrib.gis.measurer Zdjango.core.exceptionsr Z%django.db.backends.sqlite3.operationsr Zdjango.utils.functionalr Zdjango.utils.versionrrrrrrrs