gH!dZddlmZddlmZddlmZddlmZddl m Z m Z ddl m Z ddlmZdd lmZdd lmZdd lmZdd lmZGd deZGddeeZy)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_tupleceZdZfdZxZS)SpatialiteNullCheckOperatorc<t|||||\}}d|z|fS)Nz%s > 0)superas_sql)self connectionlookuptemplate_params sql_paramssqlparams __class__s /var/www/python.vincentserveurtest.ovh/public_html/venv/lib/python3.12/site-packages/django/contrib/gis/db/backends/spatialite/operations.pyrz"SpatialiteNullCheckOperator.as_sqls*gnZ*U V#~v%%)__name__ __module__ __qualname__r __classcell__)rs@rrrs &&rrc :eZdZdZdZeZdZdZdZ dZ dZ ide d d e d d e d de d de d de d de d de d de d de d de d de d d!e d" d#e d$ d%e d d&e d d'e d( Zej fZd)Zd*d+d,d-d.d/d0d1d2d3d4d5d6 Zed7Zed8Zd9Zd:Zd;Zd<Zd=Zd>Zd?Zd@ZdAZdBZ dCZ!dDZ"dEZ#dFZ$dGZ%yH)ISpatiaLiteOperations spatialiteTCollectExtentMakeLineGUnion GeomFromTextequalsEquals)funcdisjointDisjointtouchesTouchescrossesCrosseswithinWithinoverlapsOverlapscontainsContains intersects IntersectsrelateRelate coveredby CoveredBycoversCovers contained MbrWithin bbcontains MbrContains bboverlaps MbrOverlapssame_asexactdwithin PtDistWithinzCAST (AsEWKB(%s) AS BLOB) St_AsBinaryGEOSMinimumBoundingCircle ST_ForceLHRST_GeomFromWKBST_GeomFromText ST_LengthST_Line_Locate_Point ST_NPoints ST_Reverse ScaleCoords ST_TranslateST_Union) AsWKBBoundingCircleForcePolygonCWFromWKBFromWKTLengthLineLocatePoint NumPointsReverseScale TranslateUnioncfhd}|js|hdz}|jdkr|dhz}|S)N>IsEmptyMemSizeGeometryDistance>AzimuthGeoHash MakeValid)rX)geom_lib_versionspatial_version)r unsupporteds runsupported_functionsz*SpatiaLiteOperations.unsupported_functionsSs@@ $$& > >K   & ( ,- -Krc |jdd}|dkr td|S#t$r,}td|jjdd|d}~wwxYw)z0Determine the version of the SpatiaLite library.rkNz1Cannot determine the SpatiaLite version for the "NAMEzJ" database. Was the SpatiaLite initialization SQL loaded on this database?)rz.GeoDjango supports SpatiaLite 4.3.0 and above.)spatialite_version_tuple Exceptionr r settings_dict)rversionexcs rrmz$SpatiaLiteOperations.spatial_version\st 335ab9G Y &'WX X &??008;   s' A'AAcj|yt|j}|ddd\}}|ddd\}}||||fS)zV Convert the polygon data received from SpatiaLite to min/max values. Nr)rshell)rboxr{xminyminxmaxymaxs rconvert_extentz#SpatiaLiteOperations.convert_extentksQ ;S!''1Xbq\ d1Xbq\ ddD$''rcy)z Return None because geometry columns are added via the `AddGeometryColumn` stored procedure on SpatiaLite. N)rfs r geo_db_typez SpatiaLiteOperations.geo_db_typevs rc(|sgS|d}t|tru|j|jr|dk(r t d|j }|gSt |tj|j|j}|gS|}|gS)zu Return the distance parameters for the given geometry field, lookup value, and lookup type. rrIzNOnly numeric values of degree units are allowed on geographic DWithin queries.) isinstancer geodeticr ValueErrormgetattr unit_attname units_name)rrvalue lookup_type dist_params r get_distancez!SpatiaLiteOperations.get_distance}s Ia eX &zz$//*)+$6#WW | %800doo1NO |J|rc|jj} |jd|z|j}|j |dS#|j wxYw)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,cursorrows r_get_spatialite_funcz)SpatiaLiteOperations._get_spatialite_funcsW ((*  NN;- .//#C LLN1v  LLNs $AA'c$|jdS)z:Return the version of GEOS used by SpatiaLite as a string.zgeos_version()rrs r geos_versionz!SpatiaLiteOperations.geos_versions(()9::rc$|jdS)z:Return the version of the PROJ library used by SpatiaLite.zproj4_version()rrs r proj_versionz!SpatiaLiteOperations.proj_versions(():;;rc$|jdS)z8Return the version of LWGEOM library used by SpatiaLite.zlwgeom_version()rrs rlwgeom_versionz#SpatiaLiteOperations.lwgeom_version(();<SpatiaLiteOperations.get_geometry_converter..converters =4 W.>tE{J.W Wr) output_fieldrr r)rrrrrs @@rget_geometry_converterz+SpatiaLiteOperations.get_geometry_converters-,,77 w|| XrN)&rrr namer$rAdaptercollectextentmakeliner from_textrr gis_operatorsrExtent3Ddisallowed_aggregatesselectfunction_namesr rormrrrrrrrrrlrrtrrrrrrrr#r#s DJGG FHHI-8< /Z@ .I>  .I>  -8<  /Z@ /Z@ 1|D -8< 0kB -8< _+6 o=9!$ o=9%( .H=)* ,(;+. ?7/M4$__. (F5'#$1!# N   (0 ;<==)A7')'rr#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.ior django.contrib.gis.measurer django.core.exceptionsr %django.db.backends.sqlite3.operationsr django.utils.functionalr django.utils.versionrrr#rrrrsK )PO@K7/7D32&/& N02DNr