|
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 : /lib64/python2.7/site-packages/django/db/models/sql/ |
Upload File : |
�
r�\c @@ s� d Z d d l m Z d d l Z d d l m Z d d l m Z d d l m Z 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
Z d Z d e f d � � YZ d e j 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 S( sG
Code to manage the creation and SQL rendering of 'where' constraints.
i ( t absolute_importN( t repeat( t settings( t
DateTimeFieldt Field( t EmptyResultSett Empty( t Aggregate( t is_iterator( t xrange( t timezone( t treet ANDt ORt EmptyShortCircuitc B@ s e Z d Z RS( st
Internal exception used to indicate that a "matches nothing" node should be
added to the where-clause.
( t __name__t
__module__t __doc__( ( ( s< /tmp/pip-install-XxeQeY/django/django/db/models/sql/where.pyR s t WhereNodec B@ sV e Z d Z e Z d � Z d � Z d � Z d � Z d d � Z
d � Z d � Z RS( sj
Used to represent the SQL where-clause.
The class is tied to the Query class that created it (in order to create
the correct SQL).
A child is usually a tuple of:
(Constraint(alias, targetcol, field), lookup_type, value)
where value can be either raw Python value, or Query, ExpressionNode or
something else knowing how to turn itself into SQL.
However, a child could also be any class with as_sql() and either
relabeled_clone() method or relabel_aliases() and clone() methods. The
second alternative should be used if the alias is not the only mutable
variable.
c C@ s� t | t t f � s | S| \ } } } t | � rC t | � } n t | t j � ss t | j t � r | d k r t j } n' t | d � r� | j } n t | � } t | d � r� | j
| | � } n | | | | f S( s�
Prepare data for addition to the tree. If the data is a list or tuple,
it is expected to be of the form (obj, lookup_type, value), where obj
is a Constraint object, and is then slightly munged before being
stored (to avoid storing any reference to field objects). Otherwise,
the 'data' is stored unchanged and can be any class with an 'as_sql()'
method.
t isnullt value_annotationt prepare( t
isinstancet listt tupleR t datetimet fieldR t hasattrR t boolR ( t selft datat objt lookup_typet valueR ( ( s< /tmp/pip-install-XxeQeY/django/django/db/models/sql/where.pyt
_prepare_data1 s c C@ s� g } g } d
\ } } t | j � } xN| j D]C} yO t | d � rj | j d | d | � \ } }
n | j | | | � \ } }
Wn t k
r� | d 7} nJ X| r� | j | � | j |
� n& | d k r� | d 8} q1 n | d 7} | j t
k r | d } } n
d | } } | | d k rE| j r<d g f St � n | | d k r1 | j rgt � qtd g f Sq1 q1 W| d k r�d g f Sd | j }
|
j | � } | r�| j r�d | } q�t | � d k r�d | } q�n | | f S( s
Returns the SQL version of the where clause and the value to be
substituted in. Returns '', [] if this node matches everything,
None, [] if this node is empty, and raises EmptyResultSet if this
node can't match anything.
i t as_sqlt qnt
connectioni t s %s s NOT (%s)s (%s)( i i N(
t lent childrenR R# t make_atomR t appendt extendt Nonet connectorR t negatedt join( R R$ R% t resultt
result_paramst everything_childst nothing_childst non_empty_childst childt sqlt paramst full_neededt empty_neededt connt
sql_string( ( s< /tmp/pip-install-XxeQeY/django/django/db/models/sql/where.pyR# R sN
!
c C@ s� g } x� | j D]� } t | d � r; | j | j � � q t | d t � rr | j | d j | d j f � n t | d d � r | j | d j � � q q W| S( Nt get_colsi i ( R( R R+ R< R t
ConstraintR* t aliast col( R t colsR5 ( ( s< /tmp/pip-install-XxeQeY/django/django/db/models/sql/where.pyR< � s $ c C@ s� | \ } } } } | j r* | j j � n d# } t | t � r{ y | j | | | � \ } } Wq� t k
rw t � q� Xn6 t | t � r� | j j | | | � } n t
d � � t | t � r� | j | | | | � g }
} n | j
| | � \ }
} | t j k } | r | j j � n d }
t | d � rT| j
| | � \ } } d }
n d } | | } t | � d k r�| d d k r�| d k r�| j j r�d } t } n | | j k r�d | j j | � f } | |
| j | |
| f | f S| d
k rF| st � n | r,d |
| f | f S| j j � } | rt | � | k rd g } x� t d t | � | � D]~ } | d k r�| j d
� n | j d |
� t t | � | | � } d j t d | � � } | j | � | j d � quW| j d � d j | � | f Sd |
d j t d t | � � � f | f Sn8| d$ k r`d |
| f S| r�| d% k r�t j r�t j! � n d# } | j j" | |
| � \ } } d | | | f S| d& k r�d | j j# | |
� | f S| d k r0| t t$ f k st% d � � d |
| r"d n d f d' f S| d k rR| j j& |
� | f S| d( k r~| j j' | � |
|
f | f St
d" | � � d# S() s'
Turn a tuple (Constraint(table_alias, column_name, db_type),
lookup_type, value_annotation, params) into valid SQL.
The first item of the tuple may also be an Aggregate.
Returns the string for the SQL fragment and the parameters to use for
it.
s[ 'make_atom' expects a Constraint or an Aggregate as the first item of its 'child' argument.s %sR# R& i i t exactR s
%s %%s %%st ins %s IN %st (s OR s %s IN (s , t )s
%s IN (%s)t ranget years %s BETWEEN %%s and %%st montht dayt week_dayt hourt minutet seconds %s = %%ss# Invalid value_annotation for isnulls %s IS %sNULLs NOT t searcht regext iregexs Invalid lookup_type: %rN( s ranges year( s months dayRI s hours minutes second( s months dayRI ( ( s regexRO (( R t get_internal_typeR, R R= t processR R R t get_db_prep_lookupt TypeErrorR t sql_for_columnsR# R t opst datetime_cast_sqlR R' t featurest! interprets_empty_strings_as_nullst Truet operatorst lookup_castt max_in_list_sizeR R* t minR/ R R t USE_TZR
t get_current_timezone_namet datetime_extract_sqlt date_extract_sqlt Falset AssertionErrort fulltext_search_sqlt regex_lookup( R R5 R$ R% t lvalueR R t params_or_valuet field_internal_typeR7 t field_sqlt field_paramst is_datetime_fieldt cast_sqlt extrat formatR\ t in_clause_elementst offsett
group_sizet param_groupt tznameR6 t tz_params( ( s< /tmp/pip-install-XxeQeY/django/django/db/models/sql/where.pyR) � s�
"
.
c C@ sW | \ } } } | r4 d | | � | | � f } n | | � } | j j | | � | S( s�
Returns the SQL fragment used for the left-hand side of a column
constraint (for example, the "T1.foo" portion in the clause
"WHERE ... T1.foo = 6") and a list of parameters.
s %s.%s( RU t field_cast_sql( R R R$ R% t
internal_typet table_aliast namet db_typet lhs( ( s< /tmp/pip-install-XxeQeY/django/django/db/models/sql/where.pyRT s
c C@ s� x� t | j � D]� \ } } t | d � r; | j | � q t | t t f � r | d j | � f | d } t | d d � r� | d | d | d f | d j | � f } n | | j | <q q Wd S( s�
Relabels the alias values of any children. 'change_map' is a dictionary
mapping old (current) alias values to the new values.
t relabel_aliasesi i i t relabeled_clonei N( t enumerateR( R R{ R R R R| ( R t
change_mapt posR5 ( ( s< /tmp/pip-install-XxeQeY/django/django/db/models/sql/where.pyR{ s c C@ sw | j j d g d | j d | j � } xI | j D]> } t | d � r_ | j j | j � � q1 | j j | � q1 W| S( s�
Creates a clone of the tree. Must only be called on root nodes (nodes
with empty subtree_parents). Childs must be either (Contraint, lookup,
value) tuples, or objects supporting .clone().
R( R- R. t clone( t __class__t
_new_instanceR- R. R( R R* R� ( R R� R5 ( ( s< /tmp/pip-install-XxeQeY/django/django/db/models/sql/where.pyR� $ s N(
R R R R t defaultR" R# R< R) R, RT R{ R� ( ( ( s< /tmp/pip-install-XxeQeY/django/django/db/models/sql/where.pyR s ! H `
t
EmptyWherec B@ s e Z d � Z d d d � Z RS( c C@ s d S( N( ( R R R- ( ( s< /tmp/pip-install-XxeQeY/django/django/db/models/sql/where.pyt add5 s c C@ s
t � d S( N( R ( R R$ R% ( ( s< /tmp/pip-install-XxeQeY/django/django/db/models/sql/where.pyR# 8 s N( R R R� R, R# ( ( ( s< /tmp/pip-install-XxeQeY/django/django/db/models/sql/where.pyR� 3 s t EverythingNodec B@ s e Z d Z d d d � Z RS( s)
A node that matches everything.
c C@ s
d g f S( NR& ( ( R R$ R% ( ( s< /tmp/pip-install-XxeQeY/django/django/db/models/sql/where.pyR# @ s N( R R R R, R# ( ( ( s< /tmp/pip-install-XxeQeY/django/django/db/models/sql/where.pyR� ; s t NothingNodec B@ s e Z d Z d d d � Z RS( s&
A node that matches nothing.
c C@ s
t � d S( N( R ( R R$ R% ( ( s< /tmp/pip-install-XxeQeY/django/django/db/models/sql/where.pyR# H s N( R R R R, R# ( ( ( s< /tmp/pip-install-XxeQeY/django/django/db/models/sql/where.pyR� D s t
ExtraWherec B@ s e Z d � Z d d d � Z RS( c C@ s | | _ | | _ d S( N( t sqlsR7 ( R R� R7 ( ( s< /tmp/pip-install-XxeQeY/django/django/db/models/sql/where.pyt __init__M s c C@ sB g | j D] } d | ^ q
} d j | � t | j p; d � f S( Ns (%s)s AND ( ( R� R/ R R7 ( R R$ R% R6 R� ( ( s< /tmp/pip-install-XxeQeY/django/django/db/models/sql/where.pyR# Q s N( R R R� R, R# ( ( ( s< /tmp/pip-install-XxeQeY/django/django/db/models/sql/where.pyR� L s R= c B@ s2 e Z d Z d � Z d � Z d � Z d � Z RS( s�
An object that can be passed to WhereNode.add() and knows how to
pre-process itself prior to including in the WhereNode.
c C@ s! | | | | _ | _ | _ d S( N( R> R? R ( R R> R? R ( ( s< /tmp/pip-install-XxeQeY/django/django/db/models/sql/where.pyR� [ s c C@ s | j r | j j | | � S| S( N( R t get_prep_lookup( R R R! ( ( s< /tmp/pip-install-XxeQeY/django/django/db/models/sql/where.pyR ^ s c C@ s� d d l m } ym | j rU | j j | | d | d t �} | j j d | � } n' t � j | | d | d t �} d } Wn | k
r� t � n X| j | j
| f | f S( sa
Returns a tuple of data suitable for inclusion in a WhereNode
instance.
i ( t ObjectDoesNotExistR% t preparedN( t django.db.models.baseR� R RR RY Ry R R, R R> R? ( R R R! R% R� R7 Ry ( ( s< /tmp/pip-install-XxeQeY/django/django/db/models/sql/where.pyRQ c s
c C@ sZ | j | k r | St � } | j | _ | | j | j | j | _ | _ | _ | Sd S( N( R> R R� R? R ( R R~ t new( ( s< /tmp/pip-install-XxeQeY/django/django/db/models/sql/where.pyR| { s *( R R R R� R RQ R| ( ( ( s< /tmp/pip-install-XxeQeY/django/django/db/models/sql/where.pyR= V s
t SubqueryConstraintc B@ s, e Z d � Z d � Z d � Z d � Z RS( c C@ s( | | _ | | _ | | _ | | _ d S( N( R> t columnst targetst query_object( R R> R� R� R� ( ( s< /tmp/pip-install-XxeQeY/django/django/db/models/sql/where.pyR� � s c C@ s� | j } t | d � r� | j rB | j | j k rB t d � � n t | d � sf | j | j � } n | j � } | j } | j t
� n | j d | � } | j | j | j
| � S( Nt valuess2 Can't do subqueries with queries on different DBs.t field_namesR% ( R� R t _dbR> t
ValueErrorR� R� t _clonet queryt clear_orderingRY t get_compilert as_subquery_conditionR� ( R R$ R% R� t query_compiler( ( s< /tmp/pip-install-XxeQeY/django/django/db/models/sql/where.pyR# � s c C@ s | j | j | j � | _ d S( N( t getR> ( R R~ ( ( s< /tmp/pip-install-XxeQeY/django/django/db/models/sql/where.pyR{ � s c C@ s" | j | j | j | j | j � S( N( R� R> R� R� R� ( R ( ( s< /tmp/pip-install-XxeQeY/django/django/db/models/sql/where.pyR� � s ( R R R� R# R{ R� ( ( ( s< /tmp/pip-install-XxeQeY/django/django/db/models/sql/where.pyR� � s ($ R t
__future__R R t itertoolsR t django.confR t django.db.models.fieldsR R t# django.db.models.sql.datastructuresR R t django.db.models.sql.aggregatesR t django.utils.itercompatR t django.utils.six.movesR t django.utilsR
R R R
t ExceptionR t NodeR R� t objectR� R� R� R= R� ( ( ( s< /tmp/pip-install-XxeQeY/django/django/db/models/sql/where.pyt <module> s, �
.