|
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/__pycache__/ |
Upload File : |
o
��Ih � � @ s� d dl Z d dlZd dlZd dlZd dlmZ d dlmZ d dlm Z m
Z
d dl m Z m
Z
d dlmZ d dlmZ d dlmZ d d lmZ d d
lmZ d d lmZ G d d
� d
�ZG dd� d�ZG dd� d�Z eG dd� de e��Z dd� ej ej ej ej!fD �Z"ej#dd�dd� �Z$G dd� dee �Z%G d d � d e%�Z&G d d � d e%�Z'eG d d!� d!e��Z(G d"d#� d#e(�Z)G d$d%� d%e(�Z*G d&d'� d'ee �Z+G d(d)� d)e �Z,G d*d+� d+e �Z-G d,d-� d-e �Z.G d.d/� d/e �Z/G d0d1� d1e �Z0G d2d3� d3e+�Z1G d4d5� d5e �Z2G d6d7� d7e �Z3G d8d9� d9e �Z4G d:d;� d;e e�Z5G d<d=� d=e5�Z6G d>d?� d?e �Z7G d@dA� dAee �Z8G dBdC� dCe �Z9G dDdE� dEe9�Z:G dFdG� dGe9�Z;dS )H� N��Decimal)�UUID)�EmptyResultSet�
FieldError)�NotSupportedError�
connection)�fields)�
LOOKUP_SEP)�Q)�deconstructible)�cached_property)�
make_hashablec @ � e Zd ZdZdd� ZdS )�SQLiteNumericMixinzp
Some expressions with output_field=DecimalField() must be cast to
numeric to be properly filtered.
c K s\ | j ||fi |��\}}z| j�� dkr d| }W ||fS W ||fS ty- Y ||fS w )N� DecimalFieldzCAST(%s AS NUMERIC))�as_sql� output_field�get_internal_typer )�self�compilerr �
extra_context�sql�params� r �>/usr/lib/python3/dist-packages/django/db/models/expressions.py� as_sqlite s
� ��z SQLiteNumericMixin.as_sqliteN)�__name__�
__module__� __qualname__�__doc__r r r r r r s r c @ s� e Zd ZdZdZdZdZdZdZdZ dZ
d Z d
Z d Z
d Zd
d� Zdd� Zdd� Zdd� Zdd� Zdd� Zdd� Zdd � Zd d � Zd d � Zd!d"� Zd#d$� Zd%d&� Zd'd(� Z d)d*� Z d+d,� Z d-d.� Z d/d0� Z d1d2� Z!d3d4� Z"d5d6� Z#d7d8� Z$d9d:� Z%d;S )<�
Combinablezu
Provide the ability to combine one or two objects with
some connector. For example F('foo') + F('bar').
�+�-�*�/�^z%%�&�|z<<z>>�#c C s. t |d�s t|�}|rt||| �S t| ||�S )N�resolve_expression)�hasattr�Value�CombinedExpression)r �other� connector�reversedr r r �_combine: s
zCombinable._combinec C s | � d| jd�S )N���F�r1 �MUL�r r r r �__neg__G � zCombinable.__neg__c C � | � || jd�S �NF�r1 �ADD�r r. r r r �__add__J r7 zCombinable.__add__c C r8 r9 �r1 �SUBr< r r r �__sub__M r7 zCombinable.__sub__c C r8 r9 r3 r< r r r �__mul__P r7 zCombinable.__mul__c C r8 r9 �r1 �DIVr< r r r � __truediv__S r7 zCombinable.__truediv__c C r8 r9 �r1 �MODr< r r r �__mod__V r7 zCombinable.__mod__c C r8 r9 �r1 �POWr< r r r �__pow__Y r7 zCombinable.__pow__c C s0 t | dd�rt |dd�rt| �t|�@ S td���N� conditionalF�:Use .bitand() and .bitor() for bitwise logical operations.��getattrr �NotImplementedErrorr< r r r �__and__\ �
�zCombinable.__and__c C r8 r9 )r1 �BITANDr< r r r �bitandc r7 zCombinable.bitandc C r8 r9 )r1 � BITLEFTSHIFTr< r r r � bitleftshiftf r7 zCombinable.bitleftshiftc C r8 r9 )r1 �
BITRIGHTSHIFTr< r r r �
bitrightshifti r7 zCombinable.bitrightshiftc C r8 r9 )r1 �BITXORr< r r r �bitxorl r7 zCombinable.bitxorc C s0 t | dd�rt |dd�rt| �t|�B S td��rK rN r< r r r �__or__o rR zCombinable.__or__c C r8 r9 )r1 �BITORr< r r r �bitorv r7 zCombinable.bitorc C r8 �NTr: r< r r r �__radd__y r7 zCombinable.__radd__c C r8 r^ r> r< r r r �__rsub__| r7 zCombinable.__rsub__c C r8 r^ r3 r< r r r �__rmul__ r7 zCombinable.__rmul__c C r8 r^ rB r< r r r � __rtruediv__� r7 zCombinable.__rtruediv__c C r8 r^ rE r< r r r �__rmod__� r7 zCombinable.__rmod__c C r8 r^ rH r< r r r �__rpow__� r7 zCombinable.__rpow__c C � t d���NrM �rP r< r r r �__rand__� � �zCombinable.__rand__c C re rf rg r< r r r �__ror__� ri zCombinable.__ror__N)&r r r r r; r? r4 rC rI rF rS r\ rU rW rY r1 r6 r= r@ rA rD rG rJ rQ rT rV rX rZ r[ r] r_ r` ra rb rc rd rh rj r r r r r! ! sH
r! c @ s2 e Zd ZdZdZdZdZdZd?dd�Zdd� Z d d
� Z
d d � Z d
d� Z dd� Z
dd� Zedd� �Zedd� �Zedd� �Zd@dd�Zedd � �Zed d � �Zed d � �Zed!d"� �Zd#d$� Zed%d&� �Zed'd(� �Z d)d*� Z d+d,� Z d-d.� Z d/d0� Z d?d1d2�Z!d3d4� Z"d5d6� Z#d7d8� Z$d9d:� Z%d;d<� Z&d=d>� Z'dS )A�BaseExpressionz%Base class for all query expressions.FTNc C s |d ur || _ d S d S �N�r �r r r r r �__init__� s
�zBaseExpression.__init__c C s | j �� }|�dd � |S )N�
convert_value)�__dict__�copy�pop)r �stater r r � __getstate__� �
zBaseExpression.__getstate__c C s$ | j | ju rg n| j g| j�|� S rl )rp �_convert_value_noopr �get_db_converters�r r r r r rx � s
�
�z BaseExpression.get_db_convertersc C � g S rl r r5 r r r �get_source_expressions� � z%BaseExpression.get_source_expressionsc C s |rJ �d S rl r �r �exprsr r r �set_source_expressions� � z%BaseExpression.set_source_expressionsc G s dd� |D �S )Nc S s4 g | ]}t |d �r |n t|t�rt|�nt|��qS �r* )r+ �
isinstance�str�Fr, ��.0�argr r r �
<listcomp>� s
��z5BaseExpression._parse_expressions.<locals>.<listcomp>r )r � expressionsr r r �_parse_expressions� s �z!BaseExpression._parse_expressionsc C re )a�
Responsible for returning a (sql, [params]) tuple to be included
in the current query.
Different backends can provide their own implementation, by
providing an `as_{vendor}` method and patching the Expression:
```
def override_as_sql(self, compiler, connection):
# custom logic
return super().as_sql(compiler, connection)
setattr(Expression, 'as_' + connection.vendor, override_as_sql)
```
Arguments:
* compiler: the query compiler responsible for generating the query.
Must have a compile method, returning a (sql, [params]) tuple.
Calling compiler(value) will return a quoted `value`.
* connection: the database connection used for the current query.
Return: (sql, params)
Where `sql` is a string containing ordered sql parameters to be
replaced with the elements of the list `params`.
z"Subclasses must implement as_sql()rg �r r r r r r r � s zBaseExpression.as_sqlc C � t dd� | �� D ��S )Nc s � � | ]}|o|j V qd S rl )�contains_aggregate�r� �exprr r r � <genexpr>� � � z4BaseExpression.contains_aggregate.<locals>.<genexpr>��anyr{ r5 r r r r� � � z!BaseExpression.contains_aggregatec C r� )Nc s r� rl )�contains_over_clauser� r r r r� � r� z6BaseExpression.contains_over_clause.<locals>.<genexpr>r� r5 r r r r� � r� z#BaseExpression.contains_over_clausec C r� )Nc s r� rl )�contains_column_referencesr� r r r r� � r� z<BaseExpression.contains_column_references.<locals>.<genexpr>r� r5 r r r r� � r� z)BaseExpression.contains_column_referencesc s4 | � � }�|_|�� ���fdd�|�� D �� |S )a
Provide the chance to do any preprocessing or validation before being
added to the query.
Arguments:
* query: the backend query implementation
* allow_joins: boolean allowing or denying use of joins
in this query
* reuse: a set of reusable joins for multijoins
* summarize: a terminal aggregate clause
* for_save: whether this expression about to be used in a save or update
Return: an Expression to be added to the query.
c s$ g | ]}|r|� �� ���nd �qS rl r� r� �� allow_joins�query�reuse� summarizer r r� � s ���z5BaseExpression.resolve_expression.<locals>.<listcomp>)rr �
is_summaryr r{ �r r� r� r� r� �for_save�cr r� r r* � s �z!BaseExpression.resolve_expressionc C s t | jtj�S rl )r� r r � BooleanFieldr5 r r r rL � s zBaseExpression.conditionalc C � | j S rl rm r5 r r r �field s zBaseExpression.fieldc C s" | � � }|du rd| _td��|S )z+Return the output type of this expressions.NTz4Cannot resolve expression type, unknown output_field)�_resolve_output_field� _output_field_resolved_to_noner rn r r r r s
zBaseExpression.output_fieldc C s& z| j W S ty | js� Y dS w )z�
Return the output field of this expression, or None if
_resolve_output_field() didn't return an output type.
N)r r r� r5 r r r �_output_field_or_none s ��z$BaseExpression._output_field_or_nonec C sT dd� | � � D �}|D ] }|D ]}t||j�s#td|jj|jjf ��q| S dS )a�
Attempt to infer the output type of the expression. If the output
fields of all source fields match then, simply infer the same type
here. This isn't always correct, but it makes sense most of the time.
Consider the difference between `2 + 2` and `2 / 3`. Inferring
the type here is a convenience for the common case. The user should
supply their own output_field with more complex computations.
If a source's output field resolves to None, exclude it from this check.
If all sources are None, then an error is raised higher up the stack in
the output_field property.
c s s � | ] }|d ur|V qd S rl r )r� �sourcer r r r� ) s � z7BaseExpression._resolve_output_field.<locals>.<genexpr>zCExpression contains mixed types: %s, %s. You must set output_field.N)�get_source_fieldsr� � __class__r r )r � sources_iterr r� r r r r� s �����z$BaseExpression._resolve_output_fieldc C � | S rl r ��value�
expressionr r r r rw 6 � z"BaseExpression._convert_value_noopc C sF | j }|�� }|dkrdd� S |�d�rdd� S |dkr dd� S | jS )z�
Expressions provide their own converters because users have the option
of manually specifying the output_field which may be a different type
from the one the database returns.
�
FloatFieldc S � | d u rd S t | �S rl )�floatr� r r r �<lambda>D � z.BaseExpression.convert_value.<locals>.<lambda>� IntegerFieldc S r� rl )�intr� r r r r� F r� r c S r� rl r r� r r r r� H r� )r r �endswithrw )r r� �
internal_typer r r rp : s
z BaseExpression.convert_valuec C � | j �|�S rl )r �
get_lookup)r �lookupr r r r� K r� zBaseExpression.get_lookupc C r� rl )r �
get_transform�r �namer r r r� N r� z BaseExpression.get_transformc s( | � � }|�� fdd�| �� D �� |S )Nc s" g | ]
}|d ur
|� � �nd �qS rl )�relabeled_clone�r� �e��
change_mapr r r� S s ��z2BaseExpression.relabeled_clone.<locals>.<listcomp>)rr r r{ )r r� �cloner r� r r� Q s
�z BaseExpression.relabeled_clonec C s
t � | �S rl )rr r5 r r r rr Y �
zBaseExpression.copyc C s0 | j s| gS g }| �� D ] }|�|�� � q |S rl )r� r{ �extend�get_group_by_cols�r �alias�colsr� r r r r� \ s z BaseExpression.get_group_by_colsc C s dd� | � � D �S )z9Return the underlying field types used by this aggregate.c S s g | ]}|j �qS r )r� r� r r r r� f s z4BaseExpression.get_source_fields.<locals>.<listcomp>)r{ r5 r r r r� d � z BaseExpression.get_source_fieldsc K � t | fi |��S rl ��OrderBy�r �kwargsr r r �asch r7 zBaseExpression.ascc K � t | fddi|��S �N�
descendingTr� r� r r r �desck � zBaseExpression.descc C r� rl r r5 r r r �reverse_orderingn r| z BaseExpression.reverse_orderingc c s> � | V | � � D ]}|r t|d�r|�� E dH q|V qdS )zi
Recursively yield this expression and all subexpressions, in
depth-first order.
�flattenN)r{ r+ r� )r r� r r r r� q s �
��zBaseExpression.flattenc C s$ t | jd�r| j�|||�S ||fS )z�
Custom format for select clauses. For example, EXISTS expressions need
to be wrapped in CASE WHEN on Oracle.
�
select_format)r+ r r� �r r r r r r r r� ~ s z BaseExpression.select_formatrl �NTNFF)(r r r r r� r� �
filterable�window_compatiblero ru rx r{ r r� r r
r� r� r� r* �propertyrL r� r r� r� � staticmethodrw rp r� r� r� rr r� r� r� r� r� r� r� r r r r rk � sX
rk c @ s, e Zd ZdZedd� �Zdd� Zdd� ZdS ) �
Expressionz:An expression that can be combined with other expressions.c C s� t �| j�}| j\}}|j|i |��}|�� |j�� }| jg}|D ])\}}t |t
j �r@|j r;|j
r;|j
jj|j f}n t|�}nt|�}|�||f� q"t|�S rl )�inspect� signaturero �_constructor_args� bind_partial�apply_defaults� arguments�itemsr� r� r �Fieldr� �model�_meta�label�typer �append�tuple) r �constructor_signature�argsr� r� r� �identityr� r� r r r r� � s
zExpression.identityc C s t |t�stS |j| jkS rl )r� r� �NotImplementedr� r< r r r �__eq__� s
zExpression.__eq__c C �
t | j�S rl )�hashr� r5 r r r �__hash__� r� zExpression.__hash__N)r r r r r
r� r� r� r r r r r� � s
r� c
C sX i | ](}|t jt jt jft jt jt jft jt jt jft jt jt jft jt jt jfg�qS r )r r� r r� )r� r/ r r r �
<dictcomp>� s ���r� � )�maxsizec C s< t �| d�}|D ]\}}}t||�rt||�r| S qd S )Nr )�_connector_combinators�get�
issubclass)r/ �lhs_type�rhs_type� combinators�combinator_lhs_type�combinator_rhs_type�
combined_typer r r �_resolve_combined_type� s ��r c s\ e Zd Zd� fdd� Zdd� Zdd� Zdd � Zd
d � Z� fd d
�Zdd� Z ddd�Z
� Z S )r- Nc s$ t � j|d� || _|| _|| _d S �Nrm )�superro r/ �lhs�rhs)r r r/ r r �r� r r ro � s
zCombinedExpression.__init__c C s d� | jj| �S )Nz<{}: {}>)�formatr� r r5 r r r �__repr__� r7 zCombinedExpression.__repr__c C s d� | j| j| j�S )Nz{} {} {})r r r/ r r5 r r r �__str__� r� zCombinedExpression.__str__c C � | j | jgS rl �r r r5 r r r r{ � r� z)CombinedExpression.get_source_expressionsc C � |\| _ | _d S rl r
r} r r r r � r7 z)CombinedExpression.set_source_expressionsc sN zt � �� W S ty& t| jt| jj�t| jj��}|d u r!� |� Y S w rl ) r r� r r r/ r� r r r )r r r r r r� � s
�
�z(CombinedExpression._resolve_output_fieldc C sp g }g }|� | j�\}}|�|� |�|� |� | j�\}}|�|� |�|� d}|j�| j|�}|| |fS �Nz(%s))�compiler r� r� r �ops�combine_expressionr/ �r r r r� �expression_paramsr r �expression_wrapperr r r r � s
zCombinedExpression.as_sqlTFc C s | j �|||||�}| j�|||||�}t| ttf�sz|j�� }W n
tt fy/ d }Y nw z|j�� } W n
tt fyD d } Y nw d|| hv r_|| kr_t| j | j
| j��|||||�S h d�}
| j
| j kr||
v r|| krt| j | j��|||||�S | � � } || _
|| _ || _| S )N�
DurationField> � DateField� TimeField�
DateTimeField)r r* r r� �DurationExpression�TemporalSubtractionr r �AttributeErrorr r/ r? rr r� ) r r� r� r� r� r� r r r� r� �datetime_fieldsr� r r r r* � s6 ��
�
�z%CombinedExpression.resolve_expressionrl r� ) r r r ro r
r r{ r r� r r* �
__classcell__r r r r r- � s
r- c s$ e Zd Zdd� Z� fdd�Z� ZS )r c C sR z|j }W n ty Y nw |�� dkr$|�|�\}}|j�|�|fS |�|�S )Nr )r r r r r � format_for_duration_arithmetic)r �sider r �outputr r r r r r s
�
zDurationExpression.compilec s� |j jr t� �||�S |j�| � g }g }| �| j||�\}}|�|� |� |� | �| j
||�\}}|�|� |� |� d}|j� | j |�}|| |fS r )
�features�has_native_duration_fieldr r r �check_expression_supportr r r� r� r �combine_duration_expressionr/ r r r r r s
zDurationExpression.as_sql)r r r r r r r r r r r s r c s, e Zd Ze�� Z� fdd�Zdd� Z� ZS )r c s t � �|| j|� d S rl )r ro r? )r r r r r r ro ( � z TemporalSubtraction.__init__c C s< |j �| � |�| j�}|�| j�}|j �| jj�� ||�S rl )r r$ r r r �subtract_temporalsr r )r r r r r r r r r + s zTemporalSubtraction.as_sql) r r r r r r ro r r r r r r r % s r c @ sN e Zd ZdZdd� Zdd� Z dd d
�Zd d � Zd
d� Zdd� Z dd� Z
dS )r� zDAn object capable of resolving references to existing query objects.c C s
|| _ dS )z^
Arguments:
* name: the name of the field this expression references
N)r� r� r r r ro 6 s
z
F.__init__c C � d� | jj| j�S �N�{}({}))r r� r r� r5 r r r r
= � z
F.__repr__NTFc C s |� | j|||�S rl )� resolve_refr� �r r� r� r� r� r� r r r r* @ r� zF.resolve_expressionc K r� rl r� r� r r r r� D r7 zF.ascc K r� r� r� r� r r r r� G r� zF.descc C s | j |j ko | j|jkS rl )r� r� r< r r r r� J � zF.__eq__c C r� rl )r� r� r5 r r r r� M r� z
F.__hash__r� ) r r r r ro r
r* r� r� r� r� r r r r r� 2 s
� r� c s> e Zd ZdZdZdd� Z� fdd�Zdd� Zd d
d �Z� Z S )
�ResolvedOuterRefz�
An object that contains a reference to an outer query.
In this case, the reference to the outer query has been resolved because
the inner query has been used as a subquery.
Fc O re )NzXThis queryset contains a reference to an outer query and may only be used in a subquery.)�
ValueError�r r� r� r r r r Z ri zResolvedOuterRef.as_sqlc s" t � j|i |��}t| jv |_|S rl )r r* r
r� �possibly_multivalued)r r� r� �colr r r r* ` s z#ResolvedOuterRef.resolve_expressionc C r� rl r �r �relabelsr r r r� h r| z ResolvedOuterRef.relabeled_cloneNc C rz rl r �r r� r r r r� k r| z"ResolvedOuterRef.get_group_by_colsrl )
r r r r r� r r* r� r� r r r r r r/ Q s r/ c @ s e Zd ZdZdd� Zdd� ZdS )�OuterRefFc O s t | j| j�r
| jS t| j�S rl )r� r� r� r/ r1 r r r r* r s
zOuterRef.resolve_expressionc C r� rl r r4 r r r r� w r| zOuterRef.relabeled_cloneN)r r r r� r* r� r r r r r7 o s r7 c sv e Zd ZdZdZdZdZdZdd�� fdd�
Zdd � Z d
d � Z
d d
� Z dd� Z ddd�Z
ddd�Z� fdd�Z� ZS )�FunczAn SQL function call.Nz %(function)s(%(expressions)s)�, rm c sh | j d ur"t|�| j kr"td| jj| j | j dkrdndt|�f ��t� j|d� | j|� | _|| _ d S )Nz#'%s' takes exactly %s %s (%s given)� �argumentr� rm )
�arity�len� TypeErrorr� r r ro r� �source_expressions�extra)r r r� r@ r r r ro � s ��
z
Func.__init__c C sl | j �dd� | jD ��}i | j�| �� �}|r.d�dd� t|�� �D ��}d�| jj ||�S d�| jj |�S )Nc s � � | ]}t |�V qd S rl �r� r� r r r r� � � � z Func.__repr__.<locals>.<genexpr>r9 c s s( � | ]\}}t |�d t |� V qdS )�=NrB )r� �key�valr r r r� � s �& �
{}({}, {})r* )
�
arg_joiner�joinr? r@ �_get_repr_options�sortedr� r r� r )r r� r@ r r r r
� s z
Func.__repr__c C s i S )zAReturn a dict of extra __init__() options to include in the repr.r r5 r r r rJ � r� zFunc._get_repr_optionsc C r� rl �r? r5 r r r r{ � � zFunc.get_source_expressionsc C s
|| _ d S rl rL r} r r r r � r� zFunc.set_source_expressionsTFc C s> | � � }||_t|j�D ]\}}|�|||||�|j|< q |S rl )rr r� � enumerater? r* ) r r� r� r� r� r� r� �posr� r r r r* � s
zFunc.resolve_expressionc
K s� |j �| � g }g }| jD ]} |�| �\}
} |�|
� |�| � q
i | j�|�} |d ur1|| d< n| �d| j� |p@| � d| j
�}|pI| � d| j �}|� |� | d< | d< || |fS )N�function�templaterH r� r� )
r r$ r? r r� r� r@ �
setdefaultrP r� rQ rH rI )
r r r rP rQ rH r � sql_partsr r� �arg_sql�
arg_params�datar r r r � s
z Func.as_sqlc s* t � �� }| jd d � |_| j�� |_|S rl )r rr r? r@ )r rr r r r rr � s
z Func.copyr� )NNN)r r r r rP rQ rH r< ro r
rJ r{ r r* r rr r r r r r r8 { s
r8 c sV e Zd ZdZdZd� fdd� Zdd� Zdd � Zd� fd d � Zdd
d�Z dd� Z
� Z S )r, z9Represent a wrapped value as a node within an expression.FNc s t � j|d� || _dS )a:
Arguments:
* value: the value this expression represents. The value will be
added into the sql parameter list and properly quoted.
* output_field: an instance of the model field type that this
expression will return, such as IntegerField() or CharField().
rm N)r ro r� )r r� r r r r ro � s
zValue.__init__c C r( r) )r r� r r� r5 r r r r
� r+ zValue.__repr__c C s| |j �| � | j}| j}|d ur1| jr|j||d�}n|j||d�}t|d�r1|�|||�|gfS |d u r9dg fS d|gfS )N)r �get_placeholder�NULLz%s) r r$ r� r� r� �get_db_prep_save�get_db_prep_valuer+ rW )r r r rF r r r r r � s
z Value.as_sqlTc s t � �|||||�}||_|S rl )r r* r� r� r r r r* � s zValue.resolve_expressionc C rz rl r r6 r r r r� � r| zValue.get_group_by_colsc C s� t | jt�r
t�� S t | jt�rt�� S t | jt�r t�� S t | jt �r(t�
� S t | jt j �r3t� � S t | jt j
�r>t�� S t | jt j�rIt�� S t | jt j�rTt�� S t | jt�r^t�� S t | jt�rht�� S t | jt�rrt�� S d S rl )r� r� r� r � CharField�boolr� r� r� r� r� �datetimer �dater �timer � timedeltar r r �bytes� BinaryFieldr � UUIDFieldr5 r r r r� � s. �zValue._resolve_output_fieldrl r� ) r r r r r� ro r
r r* r� r� r r r r r r, � s
r, c sF e Zd Zd� fdd� Zdd� Zdd� Zddd �Zd� fd d
� Z� ZS )�RawSQLNc s0 |d u rt �� }||| _| _t� j|d� d S r )r r� r r r ro )r r r r r r r ro s zRawSQL.__init__c C � d� | jj| j| j�S �NrG )r r� r r r r5 r r r r
r& zRawSQL.__repr__c C s d| j | jfS r )r r r� r r r r r7 z
RawSQL.as_sqlc C � | gS rl r r6 r r r r� rM zRawSQL.get_group_by_colsTFc
sh |j j�� D ]#}|jjD ] }|�� \}} | �� | j�� v r(|�|j|||� nq qt � �
|||||�S rl ) r� r� �get_parent_list� local_fields�get_attname_column�lowerr r, r� r r* )
r r� r� r� r� r� �parent� parent_field�_� column_namer r r r* s ��zRawSQL.resolve_expressionrl r� ) r r r ro r
r r� r* r r r r r rd
s
rd c @ s e Zd Zdd� Zdd� ZdS )�Starc C s dS )Nz'*'r r5 r r r r
) r| z
Star.__repr__c C s dg fS )Nr$ r r� r r r r , � z Star.as_sqlN)r r r r
r r r r r rp ( s rp c sP e Zd ZdZdZd� fdd� Zdd� Zdd � Zd
d � Zdd d
�Z dd� Z
� Z S )�ColTFNc s, |d u r|}t � j|d� ||| _| _d S r )r ro r� �target)r r� rs r r r r ro 5 s z Col.__init__c C s> | j | j}}|r|t|�fnt|�f}d�| jjd�|��S )Nr* r9 )r� rs r� r r� r rI )r r� rs � identifiersr r r r
; s z Col.__repr__c C s< | j | jj}}|r||fn|f}d�t|j|��}|g fS )N�.)r� rs �columnrI �map�quote_name_unless_alias)r r r r� rv rt r r r r r @ s z
Col.as_sqlc C s, | j d u r| S | �|�| j | j �| j| j�S rl )r� r� r� rs r r4 r r r r� F s
zCol.relabeled_clonec C rg rl r r6 r r r r� K rM zCol.get_group_by_colsc C s0 | j | jkr | j�|�S | j�|�| j �|� S rl )rs r rx ry r r r rx N s
�zCol.get_db_convertersrl ) r r r r� r2 ro r
r r� r� rx r r r r r rr 0 s
rr c s\ e Zd ZdZ� fdd�Zdd� Zdd� Zdd � Zdd
d�Zdd� Z dd� Z
ddd�Z � Z S )�Refz~
Reference to column alias of the query. For example, Ref('sum_cost') in
qs.annotate(sum_cost=Sum('cost')) query.
c s t � �� ||| _| _d S rl )r ro �refsr� )r rz r� r r r ro Z s
z Ref.__init__c C re rf )r r� r rz r� r5 r r r r
^ r& z Ref.__repr__c C � | j gS rl �r� r5 r r r r{ a rq zRef.get_source_expressionsc C s |\| _ d S rl r| r} r r r r d r� zRef.set_source_expressionsNTFc C r� rl r r- r r r r* g s zRef.resolve_expressionc C r� rl r r4 r r r r� l r| zRef.relabeled_clonec C s |j �| j�g fS rl )r �
quote_namerz r� r r r r o r+ z
Ref.as_sqlc C rg rl r r6 r r r r� r rM zRef.get_group_by_colsr� rl )
r r r r ro r
r{ r r* r� r r� r r r r r ry U s
ry c s4 e Zd ZdZdZ� fdd�Zdd� Zdd� Z� ZS ) �ExpressionListz�
An expression containing multiple expressions. Can be used to provide a
list of expressions as an argument to another expression, like an
ordering clause.
z%(expressions)sc s* |s
t d| jj ��t� j|i |�� d S )Nz$%s requires at least one expression.)r0 r� r r ro )r r� r@ r r r ro ~ s zExpressionList.__init__c C s | j �dd� | jD ��S )Nc s rA rl rB r� r r r r� � rC z)ExpressionList.__str__.<locals>.<genexpr>)rH rI r? r5 r r r r � r. zExpressionList.__str__c K s | j ||fi |��S rl )r )r r r r r r r r � s zExpressionList.as_sqlite) r r r r rQ ro r r r r r r r r~ v s r~ c sN e Zd ZdZ� fdd�Zdd� Zdd� Zd� fd d
� Zd d � Zd
d� Z � Z
S )�ExpressionWrapperz�
An expression that can wrap another expression so that it can provide
extra context to the inner expression, such as the output_field.
c s t � j|d� || _d S r )r ro r� )r r� r r r r ro � s
zExpressionWrapper.__init__c C � |d | _ d S �Nr �r� r} r r r r � � z(ExpressionWrapper.set_source_expressionsc C r{ rl r� r5 r r r r{ � rq z(ExpressionWrapper.get_source_expressionsNc s4 t | jt�r| j�� }| j|_|j|d�S t� �� S )N)r� )r� r� r� rr r r� r )r r� r� r r r r� � s
z#ExpressionWrapper.get_group_by_colsc C s |� | j�S rl )r r� r� r r r r � r� zExpressionWrapper.as_sqlc C r( r) )r r� r r� r5 r r r r
� r+ zExpressionWrapper.__repr__rl ) r r r r ro r r{ r� r r
r r r r r r � s r c sl e Zd ZdZdZd� fdd� Zdd� Zdd � Zd
d � Zd d
� Z dd� Z
ddd�Z ddd�Z ddd�Z
� ZS )�Whenz"WHEN %(condition)s THEN %(result)sFNc s� |r"|d u rt di |��d }}nt|dd�r"t |fi |��d }}|d u s.t|dd�r.|r2td��t|t �r=|s=td��t� jd d� || _| �|�d | _ d S )NrL FzLWhen() supports a Q object, a boolean expression, or lookups as a condition.z1An empty Q() can't be used as a When() condition.rm r r )
r rO r> r� r0 r ro � conditionr� �result)r r� �then�lookupsr r r ro � s �z
When.__init__c C s d| j | jf S )NzWHEN %r THEN %r�r� r� r5 r r r r � r7 z When.__str__c C � d| j j| f S �Nz<%s: %s>�r� r r5 r r r r
� r7 z
When.__repr__c C r rl r� r5 r r r r{ � r� zWhen.get_source_expressionsc C r rl r� r} r r r r � r7 zWhen.set_source_expressionsc C s
| j jgS rl )r� r� r5 r r r r� � s
zWhen.get_source_fieldsTc C sJ | � � }||_t|jd�r|j�||||d�|_|j�|||||�|_|S )Nr* F)rr r� r+ r� r* r� r� r r r r* � s zWhen.resolve_expressionc K sn |j �| � |}g }|�| j�\}}||d< |�|� |�| j�\} }
| |d< |�|
� |p0| j}|| |fS )Nr� r� )r r$ r r� r� r� rQ ) r r r rQ r �template_params�
sql_params�
condition_sql�condition_params�
result_sql�
result_paramsr r r r � s
z When.as_sqlc C �$ g }| � � D ] }|�|�� � q|S rl �r{ r� r� r� r r r r� � s zWhen.get_group_by_cols�NNr� rl )r r r rQ rL ro r r
r{ r r� r* r r� r r r r r r� � s
r� c s~ e Zd ZdZdZdZddd�� fdd�
Zdd � Zd
d � Zd d
� Z dd� Z
ddd�Z � fdd�Z ddd�Z
d � fdd� Z� ZS ) �Casez�
An SQL searched CASE expression:
CASE
WHEN n > 0
THEN 'positive'
WHEN n < 0
THEN 'negative'
ELSE 'zero'
END
z#CASE %(cases)s ELSE %(default)s END� N)�defaultr c sJ t dd� |D ��s
td��t� �|� t|�| _| �|�d | _|| _d S )Nc s s � | ]}t |t�V qd S rl )r� r� )r� �caser r r r� � r� z Case.__init__.<locals>.<genexpr>z.Positional arguments must all be When objects.r ) �allr> r ro �list�casesr� r� r@ )r r� r r� r@ r r r ro � s
z
Case.__init__c C s dd� dd� | jD ��| jf S )NzCASE %s, ELSE %rr9 c s rA rl rB )r� r� r r r r� rC z Case.__str__.<locals>.<genexpr>)rI r� r� r5 r r r r s z Case.__str__c C r� r� r� r5 r r r r
r7 z
Case.__repr__c C s | j | jg S rl �r� r� r5 r r r r{ r� zCase.get_source_expressionsc C s |�^ | _ | _d S rl r� r} r r r r r+ zCase.set_source_expressionsTFc C sT | � � }||_t|j�D ]\}}|�|||||�|j|< q |j�|||||�|_|S rl )rr r� rN r� r* r� ) r r� r� r� r� r� r� rO r� r r r r* s zCase.resolve_expressionc s t � �� }|jd d � |_|S rl )r rr r� )r r� r r r rr s
z Case.copyc K s� |j �| � | js|�| j�S i | j�|�}g }g }| jD ] } z |�| �\}
} W n ty1 Y q w |�|
� |�| � q |�| j�\} }
|sK| |
fS |pO| j }|�
|�|d< | |d< |�|
� |ph|� d| j �}|| }| j
d ur{|j �| j�| }||fS )Nr� r� rQ )r r$ r� r r� r@ r r� r� � case_joinerrI r� rQ r� �unification_cast_sqlr )r r r rQ r� r r� �
case_partsr� r� �case_sql� case_params� default_sql�default_paramsr r r r r s4
�
z Case.as_sqlc s | j s | j�|�S t� �|�S rl )r� r� r� r r6 r r r r� 9 s zCase.get_group_by_colsr� r� rl )r r r r rQ r� ro r r
r{ r r* rr r r� r r r r r r� � s
r� c sv e Zd ZdZdZdZd� fdd� Zdd� Zd d
� Zd d � Z � fd
d�Z
e dd� �Z dd� Z
ddd�Zddd�Z� ZS )�Subqueryz�
An explicit subquery. It may contain OuterRef() references to the outer
query which will be resolved when it is applied to that query.
z(%(subquery)s)FNc s$ t |d|�| _|| _t� �|� d S )Nr� )rO r� r@ r ro )r �querysetr r@ r r r ro G s zSubquery.__init__c C r{ rl �r� r5 r r r r{ M rq z Subquery.get_source_expressionsc C r� r� r� r} r r r r P r� z Subquery.set_source_expressionsc C � | j jS rl )r� r r5 r r r r� S rq z Subquery._resolve_output_fieldc s t � �� }|j�� |_|S rl )r rr r� r� �r r� r r r rr V rv z
Subquery.copyc C r� rl )r� �external_aliasesr5 r r r r� [ s zSubquery.external_aliasesc C s
| j �� S rl )r� �get_external_colsr5 r r r r� _ r� zSubquery.get_external_colsc
K sf |j �| � i | j�|�}|p| j}|�||�\}}|dd� |d< |p*|�d| j�}|| } | |fS )Nr: r2 �subqueryrQ )r r$ r@ r� r r� rQ )
r r r rQ r� r r� � subquery_sqlr� r r r r r b s
zSubquery.as_sqlc C s |rt || �gS | j�� S rl )ry r� r� r6 r r r r� m s
zSubquery.get_group_by_colsrl r� )r r r r rQ r� ro r{ r r� rr r� r� r� r r� r r r r r r� ? s
r� c sH e Zd ZdZe�� Zd � fdd� Zdd� Zd
� fdd � Z d
d � Z
� Z S )�ExistszEXISTS(%(subquery)s)Fc s || _ t� j|fi |�� d S rl )�negatedr ro )r r� r� r� r r r ro { s zExists.__init__c C s | � � }| j |_|S rl )rr r� r� r r r �
__invert__ s
zExists.__invert__Nc sH | j j|jd�}t� j||f||d�|��\}}| jr d�|�}||fS )N)�using)rQ r� zNOT {})r� �existsr� r r r� r )r r r rQ r r� r r r r r r � s ��
�
z
Exists.as_sqlc C s |j jjs
d�|�}||fS )Nz CASE WHEN {} THEN 1 ELSE 0 END)r r" �&supports_boolean_expr_in_select_clauser r� r r r r� � s
zExists.select_format)Frl ) r r r rQ r r� r ro r� r r� r r r r r r� w s
r� c @ sj e Zd ZdZdZddd�Zdd� Zdd� Zd d
� Zdd d
�Z dd� Z
ddd�Z dd� Z dd� Z
dd� Zd S )r� z%(expression)s %(ordering)sFc C s> |r|rt d��|| _|| _|| _t|d�st d��|| _d S )Nz1nulls_first and nulls_last are mutually exclusiver* z%expression must be an expression type)r0 � nulls_first�
nulls_lastr� r+ r� )r r� r� r� r� r r r ro � s
zOrderBy.__init__c C re )Nz{}({}, descending={}))r r� r r� r� r5 r r r r
� s �zOrderBy.__repr__c C r� r� r� r} r r r r � r� z OrderBy.set_source_expressionsc C r{ rl r� r5 r r r r{ � rq z OrderBy.get_source_expressionsNc K s� |p| j }|jjr| jrd| }n%| jrd| }n | jr(| jr#|jjs(d| }n| jr6| js2|jjs6d| }|j�| � |� | j
�\}}|| jrJdndd�|�}|pT| j }||� d�9 }|| � � |fS ) Nz
%s NULLS LASTz%s NULLS FIRSTz%%(expression)s IS NULL, %sz %%(expression)s IS NOT NULL, %s�DESC�ASC)r� �orderingz%(expression)s)
rQ r" � supports_order_by_nulls_modifierr� r� r� �order_by_nulls_firstr r$ r r� �count�rstrip)r r r rQ r �expression_sqlr � placeholdersr r r r � s:
���
�� ��
zOrderBy.as_sqlc C sD t | jt�r | �� }tt| jdd�dd�|_|�||�S | �||�S )NT)r� F)r� )r� r� r� rr r� r� r )r r r rr r r r � as_oracle� s � zOrderBy.as_oraclec C r� rl r� r� r r r r� � s zOrderBy.get_group_by_colsc C s. | j | _ | js | jr| j | _| j | _| S rl )r� r� r� r5 r r r r� � s
zOrderBy.reverse_orderingc C �
d| _ d S r9 �r� r5 r r r r� � r� z OrderBy.ascc C r� r^ r� r5 r r r r� � r� z OrderBy.desc)FFFrl )r r r rQ rL ro r
r r{ r r� r� r� r� r� r r r r r� � s
r� c sv e Zd ZdZdZdZdZd� fdd� Zdd� Zd d
� Z d d � Z
dd
d�Z � fdd�Z dd� Z
dd� Zddd�Z� ZS )�Windowz %(expression)s OVER (%(window)s)FTNc s� || _ || _|| _t|dd�std|jj ��| j d ur/t| j tt f�s)| j f| _ t
| j � | _ | jd urMt| jt tf�rCt
| j� | _n
t| jt �sMtd��t � j
|d� | �|�d | _d S )Nr� Fz3Expression '%s' isn't compatible with OVER clauses.zCorder_by must be either an Expression or a sequence of expressions.rm r )� partition_by�order_by�framerO r0 r� r r� r� r� r~ rk r ro r� �source_expression)r r� r� r� r� r r r r ro � s, ��
�zWindow.__init__c C r� rl )r� r r5 r r r r� rq z Window._resolve_output_fieldc C s | j | j| j| jgS rl �r� r� r� r� r5 r r r r{ r� z Window.get_source_expressionsc C s |\| _ | _| _| _d S rl r� r} r r r r r. z Window.set_source_expressionsc C s |j �| � |jjstd��|�| j�\}}g g }}| jd ur5| jj||dd�\}} |� |� |� | � | j
d urQ|� d� |�| j
�\}
} |� |
� |� | � | j rh|�| j �\} }
|� d| � |� |
� |� |� |pq| j
}||d�|��� d� |fS )Nz1This backend does not support window expressions.z PARTITION BY %(expressions)s)r r rQ z
ORDER BY r� � )r� �window)r r$ r" �supports_over_clauser r r� r� r r� r� r� r� rQ rI �strip)r r r rQ �expr_sqlr �
window_sql�
window_params�sql_exprr� � order_sql� order_params� frame_sql� frame_paramsr r r r s:
�
��z
Window.as_sqlc sT t | jtj�r$| �� }|�� }t�� |d _|�|� tt |��
||�S | � ||�S r� ) r� r r r rr r{ r� r r r� r r )r r r rr r? r r r r < s
zWindow.as_sqlitec C sH d� t| j�| jrdt| j� nd| jrdt| j� ndt| jp!d��S )Nz{} OVER ({}{}{})z
PARTITION BY r� z ORDER BY )r r� r� r� r� r� r5 r r r r F s �zWindow.__str__c C r� r� r� r5 r r r r
N r7 zWindow.__repr__c C rz rl r r6 r r r r� Q r| zWindow.get_group_by_cols)NNNNrl )r r r rQ r� r� r� ro r� r{ r r r r r
r� r r r r r r� � s
"
r� c @ sX e Zd ZdZdZddd�Zdd� Zdd � Zd
d � Zd d
� Z ddd�Z
dd� Z dd� Z dS )� WindowFrameaV
Model the frame clause in window expressions. There are two types of frame
clauses which are subclasses, however, all processing and validation (by no
means intended to be complete) is done here. Thus, providing an end for a
frame is optional (the default is UNBOUNDED FOLLOWING, which is the last
row in the frame).
z,%(frame_type)s BETWEEN %(start)s AND %(end)sNc C s t |�| _t |�| _d S rl )r, �start�end�r r� r� r r r ro _ s
zWindowFrame.__init__c C r rl �r� r� r} r r r r c r7 z"WindowFrame.set_source_expressionsc C r rl r� r5 r r r r{ f r� z"WindowFrame.get_source_expressionsc C s> |j �| � | �|| jj| jj�\}}| j| j||d� g fS )N��
frame_typer� r� )r r$ �window_frame_start_endr� r� r� rQ r� )r r r r� r� r r r r i s ��zWindowFrame.as_sqlc C r� r� r� r5 r r r r
r r7 zWindowFrame.__repr__c C rz rl r r6 r r r r� u r| z WindowFrame.get_group_by_colsc C s� | j jd ur| j jdk rdt| j j�tjjf }n| j jd ur*| j jdkr*tjj}ntjj}| jjd urE| jjdkrEd| jjtjj f }n| jjd urV| jjdkrVtjj}ntjj
}| j | j ||d� S )Nr z%d %sr� )
r� r� �absr r � PRECEDING� CURRENT_ROW�UNBOUNDED_PRECEDINGr� � FOLLOWING�UNBOUNDED_FOLLOWINGrQ r� r� r r r r x s
�zWindowFrame.__str__c C re )Nz3Subclasses must implement window_frame_start_end().rg �r r r� r� r r r r� � rq z"WindowFrame.window_frame_start_endr� rl )
r r r r rQ ro r r{ r r
r� r r� r r r r r� U s
r� c @ r )�RowRange�ROWSc C � |j �||�S rl )r �window_frame_rows_start_endr� r r r r� � r� z RowRange.window_frame_start_endN�r r r r� r� r r r r r� � � r� c @ r )�
ValueRange�RANGEc C r� rl )r � window_frame_range_start_endr� r r r r� � r� z!ValueRange.window_frame_start_endNr� r r r r r� � r� r� )<rr r] � functoolsr� �decimalr �uuidr �django.core.exceptionsr r � django.dbr r �django.db.modelsr �django.db.models.constantsr
� django.db.models.query_utilsr �django.utils.deconstructr �django.utils.functionalr
�django.utils.hashabler r r! rk r� r; r? r4 rC r� � lru_cacher r- r r r� r/ r7 r8 r, rd rp rr ry r~ r r� r� r� r� r� r� r� r� r� r r r r �<module> sb u s �
K
JH%! CQ8#Sh;