U Ha,@sddlmZddlmZddlmZddlmZmZm Z ddl m Z ddl m Z Gddde ZGd d d eZejGd d d eZejGd ddeZejGdddeZejGdddeZejGdddeZejGdddeZejGdddeZejGdddeZejGdddeZeedejGdddeZejGd d!d!eZejGd"d#d#eZejGd$d%d%eZejGd&d'd'eZejGd(d)d)eZejGd*d+d+eZ ejGd,d-d-eZ!ejGd.d/d/eZ"ejGd0d1d1eZ#ejGd2d3d3eZ$ejGd4d5d5eZ%ejGd6d7d7eZ&ejGd8d9d9eZ'ejGd:d;d;eZ(Gdd?d?e)Z*Gd@dAdAe)Z+ejGdBdCdCe+Z,ejGdDdEdEe+Z-ejGdFdGdGe+Z.ejGdHdIdIe+Z/dJS)K)BaseSpatialField)Distance)NotSupportedError) ExpressionLookup Transform)Query)_lazy_re_compilec@seZdZddZdS)RasterBandTransformcCs ||jSN)compilelhs)selfcompiler connectionrH/tmp/pip-unpacked-wheel-3jxiddxt/django/contrib/gis/db/models/lookups.pyas_sql szRasterBandTransform.as_sqlN__name__ __module__ __qualname__rrrrrr sr csfeZdZdZdZdZdZdZfddZddZ dddZ d d Z fd d Z d dZ ddZZS) GISLookupNFcs>t|ttfr|n|g^}|_t||i|_|dSr ) isinstancelisttuple rhs_paramssuper__init__template_paramsprocess_rhs_params)rr rhs __class__rrrszGISLookup.__init__cCsf|jrJt|j|jdkrdndkr,|qbt|jdkrbtd|jnt|jtrb|jdddS)NrelatezTuple too long for lookup %s.T)only_lhs)rlen lookup_nameprocess_band_indices ValueErrorrr r rrrrr s  zGISLookup.process_rhs_paramscCsP|rd|_|jjd|_dSt|jtr8|jjd|_nd|_|j^|_|_dS)z Extract the lhs band index from the band transform class and the rhs band index from the input tuple. r&N)band_rhsr Z band_indexband_lhsrr r)rr'rrrr*%s zGISLookup.process_band_indicescCsd|j|gfS)N%s)opsZAdapter)rvaluerrrrget_db_prep_lookup8szGISLookup.get_db_prep_lookupcsjt|jtrt||St|jtr6|j|j|_t||\}}|j |j j |j|}|||fSr ) rr!rr process_rhsrresolve_expressionqueryr0Zget_geom_placeholderr output_field)rrrr!r placeholderr"rrr3<s  zGISLookup.process_rhscCs|jj|jSr )r0 gis_operatorsr))rrr!rrr get_rhs_opFszGISLookup.get_rhs_opc CsV|||\}}|||\}}||}||dd|j}|||} | ||||S)Nr/)r r!r1)Z process_lhsr3rr9r) rrrZlhs_sqlZ lhs_paramsrhs_sqlrZ sql_paramsrZrhs_oprrrrLs  zGISLookup.as_sql)F)rrr sql_templateZtransform_funcdistancer-r.rr r*r2r3r9r __classcell__rrr"rrs   rc@seZdZdZdZdS)OverlapsLeftLookupzy The overlaps_left operator returns true if A's bounding box overlaps or is to the left of B's bounding box. Z overlaps_leftNrrr__doc__r)rrrrr>Zsr>c@seZdZdZdZdS)OverlapsRightLookupz} The 'overlaps_right' operator returns true if A's bounding box overlaps or is to the right of B's bounding box. Zoverlaps_rightNr?rrrrrAcsrAc@seZdZdZdZdS)OverlapsBelowLookupzs The 'overlaps_below' operator returns true if A's bounding box overlaps or is below B's bounding box. Zoverlaps_belowNr?rrrrrBlsrBc@seZdZdZdZdS)OverlapsAboveLookupzs The 'overlaps_above' operator returns true if A's bounding box overlaps or is above B's bounding box. Zoverlaps_aboveNr?rrrrrCusrCc@seZdZdZdZdS) LeftLookupzo The 'left' operator returns true if A's bounding box is strictly to the left of B's bounding box. leftNr?rrrrrD~srDc@seZdZdZdZdS) RightLookupzq The 'right' operator returns true if A's bounding box is strictly to the right of B's bounding box. rightNr?rrrrrFsrFc@seZdZdZdZdS)StrictlyBelowLookupzp The 'strictly_below' operator returns true if A's bounding box is strictly below B's bounding box. Zstrictly_belowNr?rrrrrHsrHc@seZdZdZdZdS)StrictlyAboveLookupzp The 'strictly_above' operator returns true if A's bounding box is strictly above B's bounding box. Zstrictly_aboveNr?rrrrrIsrIc@seZdZdZdZdS) SameAsLookupz The "~=" operator is the "same as" operator. It tests actual geometric equality of two features. So if A and B are the same feature, vertex-by-vertex, the operator returns true. Zsame_asNr?rrrrrJsrJexactc@seZdZdZdZdS)BBContainsLookupzq The 'bbcontains' operator returns true if A's bounding box completely contains by B's bounding box. Z bbcontainsNr?rrrrrLsrLc@seZdZdZdZdS)BBOverlapsLookupz_ The 'bboverlaps' operator returns true if A's bounding box overlaps B's bounding box. Z bboverlapsNr?rrrrrMsrMc@seZdZdZdZdS)ContainedLookupzt The 'contained' operator returns true if A's bounding box is completely contained by B's bounding box. Z containedNr?rrrrrNsrNc@seZdZdZdS)ContainsLookupcontainsNrrrr)rrrrrOsrOc@seZdZdZdS)ContainsProperlyLookupZcontains_properlyNrQrrrrrRsrRc@seZdZdZdS)CoveredByLookupZ coveredbyNrQrrrrrSsrSc@seZdZdZdS) CoversLookupZcoversNrQrrrrrTsrTc@seZdZdZdS) CrossesLookupZcrossesNrQrrrrrUsrUc@seZdZdZdS)DisjointLookupZdisjointNrQrrrrrVsrVc@seZdZdZdS) EqualsLookupequalsNrQrrrrrWsrWc@seZdZdZdS)IntersectsLookupZ intersectsNrQrrrrrYsrYc@seZdZdZdS)OverlapsLookupoverlapsNrQrrrrrZsrZcs,eZdZdZdZedZfddZZS) RelateLookupr$z%(func)s(%(lhs)s, %(rhs)s, %%s)z^[012TF\*]{9}$csp|jd}|jj|j}t|dr.||n"t|trD|j |sPt d|t ||\}}|||gfS)Nrcheck_relate_argumentz)Invalid intersection matrix pattern "%s".) rr0r8r)hasattrr]rstr pattern_regexmatchr+rr3)rrrpatternZ backend_opsqlparamsr"rrr3s    zRelateLookup.process_rhs) rrrr)r;r r`r3r=rrr"rr\sr\c@seZdZdZdS) TouchesLookupZtouchesNrQrrrrre srec@seZdZdZdS) WithinLookupZwithinNrQrrrrrfsrfc@s$eZdZdZdZddZddZdS)DistanceLookupBaseTz+%(func)s(%(lhs)s, %(rhs)s) %(op)s %(value)scCsxdt|jkrdks,ntd|jn$t|jdkrP|jddkrPtdt|jdkrt|jddkrt|dS)Nr&z22, 3, or 4-element tuple required for '%s' lookup.r%spheroidzHFor 4-element tuples the last argument must be the 'spheroid' directive.)r(rr+r)r*r,rrrr s z%DistanceLookupBase.process_rhs_paramscCsB|jd}t|dr&|||jSd|j|jj|j|j fS)Nrr4r/) rr^r r4r5r0Z get_distancer r6r)rrrZ dist_paramrrrprocess_distance$s  z#DistanceLookupBase.process_distanceN)rrrr<r;r rkrrrrrgs rgcs0eZdZdZdZfddZfddZZS) DWithinLookupZdwithinz%%(func)s(%(lhs)s, %(rhs)s, %(value)s)cs<|jd}|jjs.t|dr.t|ts.tdt||S)Nrr4zXThis backend does not support expressions for specifying distance in the dwithin lookup.) rfeaturesZsupports_dwithin_distance_exprr^rrrrrkrjr"rrrk2s zDWithinLookup.process_distancecs8|||\}}||jd<t||\}}|||fS)Nr1)rkrrr3)rrrdist_sql dist_paramsr:rdr"rrr3?s zDWithinLookup.process_rhs)rrrr)r;rkr3r=rrr"rrl-s rlc@seZdZddZdS)DistanceLookupFromFunctionc Csvt|jdkr|jddkpd}|jj|j|j|d}|||j\}}| ||\}}d||j |d||fS)Nr%ri)riz%(func)s %(op)s %(dist)s)funcopdist) r(rr0Zdistance_expr_for_lookupr r!r r4r5rkrs) rrrriZ distance_exprrcrdrnrorrrrGs z!DistanceLookupFromFunction.as_sqlNrrrrrrpFsrpc@seZdZdZdZdS)DistanceGTLookupZ distance_gt>Nrrrr)rsrrrrruRsruc@seZdZdZdZdS)DistanceGTELookupZ distance_gtez>=NrwrrrrrxXsrxc@seZdZdZdZdS)DistanceLTLookupZ distance_ltrArBrCrDrFrHrIrJrLrMrNrOrRrSrTrUrVrWrYrZr\rerfrgrlrprurxryr{rrrrs     L