o i.@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@eZdZddZdS)RasterBandTransformcCs ||jSN)compilelhs)selfcompiler connectionrjC:\Users\psant\Downloads\PAF backend\school\venv\Lib\site-packages\django/contrib/gis/db/models/lookups.pyas_sql s zRasterBandTransform.as_sqlN__name__ __module__ __qualname__rrrrrr  r 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)rrrhs __class__rrr s 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 ValueErrorrrr rrrrr"s  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_rhsrZ band_indexband_lhsrr r)rr)rrrr,%s zGISLookup.process_band_indicescCsd|j|gfS)N%s)opsZAdapter)rvaluerrrrget_db_prep_lookup8szGISLookup.get_db_prep_lookupcsjt|jtr t||St|jtr|j|j|_t||\}}|j |j j |j|}|||fSr ) rr#rr process_rhsrresolve_expressionqueryr2Zget_geom_placeholderr output_field)rrrr#r placeholderr$rrr5<s    zGISLookup.process_rhscCs|jj|jSr )r2 gis_operatorsr+)rrr#rrr get_rhs_opHszGISLookup.get_rhs_opc Cs\|||\}}|||\}}g||R}||dd|j}|||} | ||||S)Nr1)rr#r3)Z process_lhsr5r!r;r) rrrZlhs_sqlZ lhs_paramsrhs_sqlrZ sql_paramsr!Zrhs_oprrrrNs zGISLookup.as_sql)F)rrr sql_templateZtransform_funcdistancer/r0r r"r,r4r5r;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. Z overlaps_leftNrrr__doc__r+rrrrrAbrAc@r@)OverlapsRightLookupz} The 'overlaps_right' operator returns true if A's bounding box overlaps or is to the right of B's bounding box. Zoverlaps_rightNrBrrrrrElrDrEc@r@)OverlapsBelowLookupzs The 'overlaps_below' operator returns true if A's bounding box overlaps or is below B's bounding box. Zoverlaps_belowNrBrrrrrFvrDrFc@r@)OverlapsAboveLookupzs The 'overlaps_above' operator returns true if A's bounding box overlaps or is above B's bounding box. Zoverlaps_aboveNrBrrrrrGrDrGc@r@) LeftLookupzo The 'left' operator returns true if A's bounding box is strictly to the left of B's bounding box. leftNrBrrrrrHrDrHc@r@) RightLookupzq The 'right' operator returns true if A's bounding box is strictly to the right of B's bounding box. rightNrBrrrrrJrDrJc@r@)StrictlyBelowLookupzp The 'strictly_below' operator returns true if A's bounding box is strictly below B's bounding box. Zstrictly_belowNrBrrrrrLrDrLc@r@)StrictlyAboveLookupzp The 'strictly_above' operator returns true if A's bounding box is strictly above B's bounding box. Zstrictly_aboveNrBrrrrrMrDrMc@r@) 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_asNrBrrrrrNsrNexactc@r@)BBContainsLookupzq The 'bbcontains' operator returns true if A's bounding box completely contains by B's bounding box. Z bbcontainsNrBrrrrrPrDrPc@r@)BBOverlapsLookupzc The 'bboverlaps' operator returns true if A's bounding box overlaps B's bounding box. Z bboverlapsNrBrrrrrQrDrQc@r@)ContainedLookupzt The 'contained' operator returns true if A's bounding box is completely contained by B's bounding box. Z containedNrBrrrrrRrDrRc@eZdZdZdS)ContainsLookupcontainsNrrrr+rrrrrTrTc@rS)ContainsProperlyLookupZcontains_properlyNrVrrrrrXrWrXc@rS)CoveredByLookupZ coveredbyNrVrrrrrYrWrYc@rS) CoversLookupZcoversNrVrrrrrZrWrZc@rS) CrossesLookupZcrossesNrVrrrrr[rWr[c@rS)DisjointLookupZdisjointNrVrrrrr\rWr\c@rS) EqualsLookupequalsNrVrrrrr]rWr]c@rS)IntersectsLookupZ intersectsNrVrrrrr_rWr_c@rS)OverlapsLookupoverlapsNrVrrrrr` rWr`cs,eZdZdZdZedZfddZZS) RelateLookupr&z%(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".) rr2r:r+hasattrrcrstr pattern_regexmatchr-rr5)rrrpatternZ backend_opsqlparamsr$rrr5s    zRelateLookup.process_rhs) rrrr+r=r rfr5r?rrr$rrbs rbc@rS) TouchesLookupZtouchesNrVrrrrrk"rWrkc@rS) WithinLookupZwithinNrVrrrrrl'rWrlc@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.rrrr"0s z%DistanceLookupBase.process_rhs_paramscCsB|jd}t|dr|||jSd|j|jj|j|j fS)Nrr6r1) rrdr r6r7r2Z get_distancerr8r+rrrZ dist_paramrrrprocess_distance?s z#DistanceLookupBase.process_distanceN)rrrr>r=r"rqrrrrrm,s  rmcs0eZdZdZdZfddZfddZZS) DWithinLookupZdwithinz%%(func)s(%(lhs)s, %(rhs)s, %(value)s)cs<|jd}|jjst|drt|tstdt||S)Nrr6zXThis backend does not support expressions for specifying distance in the dwithin lookup.) rfeaturesZsupports_dwithin_distance_exprrdrrrrrqrpr$rrrqRs zDWithinLookup.process_distancecs8|||\}}||jd<t||\}}|||fS)Nr3)rqr!rr5)rrrdist_sql dist_paramsr<rjr$rrr5_s  zDWithinLookup.process_rhs)rrrr+r=rqr5r?rrr$rrrMs   rrc@r )DistanceLookupFromFunctionc Csvt|jdko |jddkpd}|jj|j|j|d}|||j\}}| ||\}}d||j |d||fS)Nr'ro)roz%(func)s %(op)s %(dist)s)funcopdist) r*rr2Zdistance_expr_for_lookuprr#r r6r7rqry) rrrroZ distance_exprrirjrtrurrrrgs z!DistanceLookupFromFunction.as_sqlNrrrrrrvfrrvc@r@)DistanceGTLookupZ distance_gt>Nrrrr+ryrrrrr{vr{c@r@)DistanceGTELookupZ distance_gtez>=Nr}rrrrr|r~rc@r@)DistanceLTLookupZ distance_lts    T           !