OwlCyberSecurity - MANAGER
Edit File: expressions.cpython-39.pyc
a ���eS� � @ s� d dl Z d dlZd dlZd dlZd dlZd dlmZ d dlmZ d dl m Z d dl m Z m Z mZ d dlmZmZmZ d dlmZ d dlmZ d d lmZ d d lmZ d d lm Z d d l m Z d d l m Z G dd� d�Z!G dd� d�Z"G dd� d�Z#eG dd� de#e"��Z$e%d�Z&dd� e"j'e"j(e"j)e"j*e"j+e"j,fD �dd� e"j'e"j(e"j)e"j*e"j+fD �dd� e"j-e"j.e"j/e"j0e"j1fD �dd� e"j'e"j(e"j)e"j*e"j+e"j,fD �e"j'ej2ej3ej4fej4ej3ej4fej3ej2ej4fej3ej4ej4fej3ej3ej3fej5ej3ej5fej3ej5ej5fgie"j(ej2ej3ej4fej4ej3ej4fej2ej2ej3fej2ej4ej3fej4ej2ej3fej4ej4ej3fej3ej3ej3fej5ej3ej5fej5ej5ej3fg igZ6ee7�Z8dd � Z9e6D ]:Z:e:�;� D ]*\Z<Z=e=D ]\Z>Z?Z@e9e>e<e?e@� �q��q��q�ejAd d �d d � �ZBG d!d"� d"e!e$�ZCG d#d$� d$eC�ZDG d%d&� d&eC�ZEed'd(�G d)d*� d*e"��ZFG d+d,� d,eF�ZGG d-d.� d.eF�ZHed/d(�G d0d1� d1e!e$��ZIed2d(�G d3d4� d4e!e$��ZJG d5d6� d6e$�ZKG d7d8� d8e$�ZLG d9d:� d:e$�ZMG d;d<� d<e$�ZNG d=d>� d>eI�ZOG d?d@� d@eI�ZPedAd(�G dBdC� dCe!e$��ZQG dDdE� dEeQ�ZRedFd(�G dGdH� dHe$��ZSedId(�G dJdK� dKe!e$��ZTG dLdM� dMe#e"�ZUG dNdO� dOeU�ZVedPd(�G dQdR� dRe$��ZWG dSdT� dTe!e$�ZXG dUdV� dVe$�ZYG dWdX� dXeY�ZZG dYdZ� dZeY�Z[dS )[� N)� defaultdict��Decimal)�UUID)�EmptyResultSet� FieldError� FullResultSet)� DatabaseError�NotSupportedError� connection)�fields)� LOOKUP_SEP)�Q)�deconstructible)�RemovedInDjango50Warning)�cached_property)� make_hashablec @ s e Zd ZdZdd� ZdS )�SQLiteNumericMixinzp Some expressions with output_field=DecimalField() must be cast to numeric to be properly filtered. c K sN | j ||fi |��\}}z| j�� dkr0d| }W n tyD Y n0 ||fS )N� DecimalFieldzCAST(%s AS NUMERIC))�as_sql� output_field�get_internal_typer )�self�compilerr � extra_context�sql�params� r �]/home/gouroczh/virtualenv/pat/3.9/lib/python3.9/site-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;d<� Z&d=d>� Z'd?d@� Z(dAS )B� 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�st|�}|r"t||| �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�r4 �MUL�r r r r �__neg__K s zCombinable.__neg__c C s | � || jd�S �NF�r4 �ADD�r r1 r r r �__add__N s zCombinable.__add__c C s | � || jd�S r: �r4 �SUBr= r r r �__sub__Q s zCombinable.__sub__c C s | � || jd�S r: r6 r= r r r �__mul__T s zCombinable.__mul__c C s | � || jd�S r: �r4 �DIVr= r r r � __truediv__W s zCombinable.__truediv__c C s | � || jd�S r: �r4 �MODr= r r r �__mod__Z s zCombinable.__mod__c C s | � || jd�S r: �r4 �POWr= r r r �__pow__] s zCombinable.__pow__c C s4 t | dd�r(t |dd�r(t| �t|�@ S td��d S �N� conditionalF�FUse .bitand(), .bitor(), and .bitxor() for bitwise logical operations.��getattrr �NotImplementedErrorr= r r r �__and__` s �zCombinable.__and__c C s | � || jd�S r: )r4 �BITANDr= r r r �bitandg s zCombinable.bitandc C s | � || jd�S r: )r4 � BITLEFTSHIFTr= r r r � bitleftshiftj s zCombinable.bitleftshiftc C s | � || jd�S r: )r4 � BITRIGHTSHIFTr= r r r � bitrightshiftm s zCombinable.bitrightshiftc C s4 t | dd�r(t |dd�r(t| �t|�A S td��d S rL rO r= r r r �__xor__p s �zCombinable.__xor__c C s | � || jd�S r: )r4 �BITXORr= r r r �bitxorw s zCombinable.bitxorc C s4 t | dd�r(t |dd�r(t| �t|�B S td��d S rL rO r= r r r �__or__z s �zCombinable.__or__c C s | � || jd�S r: )r4 �BITORr= r r r �bitor� s zCombinable.bitorc C s | � || jd�S �NTr; r= r r r �__radd__� s zCombinable.__radd__c C s | � || jd�S r_ r? r= r r r �__rsub__� s zCombinable.__rsub__c C s | � || jd�S r_ r6 r= r r r �__rmul__� s zCombinable.__rmul__c C s | � || jd�S r_ rC r= r r r � __rtruediv__� s zCombinable.__rtruediv__c C s | � || jd�S r_ rF r= r r r �__rmod__� s zCombinable.__rmod__c C s | � || jd�S r_ rI r= r r r �__rpow__� s zCombinable.__rpow__c C s t d��d S �NrN �rQ r= r r r �__rand__� s �zCombinable.__rand__c C s t d��d S rf rg r= r r r �__ror__� s �zCombinable.__ror__c C s t d��d S rf rg r= r r r �__rxor__� s �zCombinable.__rxor__c C s t | �S �N)�NegatedExpressionr8 r r r � __invert__� s zCombinable.__invert__N))r r! r" r# r< r@ r7 rD rJ rG rS r] rU rW rZ r4 r9 r> rA rB rE rH rK rR rT rV rX rY r[ r\ r^ r` ra rb rc rd re rh ri rj rm r r r r r$ % sL r$ c @ sX e Zd ZdZeZdZdZdZdZ dGdd�Z dd� Z d d � Z d d � Z d d� Zdd� Zdd� Zedd� �Zedd� �Zedd� �Zedd� �ZdHdd �Zed d � �Zed d � �Zed!d"� �Zed#d$� �Zd%d&� Z e d'd(� �Z ed)d*� �Z d+d,� Z d-d.� Z!d/d0� Z"d1d2� Z#d3d4� Z$d5d6� Z%d7d8� Z&d9d:� Z'd;d<� Z(d=d>� Z)d?d@� Z*dAdB� Z+dCdD� Z,dEdF� Z-dS )I�BaseExpressionz%Base class for all query expressions.FTNc C s |d ur|| _ d S rk �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__� s zBaseExpression.__getstate__c C s$ | j | ju rg n| j g| j�|� S rk )rr �_convert_value_noopr �get_db_converters�r r r r r ry � s � �z BaseExpression.get_db_convertersc C s g S rk r r8 r r r �get_source_expressions� s z%BaseExpression.get_source_expressionsc C s |rJ �d S rk r �r �exprsr r r �set_source_expressions� s z%BaseExpression.set_source_expressionsc G s dd� |D �S )Nc S s4 g | ],}t |d �r|nt|t�r(t|�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 s t d��dS )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()Nrg �r r r r r r r � s zBaseExpression.as_sqlc C s t dd� | �� D ��S )Nc s s | ]}|o|j V qd S rk )�contains_aggregate�r� �exprr r r � <genexpr>� s z4BaseExpression.contains_aggregate.<locals>.<genexpr>��anyr{ r8 r r r r� � s �z!BaseExpression.contains_aggregatec C s t dd� | �� D ��S )Nc s s | ]}|o|j V qd S rk )�contains_over_clauser� r r r r� � s z6BaseExpression.contains_over_clause.<locals>.<genexpr>r� r8 r r r r� � s �z#BaseExpression.contains_over_clausec C s t dd� | �� D ��S )Nc s s | ]}|o|j V qd S rk )�contains_column_referencesr� r r r r� � s �z<BaseExpression.contains_column_references.<locals>.<genexpr>r� r8 r r r r� � s �z)BaseExpression.contains_column_referencesc C s t dd� | �� D ��S )Nc s s$ | ] }|ot |d d�p|jV qdS )�subqueryFN)rP �contains_subqueryr� r r r r� s �z3BaseExpression.contains_subquery.<locals>.<genexpr>r� r8 r r r r� s �z BaseExpression.contains_subqueryc 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 rk r r� �� allow_joins�query�reuse� summarizer r r� s ��z5BaseExpression.resolve_expression.<locals>.<listcomp>)rt � is_summaryr~ r{ �r r� r� r� r� �for_save�cr r� r r- s ��z!BaseExpression.resolve_expressionc C s t | jtj�S rk )r� r r � BooleanFieldr8 r r r rM & s zBaseExpression.conditionalc C s | j S rk ro r8 r r r �field* s zBaseExpression.fieldc C s" | � � }|du r d| _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 rp r r r r . s zBaseExpression.output_fieldc C s( z| j W S ty" | js � Y n0 dS )z� Return the output field of this expression, or None if _resolve_output_field() didn't return an output type. N)r r r� r8 r r r �_output_field_or_none7 s z$BaseExpression._output_field_or_nonec C sT dd� | � � D �}|D ]8}|D ](}t||j�s td|jj|jjf ��q | S dS )a} Attempt to infer the output type of the expression. As a guess, if the output fields of all source fields match then simply infer the same type here. 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 rk r )r� �sourcer r r r� Q 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 Z sources_iterr r� r r r r� C s � ���z$BaseExpression._resolve_output_fieldc C s | S rk r ��value� expressionr r r r rx a s z"BaseExpression._convert_value_noopc C sF | j }|�� }|dkr dd� S |�d�r0dd� 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 s | d u r d S t | �S rk )�floatr� r r r �<lambda>p s �z.BaseExpression.convert_value.<locals>.<lambda>� IntegerFieldc S s | d u r d S t | �S rk )�intr� r r r r� v s �r c S s | d u r d S t | �S rk r r� r r r r� | s �)r r �endswithrx )r r� Z internal_typer r r rr e s � ��z BaseExpression.convert_valuec C s | j �|�S rk )r � get_lookup)r �lookupr r r r� � s zBaseExpression.get_lookupc C s | j �|�S rk )r � get_transform�r �namer r r r� � s z BaseExpression.get_transformc s( | � � }|�� fdd�| �� D �� |S )Nc s" g | ]}|d ur|� � �nd �qS rk )�relabeled_clone�r� �e�� change_mapr r r� � s �z2BaseExpression.relabeled_clone.<locals>.<listcomp>�rt r~ r{ )r r� �cloner r� r r� � s ��z BaseExpression.relabeled_clonec s> � � | � }r|S | �� }|�� }|�� fdd�|D �� |S )Nc s g | ]}|r|� � �nd �qS rk )�replace_expressionsr� �� replacementsr r r� � s �z6BaseExpression.replace_expressions.<locals>.<listcomp>)�getrt r{ r~ )r r� � replacementr� �source_expressionsr r� r r� � s ��z"BaseExpression.replace_expressionsc C s$ t � }| �� D ]}||�� O }q|S rk )�setr{ �get_refs)r �refsr� r r r r� � s zBaseExpression.get_refsc C s t � | �S rk �rt r8 r r r rt � s zBaseExpression.copyc s( | � � }|�� fdd�| �� D �� |S )Nc s2 g | ]*}t |t�r$t� � |j� ��n|�� ��qS r )r� r� r� �prefix_referencesr� ��prefixr r r� � s ��z4BaseExpression.prefix_references.<locals>.<listcomp>r� )r r� r� r r� r r� � s ��z BaseExpression.prefix_referencesc C s0 | j s | gS g }| �� D ]}|�|�� � q|S rk )r� r{ �extend�get_group_by_cols�r �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� � � z4BaseExpression.get_source_fields.<locals>.<listcomp>)r{ r8 r r r r� � s z BaseExpression.get_source_fieldsc K s t | fi |��S rk ��OrderBy�r �kwargsr r r �asc� s zBaseExpression.ascc K s t | fddi|��S �N� descendingTr� r� r r r �desc� s zBaseExpression.descc C s | S rk r r8 r r r �reverse_ordering� s z BaseExpression.reverse_orderingc c s< | V | � � D ](}|rt|d�r0|�� 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� � 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_format)N)NTNFF).r r! r" r# �NotImplemented�empty_result_set_valuer� r� Z filterable�window_compatiblerq rw ry r{ r~ r� r r r� r� r� r� r- �propertyrM r� r r� r� � staticmethodrx rr r� r� r� r� r� rt r� r� r� r� r� r� r� r� r r r r rn � sd � rn 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 ]R\}}t |t j �r�|j rv|j rv|j jj|j f}q�t|�}nt|�}|�||f� qDt|�S rk )�inspect� signaturerq Z_constructor_args� bind_partial�apply_defaults� arguments�itemsr� r� r �Fieldr� �model�_meta�label�typer �append�tuple) r Zconstructor_signature�argsr� r� r� �identityr� r� r r r r� � s zExpression.identityc C s t |t�stS |j| jkS rk )r� r� r� r� r= r r r �__eq__� s zExpression.__eq__c C s t | j�S rk )�hashr� r8 r r r �__hash__� s zExpression.__hash__N)r r! r" r# r r� r� r� r r r r r� � s r� c C s< i | ]4}|t jt jt jft jt jt jft jt jt jfg�qS r )r r� r� r �r� r2 r r r � <dictcomp> s ��r� c C sJ i | ]B}|t jt jt jft jt jt jft jt jt jft jt jt jfg�qS r )r r� r r� r� r r r r� s ��c C s i | ]}|t jt jt jfg�qS r )r r� r� r r r r� , s ��c C s8 i | ]0}t jt jt jfD ]}||t|ft||fg�qqS r )r r� r r� �NoneType)r� r2 Z field_typer r r r� 9 s ��c C s t | �| ||f� dS )z� Register combinable types: lhs <connector> rhs -> result e.g. register_combinable_fields( IntegerField, Combinable.ADD, FloatField, FloatField ) N)�_connector_combinatorsr� )�lhsr2 �rhs�resultr r r �register_combinable_fieldsl s r� � )�maxsizec C s< t �| d�}|D ]&\}}}t||�rt||�r| S qd S )Nr )r� r� � issubclass)r2 �lhs_type�rhs_typeZ combinatorsZcombinator_lhs_typeZcombinator_rhs_type� combined_typer r r �_resolve_combined_type~ s �r� c sX e Zd Zd� fdd� Zdd� Zdd� Zdd � Zd d � Zd d � Zdd� Z ddd�Z � Z S )r0 Nc s$ t � j|d� || _|| _|| _d S �Nro )�superrq r2 r� r� )r r� r2 r� r �r� r r rq � s zCombinedExpression.__init__c C s d� | jj| �S )Nz<{}: {}>)�formatr� r r8 r r r �__repr__� s zCombinedExpression.__repr__c C s d� | j| j| j�S )Nz{} {} {})r r� r2 r� r8 r r r �__str__� s zCombinedExpression.__str__c C s | j | jgS rk �r� r� r8 r r r r{ � s z)CombinedExpression.get_source_expressionsc C s |\| _ | _d S rk r r| r r r r~ � s z)CombinedExpression.set_source_expressionsc C sZ t | jt| jj�t| jj��}|d u rTtd| j�d| jjjj � d| jjjj � d���|� S )NzCannot infer type of z# expression involving these types: �, z . You must set output_field.) r� r2 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� �opsZcombine_expressionr2 �r r r r� Zexpression_paramsr r Zexpression_wrapperr r r r � s zCombinedExpression.as_sqlTFc C s | j �|||||�}| j�|||||�}t| ttf�s�z|j�� }W n tt fy^ d }Y n0 z|j�� } W n tt fy� d } Y n0 d|| hv r�|| kr�t| j | j | j��|||||�S h d�} | j | j kr�|| v r�|| kr�t| j | j��|||||�S | � � } || _ || _ || _| S )N� DurationField> � TimeField� DateTimeField� DateField)r� r- r� r� �DurationExpression�TemporalSubtractionr r �AttributeErrorr r2 r@ rt r� ) r r� r� r� r� r� r� r� r� r� Zdatetime_fieldsr� r r r r- � sX � � �� ����z%CombinedExpression.resolve_expression)N)NTNFF) r r! r" rq r r r{ r~ r� r r- � __classcell__r r r r r0 � s �r0 c s, e Zd Zdd� Z� fdd�Zdd� Z� ZS )r c C sR z |j }W n ty Y n,0 |�� dkrH|�|�\}}|j�|�|fS |�|�S )Nr )r r r r r Z format_for_duration_arithmetic)r Zsider r �outputr r r r r r � s zDurationExpression.compilec s� |j jrt� �||�S |j�| � g }g }| �| j||�\}}|�|� |� |� | �| j ||�\}}|�|� |� |� d}|j� | j |�}|| |fS r ) �featuresZhas_native_duration_fieldr r r �check_expression_supportr r� r� r� r� Zcombine_duration_expressionr2 r r r r r � s zDurationExpression.as_sqlc K s� | j ||fi |��\}}| jtjtjhv r�z | jj�� }| jj�� }W n t t fy\ Y n,0 h d�}||vsv||vr�t d| j� d���||fS )N> r� r r r� z Invalid arguments for operator �.) r r2 r$ r7 rD r� r r r� r r r ) r r r r r r r� r� Zallowed_fieldsr r r r s �z DurationExpression.as_sqlite)r 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 rk )r rq r@ )r r� r� r r r rq s z TemporalSubtraction.__init__c C s< |j �| � |�| j�}|�| j�}|j �| jj�� ||�S rk )r r r r� r� Zsubtract_temporalsr r )r r r r� r� r r r r # s �zTemporalSubtraction.as_sql) r r! r" r r r rq r r r r r r r s r zdjango.db.models.F)�pathc @ sZ e Zd ZdZdd� Zdd� Zdd d �Zd d � Zd d� Zdd� Z dd� Z dd� 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 rq 0 s z F.__init__c C s d� | jj| j�S �N�{}({}))r r� r r� r8 r r r r 7 s z F.__repr__NTFc C s |� | j|||�S rk )� resolve_refr� �r r� r� r� r� r� r r r r- : s zF.resolve_expressionc C s |� | | �S rk )r� )r r� r r r r� ? s zF.replace_expressionsc K s t | fi |��S rk r� r� r r r r� B s zF.ascc K s t | fddi|��S r� r� r� r r r r� E s zF.descc C s | j |j ko| j|jkS rk )r� r� r= r r r r� H s zF.__eq__c C s t | j�S rk )r� r� r8 r r r r� K s z F.__hash__c C s t � | �S rk r� r8 r r r rt N s zF.copy)NTNFF) r r! r" r# rq r r- r� r� r� r� r� rt r r r r r� , s � r� c s@ e Zd ZdZdZdZdd� Z� fdd�Zdd� Zd 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 s t d��d S )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 ] s �zResolvedOuterRef.as_sqlc s: t � j|i |��}|jr*td| j� d���t| jv |_|S )Nz<Referencing outer query window expression is not supported: r )r r- r� r r� r �possibly_multivalued)r r� r� �colr r r r- c s �� z#ResolvedOuterRef.resolve_expressionc C s | S rk r �r �relabelsr r r r� p s z ResolvedOuterRef.relabeled_clonec C s g S rk r r8 r r r r� s s z"ResolvedOuterRef.get_group_by_cols) r r! r" r# r� r� r r- r� r� r r r r r r R s r c @ s$ e Zd ZdZdZdd� Zdd� ZdS )�OuterRefFc O s t | j| j�r| jS t| j�S rk )r� r� r� r r r r r r- { s zOuterRef.resolve_expressionc C s | S rk r r! r r r r� � s zOuterRef.relabeled_cloneN)r r! r" r� r� r- r� r r r r r# w s r# zdjango.db.models.Funcc 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)r ro c sh | j d urDt|�| j krDtd| jj| j | j dkr4dndt|�f ��t� j|d� | j|� | _|| _ d S )Nz#'%s' takes exactly %s %s (%s given)� �argumentr� ro ) �arity�len� TypeErrorr� r r rq r� r� �extra)r r r� r* r r r rq � 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 s | ]}t |�V qd S rk �r� r� r r r r� � r� z Func.__repr__.<locals>.<genexpr>r c s s& | ] \}}t |�d t |� V qdS )�=Nr+ )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 r8 r r r r2 � s zFunc._get_repr_optionsc C s | j S rk �r� r8 r r r r{ � s zFunc.get_source_expressionsc C s || _ d S rk r4 r| r r r r~ � s zFunc.set_source_expressionsTFc C s> | � � }||_t|j�D ] \}}|�|||||�|j|< q|S rk )rt 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 ]�} z|�| �\} } W n\ tyj t| dt�} | tu rT� |�t| ��\} } Y n$ ty� |�td��\} } Y n0 |� | � |� | � qi | j �|�} |d ur�|| d< n| � d| j � |p�| �d| j�}|p�| �d| j�}|�|� | d< | d< || |fS )Nr� T�function�templater0 r� r� )r r r� r r rP r� r/ r r� r� r* � setdefaultr7 r� r8 r0 r1 )r r r r7 r8 r0 r Z sql_partsr r� Zarg_sqlZ arg_paramsr� �datar r r r � s2 � z Func.as_sqlc s* t � �� }| jd d � |_| j�� |_|S rk )r rt r� r* )r rt r r r rt � s z Func.copy)NTNFF)NNN)r r! r" r# r7 r8 r0 r' rq r r2 r{ r~ r- r rt r r r r r r$ � s" � � 'r$ zdjango.db.models.Valuec s` e Zd ZdZdZd� fdd� Zdd� Zdd � Zd� fd d � Zd d� Z dd� Z e 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(). ro N)r rq r� )r r� r r r r rq � s zValue.__init__c C s | j j� d| j�d�S )N�(�))r� r r� r8 r r r r � s zValue.__repr__c C s| |j �| � | j}| j}|d urb| jr6|j||d�}n|j||d�}t|d�rb|�|||�|gfS |d u rrdg fS d|gfS )N)r �get_placeholderZNULLz%s) r r r� r� r� Zget_db_prep_saveZget_db_prep_valuer. r= )r r r r. r r r r r s z Value.as_sqlTc s t � �|||||�}||_|S rk )r r- r� r� r r r r- s zValue.resolve_expressionc C s g S rk r r8 r r r r� s zValue.get_group_by_colsc C s� t | jt�rt�� S t | jt�r(t�� S t | jt�r<t�� S t | jt �rPt� � S t | jt j �rft� � S t | jt j �r|t�� S t | jt j�r�t�� S t | jt j�r�t�� S t | jt�r�t�� S t | jt�r�t�� S t | jt�r�t�� S d S rk )r� r� r� r Z CharField�boolr� r� r� r� r� �datetimer �dater �timer � timedeltar r r �bytesZ BinaryFieldr Z UUIDFieldr8 r r r r� s, zValue._resolve_output_fieldc C s | j S rk )r� r8 r r r r� 4 s z Value.empty_result_set_value)N)NTNFF)r r! r" r# r� rq r r r- r� r� r� r� r r r r r r/ � s �r/ c sD e Zd Zd� fdd� Zdd� Zdd� Zdd � Zd� fd d � Z� ZS )�RawSQLNc s0 |d u rt �� }|| | _| _t� j|d� d S r� )r r� r r r rq )r r r r r r r rq : s zRawSQL.__init__c C s d� | jj| j| j�S �Nr/ )r r� r r r r8 r r r r @ s zRawSQL.__repr__c C s d| j | jfS r )r r r� r r r r C s z RawSQL.as_sqlc C s | gS rk r r8 r r r r� F s zRawSQL.get_group_by_colsTFc sn |j rZ|j j�� D ]F}|jjD ]8}|�� \}} | �� | j�� v r |�|j|||� qq qt � � |||||�S rk ) r� r� Zget_parent_listZ local_fieldsZget_attname_column�lowerr r r� r r- ) r r� r� r� r� r� �parentZ parent_field�_Z column_namer r r r- I s � �zRawSQL.resolve_expression)N)NTNFF) r r! r" rq r r r� r- r r r r r rD 9 s �rD c @ s e Zd Zdd� Zdd� ZdS )�Starc C s dS )Nz'*'r r8 r r r r \ s z Star.__repr__c C s dg fS )Nr' r r� r r r r _ s z Star.as_sqlN)r r! r" r r r r r r rI [ s rI c sN e Zd ZdZdZd� fdd� Zdd� Zdd � Zd d � Zd d � Z dd� Z � Z S )�ColTFNc s, |d u r |}t � j|d� || | _| _d S r� )r rq �alias�target)r rK rL r r r r rq g s z Col.__init__c C s> | j | j }}|r |t|�fnt|�f}d�| jjd�|��S )Nr r )rK rL r� r r� r r1 )r rK rL � identifiersr r r r m s z Col.__repr__c C s< | j | jj }}|r ||fn|f}d�t|j|��}|g fS )Nr )rK rL �columnr1 �mapZquote_name_unless_alias)r r r rK rN rM r r r r r r s z Col.as_sqlc C s, | j d u r| S | �|�| j | j �| j| j�S rk )rK r� r� rL r r! r r r r� x s �zCol.relabeled_clonec C s | gS rk r r8 r r r r� s zCol.get_group_by_colsc C s0 | j | jkr| j�|�S | j�|�| j �|� S rk )rL r ry rz r r r ry � s � �zCol.get_db_converters)N) r r! r" r� r rq r r r� r� ry r r r r r rJ c s rJ c sb e Zd ZdZ� fdd�Zdd� Zdd� Zdd � Zdd d�Zdd� Z dd� Z dd� Z dd� 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 rk )r rq r� r� )r r� r� r r r rq � s z Ref.__init__c C s d� | jj| j| j�S rE )r r� r r� r� r8 r r r r � s z Ref.__repr__c C s | j gS rk �r� r8 r r r r{ � s zRef.get_source_expressionsc C s |\| _ d S rk rQ r| r r r r~ � s zRef.set_source_expressionsNTFc C s | S rk r r r r r r- � s zRef.resolve_expressionc C s | j hS rk )r� r8 r r r r� � s z Ref.get_refsc C s | � � }| j�|�|_|S rk )rt r� r� )r r" r� r r r r� � s zRef.relabeled_clonec C s |j �| j�g fS rk )r Z quote_namer� r� r r r r � s z Ref.as_sqlc C s | gS rk r r8 r r r r� � s zRef.get_group_by_cols)NTNFF)r r! r" r# rq r r{ r~ r- r� r� r r� r r r r r rP � s � rP c s< e Zd ZdZdZ� fdd�Zdd� Zdd� Zd d � Z� Z S ) �ExpressionListz� An expression containing multiple expressions. Can be used to provide a list of expressions as an argument to another expression, like a partition clause. z%(expressions)sc s* |st d| jj ��t� j|i |�� d S )Nz$%s requires at least one expression.)r r� r r rq �r r� r* r r r rq � s �zExpressionList.__init__c C s | j �dd� | jD ��S )Nc s s | ]}t |�V qd S rk r+ r� r r r r� � r� z)ExpressionList.__str__.<locals>.<genexpr>)r0 r1 r� r8 r r r r � s zExpressionList.__str__c K s | j ||fi |��S rk )r )r r r r r r r r � s zExpressionList.as_sqlitec C s$ g }| � � D ]}|�|�� � q |S rk �r{ r� r� )r � group_by_cols� partitionr r r r� � s z ExpressionList.get_group_by_cols) r r! r" r# r8 rq r r r� r r r r r rR � s rR c s4 e Zd ZdZ� fdd�Z� fdd�Zdd� Z� ZS )� OrderByListzORDER BY %(expressions)sc s$ dd� |D �}t � j|i |�� d S )Nc s s@ | ]8}t |t�r4|d dkr4tt|dd� �dd�n|V qdS )r r& r% NT�r� )r� r� r� r� r� r r r r� � s �� �z'OrderByList.__init__.<locals>.<genexpr>)r rq rS r r r rq � s �zOrderByList.__init__c s | j s dS t� j|i |��S )N)� r )r� r r r r r r r � s zOrderByList.as_sqlc C s$ g }| � � D ]}|�|�� � q |S rk rT )r rU �order_byr r r r� � s z OrderByList.get_group_by_cols)r r! r" r8 rq r r� r r r r r rW � s rW z"django.db.models.ExpressionWrapperc sL e Zd ZdZ� fdd�Zdd� Zdd� Z� fdd �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 rq r� )r r� r r r r rq � s zExpressionWrapper.__init__c C s |d | _ d S �Nr �r� r| r r r r~ � s z(ExpressionWrapper.set_source_expressionsc C s | j gS rk r] r8 r r r r{ � s z(ExpressionWrapper.get_source_expressionsc s0 t | jt�r&| j�� }| j|_|�� S t� �� S rk )r� r� r� rt r r� r �r r� r r r r� � s z#ExpressionWrapper.get_group_by_colsc C s |� | j�S rk )r r� r� r r r r s zExpressionWrapper.as_sqlc C s d� | jj| j�S r )r r� r r� r8 r r r r s zExpressionWrapper.__repr__) r r! r" r# rq r~ r{ r� r r r r r r r r[ � s r[ c sJ e Zd ZdZ� fdd�Zdd� Z� fdd�Zd� fd d � Zd d� Z� Z S )rl z1The logical negation of a conditional expression.c s t � j|t�� d� d S r� )r rq r r� r^ r r r rq s zNegatedExpression.__init__c C s | j �� S rk )r� rt r8 r r r rm s z NegatedExpression.__invert__c s~ zt � �||�\}}W n4 tyJ |jj}|js8Y dS |�td�� Y S 0 |jj}|� | j �spd|� d�|fS d|� �|fS )N)z1=1r Tz CASE WHEN z = 0 THEN 1 ELSE 0 ENDzNOT ) r r r r r �&supports_boolean_expr_in_select_clauser r/ r �0conditional_expression_supported_in_where_clauser� )r r r r r r r r r r r s zNegatedExpression.as_sqlNTFc s. t � �|||||�}t|jdd�s*td��|S )NrM Fz*Cannot negate non-conditional expressions.)r r- rP r� r) )r r� r� r� r� r� �resolvedr r r r- % s �z$NegatedExpression.resolve_expressionc C s0 |j jj}|j jjs(|| j�r(d�|�}||fS �Nz CASE WHEN {} THEN 1 ELSE 0 END)r r r` r r_ r� r )r r r r Z$expression_supported_in_where_clauser r r r� / s ��� z NegatedExpression.select_format)NTNFF) r r! r" r# rq rm r r- r� r r r r r rl s � rl zdjango.db.models.Whenc sj e Zd ZdZdZd� fdd� Zdd� Zdd � Zd d � Zd d � Z dd� Z ddd�Z ddd�Z dd� Z � ZS )�Whenz"WHEN %(condition)s THEN %(result)sFNc s� |rD|d u r"t f i |��d }}n"t|dd�rDt |fi |��d }}|d u s\t|dd�r\|rdtd��t|t �rz|sztd��t� jd d� || _| �|�d | _ d S )NrM FzLWhen() supports a Q object, a boolean expression, or lookups as a condition.z1An empty Q() can't be used as a When() condition.ro r ) r rP r) r� r r rq � conditionr� r� )r rd �then�lookupsr r r rq E s �z When.__init__c C s d| j | jf S )NzWHEN %r THEN %r�rd r� r8 r r r r V s z When.__str__c C s d| j j| f S �Nz<%s: %s>�r� r r8 r r r r Y s z When.__repr__c C s | j | jgS rk rg r8 r r r r{ \ s zWhen.get_source_expressionsc C s |\| _ | _d S rk rg r| r r r r~ _ s zWhen.set_source_expressionsc C s | j jgS rk )r� r� r8 r r r r� b s zWhen.get_source_fieldsTc C sJ | � � }||_t|jd�r0|j�||||d�|_|j�|||||�|_|S )Nr- F)rt r� r. rd r- r� r� r r r r- f s � �zWhen.resolve_expressionc K sh |j �| � |}g }|�| j�\}}||d< |�| j�\} } | |d< |pL| j}|| g |�|�| �R fS )Nrd r� )r r r rd r� r8 ) r r r r8 r �template_params� sql_paramsZ condition_sqlZcondition_paramsZ result_sqlZ result_paramsr r r r t s ���z When.as_sqlc C s$ g }| � � D ]}|�|�� � q |S rk rT r� r r r r� � s zWhen.get_group_by_cols)NN)NTNFF)N)r r! r" r8 rM rq r r r{ r~ r� r- r r� r r r r r rc ? s � rc zdjango.db.models.Casec s| e Zd ZdZdZdZddd�� fdd� Zdd � Zd d � Zd d � Z dd� Z ddd�Z � fdd�Z ddd�Z � 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 ��std��t� �|� t|�| _| �|�d | _|| _d S )Nc s s | ]}t |t�V qd S rk )r� rc )r� �caser r r r� � r� z Case.__init__.<locals>.<genexpr>z.Positional arguments must all be When objects.r ) �allr) r rq �list�casesr� rn r* )r rn r rr r* r r r rq � s z Case.__init__c C s dd� dd� | jD ��| jf S )NzCASE %s, ELSE %rr c s s | ]}t |�V qd S rk r+ )r� r� r r r r� � r� z Case.__str__.<locals>.<genexpr>)r1 rr rn r8 r r r r � s �z Case.__str__c C s d| j j| f S rh ri r8 r r r r � s z Case.__repr__c C s | j | jg S rk �rr rn r8 r r r r{ � s zCase.get_source_expressionsc C s |�^ | _ | _d S rk rs r| r r r r~ � s zCase.set_source_expressionsTFc C sT | � � }||_t|j�D ] \}}|�|||||�|j|< q|j�|||||�|_|S rk )rt r� r5 rr r- rn ) r r� r� r� r� r� r� r6 ro r r r r- � s � �zCase.resolve_expressionc s t � �� }|jd d � |_|S rk )r rt rr )r r� r r r rt � s z Case.copyc K s* |j �| � | js |�| j�S i | j�|�}g }g }|�| j�\} } | jD ]h} z|�| �\} } W n< tyv Y qJY n( ty� |�| j�\} } Y q�Y n0 |� | � |� | � qJ|s�| | fS |p�| j }|� |�|d< | |d< |� | � |p�|� d| j�}|| }| jd u�r"|j �| j�| }||fS )Nrr rn r8 )r r rr r rn r* r r r� r� r� � case_joinerr1 r� r8 r� Zunification_cast_sqlr )r r r r8 rt r rj Z case_partsrk Z default_sqlZdefault_paramsro Zcase_sqlZ case_paramsr r r r r � s8 z Case.as_sqlc s | j s| j�� S t� �� S rk )rr rn r� r r8 r r r r� � s zCase.get_group_by_cols)NTNFF)NN)r r! r" r# r8 rt rq r r r{ r~ r- rt r r� r r r r r rl � s � � rl c s| e Zd ZdZdZdZdZdZd� fdd� Zdd � Z d d � Z d d � Z � fdd�Z e dd� �Zdd� Zddd�Zdd� 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)FNTc s0 t |d|��� | _d| j_|| _t� �|� d S )Nr� T)rP r� r� r� r* r rq )r �querysetr r* r r r rq � s zSubquery.__init__c C s | j gS rk �r� r8 r r r r{ � s z Subquery.get_source_expressionsc C s |d | _ d S r\ rw r| r r r r~ s z Subquery.set_source_expressionsc C s | j jS rk )r� r r8 r r r r� s z Subquery._resolve_output_fieldc s t � �� }|j�� |_|S rk )r rt r� r� )r r� r r r rt s z Subquery.copyc C s | j jS rk )r� �external_aliasesr8 r r r rx s zSubquery.external_aliasesc C s | j �� S rk )r� �get_external_colsr8 r r r ry s zSubquery.get_external_colsc K s^ |j �| � i | j�|�}| j�||�\}}|dd� |d< |pL|�d| j�}|| }||fS )Nr% r5 r� r8 )r r r* r� r r� r8 ) r r r r8 r rj Z subquery_sqlrk r r r r r s zSubquery.as_sqlc C s | j j| d�S )N)�wrapper)r� r� r8 r r r r� s zSubquery.get_group_by_cols)N)N)r r! r" r# r8 r� r� r� rq r{ r~ r� rt r� rx ry r r� r r r r r ru � s ru c s4 e Zd ZdZe�� ZdZ� fdd�Zdd� Z � Z S )�ExistszEXISTS(%(subquery)s)Fc s$ t � j|fi |�� | j�� | _d S rk )r rq r� �exists)r rv r� r r r rq & s zExists.__init__c C s |j jjsd�|�}||fS rb )r r r_ r r� r r r r� * s zExists.select_format) r r! r" r8 r r� r r� rq r� r r r r r r{ ! s r{ zdjango.db.models.OrderByc @ sh e Zd ZdZdZddd�Zdd� Zdd � Zd d � Zdd d �Z dd� Z dd� Z dd� Z dd� Z dd� ZdS )r� z%(expression)s %(ordering)sFNc C s^ |r|rt d��|du s |du r0tjdtdd� || _|| _|| _t|d�sTt d��|| _d S )Nz1nulls_first and nulls_last are mutually exclusiveFzNPassing nulls_first=False or nulls_last=False is deprecated, use None instead.� )� stacklevelr- z%expression must be an expression type) r �warnings�warnr � nulls_first� nulls_lastr� r. r� )r r� r� r� r� r r r rq 8 s � zOrderBy.__init__c C s d� | jj| j| j�S )Nz{}({}, descending={}))r r� r r� r� r8 r r r r M s �zOrderBy.__repr__c C s |d | _ d S r\ r] r| r r r r~ R s z OrderBy.set_source_expressionsc C s | j gS rk r] r8 r r r r{ U s z OrderBy.get_source_expressionsc K s� |p| j }|jjr2| jr"d| }ql| jrld| }n:| jrP| jrF|jjsPd| }n | jrl| jsd|jjsld| }|j�| � |� | j �\}}|| jr�dndd�|�}||� d�9 }|| � � |fS ) Nz %s NULLS LASTz%s NULLS FIRSTz%%(expression)s IS NULL, %sz %%(expression)s IS NOT NULL, %sZDESC�ASC)r� Zorderingz%(expression)s) r8 r Z supports_order_by_nulls_modifierr� r� r� Zorder_by_nulls_firstr r r r� �count�rstrip)r r r r8 r Zexpression_sqlr Z placeholdersr r r r X s6 �� �� ��zOrderBy.as_sqlc C sF |j �| j�r:| �� }tt| jdd�dd�|_|�||�S | �||�S )NT)re F)rn )r r` r� rt rl rc r )r r r rt r r r � as_oracler s � � zOrderBy.as_oraclec C s$ g }| � � D ]}|�|�� � q |S rk rT r� r r r r� � s zOrderBy.get_group_by_colsc C s4 | j | _ | jr d| _d | _n| jr0d| _d | _| S r_ )r� r� r� r8 r r r r� � s zOrderBy.reverse_orderingc C s d| _ d S r: rX r8 r r r r� � s z OrderBy.ascc C s d| _ d S r_ rX r8 r r r r� � s z OrderBy.desc)FNN)N)r r! r" r8 rM rq r r~ r{ r r� r� r� r� r� r r r r r� 3 s r� c sp e Zd ZdZdZdZd� fdd� Zdd� Zd d � Zd d � Z dd d�Z � fdd�Z dd� Z dd� Z dd� Z� ZS )�Windowz %(expression)s OVER (%(window)s)FTNc s� || _ || _|| _t|dd�s.td|jj ��| j d ur^t| j tt f�sR| j f| _ t | j � | _ | jd ur�t| jt tf�r�t | j� | _n&t| jt t f�r�t | j�| _ntd��t� j|d� | �|�d | _d S )Nr� Fz3Expression '%s' isn't compatible with OVER clauses.zhWindow.order_by must be either a string reference to a field, an expression, or a list or tuple of them.ro r )� partition_byrZ �framerP r r� r r� r� rq rR rW rn r� r rq r� �source_expression)r r� r� rZ r� r r r r rq � s. �� �zWindow.__init__c C s | j jS rk )r� r r8 r r r r� � s z Window._resolve_output_fieldc C s | j | j| j| jgS rk �r� r� rZ r� r8 r r r r{ � s z Window.get_source_expressionsc C s |\| _ | _| _| _d S rk r� r| r r r r~ � s z Window.set_source_expressionsc C s� |j �| � |jjs td��|�| j�\}}g d }}| jd url| jj||dd�\}} |� |� |t | �7 }| j d ur�|�| j �\} } |� | � |t | �7 }| j r�|�| j �\} } |� | � |t | �7 }|p�| j }||d�|��� d� g |�|�R fS )Nz1This backend does not support window expressions.r z PARTITION BY %(expressions)s)r r r8 rm )r� Zwindow)r r r Zsupports_over_clauser r r� r� r r� r� rZ r� r8 r1 �strip)r r r r8 Zexpr_sqlr Z window_sqlZ window_paramsZsql_exprrk Z order_sqlZ order_paramsZ frame_sqlZ frame_paramsr r r r � s2 � �z Window.as_sqlc sT t | jtj�rH| �� }|�� }t�� |d _|�|� tt |�� ||�S | � ||�S r\ ) r� r r r rt r{ r� r~ r r� r r )r r r rt r� r r r r � s zWindow.as_sqlitec C s> d� t| j�| jr dt| j� ndt| jp,d�t| jp8d��S )Nz{} OVER ({}{}{})z PARTITION BY rY )r r� r� r� rZ r� r8 r r r r � s �zWindow.__str__c C s d| j j| f S rh ri r8 r r r r � s zWindow.__repr__c C s8 g }| j r|�| j �� � | jd ur4|�| j�� � |S rk )r� r� r� rZ )r rU r r r r� s zWindow.get_group_by_cols)NNNN)N)r r! r" r8 r� r� rq r� r{ r~ r r r r r� r r r r r r� � s �$ ! r� c @ sV e Zd ZdZdZddd�Zdd� Zdd � Zd d � Zd d � Z dd� 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 rk )r/ �start�end�r r� r� r r r rq s zWindowFrame.__init__c C s |\| _ | _d S rk �r� r� r| r r r r~ s z"WindowFrame.set_source_expressionsc C s | j | jgS rk r� r8 r r r r{ s 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� r8 r� )r r r r� r� r r r r s ����zWindowFrame.as_sqlc C s d| j j| f S rh ri r8 r r r r / s zWindowFrame.__repr__c C s g S rk r r8 r r r r� 2 s z WindowFrame.get_group_by_colsc C s� | j jd ur2| j jdk r2dt| j j�tjjf }n*| j jd urT| j jdkrTtjj}ntjj}| jjd ur�| jjdkr�d| jjtjj f }n*| jjd ur�| jjdkr�tjj}ntjj }| j | j ||d� S )Nr z%d %sr� ) r� r� �absr r Z PRECEDINGZ CURRENT_ROWZUNBOUNDED_PRECEDINGr� Z FOLLOWINGZUNBOUNDED_FOLLOWINGr8 r� r� r r r r 5 s �zWindowFrame.__str__c C s t d��d S )Nz3Subclasses must implement window_frame_start_end().rg �r r r� r� r r r r� I s z"WindowFrame.window_frame_start_end)NN) r r! r" r# r8 rq r~ r{ r r r� r r� r r r r r� s r� c @ s e Zd ZdZdd� ZdS )�RowRangeZROWSc C s |j �||�S rk )r Zwindow_frame_rows_start_endr� r r r r� P s z RowRange.window_frame_start_endN�r r! r" r� r� r r r r r� M s r� c @ s e Zd ZdZdd� ZdS )� ValueRange�RANGEc C s |j �||�S rk )r Z window_frame_range_start_endr� r r r r� W s z!ValueRange.window_frame_start_endNr� r r r r r� T s r� )\rt r? � functoolsr� r � collectionsr �decimalr �uuidr Zdjango.core.exceptionsr r r Z django.dbr r r Zdjango.db.modelsr Zdjango.db.models.constantsr Z django.db.models.query_utilsr Zdjango.utils.deconstructr Zdjango.utils.deprecationr Zdjango.utils.functionalr Zdjango.utils.hashabler r r$ rn r� r� r� r< r@ r7 rD rG rJ rS r] rU rW rZ r r r r Z_connector_combinationsrq r� r� �dr� r2 Z field_typesr� r� r� � lru_cacher� r0 r r r� r r# r$ r/ rD rI rJ rP rR rW r[ rl rc rl ru r{ r� r� r� r� r� r r r r �<module> s� 9%������ �������a b3%% dO"') 3K`5ctB