|
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/models/sql/ |
Upload File : |
�
r�\c @ s\ d d l Z d d l m Z d d l m Z m Z 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 d l m Z e j Z d e j f d
� � YZ d e j e f d � � YZ d
e j e f d � � YZ d e j e f d � � YZ d e j e f d � � YZ d e j e f d � � YZ d e j e f d � � YZ d S( i����N( t settings( t
truncate_namet
typecast_datet typecast_timestamp( t compiler( t MULTI( t six( t zipt zip_longest( t timezonet GeoSQLCompilerc B sk e Z e d � Z e d d d e d d � Z d d � Z d � Z d d d � Z d � Z d d d � Z
RS( c C s | j } | j j j } g t j | j j � D]3 \ } } d | j | � | d | | � f ^ q. } g } t | j j j
� � } | r� | j � } n t � } | j j rw| j
� }
x�| j j D]�\ } } t | t t f � r | \ } } | j j | j }
|
|
k r*| |
|
k r*q� n | j | | | � } | r�| d | k r�d t | � } | j d | | f � | j | � | j | � q| j d | | | d � f � | j | � | j | d � qp| j | � | j | � | j | d � q� | j | | j � \ } } | j | � | j | � t | d � r� | j | j � | j | j � q� q� WnA | j j r�| j | | � \ } } | j | � | j | � n | j j j � } x� | j j j � D]v \ } } | j | | j � \ } } | d k r | j | � n& | j d | | t" | | � � f � | j | � q�Wx� | j j# D]� \ \ }
} } | j | |
| � } | r�| | k r�d t | � } | j d | | f � | j | � | j | � qd| j | � | j | � | j | � qdW| | _$ | | f S( s�
Return the list of columns to use in the select statement. If no
columns have been specified, returns all columns relating to fields in
the model.
If 'with_aliases' is true, any column names that are duplicated
(without the table names) are given unique aliases. This is needed in
some cases to avoid ambiguitity with nested queries.
This routine is overridden from Query to handle customized selection of
geometry columns.
s
(%s) AS %si i s Col%ds %s AS %st aliasN(% t quote_name_unless_aliast
connectiont opst
quote_nameR t iteritemst queryt extra_selectt get_extra_select_formatt sett keyst copyt selectt deferred_to_columnst
isinstancet listt tuplet alias_mapt
table_namet get_field_selectt lent appendt addt as_sqlt extendt hasattrR t default_colst get_default_columnst updatet max_name_lengtht aggregate_selectt itemst NoneR t related_select_colst _select_aliases( t selft with_aliasest qnt qn2R t colt resultt paramst aliasest col_aliasest only_loadt fieldt columnt tablet rt c_aliast col_sqlt
col_paramst colst new_aliasesR( t aggregatet agg_sqlt
agg_params( ( sK /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/models/sql/compiler.pyt get_columns sx
L
!
&
c C s� g } | d k r$ | j j � } n t � } | j � } | j j j � }
| r^ | |
d <n xd| j � D]V\ } } | r� | d k r� t | | � r� qk n | j j | | | |
� }
| j j
|
j } | | k r� | j | | k r� qk n | r | j
|
| f � | j |
� qk n | j | |
� } | r�| j | k r�d t | � } | j
d | | f � | j | � | j | � qk | } | j
| � | j | � | rk | j | j � qk qk W| | f S( s�
Computes the default columns for selecting every field in the base
model. Will sometimes be called to pull in related models (e.g. via
select_related), in which case "opts" and "start_alias" will be given
to provide a starting point for the traversal.
Returns a list of strings, quoted appropriately for use in SQL
directly, as well as a set of aliases used in the select statement (if
'as_pairs' is True, returns a list of (alias, col_name) pairs instead
of strings as the first component and None as the second component).
This routine is overridden from Query to handle customized selection of
geometry columns.
s Col%ds %s AS %sN( R+ R t get_metaR R t included_inherited_modelsR t get_concrete_fields_with_modelt
issubclasst join_parent_modelR R R9 R R! R R ( R. R/ R6 t start_aliast optst as_pairst from_parentR3 R5 R7 t seenR8 t modelR R: t field_selR< R; ( ( sK /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/models/sql/compiler.pyR& f s>
!
c C sE g } t | j j � } d } | j j j rW | j j d k sK | j j rW d } qW n | t | � } g t
| | | !| � D]9 \ } } | j j | | j j j
| d � | j � ^ q~ } | j j j s� t | j d t � r*xW t | | | � D]. \ } }
| j | j j | |
| j � � q� Wn | j | | � t | � S( s�
This routine is necessary so that distances and geometries returned
from extra selection SQL get resolved appropriately into Python
objects.
i i t
geo_valuesN( R R R R
R t oraclet high_markR+ t low_markR R t convert_valuest extra_select_fieldst gett getattrt FalseR R R# R ( R. t rowt fieldst valuesR5 t rn_offsett index_startt vt at valueR8 ( ( sK /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/models/sql/compiler.pyt resolve_columns� s S$ )c C sE d } t | j d � rA | | j j k rA | | j j | } n | S( Ns %st
custom_select( R$ R Rc ( R. R t sel_fmt( ( sK /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/models/sql/compiler.pyR � s $c C sU | j | � } | | j j k r8 | | j j | } n | | j | | | � } | S( s�
Returns the SELECT SQL string for the given field. Figures out
if any custom selection SQL is needed for the column The `alias`
keyword may be used to manually specify the database table where
the column exists, if not in the model associated with this
`GeoQuery`. Similarly, `column` may be used to specify the exact
column name, rather than using the `column` attribute on `field`.
( t get_select_formatR Rc t
_field_column( R. R8 R R9 Rd RP ( ( sK /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/models/sql/compiler.pyR � s
c C s} | j j j rs t | d � rs | j j j } | j j ry | j j j sW | j j j ry d | j j | f } qy n d } | S( s.
Returns the selection format string, depending on the requirements
of the spatial backend. For example, Oracle and MySQL require custom
selection formats in order to retrieve geometries in OGC WKT. For all
other fields a simple '%s' format string is returned.
t geom_types 'SRID=%d;'||%ss %s( R
R R R$ R t transformed_sridRR t
spatialite( R. t fldRd ( ( sK /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/models/sql/compiler.pyRe � s c C sP | d k r! | j j � j } n d | j | � | j j j | pH | j � f S( s�
Helper function that returns the database column for the given field.
The table and column are returned (quoted) in the proper format, e.g.,
`"geoapp_city"."point"`. If `table_alias` is not specified, the
database table associated with the model of this `GeoQuery` will be
used. If `column` is specified, it will be used instead of the value
in `field.column`.
s %s.%sN( R+ R RE t db_tableR R
R R R9 ( R. R8 t table_aliasR9 ( ( sK /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/models/sql/compiler.pyRf � s N( ( t __name__t
__module__RY RD R+ R& Rb R R Re Rf ( ( ( sK /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/models/sql/compiler.pyR
s W4 ! t SQLInsertCompilerc B s e Z RS( ( Rm Rn ( ( ( sK /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/models/sql/compiler.pyRo � s t SQLDeleteCompilerc B s e Z RS( ( Rm Rn ( ( ( sK /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/models/sql/compiler.pyRp � s t SQLUpdateCompilerc B s e Z RS( ( Rm Rn ( ( ( sK /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/models/sql/compiler.pyRq s t SQLAggregateCompilerc B s e Z RS( ( Rm Rn ( ( ( sK /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/models/sql/compiler.pyRr s t SQLDateCompilerc B s e Z d Z d � Z RS( s�
This is overridden for GeoDjango to properly cast date columns, since
`GeoQuery.resolve_columns` is used for spatial values.
See #14648, #16757.
c c s� | j j j r. d d l m } | � g } n | j j j } t | j j � } x� | j
t � D]� } x� | D]y } | | } | j j j r� | j | | � | } n | r� t
t | � � } n t | t j � r� | j � } n | Vql Wq_ Wd S( Ni����( t
DateTimeField( R
R RR t django.db.models.fieldsRt t featurest needs_datetime_string_castR R R t execute_sqlR Rb R t strR t datetimet date( R. Rt R[ t needs_string_castt offsett rowsRZ R{ ( ( sK /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/models/sql/compiler.pyt results_iter s
( Rm Rn t __doc__R ( ( ( sK /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/models/sql/compiler.pyRs s t SQLDateTimeCompilerc B s e Z d Z d � Z RS( s�
This is overridden for GeoDjango to properly cast date columns, since
`GeoQuery.resolve_columns` is used for spatial values.
See #14648, #16757.
c c s | j j j r. d d l m } | � g } n | j j j } t | j j � } x� | j
t � D]� } x� | D]� } | | } | j j j r� | j | | � | } n | r� t
t | � � } n t j r� | j d d � } t j | | j j � } n | Vql Wq_ Wd S( Ni����( Rt t tzinfo( R
R RR Ru Rt Rv Rw R R R Rx R Rb R Ry R t USE_TZt replaceR+ R t
make_awareR� ( R. Rt R[ R| R} R~ RZ Rz ( ( sK /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/models/sql/compiler.pyR % s
( Rm Rn R� R ( ( ( sK /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/models/sql/compiler.pyR� s ( Rz t django.confR t django.db.backends.utilR R R t django.db.models.sqlR t django.db.models.sql.constantsR t django.utilsR t django.utils.six.movesR R R t SQLCompilerR
Ro Rp Rq Rr Rs R� ( ( ( sK /tmp/pip-install-XxeQeY/django/django/contrib/gis/db/models/sql/compiler.pyt <module> s �