3 g,@sddlmZddlmZddlmZddlmZmZm Z ddl m Z ddl m Z Gddde ZGd d d eZejGd d d eZejGd ddeZejGdddeZejGdddeZejGdddeZejGdddeZejGdddeZejGdddeZejGdddeZejedejGdddeZejGd 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 |j|jS)N)compilelhs)selfcompiler connectionrb/var/www/tester-filtro-web/env/lib/python3.6/site-packages/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^}|_tj||i|_|jdS)N) isinstancelisttuple rhs_paramssuper__init__template_paramsprocess_rhs_params)r r rhs) __class__rrrszGISLookup.__init__cCsf|jrJt|j|jdkrdndkr,|jqbt|jdkrbtd|jnt|jtrb|jdddS)NrelatezTuple too long for lookup %s.T)only_lhs)rlen lookup_nameprocess_band_indices ValueErrorrr r )r rrrrs  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)r r$rrrr'%s zGISLookup.process_band_indicescCsd|jj|gfS)Nz%s)opsZAdapter)r valuerrrrget_db_prep_lookup8szGISLookup.get_db_prep_lookupcsjt|jtrtj||St|jtr6|jj|j|_tj||\}}|jj |j j |j|}|||fS)N) rrrr process_rhsrresolve_expressionqueryr+Zget_geom_placeholderr output_field)r rrrr placeholder)r rrr.<s  zGISLookup.process_rhscCs|jj|jS)N)r+ gis_operatorsr&)r rrrrr get_rhs_opFszGISLookup.get_rhs_opc CsV|j||\}}|j||\}}||}||dd|j}|j||} | j||||S)Nz%s)r rr,)Z process_lhsr.rr4r) r rrZlhs_sqlZ lhs_paramsrhs_sqlrZ sql_paramsrZrhs_oprrrrLs  zGISLookup.as_sql)F)rrr sql_templateZtransform_funcdistancer)r*rrr'r-r.r4r __classcell__rr)r 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_leftN)rrr__doc__r&rrrrr9Zsr9c@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_rightN)rrrr:r&rrrrr;csr;c@seZdZdZdZdS)OverlapsBelowLookupzs The 'overlaps_below' operator returns true if A's bounding box overlaps or is below B's bounding box. Zoverlaps_belowN)rrrr:r&rrrrr<lsr<c@seZdZdZdZdS)OverlapsAboveLookupzs The 'overlaps_above' operator returns true if A's bounding box overlaps or is above B's bounding box. Zoverlaps_aboveN)rrrr:r&rrrrr=usr=c@seZdZdZdZdS) LeftLookupzo The 'left' operator returns true if A's bounding box is strictly to the left of B's bounding box. leftN)rrrr:r&rrrrr>~sr>c@seZdZdZdZdS) RightLookupzq The 'right' operator returns true if A's bounding box is strictly to the right of B's bounding box. rightN)rrrr:r&rrrrr@sr@c@seZdZdZdZdS)StrictlyBelowLookupzp The 'strictly_below' operator returns true if A's bounding box is strictly below B's bounding box. Zstrictly_belowN)rrrr:r&rrrrrBsrBc@seZdZdZdZdS)StrictlyAboveLookupzp The 'strictly_above' operator returns true if A's bounding box is strictly above B's bounding box. Zstrictly_aboveN)rrrr:r&rrrrrCsrCc@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_asN)rrrr:r&rrrrrDsrDexactc@seZdZdZdZdS)BBContainsLookupzq The 'bbcontains' operator returns true if A's bounding box completely contains by B's bounding box. Z bbcontainsN)rrrr:r&rrrrrFsrFc@seZdZdZdZdS)BBOverlapsLookupz_ The 'bboverlaps' operator returns true if A's bounding box overlaps B's bounding box. Z bboverlapsN)rrrr:r&rrrrrGsrGc@seZdZdZdZdS)ContainedLookupzt The 'contained' operator returns true if A's bounding box is completely contained by B's bounding box. Z containedN)rrrr:r&rrrrrHsrHc@seZdZdZdS)ContainsLookupcontainsN)rrrr&rrrrrIsrIc@seZdZdZdS)ContainsProperlyLookupZcontains_properlyN)rrrr&rrrrrKsrKc@seZdZdZdS)CoveredByLookupZ coveredbyN)rrrr&rrrrrLsrLc@seZdZdZdS) CoversLookupZcoversN)rrrr&rrrrrMsrMc@seZdZdZdS) CrossesLookupZcrossesN)rrrr&rrrrrNsrNc@seZdZdZdS)DisjointLookupZdisjointN)rrrr&rrrrrOsrOc@seZdZdZdS) EqualsLookupequalsN)rrrr&rrrrrPsrPc@seZdZdZdS)IntersectsLookupZ intersectsN)rrrr&rrrrrRsrRc@seZdZdZdS)OverlapsLookupoverlapsN)rrrr&rrrrrSsrScs,eZdZdZdZedZfddZZS) RelateLookupr!z%(func)s(%(lhs)s, %(rhs)s, %%s)z^[012TF\*]{9}$cst|jd}|jj|j}t|dr.|j|n&t|t sH|jj | rTt d|t j ||\}}|||gfS)Nrcheck_relate_argumentz)Invalid intersection matrix pattern "%s".) rr+r3r&hasattrrVrstr pattern_regexmatchr(rr.)r rrpatternZ backend_opsqlparams)r rrr.s    zRelateLookup.process_rhs) rrrr&r6r rYr.r8rr)r rrUsrUc@seZdZdZdS) TouchesLookupZtouchesN)rrrr&rrrrr^ sr^c@seZdZdZdS) WithinLookupZwithinN)rrrr&rrrrr_sr_c@s$eZdZdZdZddZddZdS)DistanceLookupBaseTz+%(func)s(%(lhs)s, %(rhs)s) %(op)s %(value)scCszdt|jkodkns.td|jn$t|jdkrR|jddkrRtdt|jdkrv|jddkrv|jdS)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&|j|j|jSd|jj|jj|j|j fS)Nrr/z%s) rrWr r/r0r+Z get_distancer r1r&)r rr dist_paramrrrprocess_distance$s z#DistanceLookupBase.process_distanceN)rrrr7r6rrdrrrrr`s r`cs0eZdZdZdZfddZfddZZS) DWithinLookupZdwithinz%%(func)s(%(lhs)s, %(rhs)s, %(value)s)cs@|jd}|jj r2t|dr2t|t r2tdtj||S)Nrr/zXThis backend does not support expressions for specifying distance in the dwithin lookup.) rfeaturesZsupports_dwithin_distance_exprrWrrrrrd)r rrrc)r rrrd2s    zDWithinLookup.process_distancecs8|j||\}}||jd<tj||\}}|||fS)Nr,)rdrrr.)r rrdist_sql dist_paramsr5r])r rrr.?s zDWithinLookup.process_rhs)rrrr&r6rdr.r8rr)r rre-s rec@seZdZddZdS)DistanceLookupFromFunctionc Csvt|jdkr|jddkpd}|jj|j|j|d}|j|j|j\}}|j ||\}}d||j |d||fS)Nr"r#rb)rbz%(func)s %(op)s %(dist)s)funcopdist) r%rr+Zdistance_expr_for_lookupr rr r/r0rdrk) r rrrbZ distance_exprr\r]rgrhrrrrGs  z!DistanceLookupFromFunction.as_sqlN)rrrrrrrrriFsric@seZdZdZdZdS)DistanceGTLookupZ distance_gt>N)rrrr&rkrrrrrnRsrnc@seZdZdZdZdS)DistanceGTELookupZ distance_gtez>=N)rrrr&rkrrrrrpXsrpc@seZdZdZdZdS)DistanceLTLookupZ distance_ltr@rBrCrDrFrGrHrIrKrLrMrNrOrPrRrSrUr^r_r`rerirnrprqrsrrrrs     L