j.ddlmZddlmZddlmZddlmZmZm Z ddl m Z ddl m Z Gdde ZGd d eZejGd d eZejGd deZejGddeZejGddeZejGddeZejGddeZejGddeZejGddeZejGddeZejedejGddeZejGd d!eZejGd"d#eZejGd$d%eZejGd&d'eZejGd(d)eZejGd*d+eZ ejGd,d-eZ!ejGd.d/eZ"ejGd0d1eZ#ejGd2d3eZ$ejGd4d5eZ%ejGd6d7eZ&ejGd8d9eZ'ejGd:d;eZ(Gd<d=eZ)ejGd>d?e)Z*Gd@dAe)Z+ejGdBdCe+Z,ejGdDdEe+Z-ejGdFdGe+Z.ejGdHdIe+Z/dJS)K)BaseSpatialField)Distance)NotSupportedError) ExpressionLookup Transform)Query)_lazy_re_compileceZdZdZdS)RasterBandTransformc6||jSN)compilelhs)selfcompiler connections q/var/www/finuniver-perm.ru/html/student/venv/lib/python3.11/site-packages/django/contrib/gis/db/models/lookups.pyas_sqlzRasterBandTransform.as_sql s)))N__name__ __module__ __qualname__rrrr r s#*****rr c\eZdZdZdZdZdZdZfdZdZ d dZ dZ fdZ dZ d ZxZS) GISLookupNFct|ttfr|n|g^}|_t ||i|_|dSr) isinstancelisttuple rhs_paramssuper__init__template_paramsprocess_rhs_params)rrrhs __class__s rr$zGISLookup.__init__sb'1#e}'E'E PC5do c"""! !!!!!rcP|jrlt|j|jdkrdndkr|dSt|jdkrt d|jzdSt |jtr|ddSdS)NrelatezTuple too long for lookup %s.T)only_lhs)r"len lookup_nameprocess_band_indices ValueErrorrrr rs rr&zGISLookup.process_rhs_paramss ? 54?##T-=-I-IqQQ))+++++T_%%)) !@4CS!STTT*) "5 6 6 5  % %t % 4 4 4 4 4 5 5rc|rd|_|jjdz|_dSt |jt r|jjdz|_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_lhsrr r")rr-s rr0zGISLookup.process_band_indices%sl  DM H/!3DM F dh 3 4 4  H/!3DMMDM*./' rc<d|j|gfS)N%s)opsAdapter)rvaluers rget_db_prep_lookupzGISLookup.get_db_prep_lookup8s z~--e44566rct|jtr"t||St|jt r$|j|j|_t||\}}|j |j j |j|}||z|fSr) rr'r r# process_rhsrresolve_expressionqueryr9get_geom_placeholderr output_field)rrrr'r" placeholderr(s rr>zGISLookup.process_rhs<s dh & & =77&&x<< < dh + + Cx228>BBDH''--h CCZ n99 H !48X  S *,,rc0|jj|jSr)r9 gis_operatorsr/)rrr's r get_rhs_opzGISLookup.get_rhs_opHs~+D,<==rc|||\}}|||\}}g||R}||dd|j}|||} | ||||S)Nr8)rr'r;) process_lhsr>r%rFr) rrrlhs_sql lhs_paramsrhs_sqlr" sql_paramsr%rhs_ops rrzGISLookup.as_sqlNs"..xDD"..xDD/z/J//   "   W55}}Z KKKr)F)rrr sql_templatetransform_funcdistancer4r6r$r&r0r<r>rFr __classcell__r(s@rrrsLNHHH""""" 555::::&777 - - - - ->>> L L L L L L LrrceZdZdZdZdS)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/rrrrTrTbs "KKKrrTceZdZdZdZdS)OverlapsRightLookupz} The 'overlaps_right' operator returns true if A's bounding box overlaps or is to the right of B's bounding box. overlaps_rightNrVrrrrYrYl #KKKrrYceZdZdZdZdS)OverlapsBelowLookupzs The 'overlaps_below' operator returns true if A's bounding box overlaps or is below B's bounding box. overlaps_belowNrVrrrr]r]vr[rr]ceZdZdZdZdS)OverlapsAboveLookupzs The 'overlaps_above' operator returns true if A's bounding box overlaps or is above B's bounding box. overlaps_aboveNrVrrrr`r`r[rr`ceZdZdZdZdS) LeftLookupzo The 'left' operator returns true if A's bounding box is strictly to the left of B's bounding box. leftNrVrrrrcrcs KKKrrcceZdZdZdZdS) RightLookupzq The 'right' operator returns true if A's bounding box is strictly to the right of B's bounding box. rightNrVrrrrfrfs KKKrrfceZdZdZdZdS)StrictlyBelowLookupzp The 'strictly_below' operator returns true if A's bounding box is strictly below B's bounding box. strictly_belowNrVrrrririr[rriceZdZdZdZdS)StrictlyAboveLookupzp The 'strictly_above' operator returns true if A's bounding box is strictly above B's bounding box. strictly_aboveNrVrrrrlrlr[rrlceZdZdZdZdS) 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_asNrVrrrroros KKKrroexactceZdZdZdZdS)BBContainsLookupzq The 'bbcontains' operator returns true if A's bounding box completely contains by B's bounding box. bbcontainsNrVrrrrsrs KKKrrsceZdZdZdZdS)BBOverlapsLookupzc The 'bboverlaps' operator returns true if A's bounding box overlaps B's bounding box. bboverlapsNrVrrrrwrwrurrwceZdZdZdZdS)ContainedLookupzt The 'contained' operator returns true if A's bounding box is completely contained by B's bounding box. containedNrVrrrrzrzs KKKrrzceZdZdZdS)ContainsLookupcontainsNrrrr/rrrr}r}KKKrr}ceZdZdZdS)ContainsProperlyLookupcontains_properlyNrrrrrrs%KKKrrceZdZdZdS)CoveredByLookup coveredbyNrrrrrrsKKKrrceZdZdZdS) CoversLookupcoversNrrrrrrKKKrrceZdZdZdS) CrossesLookupcrossesNrrrrrrKKKrrceZdZdZdS)DisjointLookupdisjointNrrrrrrrrrceZdZdZdS) EqualsLookupequalsNrrrrrrrrrceZdZdZdS)IntersectsLookup intersectsNrrrrrrsKKKrrceZdZdZdS)OverlapsLookupoverlapsNrrrrrr rrrc<eZdZdZdZedZfdZxZS) RelateLookupr*z%(func)s(%(lhs)s, %(rhs)s, %%s)z ^[012TF*]{9}$ct|jd}|jj|j}t |dr||nAt |tr|j |std|zt ||\}}|||gzfS)Nrcheck_relate_argumentz)Invalid intersection matrix pattern "%s".) r"r9rEr/hasattrrrstr pattern_regexmatchr1r#r>)rrrpattern backend_opsqlparamsr(s rr>zRelateLookup.process_rhss/!$^1$2BC :6 7 7 T  , ,W 5 5 5 5GS)) T1C1I1I'1R1R TH7RSS Sgg))(J?? VFgY&&&r) rrrr/rNr rr>rQrRs@rrrsSK4L$$%566M ' ' ' ' ' ' ' ' 'rrceZdZdZdS) TouchesLookuptouchesNrrrrrr"rrrceZdZdZdS) WithinLookupwithinNrrrrrr'rrrc"eZdZdZdZdZdZdS)DistanceLookupBaseTz+%(func)s(%(lhs)s, %(rhs)s) %(op)s %(value)schdt|jcxkrdksntd|jzt|jdkr |jddkrtdt|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.r"r1r/r0r2s rr&z%DistanceLookupBase.process_rhs_params0sC((----A----DtGWW  ! !Q & &4?1+=+K+K  t  ! # #(:j(H(H  % % ' ' ' ' ' $ #(H(Hrc|jd}t|dr-|||jn1d|j|jj|j|j fS)Nrr?r8) r"rrr?r@r9 get_distancerrBr/)rrr dist_params rprocess_distancez#DistanceLookupBase.process_distance?s{_Q' z#788 H  Z::8>JJ K K K++H)4?D)rrrdist_sql dist_paramsrKrr(s rr>zDWithinLookup.process_rhs_sW $ 5 5h K K+(0W%''--h CC,,,r)rrrr/rNrr>rQrRs@rrrMs[K:L > > > > >---------rrceZdZdZdS)DistanceLookupFromFunctionc^t|jdko|jddkpd}|j|j|j|}|||j\}}| ||\}}d||j |dz||zfS)Nr+r)rz%(func)s %(op)s %(dist)s)funcopdist) r.r"r9distance_expr_for_lookuprr'rr?r@rr) rrrr distance_exprrrrrs rrz!DistanceLookupFromFunction.as_sqlgs  A % K$/"*=*K  #?? Hdh@  &&}'G'G'W'WXX V $ 5 5h K K+ &#TWh)W)W W [   rNrrrrrrfs#      rrceZdZdZdZdS)DistanceGTLookup distance_gt>Nrrrr/rrrrrrvK BBBrrceZdZdZdZdS)DistanceGTELookup distance_gtez>=Nrrrrrr| K BBBrrceZdZdZdZdS)DistanceLTLookup distance_ltrs@@@@@@//////''''''::::::::::,,,,,,666666*****)*** LLLLLLLLLLLLLLLLh!""""""""!"!#####)##"!#!#####)##"!#!#####)##"!#!"!!)"!!#####)##"!#!#####)##"!#!9"!! w777!y"!!y"!!i"!!Y"!!&&&&&Y&&"!&!i"!!9"!!I"!!Y"!!9"!!y"!!Y"!!'''''9''"!'"!I"!!9"!        B!-----&--"!-0      !3    !     1  "! !2"! !     1  "! !2"!r