3 g=@sddlZddlmZddlmZddlmZddlmZm Z ddl m Z ddl m Z ddlmZdd lmZdd lmZdd lmZmZdd lmZdd lmZmZddlmZddlmZddl m!Z!ddl"m#Z#m$Z$ddl%m&Z&dZ'GdddeZ(GdddeZ)GdddeeZ*dS)N)settings)BaseSpatialOperations)SpatialOperator) GeometryField RasterField) GDALRaster)GEOSGeometryBase)wkb_r)Distance)ImproperlyConfigured)NotSupportedErrorProgrammingError)DatabaseOperations)FuncValue)cached_property)get_version_tuple)PostGISAdapter)PostGISGeometryColumnsPostGISSpatialRefSys) from_pgrasterZ bilateralcs2eZdZdfdd ZfddZddZZS) PostGISOperatorFc s||_||_tjf|dS)N) geographyrastersuper__init__)selfrrkwargs) __class__o/var/www/tester-filtro-web/env/lib/python3.6/site-packages/django/contrib/gis/db/backends/postgis/operations.pyrszPostGISOperator.__init__csJ|jjjr(|j r(td|jp |jf|j||}tj|||f|S)Nz>PostGIS geography does not support the "%s" function/operator.) lhs output_fieldr ValueErrorfuncop check_rasterras_sql)r connectionlookuptemplate_paramsargs)rr r!r((s  zPostGISOperator.as_sqlcCs|jo|jd dk}|jjjdk}t|jt}|jdk r`|r`|jsJt dd|d|jf|d<|j dk r|r|js|t dd|d|j f|d<|j s|r|rd|d|d<|rd|d|d<nD|j t kr |r| rd|d|d<n|o| r d|d|d<|S) NrspheroidRASTERzFBand indices are not allowed for this operator, it works on bbox only.z%s, %sr"rhszST_Polygon(%s)) Z rhs_paramsr"field geom_type isinstancer/rZband_lhsr%r$Zband_rhsr BILATERAL)rr*r+r-Z lhs_is_rasterZ rhs_is_rasterr r r!r'0s,     zPostGISOperator.check_raster)FF)__name__ __module__ __qualname__rr(r' __classcell__r r )rr!rs rcs,eZdZdZfddZeddZZS) ST_PolygoncsJtj||jd}t|trF|j rFt|jt|jjdd|jd<dS)Nr)srid)r#) rrsource_expressionsr3rZ_output_field_or_nonevaluerr:)rexpr)rr r!rWs  zST_Polygon.__init__cCst|jdjjdS)Nr)r:)rr;r1r:)rr r r!r#]szST_Polygon.output_field)r5r6r7functionrrr#r8r r )rr!r9Ts r9cs0eZdZdZdZdZeZedZedZ edZ edZ edZ ed Z ed Zed dd ed dddeddd eded eded eddeddeddeddeddeddeded eded edededededdededdeded d!ed"eded#d!ed$deded%eded&d!ed'eded(eded)dedd*ZeZd+Zd,Zed-d.Zed/d0Zd1d2Zd3d4Zd5d6Zd7d8Zd9d:Zd;d<Zd=d>Zd?d@Z dAdBZ!dCdDZ"dEdFZ#dGdHZ$dIdJZ%dKdLZ&dMdNZ'dOdPZ(dQdRZ)fdSdTZ*e+dUdVZ,dWdXZ-dYdZZ.Z/S)[PostGISOperationspostgisTZST_ZCollectZExtentZ3DExtentZ3DLengthZMakeLineZ 3DPerimeterUnion~)r&rz&&)r&rr@z&z&<|)r&z|&>z<>z<<|z|>>z~=Z ST_Contains)r%rZST_ContainsProperlyZ ST_CoveredBy)r%rrZ ST_CoversZ ST_Crosses)r%Z ST_DisjointZ ST_EqualsZ ST_IntersectsZ ST_OverlapsZ ST_RelateZ ST_TouchesZ ST_WithinZ ST_DWithin)Z bbcontainsZ bboverlapsZ containedZ overlaps_leftZoverlaps_rightZoverlaps_belowZoverlaps_aboveleftrightZstrictly_belowZstrictly_aboveZsame_asexactcontainsZcontains_properlyZ coveredbyZcoversZcrossesZdisjointequalsZ intersectsoverlapsZrelateZtouchesZwithindwithinz %s::byteaNcCs$ddddd}|jd kr d |d <|S) NZ ST_AsBinaryZ ST_AsTextZST_MinimumBoundingCircleZ ST_NPoints)ZAsWKBZAsWKTZBoundingCircleZ NumPointsrZ ST_ForceRHRZForcePolygonCW)rKrLr)spatial_version)rfunction_namesr r r!rNs z PostGISOperations.function_namesc Csbttdrtj}nL|jdy |j}Wn(tk rPtd|jjdYnX|dd}|S)z-Determine the version of the PostGIS library.POSTGIS_VERSIONversionzCannot determine PostGIS version for database "%s" using command "SELECT postgis_lib_version()". GeoDjango requires at least PostGIS version 2.3. Was the database created from a spatial database template?NAMErN) hasattrrrO_get_postgis_funcpostgis_version_tupler r r)Z settings_dict)rrPZvtupr r r!rMs    z!PostGISOperations.spatial_versioncCsR|dkr dS|ddjd\}}tt|j\}}tt|j\}}||||fS)z Return a 4-tuple extent for the `Extent` aggregate by converting the bounding box text returned by PostGIS (`box` argument), for example: "BOX(-90.0 30.0, -85.0 40.0)". NrLr,r0)splitmapfloat)rZboxllurxminyminxmaxymaxr r r!convert_extents z PostGISOperations.convert_extentc CsZ|dkr dS|ddjd\}}tt|j\}}}tt|j\}}} |||||| fS)z Return a 6-tuple extent for the `Extent3D` aggregate by converting the 3d bounding-box text returned by PostGIS (`box3d` argument), for example: "BOX3D(-90.0 30.0 1, -85.0 40.0 2)". NrrUr0)rVrWrX) rZbox3drYrZr[r\Zzminr]r^Zzmaxr r r!convert_extent3ds z"PostGISOperations.convert_extent3dcCsb|jdkrdS|jdkr$|jd}n|j}|jrP|jdkrBtdd||jfSd||jfSd S) zM Return the database field type for the given spatial field. r.rZiz=PostGIS only supports geography columns with an SRID of 4326.zgeography(%s,%d)zgeometry(%s,%d)N)r2Zdimrr:r )rfr2r r r! geo_db_types    zPostGISOperations.geo_db_typecCsp|d}|j|j}|j}t|trf|r0|j}qj|rL|dkrDtd|j}qjt|tj|j |j}n|}|gS)a Retrieve the distance parameters for the given geometry field, distance lookup value, and the distance lookup type. This is the most complex implementation of the spatial backends due to what is supported on geodetic geometry columns vs. what's available on projected geometry columns. In addition, it has to take into account the geography column type. rrJzNOnly numeric values of degree units are allowed on geographic DWithin queries.) geodeticr)rr3r mr$getattrZ unit_attnameZ units_name)rrdZdist_valZ lookup_typer<rfrZ dist_paramr r r! get_distances   zPostGISOperations.get_distancecCsx|jd}t|dr:|jj|jkr(d}nd||jf}|S|dkrHd}n|j}|dks`||jkrfd}nd||jf}|S)z Provide a proper substitution value for Geometries or rasters that are not in the SRID of the field. Specifically, this routine will substitute in the ST_Transform() function call. Z Transformr(z%sz %s(%%s, %s)N)Zspatial_function_namerRr1r:)rrdr<compilerZtransform_func placeholderZ value_sridr r r!get_geom_placeholder s  z&PostGISOperations.get_geom_placeholderc Cs0|jj}|jd||jdSQRXdS)zZ Helper routine for calling PostGIS functions and returning their result. z SELECT %s()rN)r)Ztemporary_connectionexecuteZfetchone)rr%cursorr r r!rS*s z#PostGISOperations._get_postgis_funccCs |jdS)z9Return the version of the GEOS library used with PostGIS.postgis_geos_version)rS)rr r r!ro3sz&PostGISOperations.postgis_geos_versioncCs |jdS)zFReturn the version number of the PostGIS library used with PostgreSQL.postgis_lib_version)rS)rr r r!rp7sz%PostGISOperations.postgis_lib_versioncCs |jdS)z9Return the version of the PROJ library used with PostGIS.postgis_proj_version)rS)rr r r!rq;sz&PostGISOperations.postgis_proj_versioncCs |jdS)z7Return PostGIS version number and compile-time options.postgis_version)rS)rr r r!rr?sz!PostGISOperations.postgis_versioncCs |jdS)z7Return PostGIS version number and compile-time options.postgis_full_version)rS)rr r r!rsCsz&PostGISOperations.postgis_full_versioncCs|j}|ft|S)zi Return the PostGIS version as a tuple (version string, major, minor, subminor). )rpr)rrPr r r!rTGsz'PostGISOperations.postgis_version_tuplecCs>tjd}|j}|j|}|r2ttt|jStddS)z Return the version of PROJ used by PostGIS as a tuple of the major, minor, and subminor release numbers. z(\d+)\.(\d+)\.(\d+)z.Could not determine PROJ version from PostGIS.N) recompilerqsearchtuplerWintgroups Exception)rZ proj_regexZ proj_ver_strrgr r r!proj_version_tupleOs   z$PostGISOperations.proj_version_tuplecCs|dkr|jS|j|SdS)NZExtent3D)extent3dgeom_func_prefix)rZagg_namer r r!spatial_aggregate_name\sz(PostGISOperations.spatial_aggregate_namecCstS)N)r)rr r r!geometry_columnscsz"PostGISOperations.geometry_columnscCstS)N)r)rr r r!spatial_ref_sysfsz!PostGISOperations.spatial_ref_syscCst|S)z@Convert a PostGIS HEX String into a dict readable by GDALRaster.)r)rr<r r r! parse_rasteriszPostGISOperations.parse_rasterc stj|j||j|f|S)N)rdistance_expr_for_lookup_normalize_distance_lookup_arg)rr"r/r)rr r!rms z*PostGISOperations.distance_expr_for_lookupcCs0t|dr|jjdknt|t}|r,t|S|S)Nr1r.)rRr1r2r3rr9)argZ is_rasterr r r!rts z0PostGISOperations._normalize_distance_lookup_argcs"tj|jjfdd}|S)Ncs|dkr dSt|S)N)r)r< expressionr)) geom_classreadr r! convertersz;PostGISOperations.get_geometry_converter..converter)r rr#r)rrrr )rrr!get_geometry_converter}sz(PostGISOperations.get_geometry_convertercCsdS)NZsq_mr )rr1r r r!get_area_att_for_fieldsz(PostGISOperations.get_area_att_for_field)0r5r6r7namer@r}rZAdapterZcollectZextentr|Zlength3dZmakelineZ perimeter3dZunionaggrr4Z gis_operatorssetZunsupported_functionsselectZ select_extentrrNrMr_rarerirlrSrorprqrrrsrTr{r~rrrr staticmethodrrrr8r r )rr!r?bs~                   !    r?)+rtZ django.confrZ.django.contrib.gis.db.backends.base.operationsrZ$django.contrib.gis.db.backends.utilsrZdjango.contrib.gis.db.modelsrrZdjango.contrib.gis.gdalrZ django.contrib.gis.geos.geometryrZ%django.contrib.gis.geos.prototypes.ior Zdjango.contrib.gis.measurer Zdjango.core.exceptionsr Z django.dbr r Z(django.db.backends.postgresql.operationsrZdjango.db.modelsrrZdjango.utils.functionalrZdjango.utils.versionradapterrmodelsrrZpgrasterrr4rr9r?r r r r!s*             8