|
Server : Apache System : Linux iad1-shared-b8-43 6.6.49-grsec-jammy+ #10 SMP Thu Sep 12 23:23:08 UTC 2024 x86_64 User : dh_edsupp ( 6597262) PHP Version : 8.2.26 Disable Function : NONE Directory : /lib/python3/dist-packages/django/db/models/sql/__pycache__/ |
Upload File : |
o
3�a*" � @ sp d Z ddlmZ ddlmZ ddlmZ dZdZG dd� dej �Z
G d d
� d
�Z G d d � d �Z G d
d� d�Z
dS )zG
Code to manage the creation and SQL rendering of 'where' constraints.
� ��EmptyResultSet)�tree)�cached_property�AND�ORc @ s� e Zd ZdZeZdZdZd'dd�Zdd� Z d(d d
�Z
d d � Z d
d� Z dd� Z
dd� Zdd� Zdd� Zedd� �Zedd� �Zedd � �Zed d � �Zed d � �Zed!d"� �Zed#d$� �Zd%d&� Z dS ))� WhereNodea�
An 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 an expression producing boolean values. Most likely the
expression is a Lookup instance.
However, a child could also be any class with as_sql() and either
relabeled_clone() method or relabel_aliases() and clone() methods and
contains_aggregate attribute.
FTc C s� | j s| dfS || jA }|r| jtkp| o| jtk}|r$| j r$d| fS g }g }| jD ]/}t|d�rL|�|�\}}|durB|�|� |durK|�|� q+|j rU|�|� q+|�|� q+|rf| � || j| j�nd} |rs| � || j| j�nd}
|
| fS )z�
Return two possibly None nodes: one for those parts of self that
should be included in the WHERE clause and one for those parts of
self that must be included in the HAVING clause.
N� split_having)
�contains_aggregate�negated� connectorr r �children�hasattrr �append� __class__) �selfr �
in_negated�may_need_split� where_parts� having_parts�c�
where_part� having_part� having_node�
where_node� r �</usr/lib/python3/dist-packages/django/db/models/sql/where.pyr s0
�
� zWhereNode.split_havingc C s g }g }| j tkrt| j�d}}ndt| j�}}| jD ]H}z |�|�\}} W n
ty5 |d8 }Y nw |rC|�|� |�| � n|d8 }|dkrV| jrTdg f S t�|dkre| jr_t�dg f S q d| j }
|
� |�} | r�| jr}d| } | |fS t|�dks�| j
r�d| } | |fS )a
Return the SQL version of the where clause and the value to be
substituted in. Return '', [] if this node matches everything,
None, [] if this node is empty, and raise EmptyResultSet if this
node can't match anything.
� r � z %s zNOT (%s)�(%s)) r r �lenr
�compiler r �extendr �join�resolved) r �compiler�
connection�result�
result_params� full_needed� empty_needed�child�sql�params�conn�
sql_stringr r r �as_sqlA sB
�
�
�zWhereNode.as_sqlNc C s" g }| j D ] }|�|�� � q|S �N)r
r" �get_group_by_cols)r �alias�colsr+ r r r r2 u s
zWhereNode.get_group_by_colsc C s | j d d � S r1 )r
�r r r r �get_source_expressions{ s z WhereNode.get_source_expressionsc C s t |�t | j�ks J �|| _d S r1 )r r
)r r
r r r �set_source_expressions~ s
z WhereNode.set_source_expressionsc C sH t | j�D ] \}}t|d�r|�|� qt|d�r!|�|�| j|< qdS )z�
Relabel the alias values of any children. 'change_map' is a dictionary
mapping old (current) alias values to the new values.
�relabel_aliases�relabeled_cloneN)� enumerater
r r8 r9 )r �
change_map�posr+ r r r r8 � s
��zWhereNode.relabel_aliasesc C sN | j jg | j| jd�}| jD ]}t|d�r |j�|�� � q|j�|� q|S )z�
Create a clone of the tree. Must only be called on root nodes (nodes
with empty subtree_parents). Childs must be either (Constraint, lookup,
value) tuples, or objects supporting .clone().
)r
r r �clone)r �
_new_instancer r r
r r r= )r r= r+ r r r r= � s
�
zWhereNode.clonec C s | � � }|�|� |S r1 )r= r8 )r r; r= r r r r9 � s
zWhereNode.relabeled_clonec C s | � � S r1 )r= r5 r r r �copy� s zWhereNode.copyc �* t |tj�rt� fdd�|jD ��S |jS )Nc 3 � � | ]}� � |�V qd S r1 ��_contains_aggregate��.0r ��clsr r � <genexpr>� � � z0WhereNode._contains_aggregate.<locals>.<genexpr>)�
isinstancer �Node�anyr
r
�rG �objr rF r rC � � z WhereNode._contains_aggregatec C �
| � | �S r1 rB r5 r r r r
� �
z WhereNode.contains_aggregatec r@ )Nc 3 rA r1 ��_contains_over_clauserD rF r r rH � rI z2WhereNode._contains_over_clause.<locals>.<genexpr>)rJ r rK rL r
�contains_over_clauserM r rF r rS � rO z WhereNode._contains_over_clausec C rP r1 rR r5 r r r rT � rQ z WhereNode.contains_over_clausec C s t dd� | jD ��S )Nc s s � | ]}|j V qd S r1 )�
is_summary)rE r+ r r r rH � s � z'WhereNode.is_summary.<locals>.<genexpr>)rL r
r5 r r r rU � s zWhereNode.is_summaryc O s& t | d�r| j|g|�R i |��} | S )N�resolve_expression)r rV )�expr�query�args�kwargsr r r �
_resolve_leaf� s
zWhereNode._resolve_leafc O s� t |d�r|jD ]}| j||g|�R i |�� qt |d�r,| j|j|g|�R i |��|_t |d�rB| j|j|g|�R i |��|_d S d S )Nr
�lhs�rhs)r r
�
_resolve_noder[ r\ r] )rG �noderX rY rZ r+ r r r r^ � s
"�zWhereNode._resolve_nodec O s* | � � }|j|g|�R i |�� d|_|S )NT)r= r^ r$ )r rY rZ r= r r r rV � s z WhereNode.resolve_expression)Fr1 ) �__name__�
__module__� __qualname__�__doc__r �defaultr$ � conditionalr r0 r2 r6 r7 r8 r= r9 r? � classmethodrC r r
rS rT �propertyrU � staticmethodr[ r^ rV r r r r r s:
!
4
r c @ s e Zd ZdZdZddd�ZdS )� NothingNodez A node that matches nothing.FNc C s t �r1 r )r r% r& r r r r0 � s zNothingNode.as_sql�NN)r` ra rb rc r
r0 r r r r ri � s ri c @ s" e Zd ZdZdd� Zddd�ZdS )�
ExtraWhereFc C s || _ || _d S r1 )�sqlsr- )r rl r- r r r �__init__� s
zExtraWhere.__init__Nc C s( dd� | j D �}d�|�t| jpd�fS )Nc S s g | ]}d | �qS )r r )rE r, r r r �
<listcomp>� s z%ExtraWhere.as_sql.<locals>.<listcomp>z AND r )rl r# �listr- )r r% r& rl r r r r0 � s zExtraWhere.as_sqlrj �r` ra rb r
rm r0 r r r r rk � s rk c @ s e Zd ZdZdd� Zdd� ZdS )�SubqueryConstraintFc C s || _ || _|| _|| _d S r1 )r3 �columns�targets� query_object)r r3 rr rs rt r r r rm � s
zSubqueryConstraint.__init__c C s0 | j }|�| j� |j|d�}|�| j| j|�S )N)r& )rt �
set_valuesrs � get_compiler�as_subquery_conditionr3 rr )r r% r& rX �query_compilerr r r r0 � s zSubqueryConstraint.as_sqlNrp r r r r rq � s rq N)rc �django.core.exceptionsr � django.utilsr �django.utils.functionalr r r rK r ri rk rq r r r r �<module> s G