|
Server : Apache System : Linux cvar2.toservers.com 3.10.0-962.3.2.lve1.5.73.el7.x86_64 #1 SMP Wed Aug 24 21:31:23 UTC 2022 x86_64 User : njnconst ( 1116) PHP Version : 8.4.18 Disable Function : NONE Directory : /usr/lib64/python2.7/site-packages/django/contrib/gis/db/backends/postgis/ |
Upload File : |
�
r�\c @ s� d d l Z d d l m Z d d l m Z d d l m Z d d l m Z m Z d d l
m Z d d l m
Z
d d l m Z d d l m Z d d
l m Z d d l m Z d d l m Z d d
l m Z d d l m Z m Z d e f d � � YZ d e f d � � YZ d e f d � � YZ d e f d � � YZ d e f d � � YZ! d e f d � � YZ" d e f d � � YZ# d e e f d � � YZ$ d S( i����N( t Decimal( t settings( t BaseSpatialOperations( t SpatialOperationt SpatialFunction( t PostGISAdapter( t Geometry( t Distance( t ImproperlyConfigured( t DatabaseOperations( t
DatabaseError( t six( t cached_propertyi ( t GeometryColumnst
SpatialRefSyst PostGISOperatorc B s e Z d Z d � Z RS( s' For PostGIS operators (e.g. `&&`, `~`).c C s t t | � j d | � d S( Nt operator( t superR t __init__( t selfR ( ( sS /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/backends/postgis/operations.pyR s ( t __name__t
__module__t __doc__R ( ( ( sS /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/backends/postgis/operations.pyR s t PostGISFunctionc B s e Z d Z d � Z RS( s> For PostGIS function calls (e.g., `ST_Contains(table, geom)`).c K s! t t | � j | | | � d S( N( R R R ( R t prefixt functiont kwargs( ( sS /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/backends/postgis/operations.pyR s ( R R R R ( ( ( sS /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/backends/postgis/operations.pyR s t PostGISFunctionParamc B s e Z d Z d Z RS( sI For PostGIS functions that take another parameter (e.g. DWithin, Relate).s, %(function)s(%(geo_col)s, %(geometry)s, %%s)( R R R t sql_template( ( ( sS /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/backends/postgis/operations.pyR s t PostGISDistancec B s# e Z d Z d Z d Z d � Z RS( s For PostGIS distance operations.R s8 %(function)s(%(geo_col)s, %(geometry)s) %(operator)s %%sc C s& t t | � j | | j d | �d S( NR ( R R R t dist_func( R R R ( ( sS /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/backends/postgis/operations.pyR ' s ( R R R R R R ( ( ( sS /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/backends/postgis/operations.pyR " s t PostGISSpheroidDistancec B s# e Z d Z d Z d Z d � Z RS( s? For PostGIS spherical distance operations (using the spheroid).t distance_spheroids= %(function)s(%(geo_col)s, %(geometry)s, %%s) %(operator)s %%sc C s& t t | � j | | j d | �d S( NR ( R R R R ( R R R ( ( sS /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/backends/postgis/operations.pyR / s ( R R R R R R ( ( ( sS /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/backends/postgis/operations.pyR + s t PostGISSphereDistancec B s e Z d Z d Z RS( s* For PostGIS spherical distance operations.t distance_sphere( R R R R ( ( ( sS /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/backends/postgis/operations.pyR! 4 s t
PostGISRelatec B s& e Z d Z e j d � Z d � Z RS( s, For PostGIS Relate(<geom>, <pattern>) calls.s ^[012TF\*]{9}$c C sB | j j | � s% t d | � � n t t | � j | d � d S( Ns) Invalid intersection matrix pattern "%s".t Relate( t
pattern_regext matcht
ValueErrorR R# R ( R R t pattern( ( sS /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/backends/postgis/operations.pyR ; s ( R R R t ret compileR% R ( ( ( sS /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/backends/postgis/operations.pyR# 8 s t PostGISOperationsc B s, e Z d Z d Z e Z d Z e j d � Z e
g d D] Z e d f ^ q7 � Z
e Z e Z d � Z e d
� � Z d � Z d � Z d
� Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z! d � Z" d � Z# d � Z$ d � Z% d � Z& d � Z' RS(! s) django.contrib.gis.db.models.sql.compilert postgist ST_s/ ^(?P<major>\d)\.(?P<minor1>\d)\.(?P<minor2>\d+)t Collectt Extentt Extent3Dt MakeLinet Unionc sr t t | � j | � | j � i
t d � d 6t d � d 6t d � d 6t d � d 6t d � d
6t d � d 6t d
� d 6t d � d 6t d � d 6t d � d 6t d � d 6t d � d 6t d � d 6| _ i t � d � d 6t � d � d 6t � d � d 6t � d � d! 6t � d" � d# 6t � d$ � d% 6t � d& � d' 6t � d( � d) 6t t j f d* 6t � d+ � d, 6t � d- � d. 6| _
t t t
f t j } � f d/ � } i | d0 � | f d1 6| d2 � | f d3 6| d4 � | f d5 6| d6 � | f d7 6t � d8 � | f d9 6| _ | j
j | j � | j dj k rEt } n
� d= } | j dk k r�d? } d@ } t � dA � | j
dB <n
t t } } | j dl k r
t | _ | j j � | _ | j j i | j
d, d, 6| j
d. d. 6| j
d) d) 6� i t d � d 6| _ n | j dm k r(t | _ n t dE g � | _ | j j | j � | j j | j
� � dF | _ | | _ � dG | _ � dH | _ � dI | _ � dJ | _! � dK | _" � dL | _# � dM | _$ � dN | _% � dO | _& | | _' | | _( � dP | _) � dQ | _* � dR | _+ � dS | _, � dT | _- � dU | _. � dV | _/ � dW | _0 � dX | _1 � dY | _2 � dZ | _3 � d[ | _4 � d\ | _5 � d] | _6 � d^ | _7 � d_ | _8 � d` | _9 � da | _: � db | _; � dc | _< � dc | _= | j dn k rG� dd | _> � de | _? � df | _@ n' � dg | _> � dh | _? � di | _@ d S(o Ns &<t
overlaps_lefts &>t overlaps_rights <<t lefts >>t rights &<|t overlaps_belows |&>t overlaps_aboves <<|t strictly_belows |>>t strictly_aboves ~=t same_ast exactt @t containedt ~t
bbcontainss &&t
bboverlapst Equalst equalst Disjointt disjointt Touchest touchest Crossest crossest Withint withint Overlapst overlapst Containst containst
Intersectst
intersectst relatet CoveredByt coveredbyt Coverst coversc s4 i t � | � d 6t � | � d 6t � | � d 6S( s< Returns operations for both regular and spherical distances.t cartesiant spheret spheroid( R R! R ( R ( R ( sS /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/backends/postgis/operations.pyt get_dist_ops� s t >t distance_gts >=t distance_gtet <t distance_lts <=t distance_ltet DWithint dwithini i i t AsGeoJsoni t
ST_GeoHasht ST_MinimumBoundingCirclet ContainsProperlyt contains_properlyi i t isnullt Areat CentroidR. t
DifferenceR R" R t EnvelopeR/ t ForceRHRt AsGMLt Intersectiont AsKMLt Lengtht length_spheroidR1 t mem_sizet
NumGeometriest npointst Perimetert PointOnSurfacet
Polygonizet Reverset Scalet
SnapToGridt AsSVGt
SymDifferencet Transformt TranslateR2 t 3DExtentt 3DLengtht 3DPerimeterR0 t Length3Dt Perimeter3D( i i i ( i i i ( i i i ( i i i ( i i i (A R R+ R t geom_func_prefixR t geometry_operatorsR R# R t string_typest geometry_functionsR R t floatt
integer_typesR t distance_functionst updatet spatial_versiont Falset Truet geographyt copyt geography_functionst geography_operatorst geometryt sett gis_termst areat bounding_circlet centroidt collectt
differencet distanceR" R t envelopet extentt force_rhrt geohasht geojsont gmlt intersectiont kmlt lengthRr t makelineRs t num_geomt
num_pointst perimetert point_on_surfacet
polygonizet reverset scalet snap_to_gridt svgt sym_differencet transformt translatet uniont unionaggt extent3dt length3dt perimeter3d( R t
connectiont dtypesRZ t GEOJSONt GEOHASHt BOUNDINGCIRCLE( ( R sS /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/backends/postgis/operations.pyR M s�
c C sg t t d � r t j } nH y | j � } Wn+ t k
rX t d | j j d � � n X| d } | S( s- Determine the version of the PostGIS library.t POSTGIS_VERSIONs� Cannot determine PostGIS version for database "%s". GeoDjango requires at least PostGIS version 1.3. Was the database created from a spatial database template?t NAMEi ( t hasattrR R� t postgis_version_tupleR
R R� t
settings_dict( R t versiont vtup( ( sS /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/backends/postgis/operations.pyR� � s
c C s | j j } | | j k S( sx
Checks if the given aggregate name is supported (that is, if it's
in `self.valid_aggregates`).
( t __class__R t valid_aggregates( R t aggregatet agg_name( ( sS /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/backends/postgis/operations.pyt check_aggregate_support s c C sb | d d !j d � \ } } t t | j � � \ } } t t | j � � \ } } | | | | f S( s�
Returns 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)".
i i����t ,( t splitt mapR� ( R t boxt llt urt xmint ymint xmaxt ymax( ( sS /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/backends/postgis/operations.pyt convert_extent s c
C sn | d d !j d � \ } } t t | j � � \ } } } t t | j � � \ } } } | | | | | | f S( s�
Returns a 6-tuple extent for the `Extent3D` aggregate by converting
the 3d bounding-box text returnded by PostGIS (`box3d` argument), for
example: "BOX3D(-90.0 30.0 1, -85.0 40.0 2)".
i i����R� ( R� R� R� (
R t box3dR� R� R� R� t zminR� R� t zmax( ( sS /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/backends/postgis/operations.pyt convert_extent3d s c C s | r t | � Sd Sd S( sI
Converts the geometry returned from PostGIS aggretates.
N( R t None( R t hext geo_field( ( sS /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/backends/postgis/operations.pyt convert_geom% s
c C s� | j rS | j s! t d � � n | j d k r? t d � � n d | j | j f S| j r� | j d k r{ | j d } n | j } d | | j f Sd Sd S( s
Return the database field type for the given geometry field.
Typically this is `None` because geometry columns are added via
the `AddGeometryColumn` stored procedure, unless the field
has been specified to be of geography type instead.
s2 PostGIS 1.5 required for geography column support.i� sA PostGIS 1.5 supports geography columns only with an SRID of 4326.s geography(%s,%d)i t Zs geometry(%s,%d)N( R� t NotImplementedErrort sridt geom_typeR� t dimR� ( R t fR� ( ( sS /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/backends/postgis/operations.pyt geo_db_type. s c C s t | � d k r& | d d } } n | \ } } | j | j � } | j oS | j } t | t � r� | rw | j } q� | r� | d k r� t d � � n | j } q� t | t j
| j | j � � � } n | } | r| r| d k r| d k r| j | g S| g Sd S( s�
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 newly introduced geography column type introudced in PostGIS 1.5.
i i Rb sN Only numeric values of degree units are allowed on geographic DWithin queries.RY N(
t lenR� t geodeticR� R� t
isinstanceR t mR' t getattrt unit_attnamet
units_namet _spheroid( R R� t dist_valt lookup_typet valuet optionR� R� t
dist_param( ( sS /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/backends/postgis/operations.pyt get_distanceI s$ '
c C sf | d k s | j | j k r' d } n d | j | j f } t | d � rb | | j | � } n | S( s�
Provides a proper substitution value for Geometries that are not in the
SRID of the field. Specifically, this routine will substitute in the
ST_Transform() function call.
s %ss %s(%%s, %s)t
expressionN( R� R� R� R� t get_expression_column( R R� R� t placeholder( ( sS /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/backends/postgis/operations.pyt get_geom_placeholders s c C s; | j j � �& } | j d | � | j � d SWd QXd S( sZ
Helper routine for calling PostGIS functions and returning their result.
s SELECT %s()i N( R� t temporary_connectiont executet fetchone( R t funct cursor( ( sS /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/backends/postgis/operations.pyt _get_postgis_func� s c C s
| j d � S( s: Returns the version of the GEOS library used with PostGIS.t postgis_geos_version( R� ( R ( ( sS /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/backends/postgis/operations.pyR� � s c C s
| j d � S( sG Returns the version number of the PostGIS library used with PostgreSQL.t postgis_lib_version( R� ( R ( ( sS /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/backends/postgis/operations.pyR� � s c C s
| j d � S( s< Returns the version of the PROJ.4 library used with PostGIS.t postgis_proj_version( R� ( R ( ( sS /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/backends/postgis/operations.pyR� � s c C s
| j d � S( s8 Returns PostGIS version number and compile-time options.t postgis_version( R� ( R ( ( sS /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/backends/postgis/operations.pyR� � s c C s
| j d � S( s8 Returns PostGIS version number and compile-time options.t postgis_full_version( R� ( R ( ( sS /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/backends/postgis/operations.pyR� � s c C s� | j � } | j j | � } | rf t | j d � � } t | j d � � } t | j d � � } n t d | � � | | | | f S( sj
Returns the PostGIS version as a tuple (version string, major,
minor, subminor).
t majort minor1t minor2s* Could not parse PostGIS version string: %s( R� t
version_regexR& t intt groupt Exception( R R� R� R R R ( ( sS /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/backends/postgis/operations.pyR� � s c C sw t j d � } | j � } | j | � } | rg t t t | j d � | j d � | j d � g � � St d � � d S( s�
Return the version of PROJ.4 used by PostGIS as a tuple of the
major, minor, and subminor release numbers.
s (\d+)\.(\d+)\.(\d+)i i i s0 Could not determine PROJ.4 version from PostGIS.N( R) R* R� t searcht tupleR� R R R ( R t
proj_regext proj_ver_strR� ( ( sS /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/backends/postgis/operations.pyt proj_version_tuple� s 7c C sE d � } d � } | | j k r7 | d k r7 | | � S| | � Sd S( s�
Helper routine that returns a boolean indicating whether the number of
parameters is correct for the lookup type.
c S s
| d k S( Ni ( ( t np( ( sS /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/backends/postgis/operations.pyt exactly_two� s c S s | d k o | d k S( Ni i ( ( R ( ( sS /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/backends/postgis/operations.pyt two_to_three� s Rb N( R� ( R R� t num_paramR
R ( ( sS /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/backends/postgis/operations.pyt
num_params� s
c C s� | \ } } } d | | � | | � f } | | j k r� | j re | | j k re t d | � � n | j | }
|
j | | j | | � � S| | j k r�| j r� | | j k r� t d | � � n | j | } t | t � r| \ }
} t | t t
f � st d | � � n | d }
t | � } | j | | � sSt d | � � n t | d | � s�t d | t
| d � f � � n | d k r�|
| j | d � }
q�| | j k r�| d
k r�| j ro| j | j � ro| j j j s9| j d k rt d � � n t |
j � d
k r9t d � � q9n | d k rb| d d k rb|
d }
qy|
d }
q||
d }
q�n | }
| }
|
j | | j | |
� � S| d k r�d | | r�d n d f g f St d t | � � � d S( s�
Constructs spatial SQL from the given lookup value tuple a
(alias, col, db_type), the lookup type string, lookup value, and
the geometry field.
s %s.%ss3 PostGIS geography does not support the "%s" lookup.s8 PostGIS geography type does not support the "%s" lookup.s$ Tuple required for `%s` lookup type.i s: Incorrect number of parameters given for `%s` lookup type.i s+ Argument type should be %s, got %s instead.RR Rb t POINTs; PostGIS spherical operations are only valid on PointFields.t PointsD PostGIS geometry distance parameter is required to be of type Point.i i RY RX RW Rh s %s IS %sNULLt s NOT s Got invalid lookup_type: %sN( R� R� R� R' t as_sqlR� R� R� R� R t listR� R t typeR� R� R� R� t opsR� t strt TypeErrort repr( R t lvalueR� R� t fieldt qnt aliast colt db_typet geo_colt opt tmpt arg_typet geomt nparams( ( sS /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/backends/postgis/operations.pyt spatial_lookup_sql� sT
#
c C sr | j j } | j | � s. t d | � � n | j � } | d k rS | d 7} n d } t | | � } | | f S( ss
Returns the spatial aggregate SQL template and function for the
given Aggregate instance.
s8 %s spatial aggregate is not implmented for this backend.R� t aggs %(function)s(%(field)s)( R� R R� R� t lowerR� ( R R( R� R t sql_function( ( sS /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/backends/postgis/operations.pyt spatial_aggregate_sql% s
c C s t S( N( R
( R ( ( sS /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/backends/postgis/operations.pyt geometry_columns5 s c C s t S( N( R ( R ( ( sS /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/backends/postgis/operations.pyt spatial_ref_sys8 s ( s Collects Extents Extent3Ds MakeLines UnionN(( R R t compiler_modulet nameR� R, R� R) R* R t dictt kR� R� R t Adaptert AdaptorR R R� R� R� R� R� R� R� R� R� R� R� R� R� R� R� R R R' R+ R, R- ( ( ( sS /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/backends/postgis/operations.pyR+ A s> � *
U (% R) t decimalR t django.confR t# django.contrib.gis.db.backends.baseR t# django.contrib.gis.db.backends.utilR R t. django.contrib.gis.db.backends.postgis.adapterR t# django.contrib.gis.geometry.backendR t django.contrib.gis.measureR t django.core.exceptionsR t+ django.db.backends.postgresql_psycopg2.baseR t django.db.utilsR
t django.utilsR t django.utils.functionalR t modelsR
R R R R R R R! R# R+ ( ( ( sS /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/backends/postgis/operations.pyt <module> s*