DvgH!dZddlmZddlmZddlmZddlmZddl m Z m Z ddl m Z ddlmZdd lmZdd lmZdd lmZdd lmZGd deZGddeeZdS)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 q/var/www/pixelcanvas.ch/venv/lib/python3.11/site-packages/django/contrib/gis/db/backends/spatialite/operations.pyrz"SpatialiteNullCheckOperator.as_sqls1ggnnZ*UU V#~v%%)__name__ __module__ __qualname__r __classcell__)rs@rrrs8&&&&&&&&&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( ZejfZd)Zd*d+d,d-d.d/d0d1d2d3d4d5d6 Zed7Zed8Zd9Zd:Zd;Zd<Zd=Zd>Zd?Zd@ZdAZdBZ dCZ!dDZ"dEZ#dFZ$dGZ%dHS)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}|s|hdz}|jdkr|dhz}|S)N>IsEmptyMemSizeGeometryDistance>AzimuthGeoHash MakeValid)rX)geom_lib_versionspatial_version)r unsupporteds runsupported_functionsz*SpatiaLiteOperations.unsupported_functionsSsT@@@ $$&& ? >>> >K  & ( ( ,- -Krc |dd}n6#t$r)}td|jjdd|d}~wwxYw|dkrtd|S)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\s 3355abb9GG   &&?0888;    Y  &'WXX Xs A$A  Ac|dSt|j}|ddd\}}|ddd\}}||||fS)zV Convert the polygon data received from SpatiaLite to min/max values. Nr)rshell)rboxr{xminyminxmaxymaxs rconvert_extentz#SpatiaLiteOperations.convert_extentksW ;4S!!'1Xbqb\ d1Xbqb\ ddD$''rcdS)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 trc2|sgS|d}t|trr||jr|dkrt d|j}n=t |tj||j}n|}|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#W $80do1N1NOO J|rc|j} |d|z|}|n#|wxYw|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 %sr)r_cursorexecutefetchoneclose)rr,cursorrows r_get_spatialite_funcz)SpatiaLiteOperations._get_spatialite_funcsl ((**  NN;- . . .//##C LLNNNNFLLNNNN1v s ,AA2c,|dS)z:Return the version of GEOS used by SpatiaLite as a string.zgeos_version()rrs r geos_versionz!SpatiaLiteOperations.geos_versions(()9:::rc,|dS)z:Return the version of the PROJ library used by SpatiaLite.zproj4_version()rrs r proj_versionz!SpatiaLiteOperations.proj_versions(():;;;rc,|dS)z8Return the version of LWGEOM library used by SpatiaLite.zlwgeom_version()rrs rlwgeom_versionz#SpatiaLiteOperations.lwgeom_version(();<<|dnt|S)N)r)r expressionr geom_classreads r converterz>SpatiaLiteOperations.get_geometry_converter..converters$ =44.>ttE{{J.W.W Wr) output_fieldrr r)rrrrrs @@rget_geometry_converterz+SpatiaLiteOperations.get_geometry_convertersF,7 ww| X X X X X XrN)&rrr namer$rAdaptercollectextentmakeliner from_textrr gis_operatorsrExtent3Ddisallowed_aggregatesselectfunction_namesr rormrrrrrrrrrlrrtrrrrrrrr#r#sb DJGG FHHI--8<<< //Z@@@ ..I>>>  ..I>>>  --8<<<  //Z@@@ //Z@@@ 11|DDD --8<<< 00kBBB --8<<< __+666 oo=999!$ oo=999%( ..H===)* ,,(;;;+. ??777/M4$_. (F5'#$1!#  N_  _  ( ( (0   ;;;<<<======)))AAA777''')))'''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#rrrrsI )(((((PPPPPPOOOOOO@@@@@@KKKKKKKK777777//////777777DDDDDD333333222222&&&&&/&&& NNNNN02DNNNNNr