File manager - Edit - /usr/local/CyberCP/lib/python3.10/site-packages/django/contrib/gis/db/backends/postgis/__pycache__/operations.cpython-310.pyc
Back
o �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_pgraster� bilateralc s: e Zd Zd � fdd� Z� fdd�Zdd� Zdd � Z� ZS ) �PostGISOperatorFc s" || _ || _t� jdi |�� d S )N� )� geography�raster�super�__init__)�selfr r �kwargs�� __class__r �d/usr/local/CyberCP/lib/python3.10/site-packages/django/contrib/gis/db/backends/postgis/operations.pyr s zPostGISOperator.__init__c s0 | � ||�}| �||�}t� j|||g|�R � S �N)� 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 ur0|r0| js%t d��d|d |jf |d< |j d urI|rI| js>t d��d|d |j f |d< | j rN|rd|rXd|d |d< |rbd|d |d< |S | j t kr�|rw|swd|d |d< |S |r�|s�d|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)) � rhs_paramsr1 �field� geom_type� isinstancer2 r �band_lhs�func� ValueError�band_rhsr � BILATERAL)r! r+ r, r/ � lhs_is_raster� rhs_is_rasterr r r% r' - sD � �� � ��z PostGISOperator.check_rasterc C s$ |j jjr| js|d d7 < |S )z9Convert geography fields to geometry types, if necessary.r1 z ::geometry)r1 � 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 sP t � �|� | jd }t|t�r$|js&t|jt|jjd�d�| jd< d S d S d S )Nr ��srid)r> ) r r �source_expressionsr6 r �_output_field_or_none�valuer rE )r! �exprr# r r% r f s ��zST_Polygon.__init__c C s t | jd jjd�S )Nr rD )r rF r4 rE �r! r r r% r> n s zST_Polygon.output_field)r? r@ rA �functionr r r> rB r r r# r% rC c s rC c s� e Zd ZdZdZdZeZed Zed Z ed Z ed Z ed Z ed Z ed Zi d ed dd ��dedddd��deddd ��deded ��deded ��dedd��dedd��d ed d��d ed d��d ed!d��d"ed#d��d$ed%ed ��d&ed%ed ��d'ed(ed)��d*ed+ed)��d,ed-ded.��d/ed0ded.��ed1d2�ed3ed)�ed4d2�ed5ded.�ed6ed)�ed7d2�ed8ed)�ed9ed)�ed:ded.�d;� �Ze� Zer�d<nd=Zd>Zed?d@� �ZedAdB� �ZdCdD� ZdEdF� ZdGdH� Z dIdJ� Z dKdL� Z dMdN� Z dOdP� Z dQdR� Z!dSdT� Z"dUdV� Z#dWdX� Z$dYdZ� Z%d[d\� Z&d]d^� Z'd_d`� Z(dadb� Z)dcdd� Z*� fdedf�Z+e,dgdh� �Z-didj� Z.dkdl� Z/� Z0S )m�PostGISOperations�postgisT�ST_�Collect�Extent�3DExtent�3DLength�MakeLine� 3DPerimeter�Union� bbcontains�~)�opr � bboverlapsz&&)rX r r � contained�@� overlaps_leftz&<�overlaps_rightz&>�overlaps_belowz&<|)rX �overlaps_abovez|&>�leftz<<�rightz>>�strictly_belowz<<|�strictly_abovez|>>�same_asz~=�exact�contains� ST_Contains)r8 r �contains_properly�ST_ContainsProperly� coveredby� ST_CoveredBy)r8 r r �covers� ST_Covers� ST_Crosses)r8 � ST_Disjoint� ST_Equals� ST_Intersects� ST_Overlaps� ST_Relate� ST_Touches� ST_Within� ST_DWithin) �crosses�disjoint�equals� intersects�overlaps�relate�touches�within�dwithin�%sz %s::byteaNc C s ddddddd�}|S )N� ST_AsBinary� ST_AsText�ST_MinimumBoundingCircle�ST_GeomFromWKB�ST_GeomFromText� ST_NPoints)�AsWKB�AsWKT�BoundingCircle�FromWKB�FromWKT� NumPointsr )r! �function_namesr r r% r� � s �z PostGISOperations.function_namesc C s^ t td�r tj}|S | �d� z| �� }W n ty& td| jjd ��w |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 r� �_get_postgis_func�postgis_version_tupler r r* � settings_dict)r! r� �vtupr r r% �spatial_version� s � ��� z!PostGISOperations.spatial_versionc C sR |du rdS |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 rdS |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! �box3dr� r� r� r� �zminr� r� �zmaxr r r% �convert_extent3d� s z"PostGISOperations.convert_extent3dc C s^ |j dkrdS |jdkr|j d }n|j }|jr(|jdkr!td��d||jf S d||jf S ) zM Return the database field type for the given spatial field. r0 r � �Zi� z=PostGIS only supports geography columns with an SRID of 4326.zgeography(%s,%d)zgeometry(%s,%d))r5 �dimr rE r )r! �fr5 r r r% � geo_db_type� s �z PostGISOperations.geo_db_typec C s| |d }|� | j�}|j}t|t�r9|r|j}|gS |r*|dkr$td��|j}|gS t|t�|� | j���}|gS |}|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 r zNOnly numeric values of degree units are allowed on geographic DWithin queries.) �geodeticr* r r6 r �mr9 �getattr� unit_attname� units_name)r! r� �dist_val� lookup_typerH r� r � dist_paramr r r% � get_distance s( �� ���z PostGISOperations.get_distancec C s| | � d�}t|d�r |jj|jkrd}|S d||jf }|S |du r%d}n|j}|du s1||jkr5d}|S d||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. � Transformr) r� z %s(%%s, %s)N)�spatial_function_namer� r4 rE )r! r� rH �compiler�transform_func� placeholder� value_sridr r r% �get_geom_placeholder+ s ��z&PostGISOperations.get_geom_placeholderc C sH | j �� �}|�d| � |�� d W d � S 1 s w Y dS )zZ Helper routine for calling PostGIS functions and returning their result. z SELECT %s()r N)r* �temporary_connection�execute�fetchone)r! r8 �cursorr r r% r� H s $�z#PostGISOperations._get_postgis_funcc C � | � d�S )z9Return the version of the GEOS library used with PostGIS.�postgis_geos_version�r� rJ r r r% r� Q � z&PostGISOperations.postgis_geos_versionc C r� )zFReturn the version number of the PostGIS library used with PostgreSQL.�postgis_lib_versionr� rJ r r r% r� U r� z%PostGISOperations.postgis_lib_versionc C r� )z9Return the version of the PROJ library used with PostGIS.�postgis_proj_versionr� rJ r r r% r� Y r� z&PostGISOperations.postgis_proj_versionc C r� )�7Return PostGIS version number and compile-time options.�postgis_versionr� rJ r r r% r� ] r� z!PostGISOperations.postgis_versionc C r� )r� �postgis_full_versionr� rJ r r r% r� a r� 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! r� r r r% r� e s z'PostGISOperations.postgis_version_tuplec C s: t �d�}| �� }|�|�}|rttt|�� ��S td��)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.) �re�compiler� �search�tupler� �int�groups� Exception)r! � proj_regex� proj_ver_strr� r r r% �proj_version_tuplem s z$PostGISOperations.proj_version_tuplec C s |dkr| j S | j| S )N�Extent3D)�extent3d�geom_func_prefix)r! �agg_namer r r% �spatial_aggregate_namez s z(PostGISOperations.spatial_aggregate_namec C � t S r& )r rJ r r r% �geometry_columns� � z"PostGISOperations.geometry_columnsc C r� r& )r rJ r r r% �spatial_ref_sys� r� z!PostGISOperations.spatial_ref_sysc C s t |�S )z@Convert a PostGIS HEX String into a dict readable by GDALRaster.r )r! rH 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! r1 r2 r" r# r r% r� � s ��z*PostGISOperations.distance_expr_for_lookupc C s0 t | d�r | jjdknt| t�}|rt| �S | S )Nr4 r0 )r� r4 r5 r6 r rC )�arg� 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 rd S t�| �� �S )N�ascii)r6 �str�encoder )rH � expressionr* �� geom_class�readr r% � converter� s z;PostGISOperations.get_geometry_converter.<locals>.converter)r r� r> r� )r! r� r� r r� r% �get_geometry_converter� s z(PostGISOperations.get_geometry_converterc C s dS )N�sq_mr )r! r4 r r r% �get_area_att_for_field� r� z(PostGISOperations.get_area_att_for_field)1r? r@ rA �namerM r� r �Adapter�collect�extentr� �length3d�makeline� perimeter3d�unionaggr r; � gis_operators�set�unsupported_functionsr �select� select_extentr r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� � staticmethodr� r� r� rB r r r# r% rL s s� �� � � � � � � � � � � � ������ � �# % rL )-r� � django.confr �.django.contrib.gis.db.backends.base.operationsr �$django.contrib.gis.db.backends.utilsr � django.contrib.gis.db.modelsr r �django.contrib.gis.gdalr � django.contrib.gis.geos.geometryr �%django.contrib.gis.geos.prototypes.ior �django.contrib.gis.measurer �django.core.exceptionsr � django.dbr r �(django.db.backends.postgresql.operationsr �)django.db.backends.postgresql.psycopg_anyr �django.db.modelsr r �django.utils.functionalr �django.utils.versionr �adapterr �modelsr r �pgrasterr r; r rC rL r r r r% �<module> s. H
| ver. 1.4 |
Github
|
.
| PHP 8.2.28 | Generation time: 0.02 |
proxy
|
phpinfo
|
Settings