o uvXja*@s ddlZddlmZddlmZddlmZmZddlm Z GdddeZ Gdd d eZ ej Gd d d e Z ej Gd d d e Zej Gddde Zej Gddde Zej Gddde Zej Gddde Zej Gddde Zej Gddde Zej Gddde Ze edej Gddde Zej Gdd d e Zej Gd!d"d"e Zej Gd#d$d$e Zej Gd%d&d&e Zej Gd'd(d(e Zej Gd)d*d*e Zej Gd+d,d,e Zej Gd-d.d.e Zej Gd/d0d0e Zej Gd1d2d2e Z ej Gd3d4d4e Z!ej Gd5d6d6e Z"ej Gd7d8d8e Z#ej Gd9d:d:e Z$Gd;d<dd>e%Z&Gd?d@d@e%Z'ej GdAdBdBe'Z(ej GdCdDdDe'Z)ej GdEdFdFe'Z*ej GdGdHdHe'Z+dS)IN)BaseSpatialField) Expression)Lookup Transform)Queryc@eZdZddZdS)RasterBandTransformcCs ||jSN)compilelhs)selfcompiler connectionra/var/www/html/myproject/venv/lib/python3.10/site-packages/django/contrib/gis/db/models/lookups.pyas_sql s zRasterBandTransform.as_sqlN__name__ __module__ __qualname__rrrrrr  rcsfeZdZdZdZdZdZdZfddZddZ 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)r r rhs __class__rrrs zGISLookup.__init__cCsn|jr't|j|jdkrdndkr|dSt|jdkr%td|jdSt|jtr5|jdddSdS)NrelatezTuple too long for lookup %s.T)only_lhs)rlen lookup_nameprocess_band_indices ValueErrorrr rr rrrrs  zGISLookup.process_rhs_paramscCsP|rd|_|jjd|_dSt|jtr|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 band_indexband_lhsrrr)r r&rrrr)%s zGISLookup.process_band_indicescCsd|j|gfS)N%s)opsAdapter)r valuerrrrget_db_prep_lookup8szGISLookup.get_db_prep_lookupcsjt|jtr t||St|jtr|j|j|_t||\}}|j |j j |j|}|||fSr ) rr rr process_rhsrresolve_expressionqueryr0get_geom_placeholderr output_field)r r rr r placeholderr!rrr4<s   zGISLookup.process_rhscCs|jj|jSr )r0 gis_operatorsr()r rr rrr get_rhs_opFszGISLookup.get_rhs_opc CsX|||\}}|||\}}||||dd|j}|||}|||||S)Nr/)r r r2) process_lhsr4extendrr;r) r r rlhs_sql sql_paramsrhs_sqlrrrhs_oprrrrLs   zGISLookup.as_sql)F)rrr sql_templatetransform_funcdistancer,r.rrr)r3r4r;r __classcell__rrr!rrs    rc@eZdZdZdZdS)OverlapsLeftLookupzy The overlaps_left operator returns true if A's bounding box overlaps or is to the left of B's bounding box. overlaps_leftNrrr__doc__r(rrrrrGZrGc@rF)OverlapsRightLookupz} The 'overlaps_right' operator returns true if A's bounding box overlaps or is to the right of B's bounding box. overlaps_rightNrIrrrrrLcrKrLc@rF)OverlapsBelowLookupzs The 'overlaps_below' operator returns true if A's bounding box overlaps or is below B's bounding box. overlaps_belowNrIrrrrrNlrKrNc@rF)OverlapsAboveLookupzs The 'overlaps_above' operator returns true if A's bounding box overlaps or is above B's bounding box. overlaps_aboveNrIrrrrrPurKrPc@rF) LeftLookupzo The 'left' operator returns true if A's bounding box is strictly to the left of B's bounding box. leftNrIrrrrrR~rKrRc@rF) RightLookupzq The 'right' operator returns true if A's bounding box is strictly to the right of B's bounding box. rightNrIrrrrrTrKrTc@rF)StrictlyBelowLookupzp The 'strictly_below' operator returns true if A's bounding box is strictly below B's bounding box. strictly_belowNrIrrrrrVrKrVc@rF)StrictlyAboveLookupzp The 'strictly_above' operator returns true if A's bounding box is strictly above B's bounding box. strictly_aboveNrIrrrrrXrKrXc@rF) 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. same_asNrIrrrrrZsrZexactc@rF)BBContainsLookupzq The 'bbcontains' operator returns true if A's bounding box completely contains by B's bounding box. bbcontainsNrIrrrrr]rKr]c@rF)BBOverlapsLookupz_ The 'bboverlaps' operator returns true if A's bounding box overlaps B's bounding box. bboverlapsNrIrrrrr_sr_c@rF)ContainedLookupzt The 'contained' operator returns true if A's bounding box is completely contained by B's bounding box. containedNrIrrrrrarKrac@eZdZdZdS)ContainsLookupcontainsNrrrr(rrrrrdrdc@rc)ContainsProperlyLookupcontains_properlyNrfrrrrrhrgrhc@rc)CoveredByLookup coveredbyNrfrrrrrjrgrjc@rc) CoversLookupcoversNrfrrrrrlrgrlc@rc) CrossesLookupcrossesNrfrrrrrnrgrnc@rc)DisjointLookupdisjointNrfrrrrrprgrpc@rc) EqualsLookupequalsNrfrrrrrrrgrrc@rc)IntersectsLookup intersectsNrfrrrrrtrgrtc@rc)OverlapsLookupoverlapsNrfrrrrrvrgrvcs.eZdZdZdZedZfddZZ S) RelateLookupr#%(func)s(%(lhs)s, %(rhs)s, %%s)z^[012TF\*]{9}$csp|jd}|jj|j}t|dr||nt|tr"|j |s(t d|t ||\}}|||gfS)Nrcheck_relate_argumentz)Invalid intersection matrix pattern "%s".) rr0r:r(hasattrrzrstr pattern_regexmatchr*rr4)r r rpattern backend_opsqlparamsr!rrr4s    zRelateLookup.process_rhs) rrrr(rBrer r}r4rErrr!rrxs  rxc@rc) TouchesLookuptouchesNrfrrrrr rgrc@rc) WithinLookupwithinNrfrrrrrrgrc@s$eZdZdZdZddZddZdS)DistanceLookupBaseTz+%(func)s(%(lhs)s, %(rhs)s) %(op)s %(value)scCs~dt|jkr dksntd|jt|jdkr'|jddkr'tdt|jdkr;|jddkr=|dSdSdS)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+rrrrs z%DistanceLookupBase.process_rhs_paramscCsB|jd}t|dr|||jSd|j|jj|j|j fS)Nrr5r/) rr{r r5r6r0 get_distancer r8r()r r r dist_paramrrrprocess_distance$s z#DistanceLookupBase.process_distanceN)rrrrDrBrrrrrrrs  rcs$eZdZdZdZfddZZS) DWithinLookupdwithinrycs8|||\}}||jd<t||\}}|||fS)Nr2)rrrr4)r r rdist_sql dist_paramsr@rr!rrr42s  zDWithinLookup.process_rhs)rrrr(rBr4rErrr!rr-src@r)DistanceLookupFromFunctionc Csvt|jdkr|jddkpd}|jj|j|j|d}|||j\}}| ||\}}d||j |d||fS)Nr$r)rz%(func)s %(op)s %(dist)s)funcopdist) r'rr0distance_expr_for_lookupr r r r5r6rr) r r rr distance_exprrrrrrrrr:s z!DistanceLookupFromFunction.as_sqlNrrrrrr9rrc@rF)DistanceGTLookup distance_gt>Nrrrr(rrrrrrErc@rF)DistanceGTELookup distance_gtez>=NrrrrrrKrrc@rF)DistanceLTLookup distance_lts   L