i4Vdc@sdZddlZddlZddlmZddlmZddlmZddl m Z ddl m Z ddl mZdd lmZdd lmZdd lmZdd lmZdd lmZdeefdYZdS(s SQL functions reference lists: http://www.gaia-gis.it/spatialite-2.4.0/spatialite-sql-2.4.html http://www.gaia-gis.it/spatialite-3.0.0-BETA/spatialite-sql-3.0.0.html http://www.gaia-gis.it/gaia-sins/spatialite-sql-4.2.1.html iN(tBaseSpatialOperations(tSpatiaLiteAdapter(tSpatialOperator(t aggregates(tGeometry(tDistance(tImproperlyConfigured(tDatabaseOperations(t DatabaseError(tsix(tcached_propertytSpatiaLiteOperationscBseZdZeZejdZeZ e Z dZ dZ dZ dZdZdZdZd Zd Zd Zd Zd ZdZdZdZdZdZdZdZdZdZdZ dZ!ie"ddd6e"ddd6e"ddd6e"ddd 6e"dd!d"6e"dd#d$6e"dd%d&6e"dd'd(6e"dd)d*6e"ddd+6e"dd,d-6e"dd.d/6e"ddd06e"ddd16e"ddd2d3d46e"ddd2d5d66e"ddd2d7d86e"ddd2d9d:6Z#e$d;Z%e$d<Z&e$d=Z'e(d>Z)e$d?Z*e$d@Z+e$dAZ,e$dBZ-dCZ.dDZ/dEZ0dFZ1dGZ2dHZ3dIZ4dJZ5dKZ6dLZ7dMZ8dNZ9dOZ:dPZ;dQZ<RS(Rt spatialites/^(?P\d)\.(?P\d)\.(?P\d+)tAreatCentroidtCollectt MbrWithint DifferenceRtEnvelopetExtentt IntersectiontGLengtht NumGeometriest NumPointstPointOnSurfacet ScaleCoordstAsSVGt SymDifferencet Transformt ShiftCoordstGUniont GeomFromTextt GeomFromWKBs AsText(%s)tfunctEqualstequalstDisjointtdisjointtTouchesttouchestCrossestcrossestWithintwithintOverlapstoverlapstContainstcontainst Intersectst intersectstRelatetrelatet containedt MbrContainst bbcontainst MbrOverlapst bboverlapstsame_astexacttopt>t distance_gts>=t distance_gtettjtjf}|jdkr:|tjtjf7}n|S(Nii(iii(RtExtent3DtMakeLineRKRR(RLt disallowed((s/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/contrib/gis/db/backends/spatialite/operations.pytdisallowed_aggregatesscCs|jr dSdS(NRR(RktNone(RL((s/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/contrib/gis/db/backends/spatialite/operations.pyRWscCs|jr dSdS(NRS(RkRp(RL((s/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/contrib/gis/db/backends/spatialite/operations.pyRYscCs|jdkrdSdS(NiiRT(iii(RKRp(RL((s/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/contrib/gis/db/backends/spatialite/operations.pytgeojsonscCsZ|dkrdSt||j}|dd \}}|dd \}}||||fS(sV Convert the polygon data received from Spatialite to min/max values. iiN(RpRtshell(RLtboxtsridRrtxmintymintxmaxtymax((s/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/contrib/gis/db/backends/spatialite/operations.pytconvert_extents  cCs|rt||jSdSdS(sM Converts geometry WKT returned from a SpatiaLite aggregate. N(RRtRp(RLtwktt geo_field((s/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/contrib/gis/db/backends/spatialite/operations.pyt convert_geomscCsdS(s Returns None because geometry columns are added via the `AddGeometryColumn` stored procedure on SpatiaLite. N(Rp(RLtf((s/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/contrib/gis/db/backends/spatialite/operations.pyt geo_db_typescCsx|s gS|d}t|trk|j|jrDtdqqt|tj|j|j}n|}|gS(s Returns the distance parameters for the given geometry field, lookup value, and lookup type. SpatiaLite only supports regular cartesian-based queries (no spheroid/sphere calculations for point geometries like PostGIS). isSpatiaLite does not support distance queries on geometry fields with a geodetic coordinate system. Distance objects; use a numeric value of your distance in degrees instead.(t isinstanceRtgeodeticR`t ValueErrortgetattrt unit_attnamet units_name(RLR}tvaluet lookup_typet dist_param((s/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/contrib/gis/db/backends/spatialite/operations.pyt get_distances 'cCsd}t|drf|||jrCd|j|jf}nd}|j|\}}||S|||jrd|j|j|j|jfSd|j|jfSdS(s Provides a proper substitution value for Geometries that are not in the SRID of the field. Specifically, this routine will substitute in the Transform() and GeomFromText() function call(s). cSs|dkp|j|k S(N(RpRt(RRt((s/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/contrib/gis/db/backends/spatialite/operations.pyttransform_valuestas_sqls %s(%%s, %s)s%ss%s(%s(%%s,%s), %s)s %s(%%s,%s)N(thasattrRtt transformtcompilet from_text(RLR}RtcompilerRt placeholdertsqlt_((s/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/contrib/gis/db/backends/spatialite/operations.pytget_geom_placeholders  cCsF|jj}z!|jd||j}Wd|jX|dS(s Helper routine for calling SpatiaLite functions and returning their result. Any error occurring in this method should be handled by the caller. s SELECT %sNi(R`t_cursortexecutetfetchonetclose(RLR!tcursortrow((s/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/contrib/gis/db/backends/spatialite/operations.pyRis  cCs |jdS(s;Returns the version of GEOS used by SpatiaLite as a string.sgeos_version()(Ri(RL((s/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/contrib/gis/db/backends/spatialite/operations.pyt geos_versionscCs |jdS(s=Returns the version of the PROJ.4 library used by SpatiaLite.sproj4_version()(Ri(RL((s/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/contrib/gis/db/backends/spatialite/operations.pyt proj4_versionscCs |jdS(s3Returns the SpatiaLite library version as a string.sspatialite_version()(Ri(RL((s/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/contrib/gis/db/backends/spatialite/operations.pytspatialite_versionscCs|j}|jj|}|rft|jd}t|jd}t|jd}ntd|||||fS(sm Returns the SpatiaLite version as a tuple (version string, major, minor, subminor). tmajortminor1tminor2s-Could not parse SpatiaLite version string: %s(Rt version_regextmatchtinttgroupR_(RLRetmRRR((s/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/contrib/gis/db/backends/spatialite/operations.pyR^s cCs1|jdkrdn |j}t||S(ss Returns the spatial aggregate SQL template and function for the given Aggregate instance. tuniontunionagg(tlowerR(RLtagg_name((s/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/contrib/gis/db/backends/spatialite/operations.pytspatial_aggregate_names$cCsddlm}|S(Ni(tSpatialiteGeometryColumns(t0django.contrib.gis.db.backends.spatialite.modelsR(RLR((s/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/contrib/gis/db/backends/spatialite/operations.pytgeometry_columnsscCsddlm}|S(Ni(tSpatialiteSpatialRefSys(RR(RLR((s/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/contrib/gis/db/backends/spatialite/operations.pytspatial_ref_sysscCsAtt|j|}t|jdr=|j|jn|S(Nt geom_type(tsuperR tget_db_convertersRt output_fieldtappendtconvert_geometry(RLt expressiont converters((s/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/contrib/gis/db/backends/spatialite/operations.pyR"scCs5|r1t|}d|kr1|d|_q1n|S(Nttransformed_srid(RRt(RLRRR`tcontext((s/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/contrib/gis/db/backends/spatialite/operations.pyR(s   (=t__name__t __module__tnameRhR treRRRtAdaptertAdaptortareatcentroidtcollectR4t differencetdistancetenvelopetextentt intersectiontlengthtnum_geomt num_pointstpoint_on_surfacetscaletsvgtsym_differenceRt translateRRRtfrom_wkbtselectRt gis_operatorsR RMR\RKtpropertyRkRoRWRYRqRyR|R~RRRiRRRR^RRRRR(((s/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/contrib/gis/db/backends/spatialite/operations.pyR s            (t__doc__RRct.django.contrib.gis.db.backends.base.operationsRt1django.contrib.gis.db.backends.spatialite.adapterRt$django.contrib.gis.db.backends.utilsRtdjango.contrib.gis.db.modelsRt#django.contrib.gis.geometry.backendRtdjango.contrib.gis.measureRtdjango.core.exceptionsRt%django.db.backends.sqlite3.operationsRtdjango.db.utilsRt django.utilsR tdjango.utils.functionalR R (((s/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/contrib/gis/db/backends/spatialite/operations.pyts