/usr/local/lib/python3.9/site-packages/django/contrib/gis/db/backends/postgis/__pycache__
a Ӱ�h�@ � @ s* d dl Z d dlmZ d dlmZ d dlmZ d dlmZm Z d dl m Z d dl m Z d dlmZ d d lmZ d d lmZ d d lmZmZ d d lmZ d d lmZ d dlm Z m Z d dl m Z d dl m!Z! ddl"m#Z# ddl$m%Z%m&Z& ddl'm(Z( dZ)G dd� de�Z*G dd� de �Z+G dd� dee�Z,dS ) � N)�settings)�BaseSpatialOperations)�SpatialOperator)� GeometryField� RasterField)� GDALRaster)�GEOSGeometryBase)�wkb_r)�Distance)�ImproperlyConfigured)�NotSupportedError�ProgrammingError)�DatabaseOperations)� is_psycopg3)�Func�Value)�cached_property)�get_version_tuple� )�PostGISAdapter)�PostGISGeometryColumns�PostGISSpatialRefSys�� from_pgrasterZ bilateralc s: e Zd Zd � fdd� Z� fdd�Zdd� Zdd � Z� ZS ) �PostGISOperatorFc s" || _ || _t� jf i |�� d S �N)� geography�raster�super�__init__)�selfr r �kwargs�� __class__� �[/usr/local/lib/python3.9/site-packages/django/contrib/gis/db/backends/postgis/operations.pyr s zPostGISOperator.__init__c s0 | � ||�}| �||�}t� j|||g|�R � S r )� check_raster�check_geographyr �as_sql)r � connection�lookup�template_params�argsr" r$ r% r( ( s zPostGISOperator.as_sqlc C s |j o|j d dk}|jjjdk}t|jt�}|jd ur`|r`| jsJt d��d|d |jf |d< |j d ur�|r�| js|t d��d|d |j f |d< | j r�|r�|r�d|d |d< |r�d|d |d< nB| j t k�r|r�|s�d|d |d< n |�r|�sd|d |d< |S ) N����spheroid�RASTERzFBand indices are not allowed for this operator, it works on bbox only.z%s, %s�lhs�rhszST_Polygon(%s)) Z rhs_paramsr0 �field� geom_type� isinstancer1 r Zband_lhs�func� ValueErrorZband_rhsr � BILATERAL)r r* r+ r. Z lhs_is_rasterZ rhs_is_rasterr$ r$ r% r& - s@ �� �� z PostGISOperator.check_rasterc C s$ |j jjr | js |d d7 < |S )z9Convert geography fields to geometry types, if necessary.r0 z ::geometry)r0 � output_fieldr )r r* r+ r$ r$ r% r' \ s z PostGISOperator.check_geography)FF)�__name__� __module__� __qualname__r r( r& r' � __classcell__r$ r$ r" r% r s /r c s, e Zd Zd Z� fdd�Zedd� �Z� ZS )� ST_Polygonc sH t � �|� | jd }t|t�rD|jsDt|jt|jjd�d�| jd< d S )Nr ��srid)r8 ) r r �source_expressionsr4 r Z_output_field_or_none�valuer r? )r �exprr" r$ r% r f s �zST_Polygon.__init__c C s t | jd jjd�S )Nr r> )r r@ r2 r? �r r$ r$ r% r8 n s zST_Polygon.output_field)r9 r: r; �functionr r r8 r< r$ r$ r" r% r= c s r= c s: e Zd ZdZdZdZeZed Zed Z ed Z ed Z ed Z ed Z ed Zed dd �ed ddd�eddd �eded �eded �edd�edd�edd�edd�edd�edd�eded �eded �eded�ed ed�ed ded �ed ded �ed d!�ed"ed�ed#d!�ed$ded �ed%ed�ed&d!�ed'ed�ed(ed�ed)ded �d*�Ze� Ze�rbd+nd,Zd-Zed.d/� �Zed0d1� �Zd2d3� Zd4d5� Zd6d7� Z d8d9� Z d:d;� Z d<d=� Z d>d?� Z d@dA� Z!dBdC� Z"dDdE� Z#dFdG� Z$dHdI� Z%dJdK� Z&dLdM� Z'dNdO� Z(dPdQ� Z)dRdS� Z*� fdTdU�Z+e,dVdW� �Z-dXdY� Z.dZd[� Z/� Z0S )\�PostGISOperations�postgisTZST_ZCollectZExtentZ3DExtentZ3DLengthZMakeLineZ 3DPerimeter�Union�~)�opr z&&)rI r r �@z&<z&>z&<|)rI z|&>z<<z>>z<<|z|>>z~=Z ST_Contains)r5 r ZST_ContainsProperlyZ ST_CoveredBy)r5 r r Z ST_CoversZ ST_Crosses)r5 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_above�left�rightZstrictly_belowZstrictly_aboveZsame_as�exact�containsZcontains_properlyZ coveredbyZcoversZcrossesZdisjoint�equalsZ intersects�overlapsZrelateZtouchesZwithin�dwithin�%sz %s::byteaNc C s ddddddd�}|S )NZ ST_AsBinaryZ ST_AsTextZST_MinimumBoundingCircleZST_GeomFromWKBZST_GeomFromTextZ ST_NPoints)ZAsWKBZAsWKTZBoundingCircleZFromWKBZFromWKTZ NumPointsr$ )r �function_namesr$ r$ r% rS � s �z PostGISOperations.function_namesc C s` t td�rtj}nJ| �d� z | �� }W n& tyN td| jjd ��Y n0 |dd� }|S )z-Determine the version of the PostGIS library.�POSTGIS_VERSION�versionz�Cannot determine PostGIS version for database "%s" using command "SELECT postgis_lib_version()". GeoDjango requires at least PostGIS version 2.5. Was the database created from a spatial database template?�NAMEr N) �hasattrr rT �_get_postgis_func�postgis_version_tupler r r) Z settings_dict)r rU Zvtupr$ r$ r% �spatial_version� s �� z!PostGISOperations.spatial_versionc C sR |du r dS |dd� � d�\}}tt|� � �\}}tt|� � �\}}||||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)". N� r- �,��split�map�float)r �box�ll�ur�xmin�ymin�xmax�ymaxr$ r$ r% �convert_extent� s z PostGISOperations.convert_extentc C sZ |du r dS |dd� � d�\}}tt|� � �\}}}tt|� � �\}}} |||||| 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)". N� r- r\ r] ) r Zbox3drb rc rd re Zzminrf rg Zzmaxr$ r$ r% �convert_extent3d� s z"PostGISOperations.convert_extent3dc C sb |j dkrdS |jdkr$|j d }n|j }|jrP|jdkrBtd��d||jf S d||jf S d S ) zM Return the database field type for the given spatial field. r/ r � �Zi� z=PostGIS only supports geography columns with an SRID of 4326.zgeography(%s,%d)zgeometry(%s,%d)N)r3 �dimr r? r )r �fr3 r$ r$ r% � geo_db_type� s �z PostGISOperations.geo_db_typec C sp |d }|� | j�}|j}t|t�rf|r0|j}qj|rL|dkrDtd��|j}qjt|t�|� | 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. r rQ zNOnly numeric values of degree units are allowed on geographic DWithin queries.) �geodeticr) r r4 r �mr6 �getattrZ unit_attnameZ units_name)r rn Zdist_valZ lookup_typerA rp r Z dist_paramr$ r$ r% � get_distance s" ��z PostGISOperations.get_distancec C sx | � d�}t|d�r:|jj|jkr(d}nd||jf }|S |du rHd}n|j}|du s`||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( rR z %s(%%s, %s)N)Zspatial_function_namerW r2 r? )r rn rA �compilerZtransform_func� placeholderZ value_sridr$ r$ r% �get_geom_placeholder+ s z&PostGISOperations.get_geom_placeholderc C sH | j �� �*}|�d| � |�� d W d � S 1 s:0 Y dS )zZ Helper routine for calling PostGIS functions and returning their result. z SELECT %s()r N)r) Ztemporary_connection�executeZfetchone)r r5 �cursorr$ r$ r% rX H s z#PostGISOperations._get_postgis_funcc C s | � d�S )z9Return the version of the GEOS library used with PostGIS.�postgis_geos_version�rX rC r$ r$ r% ry Q s z&PostGISOperations.postgis_geos_versionc C s | � d�S )zFReturn the version number of the PostGIS library used with PostgreSQL.�postgis_lib_versionrz rC r$ r$ r% r{ U s z%PostGISOperations.postgis_lib_versionc C s | � d�S )z9Return the version of the PROJ library used with PostGIS.�postgis_proj_versionrz rC r$ r$ r% r| Y s z&PostGISOperations.postgis_proj_versionc C s | � d�S )�7Return PostGIS version number and compile-time options.�postgis_versionrz rC r$ r$ r% r~ ] s z!PostGISOperations.postgis_versionc C s | � d�S )r} �postgis_full_versionrz rC r$ r$ r% r a s z&PostGISOperations.postgis_full_versionc C s | � � }|ft|� S )zi Return the PostGIS version as a tuple (version string, major, minor, subminor). )r{ r )r rU r$ r$ r% rY e s z'PostGISOperations.postgis_version_tuplec C s> t �d�}| �� }|�|�}|r2ttt|�� ��S td��dS )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) �re�compiler| �search�tupler_ �int�groups� Exception)r Z proj_regexZ proj_ver_strrq r$ r$ r% �proj_version_tuplem s z$PostGISOperations.proj_version_tuplec C s |dkr| j S | j| S d S )NZExtent3D)�extent3d�geom_func_prefix)r Zagg_namer$ r$ r% �spatial_aggregate_namez s z(PostGISOperations.spatial_aggregate_namec C s t S r )r rC r$ r$ r% �geometry_columns� s z"PostGISOperations.geometry_columnsc C s t S r )r rC r$ r$ r% �spatial_ref_sys� s z!PostGISOperations.spatial_ref_sysc C s t |�S )z@Convert a PostGIS HEX String into a dict readable by GDALRaster.r )r rA r$ r$ r% � parse_raster� s z PostGISOperations.parse_rasterc s" t � j| �|�| �|�fi |��S r )r �distance_expr_for_lookup� _normalize_distance_lookup_arg)r r0 r1 r! r" r$ r% r� � s ��z*PostGISOperations.distance_expr_for_lookupc C s0 t | d�r| jjdknt| t�}|r,t| �S | S )Nr2 r/ )rW r2 r3 r4 r r= )�argZ is_rasterr$ r$ r% r� � s ��z0PostGISOperations._normalize_distance_lookup_argc s" t � j�|jj� � �fdd�}|S )Nc s. t | t�r| �d�} | d u r d S t�| �� �S )N�ascii)r4 �str�encoder )rA � expressionr) �� geom_class�readr$ r% � converter� s z;PostGISOperations.get_geometry_converter.<locals>.converter)r r� r8 r� )r r� r� r$ r� r% �get_geometry_converter� s z(PostGISOperations.get_geometry_converterc C s dS )NZsq_mr$ )r r2 r$ r$ r% �get_area_att_for_field� s z(PostGISOperations.get_area_att_for_field)1r9 r: r; �namerF r� r ZAdapterZcollectZextentr� Zlength3dZmakelineZ perimeter3dZunionaggr r7 Z gis_operators�setZunsupported_functionsr �selectZ select_extentr rS rZ rh rj ro rs rv rX ry r{ r| r~ r rY r� r� r� r� r� r� � staticmethodr� r� r� r< r$ r$ r" r% rE s s� �� � �# % rE )-r� Z django.confr Z.django.contrib.gis.db.backends.base.operationsr Z$django.contrib.gis.db.backends.utilsr Z django.contrib.gis.db.modelsr r Zdjango.contrib.gis.gdalr Z django.contrib.gis.geos.geometryr Z%django.contrib.gis.geos.prototypes.ior Zdjango.contrib.gis.measurer Zdjango.core.exceptionsr Z django.dbr r Z(django.db.backends.postgresql.operationsr Z)django.db.backends.postgresql.psycopg_anyr Zdjango.db.modelsr r Zdjango.utils.functionalr Zdjango.utils.versionr �adapterr �modelsr r Zpgrasterr r7 r r= rE r$ r$ r$ r% �<module> s, H
.
Edit
..
Edit
__init__.cpython-39.pyc
Edit
adapter.cpython-39.pyc
Edit
base.cpython-39.pyc
Edit
const.cpython-39.pyc
Edit
features.cpython-39.pyc
Edit
introspection.cpython-39.pyc
Edit
models.cpython-39.pyc
Edit
operations.cpython-39.pyc
Edit
pgraster.cpython-39.pyc
Edit
schema.cpython-39.pyc
Edit