
TQc           @   sy  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 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(   iN(   t   Decimal(   t   settings(   t   BaseSpatialOperations(   t   SpatialOperationt   SpatialFunction(   t   PostGISAdapter(   t   Geometry(   t   Distance(   t   ImproperlyConfigured(   t   DatabaseOperations(   t   DatabaseError(   t   sixt   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   (    (    sJ   ../Django//lib/python/django/contrib/gis/db/backends/postgis/operations.pyR      s    (   t   __name__t
   __module__t   __doc__R   (    (    (    sJ   ../Django//lib/python/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(    (    sJ   ../Django//lib/python/django/contrib/gis/db/backends/postgis/operations.pyR      s    (   R   R   R   R   (    (    (    sJ   ../Django//lib/python/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(    (    (    sJ   ../Django//lib/python/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   (    (    sJ   ../Django//lib/python/django/contrib/gis/db/backends/postgis/operations.pyR   #   s    (   R   R   R   R   R   R   (    (    (    sJ   ../Django//lib/python/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   (    (    sJ   ../Django//lib/python/django/contrib/gis/db/backends/postgis/operations.pyR   +   s    (   R   R   R   R   R   R   (    (    (    sJ   ../Django//lib/python/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   (    (    (    sJ   ../Django//lib/python/django/contrib/gis/db/backends/postgis/operations.pyR   0   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(    (    sJ   ../Django//lib/python/django/contrib/gis/db/backends/postgis/operations.pyR   7   s    (   R   R   R   t   ret   compileR"   R   (    (    (    sJ   ../Django//lib/python/django/contrib/gis/db/backends/postgis/operations.pyR    4   s   t   PostGISOperationsc           B   s  e  Z d  Z d Z e Z e j d  Z e	 g  d D] Z
 e
 d f ^ q1  Z e Z e 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# d   Z$ RS(   s)   django.contrib.gis.db.models.sql.compilert   postgiss/   ^(?P<major>\d)\.(?P<minor1>\d)\.(?P<minor2>\d+)t   Collectt   Extentt   Extent3Dt   MakeLinet   Unionc            s1  t  t |   j |  y t t d  r\ t j } t |  d k rL | } qr | d d !} n |  j   } | d } | do k r d   n d     |  _ | |  _	 Wn+ t
 k
 r t d |  j j d	   n Xi 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/  d0 6t   d1  d2 6t t j f d3 6t   d4  d5 6t   d6  d7 6|  _ t t t f t j }   f d8   } i | d9  | f d: 6| d;  | f d< 6| d=  | f d> 6| d?  | f d@ 6t   dA  | f dB 6|  _ |  j j |  j  | dp k  rt } n
   dC } | dq k r,dE } dF } t   dG  |  j dH <n t t } } | dr k rt |  _ |  j j   |  _  |  j  j i |  j d5 d5 6|  j d7 d7 6|  j d2 d2 6 i t d!  d" 6|  _! n  | ds k rt |  _" n  dJ g }	 |	 t# |  j  7}	 |	 t# |  j  7}	 t$ g  |	 D] }
 |
 d  f ^ q |  _&   dK |  _' | |  _(   dL |  _)   dM |  _*   dN |  _+   dO |  _,   dP |  _-   dQ |  _.   dR |  _/   dS |  _0   dT |  _1 | |  _2 | |  _3   dU |  _4   dV |  _5   dW |  _6   dX |  _7   dY |  _8   dZ |  _9   d[ |  _:   d\ |  _;   d] |  _<   d^ |  _=   d_ |  _>   d` |  _?   da |  _@   db |  _A   dc |  _B   dd |  _C   de |  _D   df |  _E   dg |  _F   dh |  _G   dh |  _H | dt k r  di |  _I   dj |  _J   dk |  _K n'   dl |  _I   dm |  _J   dn |  _K d  S(u   Nt   POSTGIS_VERSIONi   i   i   i   t   ST_t    s   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   NAMEs   &<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   (    sJ   ../Django//lib/python/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   dwithint	   AsGeoJsoni    t
   ST_GeoHasht   ST_MinimumBoundingCirclet   ContainsProperlyt   contains_properlyi   t   isnullt   Areat   CentroidR*   t
   DifferenceR   R   R   t   EnvelopeR+   t   ForceRHRt   AsGMLt   Intersectiont   AsKMLt   Lengtht   length_spheroidR-   t   mem_sizet   NumGeometriest   npointst	   Perimetert   PointOnSurfacet
   Polygonizet   Reverset   Scalet
   SnapToGridt   AsSVGt   SymDifferencet	   Transformt	   TranslateR.   t   3DExtentt   3DLengtht   3DPerimeterR,   t   Length3Dt   Perimeter3D(   i   i   i   (   i   i   i   (   i   i   i    (   i   i   i    (   i   i    i    (   i   i    i    (L   R   R(   R   t   hasattrR   R/   t   lent   postgis_version_tuplet   geom_func_prefixt   spatial_versionR
   R   t
   connectiont   settings_dictR   t   geometry_operatorsR   R    R   t   string_typest   geometry_functionsR    R   t   floatt   integer_typesR   t   distance_functionst   updatet   Falset   Truet	   geographyt   copyt   geography_functionst   geography_operatorst   geometryt   listt   dictt   Nonet	   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   R   t   vtupt   versiont   dtypesRZ   t   GEOJSONt   GEOHASHt   BOUNDINGCIRCLER   t   term(    (   R   sJ   ../Django//lib/python/django/contrib/gis/db/backends/postgis/operations.pyR   H   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(    (    sJ   ../Django//lib/python/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   it   ,(   t   splitt   mapR   (   R   t   boxt   llt   urt   xmint   ymint   xmaxt   ymax(    (    sJ   ../Django//lib/python/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   iR   (   R   R   R   (
   R   t   box3dR   R   R   R   t   zminR   R   t   zmax(    (    sJ   ../Django//lib/python/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   R   (   R   t   hext	   geo_field(    (    sJ   ../Django//lib/python/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   (    (    sJ   ../Django//lib/python/django/contrib/gis/db/backends/postgis/operations.pyt   geo_db_type8  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(   R   R   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(    (    sJ   ../Django//lib/python/django/contrib/gis/db/backends/postgis/operations.pyt   get_distanceS  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(    (    sJ   ../Django//lib/python/django/contrib/gis/db/backends/postgis/operations.pyt   get_geom_placeholder}  s    	c         C   sZ   |  j  j   } z2 y! | j d |  | j   } Wn
   n XWd |  j  j   X| d S(   sZ   
        Helper routine for calling PostGIS functions and returning their result.
        s   SELECT %s()Ni    (   R   t   _cursort   executet   fetchonet   close(   R   t   funct   cursort   row(    (    sJ   ../Django//lib/python/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   (    (    sJ   ../Django//lib/python/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   (    (    sJ   ../Django//lib/python/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   (    (    sJ   ../Django//lib/python/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   (    (    sJ   ../Django//lib/python/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   (    (    sJ   ../Django//lib/python/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  (    (    sJ   ../Django//lib/python/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   (    (    sJ   ../Django//lib/python/django/contrib/gis/db/backends/postgis/operations.pyt   proj_version_tuple  s    7c         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(    (    sJ   ../Django//lib/python/django/contrib/gis/db/backends/postgis/operations.pyt   exactly_two  s    c         S   s   |  d k o |  d k S(   Ni   i   (    (   R  (    (    sJ   ../Django//lib/python/django/contrib/gis/db/backends/postgis/operations.pyt   two_to_three  s    Rb   N(   R   (   R   R   t	   num_paramR  R  (    (    sJ   ../Django//lib/python/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  st d |   n  | d } t |  } |  j | |  sSt 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 rt d   n  t | j  d k r9t d   q9n  | d k rb| d d k rb|
 d }
 qy|
 d }
 q||
 d }
 qn | }
 | } |
 j |	 |  j | |   S| d k rd |	 | rd pd 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 %sNULLs   NOT R1   s   Got invalid lookup_type: %sN(   R   R   R   R$   t   as_sqlR   R   R   R   R
  R   R   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(    (    sJ   ../Django//lib/python/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(    (    sJ   ../Django//lib/python/django/contrib/gis/db/backends/postgis/operations.pyt   spatial_aggregate_sql7  s     c         C   s   d d l  m } | S(   Ni(   t   GeometryColumns(   t-   django.contrib.gis.db.backends.postgis.modelsR,  (   R   R,  (    (    sJ   ../Django//lib/python/django/contrib/gis/db/backends/postgis/operations.pyt   geometry_columnsF  s    c         C   s   d d l  m } | S(   Ni(   t   SpatialRefSys(   R-  R/  (   R   R/  (    (    sJ   ../Django//lib/python/django/contrib/gis/db/backends/postgis/operations.pyt   spatial_ref_sysJ  s    (   s   Collects   Extents   Extent3Ds   MakeLines   UnionN(%   R   R   t   compiler_modulet   nameR   R)   R&   R'   R  R   t   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.  R0  (    (    (    sJ   ../Django//lib/python/django/contrib/gis/db/backends/postgis/operations.pyR(   =   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   R   R   R   R   R   R   R    R(   (    (    (    sJ   ../Django//lib/python/django/contrib/gis/db/backends/postgis/operations.pyt   <module>   s&   			