v^m@sdZddlmZddlmZddlmZddlmZddl m Z m Z ddl m Z ddlmZdd lmZdd lmZdd lmZdd lmZGd ddeZGdddeeZdS)z\ SQL functions reference lists: https://www.gaia-gis.it/gaia-sins/spatialite-sql-4.3.0.html )BaseSpatialOperations)SpatiaLiteAdapter)SpatialOperator) aggregates) GEOSGeometryGEOSGeometryBase)wkb_r)Distance)ImproperlyConfigured)DatabaseOperations)cached_property)get_version_tuplecs"eZdZfddZS)SpatialiteNullCheckOperatorcs/tj||||\}}d||fS)Nz%s > 0)superas_sql)self connectionlookupZtemplate_paramsZ sql_paramsZsqlparams) __class__V/tmp/pip-build-8lau8j11/django/django/contrib/gis/db/backends/spatialite/operations.pyrs!z"SpatialiteNullCheckOperator.as_sql)__name__ __module__ __qualname__rrr)rrrs rc$@sMeZdZdZdZeZdZdZdZ dZ dZ de d d d e d d d e d dde d dde d dde d dde d dde d dde d dde d dde d dde d d d!e d d"d#e d d$d%e d d d&e d d d'e d d(iZejfZd)Zd*d+d,d-d.d/d0d1d2d3d4d5d6d7d8d9iZed:d;Zed<d=Zd>d?Zd@dAZdBdCZdDdEZdFdGZdHdIZdJdKZdLdMZdNdOZdPdQZ dRdSZ!dTdUZ"dVdWZ#dXS)YSpatiaLiteOperations spatialiteTZCollectZExtentZMakeLineZGUnionZ GeomFromTextequalsfuncZEqualsZdisjointZDisjointZtouchesZTouchesZcrossesZCrossesZwithinZWithinoverlapsZOverlapscontainsZContainsZ intersectsZ IntersectsZrelateZRelateZ coveredbyZ CoveredByZcoversZCoversZ containedZ MbrWithinZ bbcontainsZ MbrContainsZ bboverlapsZ MbrOverlapsZsame_asexactdwithinZ PtDistWithinzCAST (AsEWKB(%s) AS BLOB)ZForcePolygonCWZ ST_ForceLHRZLengthZ ST_LengthZLineLocatePointZST_Line_Locate_PointZ NumPointsZ ST_NPointsZReverseZ ST_ReverseZScaleZ ScaleCoordsZ TranslateZ ST_TranslateUnionZST_UnioncCs5dddh}|js1|ddddhO}|S)NZBoundingCircleZGeometryDistanceZMemSizeZAzimuthZGeoHashZIsValidZ MakeValid)lwgeom_version)rZ unsupportedrrrunsupported_functionsPs z*SpatiaLiteOperations.unsupported_functionscCs~y|jdd}WnEtk ra}z%td|jjdf|WYdd}~XnX|d krztd|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?NAMErz.GeoDjango supports SpatiaLite 4.3.0 and above.)r(r)r)spatialite_version_tuple Exceptionr rZ settings_dict)rversionexcrrrspatial_versionWs  z$SpatiaLiteOperations.spatial_versioncCsc|dkrdSt|j}|ddd\}}|ddd\}}||||fS)zV Convert the polygon data received from SpatiaLite to min/max values. Nr)rshell)rZboxr0ZxminZyminZxmaxZymaxrrrconvert_extentgs  z#SpatiaLiteOperations.convert_extentcCsdS)z Return None because geometry columns are added via the `AddGeometryColumn` stored procedure on SpatiaLite. Nr)rfrrr geo_db_typersz SpatiaLiteOperations.geo_db_typecCs|s gS|d}t|tr|j|jrY|dkrMtd|j}qt|tj|j|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)rr2valueZ lookup_typeZ dist_paramrrr get_distanceys    'z!SpatiaLiteOperations.get_distancec CsF|jj}z!|jd||j}Wd|jX|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 |jdS)z:Return the version of GEOS used by SpatiaLite as a string.zgeos_version())r>)rrrr geos_versionsz!SpatiaLiteOperations.geos_versioncCs |jdS)z)rrrr proj4_versionsz"SpatiaLiteOperations.proj4_versioncCs |jdS)z8Return the version of LWGEOM library used by SpatiaLite.zlwgeom_version())r>)rrrrr$sz#SpatiaLiteOperations.lwgeom_versioncCs |jdS)z2Return the SpatiaLite library version as a string.zspatialite_version())r>)rrrrspatialite_versionsz'SpatiaLiteOperations.spatialite_versioncCs|j}|ft|S)zl Return the SpatiaLite version as a tuple (version string, major, minor, subminor). )rAr )rr,rrrr*s z-SpatiaLiteOperations.spatialite_version_tuplecCs1|jdkrdn |j}t||S)zr Return the spatial aggregate SQL template and function for the given Aggregate instance. unionunionagg)lowerr7)rZagg_namerrrspatial_aggregate_names$z+SpatiaLiteOperations.spatial_aggregate_namecCsddlm}|S)Nr)SpatialiteGeometryColumns)0django.contrib.gis.db.backends.spatialite.modelsrF)rrFrrrgeometry_columnssz%SpatiaLiteOperations.geometry_columnscCsddlm}|S)Nr)SpatialiteSpatialRefSys)rGrI)rrIrrrspatial_ref_syssz$SpatiaLiteOperations.spatial_ref_syscs1|jjtjfdd}|S)Ncs#|dkrdSt|S)N)r)r8 expressionr) geom_classreadrr convertersz>SpatiaLiteOperations.get_geometry_converter..converter)Z output_fieldrLrrM)rrKrNr)rLrMrget_geometry_converters  z+SpatiaLiteOperations.get_geometry_converterN)$rrrnamerrZAdapterZcollectZextentZmakelinerCZ from_textrrZ gis_operatorsrZExtent3DZdisallowed_aggregatesselectZfunction_namesr r%r.r1r3r9r>r?r@r$rAr*rErHrJrOrrrrrsd             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.iorZdjango.contrib.gis.measurer Zdjango.core.exceptionsr Z%django.db.backends.sqlite3.operationsr Zdjango.utils.functionalr Zdjango.utils.versionr rrrrrrs