o ht @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 )models)BaseSpatialOperations)SpatiaLiteAdapter)SpatialOperator) GEOSGeometryGEOSGeometryBase)wkb_r)Distance)ImproperlyConfigured)DatabaseOperations)cached_property)get_version_tuplecseZdZfddZZS)SpatialiteNullCheckOperatorcs"t||||\}}d||fS)Nz%s > 0)superas_sql)self connectionlookuptemplate_params sql_paramssqlparams __class__f/var/www/html/env/lib/python3.10/site-packages/django/contrib/gis/db/backends/spatialite/operations.pyrs z"SpatialiteNullCheckOperator.as_sql)__name__ __module__ __qualname__r __classcell__rrrrrsrc @seZdZdZdZeZdZdZdZ dZ dZ ide d d d e d d d e dd de dd de dd de dd de dd de dd de dd de dd de dd de d d d!e d"d d#e d$d d%e d d d&e d d d'e d(d ZejfZd)Zd*d+d,d-d.d/d0d1d2d3 Zed4d5Zed6d7Zd8d9Zd:d;Zdd?Zd@dAZdBdCZdDdEZdFdGZdHdIZdJdKZ dLdMZ!dNdOZ"dPdQZ#dRdSZ$dTdUZ%dVS)WSpatiaLiteOperations spatialiteTCollectExtentMakeLineGUnion GeomFromTextequalsEquals)funcdisjointDisjointtouchesTouchescrossesCrosseswithinWithinoverlapsOverlapscontainsContains intersects IntersectsrelateRelate coveredby CoveredBycoversCovers contained MbrWithin bbcontains MbrContains bboverlaps MbrOverlapssame_asexactdwithin PtDistWithinzCAST (AsEWKB(%s) AS BLOB) St_AsBinary ST_ForceLHR ST_LengthST_Line_Locate_Point ST_NPoints ST_Reverse ScaleCoords ST_TranslateST_Union) AsWKBForcePolygonCWLengthLineLocatePoint NumPointsReverseScale TranslateUnioncCs hd}|s|hdO}|S)N>MemSizeBoundingCircleGeometryDistance>AzimuthGeoHash MakeValid)geom_lib_version)r unsupportedrrrunsupported_functionsOs z*SpatiaLiteOperations.unsupported_functionsc CsZz |dd}Wnty"}z td|jjdf|d}~ww|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)rz.GeoDjango supports SpatiaLite 4.3.0 and above.)spatialite_version_tuple Exceptionr r settings_dict)rversionexcrrrspatial_versionVs z$SpatiaLiteOperations.spatial_versioncCsJ|durdSt|j}|ddd\}}|ddd\}}||||fS)zV Convert the polygon data received from SpatiaLite to min/max values. Nr)rshell)rboxrnxminyminxmaxymaxrrrconvert_extentes   z#SpatiaLiteOperations.convert_extentcCsdS)z Return None because geometry columns are added via the `AddGeometryColumn` stored procedure on SpatiaLite. Nr)rfrrr geo_db_typepsz SpatiaLiteOperations.geo_db_typecCsj|sgS|d}t|tr0||jr!|dkrtd|j}|gSt|t||j}|gS|}|gS)zu Return the distance parameters for the given geometry field, lookup value, and lookup type. rrFzNOnly numeric values of degree units are allowed on geographic DWithin queries.) isinstancer geodeticr ValueErrormgetattr unit_attname units_name)rruvalue lookup_type dist_paramrrr get_distancews"  z!SpatiaLiteOperations.get_distancecCs>|j}z|d||}W||dS|w)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 %sr)r_cursorexecutefetchoneclose)rr)cursorrowrrr_get_spatialite_funcs   z)SpatiaLiteOperations._get_spatialite_funccC |dS)z:Return the version of GEOS used by SpatiaLite as a string.zgeos_version()rrrrr geos_version z!SpatiaLiteOperations.geos_versioncCr)z:Return the version of the PROJ library used by SpatiaLite.zproj4_version()rrrrr proj_versionrz!SpatiaLiteOperations.proj_versioncCr)z8Return the version of LWGEOM library used by SpatiaLite.zlwgeom_version()rrrrrlwgeom_versionrz#SpatiaLiteOperations.lwgeom_versioncCr)z8Return the version of RTTOPO library used by SpatiaLite.zrttopo_version()rrrrrrttopo_versionrz#SpatiaLiteOperations.rttopo_versioncCs|jdkr |S|S)zf Return the version of the version-dependant geom library used by SpatiaLite. ))rlrrrrrrr`s z%SpatiaLiteOperations.geom_lib_versioncCr)z2Return the SpatiaLite library version as a string.zspatialite_version()rrrrrspatialite_versionrz'SpatiaLiteOperations.spatialite_versioncCs|}|ft|S)zl Return the SpatiaLite version as a tuple (version string, major, minor, subminor). )rr )rrjrrrrgsz-SpatiaLiteOperations.spatialite_version_tuplecCs"|dkrdn|}t||S)zr Return the spatial aggregate SQL template and function for the given Aggregate instance. unionunionagg)lowerr{)ragg_namerrrspatial_aggregate_names z+SpatiaLiteOperations.spatial_aggregate_namecCddlm}|S)Nr)SpatialiteGeometryColumns)0django.contrib.gis.db.backends.spatialite.modelsr)rrrrrgeometry_columns z%SpatiaLiteOperations.geometry_columnscCr)Nr)SpatialiteSpatialRefSys)rr)rrrrrspatial_ref_sysrz$SpatiaLiteOperations.spatial_ref_syscs"|jjtjfdd}|S)Ncs|durdSt|S)N)r)r~ expressionr geom_classreadrr convertersz>SpatiaLiteOperations.get_geometry_converter..converter) output_fieldrrr)rrrrrrget_geometry_convertersz+SpatiaLiteOperations.get_geometry_converterN)&rrrnamer!rAdaptercollectextentmakeliner from_textrr gis_operatorsrExtent3Ddisallowed_aggregatesselectfunction_namesr rbrlrtrvrrrrrrr`rrgrrrrrrrrr s                       r N)__doc__django.contrib.gis.dbr.django.contrib.gis.db.backends.base.operationsr1django.contrib.gis.db.backends.spatialite.adapterr$django.contrib.gis.db.backends.utilsr django.contrib.gis.geos.geometryrr%django.contrib.gis.geos.prototypes.iordjango.contrib.gis.measurer django.core.exceptionsr %django.db.backends.sqlite3.operationsr django.utils.functionalr django.utils.versionr rr rrrrs