3 g@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"tj||||\}}d||fS)Nz%s > 0)superas_sql)self connectionlookupZtemplate_paramsZ sql_paramsZsqlparams) __class__r/var/www/tester-filtro-web/env/lib/python3.6/site-packages/django/contrib/gis/db/backends/spatialite/operations.pyrsz"SpatialiteNullCheckOperator.as_sql)__name__ __module__ __qualname__r __classcell__rr)rrrsrc@s^eZdZdZdZeZdZdZdZ 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 e dd e dd dZejfZdZddddddd d!d"d# Zed$d%Zed&d'Zd(d)Zd*d+Zd,d-Zd.d/Zd0d1Zd2d3Zd4d5Zd6d7Zd8d9Zd:d;Z dd?Z"d@dAZ#dBS)CSpatiaLiteOperations spatialiteTZCollectZExtentZMakeLineZGUnionZ GeomFromTextZEquals)funcZDisjointZTouchesZCrossesZWithinZOverlapsZContainsZ IntersectsZRelateZ CoveredByZCoversZ MbrWithinZ MbrContainsZ MbrOverlapsZ PtDistWithin)equalsZdisjointZtouchesZcrossesZwithinoverlapscontainsZ intersectsZrelateZ coveredbyZcoversZ containedZ bbcontainsZ bboverlapsZsame_asexactdwithinzCAST (AsEWKB(%s) AS BLOB)Z St_AsBinaryZ ST_ForceLHRZ ST_LengthZST_Line_Locate_PointZ ST_NPointsZ ST_ReverseZ ScaleCoordsZ ST_TranslateZST_Union) ZAsWKBZForcePolygonCWZLengthZLineLocatePointZ NumPointsZReverseZScaleZ TranslateUnioncCs&dddh}|js"|ddddhO}|S)NZBoundingCircleZGeometryDistanceZMemSizeZAzimuthZGeoHashZIsValidZ MakeValid)lwgeom_version)r unsupportedrrrunsupported_functionsQs z*SpatiaLiteOperations.unsupported_functionscCsdy|jdd}Wn:tk rN}ztd|jjdf|WYdd}~XnX|d kr`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?NAMErz.GeoDjango supports SpatiaLite 4.3.0 and above.)r*r+r)spatialite_version_tuple Exceptionr rZ settings_dict)rversionexcrrrspatial_versionXsz$SpatiaLiteOperations.spatial_versioncCsJ|dkr dSt|j}|ddd\}}|ddd\}}||||fS)zV Convert the polygon data received from SpatiaLite to min/max values. Nr)rshell)rZboxr2ZxminZyminZxmaxZymaxrrrconvert_extenths  z#SpatiaLiteOperations.convert_extentcCsdS)z Return None because geometry columns are added via the `AddGeometryColumn` stored procedure on SpatiaLite. Nr)rfrrr geo_db_typessz SpatiaLiteOperations.geo_db_typecCsb|sgS|d}t|trX|j|jr>|dkr6td|j}q\t|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)rr4valueZ lookup_typeZ dist_paramrrr get_distancezs  z!SpatiaLiteOperations.get_distancec Cs8|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:Return the version of the PROJ library used by SpatiaLite.zproj4_version())r@)rrrr proj_versionsz!SpatiaLiteOperations.proj_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). )rCr )rr.rrrr,sz-SpatiaLiteOperations.spatialite_version_tuplecCs"|jdkrdn|j}t||S)zr Return the spatial aggregate SQL template and function for the given Aggregate instance. unionunionagg)lowerr9)rZagg_namerrrspatial_aggregate_namesz+SpatiaLiteOperations.spatial_aggregate_namecCsddlm}|S)Nr)SpatialiteGeometryColumns)0django.contrib.gis.db.backends.spatialite.modelsrH)rrHrrrgeometry_columnss z%SpatiaLiteOperations.geometry_columnscCsddlm}|S)Nr)SpatialiteSpatialRefSys)rIrK)rrKrrrspatial_ref_syss z$SpatiaLiteOperations.spatial_ref_syscs"|jjtjfdd}|S)Ncs|dkr dSt|S)N)r)r: expressionr) geom_classreadrr convertersz>SpatiaLiteOperations.get_geometry_converter..converter)Z output_fieldrNrrO)rrMrPr)rNrOrget_geometry_convertersz+SpatiaLiteOperations.get_geometry_converterN)$rrrnamerrZAdapterZcollectZextentZmakelinerEZ from_textrrZ gis_operatorsrZExtent3DZdisallowed_aggregatesselectZfunction_namesr r'r0r3r5r;r@rArBr%rCr,rGrJrLrQrrrrrsf    rN)__doc__Zdjango.contrib.gis.dbrZ.django.contrib.gis.db.backends.base.operationsrZ1django.contrib.gis.db.backends.spatialite.adapterrZ$django.contrib.gis.db.backends.utilsrZ 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