TQc@s\ddlZddlmZddlmZddlmZmZddlm Z ddl m Z ddl m Z ddlmZdd lmZdd lmZdd lmZd efd YZdefdYZdefdYZdefdYZdefdYZee efejZdZdeefdYZdS(iN(tDecimal(tBaseSpatialOperations(tSpatialOperationtSpatialFunction(tSpatiaLiteAdapter(tGeometry(tDistance(tImproperlyConfigured(tDatabaseOperations(t DatabaseError(tsixtSpatiaLiteOperatorcBseZdZdZRS(s*For SpatiaLite operators (e.g. `&&`, `~`).cCstt|jd|dS(Ntoperator(tsuperR t__init__(tselfR ((sM../Django//lib/python/django/contrib/gis/db/backends/spatialite/operations.pyRs(t__name__t __module__t__doc__R(((sM../Django//lib/python/django/contrib/gis/db/backends/spatialite/operations.pyR stSpatiaLiteFunctioncBseZdZdZRS(sFor SpatiaLite function calls.cKstt|j||dS(N(R RR(Rtfunctiontkwargs((sM../Django//lib/python/django/contrib/gis/db/backends/spatialite/operations.pyRs(RRRR(((sM../Django//lib/python/django/contrib/gis/db/backends/spatialite/operations.pyRstSpatiaLiteFunctionParamcBseZdZdZRS(s5For SpatiaLite functions that take another parameter.s,%(function)s(%(geo_col)s, %(geometry)s, %%s)(RRRt sql_template(((sM../Django//lib/python/django/contrib/gis/db/backends/spatialite/operations.pyRstSpatiaLiteDistancecBs#eZdZdZdZdZRS(s#For SpatiaLite distance operations.Rs8%(function)s(%(geo_col)s, %(geometry)s) %(operator)s %%scCs#tt|j|jd|dS(NR (R RRt dist_func(RR ((sM../Django//lib/python/django/contrib/gis/db/backends/spatialite/operations.pyR!s(RRRRRR(((sM../Django//lib/python/django/contrib/gis/db/backends/spatialite/operations.pyRstSpatiaLiteRelatecBs&eZdZejdZdZRS(s/For SpatiaLite Relate(, ) calls.s^[012TF\*]{9}$cCs?|jj|s%td|ntt|jddS(Ns)Invalid intersection matrix pattern "%s".tRelate(t pattern_regextmatcht ValueErrorR RR(Rtpattern((sM../Django//lib/python/django/contrib/gis/db/backends/spatialite/operations.pyR(s(RRRtretcompileRR(((sM../Django//lib/python/django/contrib/gis/db/backends/spatialite/operations.pyR%scCs t|fS(sZReturns operations for regular distances; spherical distances are not currently supported.(R(R ((sM../Django//lib/python/django/contrib/gis/db/backends/spatialite/operations.pyt get_dist_ops/stSpatiaLiteOperationscBseZdZdZeZejdZe gdID]Z e dJf^q1Z e ZeZdZdZdZdZd Zd Zd Zd Zd ZdZdZdZdZdZdZdZdZ dZ!dZ"dZ#dZ$ie%dd6e%dd6e%dd6e%dd 6e%d!d"6e%d#d$6e%d%d&6e%d'd(6e&e'j(fd)6e%dd*6e%d+d,6e%d-d.6e%dd/6e%dd06Z)ie*d1e+fd26e*d3e+fd46e*d5e+fd66e*d7e+fd86Z,e)j-e,d9Z.d:Z/d;Z0d<Z1d=Z2d>Z3d?Z4d@Z5dAZ6dBZ7dCZ8dDZ9dEZ:dFZ;dGZ<dHZ=RS(Ks)django.contrib.gis.db.models.sql.compilert spatialites/^(?P\d)\.(?P\d)\.(?P\d+)tExtenttUniontAreatCentroidt MbrWithint DifferenceRtEnvelopet IntersectiontGLengtht NumGeometriest NumPointstPointOnSurfacet ScaleCoordstAsSVGt SymDifferencet Transformt ShiftCoordstGUniont GeomFromTextt GeomFromWKBs AsText(%s)tEqualstequalstDisjointtdisjointtTouchesttouchestCrossestcrossestWithintwithintOverlapstoverlapstContainstcontainst Intersectst intersectstrelatet containedt MbrContainst bbcontainst MbrOverlapst bboverlapstsame_astexactt>t distance_gts>=t distance_gtet|j}|d}|d kr4tdn||_WnFtk rTn3tk r}td|jjd|fnX|dkry#|jd d |_d |_Wqt k rqXn|dkrd |_ ndS(Niiiis;GeoDjango only supports SpatiaLite versions 2.3.0 and abovesCannot determine the SpatiaLite version for the "%s" database (error was "%s"). Was the SpatiaLite initialization SQL loaded on this database?tNAMEis!AsGML(GeomFromText('POINT(1 1)'))tAsGMLtAsKMLt AsGeoJSON(iii(iii(iii( tspatialite_version_tupleRtspatial_versiont ExceptionR]t settings_dictt_get_spatialite_functgmltkmlR tgeojson(Rtvtuptversiontmsg((sM../Django//lib/python/django/contrib/gis/db/backends/spatialite/operations.pyt#confirm_spatial_components_versionsys(           cCs|jj}||jkS(sx Checks if the given aggregate name is supported (that is, if it's in `self.valid_aggregates`). (t __class__Rtvalid_aggregates(Rt aggregatetagg_name((sM../Django//lib/python/django/contrib/gis/db/backends/spatialite/operations.pytcheck_aggregate_supports cCs|rt||jSdSdS(sM Converts geometry WKT returned from a SpatiaLite aggregate. N(RtsridR[(Rtwktt geo_field((sM../Django//lib/python/django/contrib/gis/db/backends/spatialite/operations.pyt convert_geomscCsdS(s Returns None because geometry columnas are added via the `AddGeometryColumn` stored procedure on SpatiaLite. N(R[(Rtf((sM../Django//lib/python/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]Rtgetattrt unit_attnamet units_name(RRxtvaluet lookup_typet dist_param((sM../Django//lib/python/django/contrib/gis/db/backends/spatialite/operations.pyt get_distances 'cCsd}t|drZ|||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(R[Rt(RRt((sM../Django//lib/python/django/contrib/gis/db/backends/spatialite/operations.pyttransform_valuest expressions %s(%%s, %s)s%ss%s(%s(%%s,%s), %s)s %s(%%s,%s)N(thasattrRtt transformtget_expression_columnt from_text(RRxRRt placeholder((sM../Django//lib/python/django/contrib/gis/db/backends/spatialite/operations.pytget_geom_placeholders  cCsW|jj}z2y!|jd||j}Wn nXWd|jX|dS(se Helper routine for calling SpatiaLite functions and returning their result. s SELECT %sNi(R]t_cursortexecutetfetchonetclose(Rtfunctcursortrow((sM../Django//lib/python/django/contrib/gis/db/backends/spatialite/operations.pyRgs  cCs |jdS(s;Returns the version of GEOS used by SpatiaLite as a string.sgeos_version()(Rg(R((sM../Django//lib/python/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()(Rg(R((sM../Django//lib/python/django/contrib/gis/db/backends/spatialite/operations.pyt proj4_versionscCs |jdS(s3Returns the SpatiaLite library version as a string.sspatialite_version()(Rg(R((sM../Django//lib/python/django/contrib/gis/db/backends/spatialite/operations.pytspatialite_versionscCsy|j}Wnetk rwd}y(|jd}|dkrMd}nWntk ranX|dkrxqxnX|jj|}|rt|jd}t|jd}t|jd}ntd|||||fS( sm Returns the SpatiaLite version as a tuple (version string, major, minor, subminor). sX(GeomFromText('POINT(1 1)'))g?s2.3.0tmajortminor1tminor2s-Could not parse SpatiaLite version string: %sN( RR R[Rgt version_regexRtinttgroupRe(RRlttmptmRRR((sM../Django//lib/python/django/contrib/gis/db/backends/spatialite/operations.pyRcs&    cCsy|jj}|j|s.td|n|j}|dkrS|d7}n|jd}t||}||fS(ss Returns the spatial aggregate SQL template and function for the given Aggregate instance. s8%s spatial aggregate is not implmented for this backend.tuniontaggs%(function)s(%(field)s)(RoRRstNotImplementedErrortlowertselectR|(RRRrRt sql_function((sM../Django//lib/python/django/contrib/gis/db/backends/spatialite/operations.pytspatial_aggregate_sqls    cCs|\}}}d||||f} ||jkrU|j|} t| tr-| \} } t|ttfstd|n|d} t|dkrtd|nt|d| std| t|dfn|dkr| |d} q9||jkr9| d} q9n | } |} | j| |j || S|d kr|d | | rtd pwd fSt d t |dS(s Returns the SpatiaLite-specific SQL for the given lookup value [a tuple of (alias, column, db_type)], lookup type, lookup value, the model field, and the quoting function. s%s.%ss$Tuple required for `%s` lookup type.iis:Incorrect number of parameters given for `%s` lookup type.is+Argument type should be %s, got %s instead.RIRWs %s IS %sNULLsNOT tsGot invalid lookup_type: %sN( RXRzttupletlistRtlenttypetdistance_functionstas_sqlRt TypeErrortrepr(RtlvalueRRtfieldtqntaliastcoltdb_typetgeo_colRtoptarg_typetgeom((sM../Django//lib/python/django/contrib/gis/db/backends/spatialite/operations.pytspatial_lookup_sql(s.   #  cCsddlm}|S(Ni(tGeometryColumns(t0django.contrib.gis.db.backends.spatialite.modelsR(RR((sM../Django//lib/python/django/contrib/gis/db/backends/spatialite/operations.pytgeometry_columns`scCsddlm}|S(Ni(t SpatialRefSys(RR(RR((sM../Django//lib/python/django/contrib/gis/db/backends/spatialite/operations.pytspatial_ref_sysds(R%R&N(>RRtcompiler_moduletnametTrueR$R R!RRZtkR[RpRtAdaptertAdaptortareatcentroidRJt differencetdistancetenvelopet intersectiontlengthtnum_geomt num_pointstpoint_on_surfacetscaletsvgtsym_differenceRt translateRtunionaggRtfrom_wkbRRRR t string_typesRXR"tdtypesRtupdateRRnRsRwRyRRRgRRRRcRRRR(((sM../Django//lib/python/django/contrib/gis/db/backends/spatialite/operations.pyR#3s%                         8 ( R tdecimalRt#django.contrib.gis.db.backends.baseRt#django.contrib.gis.db.backends.utilRRt1django.contrib.gis.db.backends.spatialite.adapterRt#django.contrib.gis.geometry.backendRtdjango.contrib.gis.measureRtdjango.core.exceptionsRtdjango.db.backends.sqlite3.baseRtdjango.db.utilsR t django.utilsR R RRRRtfloatt integer_typesRR"R#(((sM../Django//lib/python/django/contrib/gis/db/backends/spatialite/operations.pyts$