o
    ×ŸŽiý  ã                   @   sØ  d dl Z d dlZd dlZd dlZd dlZd dlmZ d dlmZ d dl	m
Z
 d dlmZmZ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 d dlmZ d dlmZ d dlm Z  G dd„ dƒZ!G dd„ dƒZ"G dd„ dƒZ#eG dd„ de#e"ƒƒZ$e%dƒZ&dd„ e"j'e"j(e"j)e"j*e"j+e"j,fD ƒdd„ e"j'e"j(e"j)e"j*e"j+fD ƒdd„ e"j-e"j.e"j/e"j0e"j1fD ƒdd„ e"j'e"j(e"j)e"j*e"j+e"j,fD ƒe"j'ej2ej3ej4fej4ej3ej4fej3ej2ej4fej3ej4ej4fej3ej3ej3fej5ej3ej5fej3ej5ej5fgie"j(ej2ej3ej4fej4ej3ej4fej2ej2ej3fej2ej4ej3fej4ej2ej3fej4ej4ej3fej3ej3ej3fej5ej3ej5fej5ej5ej3fg	igZ6ee7ƒZ8dd„ Z9e6D ]Z:e: ;¡ D ]\Z<Z=e=D ]\Z>Z?Z@e9e>e<e?e@ƒ �q\�qV�qPejAdd�dd „ ƒZBG d!d"„ d"e!e$ƒZCG d#d$„ d$eCƒZDG d%d&„ d&eCƒZEed'd(�G d)d*„ d*e"ƒƒZFG d+d,„ d,eFƒZGG d-d.„ d.eFƒZHed/d(�G d0d1„ d1e!e$ƒƒZIed2d(�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ƒZPedAd(�G dBdC„ dCe!e$ƒƒZQG dDdE„ dEeQƒZRedFd(�G dGdH„ dHe$ƒƒZSedId(�G dJdK„ dKe!e$ƒƒZTG dLdM„ dMe#e"ƒZUG dNdO„ dOeUƒZVedPd(�G dQdR„ dRe$ƒƒZWG dSdT„ dTe!e$ƒZXG dUdV„ dVe$ƒZYG dWdX„ dXeYƒZZG dYdZ„ dZeYƒZ[dS )[é    N)Údefaultdict©ÚDecimal)ÚUUID)ÚEmptyResultSetÚ
FieldErrorÚFullResultSet)ÚDatabaseErrorÚNotSupportedErrorÚ
connection)Úfields)Ú
LOOKUP_SEP)ÚQ)Údeconstructible)ÚRemovedInDjango50Warning)Úcached_property)Úmake_hashablec                   @   ó   e Zd ZdZdd„ ZdS )ÚSQLiteNumericMixinzp
    Some expressions with output_field=DecimalField() must be cast to
    numeric to be properly filtered.
    c                 K   s\   | j ||fi |¤Ž\}}z| j ¡ dkrd| }W ||fS W ||fS  ty-   Y ||fS w )NÚDecimalFieldzCAST(%s AS NUMERIC))Úas_sqlÚoutput_fieldÚget_internal_typer   )ÚselfÚcompilerr   Úextra_contextÚsqlÚparams© r   úfC:\Users\psant\Downloads\Anu Raj Backend\school\venv\Lib\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 Zd ZdZdZdZdZdZdZdZ	dZ
d	Zd
ZdZdZdd„ Zdd„ Zdd„ Zdd„ Zdd„ Zdd„ Zdd„ Zdd„ Zdd„ Zdd „ Zd!d"„ Zd#d$„ Zd%d&„ Zd'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ƒs	t|ƒ}|rt||| ƒS t| ||ƒS )NÚresolve_expression)ÚhasattrÚValueÚCombinedExpression)r   ÚotherÚ	connectorÚreversedr   r   r   Ú_combine>   s
   
zCombinable._combinec                 C   s   |   d| jd¡S )NéÿÿÿÿF©r5   ÚMUL©r   r   r   r   Ú__neg__K   ó   zCombinable.__neg__c                 C   ó   |   || jd¡S ©NF©r5   ÚADD©r   r2   r   r   r   Ú__add__N   r;   zCombinable.__add__c                 C   r<   r=   ©r5   ÚSUBr@   r   r   r   Ú__sub__Q   r;   zCombinable.__sub__c                 C   r<   r=   r7   r@   r   r   r   Ú__mul__T   r;   zCombinable.__mul__c                 C   r<   r=   ©r5   ÚDIVr@   r   r   r   Ú__truediv__W   r;   zCombinable.__truediv__c                 C   r<   r=   ©r5   ÚMODr@   r   r   r   Ú__mod__Z   r;   zCombinable.__mod__c                 C   r<   r=   ©r5   ÚPOWr@   r   r   r   Ú__pow__]   r;   zCombinable.__pow__c                 C   s0   t | ddƒrt |ddƒrt| ƒt|ƒ@ S tdƒ‚©NÚconditionalFúFUse .bitand(), .bitor(), and .bitxor() for bitwise logical operations.©Úgetattrr   ÚNotImplementedErrorr@   r   r   r   Ú__and__`   ó
   ÿzCombinable.__and__c                 C   r<   r=   )r5   ÚBITANDr@   r   r   r   Úbitandg   r;   zCombinable.bitandc                 C   r<   r=   )r5   ÚBITLEFTSHIFTr@   r   r   r   Úbitleftshiftj   r;   zCombinable.bitleftshiftc                 C   r<   r=   )r5   ÚBITRIGHTSHIFTr@   r   r   r   Úbitrightshiftm   r;   zCombinable.bitrightshiftc                 C   s0   t | ddƒrt |ddƒrt| ƒt|ƒA S tdƒ‚rO   rR   r@   r   r   r   Ú__xor__p   rV   zCombinable.__xor__c                 C   r<   r=   )r5   ÚBITXORr@   r   r   r   Úbitxorw   r;   zCombinable.bitxorc                 C   s0   t | ddƒrt |ddƒrt| ƒt|ƒB S tdƒ‚rO   rR   r@   r   r   r   Ú__or__z   rV   zCombinable.__or__c                 C   r<   r=   )r5   ÚBITORr@   r   r   r   Úbitor�   r;   zCombinable.bitorc                 C   r<   ©NTr>   r@   r   r   r   Ú__radd__„   r;   zCombinable.__radd__c                 C   r<   rc   rB   r@   r   r   r   Ú__rsub__‡   r;   zCombinable.__rsub__c                 C   r<   rc   r7   r@   r   r   r   Ú__rmul__Š   r;   zCombinable.__rmul__c                 C   r<   rc   rF   r@   r   r   r   Ú__rtruediv__�   r;   zCombinable.__rtruediv__c                 C   r<   rc   rI   r@   r   r   r   Ú__rmod__�   r;   zCombinable.__rmod__c                 C   r<   rc   rL   r@   r   r   r   Ú__rpow__“   r;   zCombinable.__rpow__c                 C   ó   t dƒ‚©NrQ   ©rT   r@   r   r   r   Ú__rand__–   ó   ÿzCombinable.__rand__c                 C   rj   rk   rl   r@   r   r   r   Ú__ror__›   rn   zCombinable.__ror__c                 C   rj   rk   rl   r@   r   r   r   Ú__rxor__    rn   zCombinable.__rxor__c                 C   s   t | ƒS ©N)ÚNegatedExpressionr9   r   r   r   Ú
__invert__¥   ó   zCombinable.__invert__N))r!   r"   r#   r$   r?   rC   r8   rG   rM   rJ   rW   ra   rY   r[   r^   r5   r:   rA   rD   rE   rH   rK   rN   rU   rX   rZ   r\   r]   r_   r`   rb   rd   re   rf   rg   rh   ri   rm   ro   rp   rs   r   r   r   r   r%   %   sN    r%   c                   @   sN  e Zd ZdZeZdZdZdZdZ	dEdd„Z
dd„ Zd	d
„ Zdd„ Zdd„ Zdd„ Zdd„ Zedd„ ƒZedd„ ƒZedd„ ƒZ	dFdd„Zedd„ ƒZedd„ ƒZedd „ ƒZed!d"„ ƒZd#d$„ Zed%d&„ ƒZed'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*dAdB„ Z+dCdD„ Z,dS )GÚBaseExpressionz%Base class for all query expressions.FTNc                 C   s   |d ur	|| _ d S d S rq   ©r   ©r   r   r   r   r   Ú__init__µ   s   
ÿzBaseExpression.__init__c                 C   s   | j  ¡ }| dd ¡ |S )NÚconvert_value)Ú__dict__ÚcopyÚpop)r   Ústater   r   r   Ú__getstate__¹   ó   
zBaseExpression.__getstate__c                 C   s$   | j | ju rg n| j g| j |¡ S rq   )ry   Ú_convert_value_noopr   Úget_db_converters©r   r   r   r   r   r�   ¾   s
   
ÿ
üz BaseExpression.get_db_convertersc                 C   ó   g S rq   r   r9   r   r   r   Úget_source_expressionsÅ   ó   z%BaseExpression.get_source_expressionsc                 C   s   |rJ ‚d S rq   r   ©r   Úexprsr   r   r   Úset_source_expressionsÈ   ó   z%BaseExpression.set_source_expressionsc                 G   s   dd„ |D ƒS )Nc                 S   s4   g | ]}t |d ƒr|nt|tƒrt|ƒnt|ƒ‘qS ©r.   )r/   Ú
isinstanceÚstrÚFr0   ©Ú.0Úargr   r   r   Ú
<listcomp>Ì   s    þÿýz5BaseExpression._parse_expressions.<locals>.<listcomp>r   )r   Úexpressionsr   r   r   Ú_parse_expressionsË   s   üz!BaseExpression._parse_expressionsc                 C   rj   )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()Nrl   ©r   r   r   r   r   r   r   Ó   s   zBaseExpression.as_sqlc                 C   ó   t dd„ |  ¡ D ƒƒS )Nc                 s   ó   � | ]}|o|j V  qd S rq   )Úcontains_aggregate©r�   Úexprr   r   r   Ú	<genexpr>ñ   ó   € 

ÿz4BaseExpression.contains_aggregate.<locals>.<genexpr>©Úanyr„   r9   r   r   r   r—   ï   ó   ÿz!BaseExpression.contains_aggregatec                 C   r•   )Nc                 s   r–   rq   )Úcontains_over_clauser˜   r   r   r   rš   ÷   r›   z6BaseExpression.contains_over_clause.<locals>.<genexpr>rœ   r9   r   r   r   rŸ   õ   rž   z#BaseExpression.contains_over_clausec                 C   r•   )Nc                 s   r–   rq   )Úcontains_column_referencesr˜   r   r   r   rš   ý   s
   € ÿ
ÿz<BaseExpression.contains_column_references.<locals>.<genexpr>rœ   r9   r   r   r   r    û   s   þz)BaseExpression.contains_column_referencesc                    s4   |   ¡ }ˆ|_| ‡ ‡‡‡fdd„| ¡ 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|  ˆˆ ˆˆ¡nd ‘qS rq   rŠ   r˜   ©Úallow_joinsÚqueryÚreuseÚ	summarizer   r   r‘     s    þÿýz5BaseExpression.resolve_expression.<locals>.<listcomp>N)r{   Ú
is_summaryrˆ   r„   ©r   r£   r¢   r¤   r¥   Úfor_saveÚcr   r¡   r   r.     s   üÿz!BaseExpression.resolve_expressionc                 C   s   t | jtjƒS rq   )r‹   r   r   ÚBooleanFieldr9   r   r   r   rP     s   zBaseExpression.conditionalc                 C   ó   | j S rq   rv   r9   r   r   r   Úfield#  ó   zBaseExpression.fieldc                 C   s"   |   ¡ }|du rd| _tdƒ‚|S )z+Return the output type of this expressions.NTz4Cannot resolve expression type, unknown output_field)Ú_resolve_output_fieldÚ_output_field_resolved_to_noner   rw   r   r   r   r   '  s
   zBaseExpression.output_fieldc                 C   s&   z| j W S  ty   | js‚ Y dS 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¯   r9   r   r   r   Ú_output_field_or_none0  s   ÿÿz$BaseExpression._output_field_or_nonec                 C   sT   dd„ |   ¡ D ƒ}|D ]}|D ]}t||jƒs#td|jj|jjf ƒ‚q|  S dS )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 ur|V  qd S rq   r   )r�   Úsourcer   r   r   rš   J  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®   <  s    ÿþþÿÿ	õz$BaseExpression._resolve_output_fieldc                 C   ó   | S rq   r   ©ÚvalueÚ
expressionr   r   r   r   r€   Z  ó   z"BaseExpression._convert_value_noopc                 C   sF   | j }| ¡ }|dkrdd„ S | d¡rdd„ S |dkr dd„ S | jS )	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 rd S t | ƒS rq   )Úfloatrµ   r   r   r   Ú<lambda>i  ó   ÿz.BaseExpression.convert_value.<locals>.<lambda>ÚIntegerFieldc                 S   rº   rq   )Úintrµ   r   r   r   r¼   o  r½   r   c                 S   rº   rq   r   rµ   r   r   r   r¼   u  r½   N)r   r   Úendswithr€   )r   r¬   Zinternal_typer   r   r   ry   ^  s   ÿ
ÿÿzBaseExpression.convert_valuec                 C   ó   | j  |¡S rq   )r   Ú
get_lookup)r   Úlookupr   r   r   rÂ   {  r‰   zBaseExpression.get_lookupc                 C   rÁ   rq   )r   Úget_transform©r   Únamer   r   r   rÄ   ~  r‰   zBaseExpression.get_transformc                    ó(   |   ¡ }| ‡ fdd„|  ¡ D ƒ¡ |S )Nc                    s"   g | ]}|d ur|  ˆ ¡nd ‘qS rq   )Úrelabeled_clone©r�   Úe©Ú
change_mapr   r   r‘   „  s    ÿÿz2BaseExpression.relabeled_clone.<locals>.<listcomp>©r{   rˆ   r„   )r   rÌ   Úcloner   rË   r   rÈ   �  s   
þÿzBaseExpression.relabeled_clonec                    s>   ˆ   | ¡ }r	|S |  ¡ }| ¡ }| ‡ fdd„|D ƒ¡ |S )Nc                    s   g | ]}|r|  ˆ ¡nd ‘qS rq   )Úreplace_expressionsr˜   ©Úreplacementsr   r   r‘   ‘  s    ÿÿz6BaseExpression.replace_expressions.<locals>.<listcomp>)Úgetr{   r„   rˆ   )r   rÑ   ÚreplacementrÎ   Úsource_expressionsr   rÐ   r   rÏ   ‹  s   
þÿz"BaseExpression.replace_expressionsc                 C   s$   t ƒ }|  ¡ D ]}|| ¡ O }q|S rq   )Úsetr„   Úget_refs)r   Úrefsr™   r   r   r   rÖ   ˜  s   zBaseExpression.get_refsc                 C   ó
   t   | ¡S rq   ©r{   r9   r   r   r   r{   ž  ó   
zBaseExpression.copyc                    rÇ   )Nc                    s2   g | ]}t |tƒrtˆ › |j› �ƒn| ˆ ¡‘qS 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| gS g }|  ¡ D ]	}| | ¡ ¡ q|S rq   )r—   r„   ÚextendÚget_group_by_cols©r   Úcolsr±   r   r   r   rß   ­  s   z BaseExpression.get_group_by_colsc                 C   s   dd„ |   ¡ D ƒS )z9Return the underlying field types used by this aggregate.c                 S   s   g | ]}|j ‘qS r   )r°   rÉ   r   r   r   r‘   ·  s    z4BaseExpression.get_source_fields.<locals>.<listcomp>N)r„   r9   r   r   r   r²   µ  s   z BaseExpression.get_source_fieldsc                 K   ó   t | fi |¤ŽS rq   ©ÚOrderBy©r   Úkwargsr   r   r   Úasc¹  r;   zBaseExpression.ascc                 K   ó   t | fddi|¤ŽS ©NÚ
descendingTrã   rå   r   r   r   Údesc¼  ó   zBaseExpression.descc                 C   r´   rq   r   r9   r   r   r   Úreverse_ordering¿  r…   zBaseExpression.reverse_orderingc                 c   s>   � | V  |   ¡ D ]}|rt|dƒr| ¡ E dH  q|V  qdS )zi
        Recursively yield this expression and all subexpressions, in
        depth-first order.
        ÚflattenN)r„   r/   rî   )r   r™   r   r   r   rî   Â  s   €
€ûzBaseExpression.flattenc                 C   s$   t | jdƒr| j |||¡S ||fS )z†
        Custom format for select clauses. For example, EXISTS expressions need
        to be wrapped in CASE WHEN on Oracle.
        Úselect_formatN)r/   r   rï   ©r   r   r   r   r   r   r   rï   Ï  s   zBaseExpression.select_formatrq   ©NTNFF)-r!   r"   r#   r$   ÚNotImplementedÚempty_result_set_valuer¦   r¯   Z
filterableÚwindow_compatiblerx   r~   r�   r„   rˆ   r“   r   r   r—   rŸ   r    r.   ÚpropertyrP   r¬   r   r°   r®   Ústaticmethodr€   ry   rÂ   rÄ   rÈ   rÏ   rÖ   r{   rÛ   rß   r²   rç   rë   rí   rî   rï   r   r   r   r   ru   ©   sb    




ÿ






ru   c                   @   s,   e Zd ZdZedd„ ƒZdd„ Zdd„ ZdS )	Ú
Expressionz:An expression that can be combined with other expressions.c           	      C   s    t  | j¡}| j\}}|j|i |¤Ž}| ¡  |j ¡ }| jg}|D ])\}}t	|t
jƒr@|jr;|jr;|jjj|jf}n	t|ƒ}nt|ƒ}| ||f¡ q"t|ƒS rq   )ÚinspectÚ	signaturerx   Z_constructor_argsÚbind_partialÚapply_defaultsÚ	argumentsÚitemsr³   r‹   r   ÚFieldrÆ   ÚmodelÚ_metaÚlabelÚtyper   ÚappendÚtuple)	r   Zconstructor_signatureÚargsræ   rù   rü   Úidentityr�   r¶   r   r   r   r  Ý  s   


zExpression.identityc                 C   s   t |tƒstS |j| jkS rq   )r‹   r÷   rò   r  r@   r   r   r   Ú__eq__ð  s   
zExpression.__eq__c                 C   ó
   t | jƒS rq   )Úhashr  r9   r   r   r   Ú__hash__õ  rÚ   zExpression.__hash__N)r!   r"   r#   r$   r   r  r  r
  r   r   r   r   r÷   Ù  s    
r÷   c                 C   s<   i | ]}|t jt jt jft jt jt jft jt jt jfg“qS r   )r   r¾   r¹   r   ©r�   r3   r   r   r   Ú
<dictcomp>  s    ûýÿr  c              	   C   sJ   i | ]!}|t jt jt jft jt jt jft jt jt jft jt jt jfg“qS r   )r   r¾   r   r¹   r  r   r   r   r    s    úüÿc                 C   s    i | ]}|t jt jt jfg“qS r   )r   r¾   r  r   r   r   r  %  s    ýÿÿc                 C   s8   i | ]}t jt jt jfD ]}||t|ft||fg“qqS r   )r   r¾   r   r¹   ÚNoneType)r�   r3   Z
field_typer   r   r   r  2  s    óôþÿc                 C   s   t |  | ||f¡ dS )zÂ
    Register combinable types:
        lhs <connector> rhs -> result
    e.g.
        register_combinable_fields(
            IntegerField, Combinable.ADD, FloatField, FloatField
        )
    N)Ú_connector_combinatorsr  )Úlhsr3   ÚrhsÚresultr   r   r   Úregister_combinable_fieldse  s   	r  é€   )Úmaxsizec                 C   s<   t  | d¡}|D ]\}}}t||ƒrt||ƒr|  S qd S )Nr   )r  rÒ   Ú
issubclass)r3   Úlhs_typeÚrhs_typeZcombinatorsZcombinator_lhs_typeZcombinator_rhs_typeÚcombined_typer   r   r   Ú_resolve_combined_typew  s   ÿ€ür  c                       sZ   e Zd Zd‡ fdd„	Zdd„ Zdd„ Zdd	„ Zd
d„ Zdd„ Zdd„ Z		ddd„Z
‡  ZS )r1   Nc                    s$   t ƒ j|d� || _|| _|| _d S ©Nrv   )Úsuperrx   r3   r  r  )r   r  r3   r  r   ©r³   r   r   rx   ‚  s   
zCombinedExpression.__init__c                 C   s   d  | jj| ¡S )Nz<{}: {}>)Úformatr³   r!   r9   r   r   r   Ú__repr__ˆ  r;   zCombinedExpression.__repr__c                 C   s   d  | j| j| j¡S )Nz{} {} {})r  r  r3   r  r9   r   r   r   Ú__str__‹  rì   zCombinedExpression.__str__c                 C   ó   | j | jgS rq   ©r  r  r9   r   r   r   r„   Ž  r‰   z)CombinedExpression.get_source_expressionsc                 C   ó   |\| _ | _d S rq   r!  r†   r   r   r   rˆ   ‘  r;   z)CombinedExpression.set_source_expressionsc                 C   sZ   t | jt| jjƒt| jjƒƒ}|d u r*td| j›d| jjjj	› d| jjjj	› d�ƒ‚|ƒ S )NzCannot infer type of z# expression involving these types: ú, z. You must set output_field.)
r  r3   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|¡}|| |fS ©Nz(%s))Úcompiler  r  rÞ   r  ÚopsZcombine_expressionr3   ©r   r   r   r’   Zexpression_paramsr   r   Zexpression_wrapperr   r   r   r   ¥  s   



zCombinedExpression.as_sqlTFc              	   C   s  | j  |||||¡}| j |||||¡}t| ttfƒsz|j ¡ }W n tt	fy/   d }Y nw z|j ¡ }	W n tt	fyD   d }	Y nw d||	hv r_||	kr_t| j | j
| jƒ |||||¡S h d£}
| j
| jkr||
v r||	krt| j | jƒ |||||¡S |  ¡ }||_||_ ||_|S )NÚDurationField>   ÚDateTimeFieldÚ	TimeFieldÚ	DateField)r  r.   r  r‹   ÚDurationExpressionÚTemporalSubtractionr   r   ÚAttributeErrorr   r3   rC   r{   r¦   )r   r£   r¢   r¤   r¥   r¨   r  r  r  r  Zdatetime_fieldsr©   r   r   r   r.   ³  s`   
ÿ
ÿÿÿÿûþ	
ÿþýûz%CombinedExpression.resolve_expressionrq   rñ   )r!   r"   r#   rx   r  r  r„   rˆ   r®   r   r.   Ú__classcell__r   r   r  r   r1   �  s    ÿr1   c                       s,   e Zd Zdd„ Z‡ fdd„Zdd„ Z‡  ZS )r,  c                 C   sR   z|j }W n	 ty   Y nw | ¡ dkr$| |¡\}}|j |¡|fS | |¡S )Nr(  )r   r   r   r%  r&  Zformat_for_duration_arithmetic)r   Zsider   r   Úoutputr   r   r   r   r   r%  ä  s   
ÿ
zDurationExpression.compilec                    sš   |j jrtƒ  ||¡S |j | ¡ g }g }|  | j||¡\}}| |¡ | 	|¡ |  | j
||¡\}}| |¡ | 	|¡ d}|j | j|¡}|| |fS r$  )ÚfeaturesZhas_native_duration_fieldr  r   r&  Úcheck_expression_supportr%  r  r  rÞ   r  Zcombine_duration_expressionr3   r'  r  r   r   r   ï  s   



zDurationExpression.as_sqlc           	   	   K   s–   | j ||fi |¤Ž\}}| jtjtjhv rGz| jj ¡ }| jj ¡ }W n t	t
fy1   Y ||fS w h d£}||vs>||vrGtd| j› d�ƒ‚||fS )N>   r¹   r(  r   r¾   zInvalid arguments for operator Ú.)r   r3   r%   r8   rG   r  r   r   r  r.  r   r	   )	r   r   r   r   r   r   r  r  Zallowed_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 Zd Ze ¡ Z‡ fdd„Zdd„ Z‡  ZS )r-  c                    s   t ƒ  || j|¡ d S rq   )r  rx   rC   )r   r  r  r  r   r   rx     ó   zTemporalSubtraction.__init__c                 C   s<   |j  | ¡ | | j¡}| | j¡}|j  | jj ¡ ||¡S rq   )r&  r2  r%  r  r  Zsubtract_temporalsr   r   )r   r   r   r  r  r   r   r   r     s   ÿzTemporalSubtraction.as_sql)	r!   r"   r#   r   r(  r   rx   r   r/  r   r   r  r   r-    s    r-  zdjango.db.models.F)Úpathc                   @   s\   e Zd ZdZdd„ Zdd„ Z	dd	d
„Zdd„ Zdd„ Zdd„ Z	dd„ Z
dd„ Zdd„ ZdS )r�   zDAn object capable of resolving references to existing query objects.c                 C   s
   || _ dS )z^
        Arguments:
         * name: the name of the field this expression references
        N)rÆ   rÅ   r   r   r   rx   )  s   
z
F.__init__c                 C   ó   d  | jj| j¡S ©Nú{}({}))r  r³   r!   rÆ   r9   r   r   r   r  0  ó   z
F.__repr__NTFc                 C   s   |  | j|||¡S rq   )Úresolve_refrÆ   ©r   r£   r¢   r¤   r¥   r¨   r   r   r   r.   3  s   zF.resolve_expressionc                 C   s   |  | | ¡S rq   )rÒ   )r   rÑ   r   r   r   rÏ   8  r‰   zF.replace_expressionsc                 K   râ   rq   rã   rå   r   r   r   rç   ;  r;   zF.ascc                 K   rè   ré   rã   rå   r   r   r   rë   >  rì   zF.descc                 C   s   | j |j ko| j|jkS rq   )r³   rÆ   r@   r   r   r   r  A  ó   zF.__eq__c                 C   r  rq   )r	  rÆ   r9   r   r   r   r
  D  rÚ   z
F.__hash__c                 C   rØ   rq   rÙ   r9   r   r   r   r{   G  rÚ   zF.copyrñ   )r!   r"   r#   r$   rx   r  r.   rÏ   rç   rë   r  r
  r{   r   r   r   r   r�   %  s    
ÿr�   c                       s@   e Zd ZdZdZdZdd„ Z‡ fdd„Zdd„ Z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   rj   )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   V  rn   zResolvedOuterRef.as_sqlc                    s:   t ƒ j|i |¤Ž}|jrtd| j› d�ƒ‚t| jv |_|S )Nz<Referencing outer query window expression is not supported: r3  )r  r.   rŸ   r
   rÆ   r   Úpossibly_multivalued)r   r  ræ   Úcolr  r   r   r.   \  s   ÿÿz#ResolvedOuterRef.resolve_expressionc                 C   r´   rq   r   ©r   Zrelabelsr   r   r   rÈ   i  r…   z ResolvedOuterRef.relabeled_clonec                 C   rƒ   rq   r   r9   r   r   r   rß   l  r…   z"ResolvedOuterRef.get_group_by_cols)r!   r"   r#   r$   r—   rŸ   r   r.   rÈ   rß   r/  r   r   r  r   r=  K  s    r=  c                   @   s    e Zd ZdZdd„ Zdd„ ZdS )ÚOuterRefFc                 O   s   t | j| jƒr
| jS t| jƒS rq   )r‹   rÆ   r³   r=  r?  r   r   r   r.   s  s   
zOuterRef.resolve_expressionc                 C   r´   rq   r   rB  r   r   r   rÈ   x  r…   zOuterRef.relabeled_cloneN)r!   r"   r#   r—   r.   rÈ   r   r   r   r   rC  p  s    rC  zdjango.db.models.Funcc                       s~   e Zd ZdZdZdZdZdZddœ‡ fdd„
Zdd	„ Z	d
d„ Z
dd„ Zdd„ Z	ddd„Z			ddd„Z‡ fdd„Z‡  ZS )ÚFunczAn SQL function call.Nz%(function)s(%(expressions)s)r#  rv   c                   sh   | j d ur"t|ƒ| j kr"td| jj| j | j dkrdndt|ƒf ƒ‚tƒ j|d� | j|Ž | _|| _	d S )Nz#'%s' takes exactly %s %s (%s given)é   Zargumentrü   rv   )
ÚarityÚlenÚ	TypeErrorr³   r!   r  rx   r“   rÔ   Úextra)r   r   r’   rI  r  r   r   rx   …  s   üÿÿ	
zFunc.__init__c                 C   sl   | j  dd„ | jD ƒ¡}i | j¥|  ¡ ¥}|r.d dd„ t| ¡ ƒD ƒ¡}d | jj	||¡S d | jj	|¡S )Nc                 s   ó   � | ]}t |ƒV  qd S rq   ©rŒ   rŽ   r   r   r   rš   •  ó   € z Func.__repr__.<locals>.<genexpr>r#  c                 s   s(   � | ]\}}t |ƒd  t |ƒ V  qdS )ú=NrK  )r�   ÚkeyÚvalr   r   r   rš   ˜  s   € 
ÿú
{}({}, {})r8  )
Ú
arg_joinerÚjoinrÔ   rI  Ú_get_repr_optionsÚsortedrý   r  r³   r!   )r   r  rI  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.Nr   r9   r   r   r   rS  ž  r¸   zFunc._get_repr_optionsc                 C   r«   rq   ©rÔ   r9   r   r   r   r„   ¢  ó   zFunc.get_source_expressionsc                 C   s
   || _ d S rq   rU  r†   r   r   r   rˆ   ¥  rÚ   zFunc.set_source_expressionsTFc           	      C   s>   |   ¡ }||_t|jƒD ]\}}| |||||¡|j|< q|S rq   )r{   r¦   Ú	enumeraterÔ   r.   )	r   r£   r¢   r¤   r¥   r¨   r©   Úposr�   r   r   r   r.   ¨  s   
ÿzFunc.resolve_expressionc              	   K   s  |j  | ¡ g }g }| jD ]D}	z	| |	¡\}
}W n. ty5   t|	dtƒ}|tu r*‚ | t|ƒ¡\}
}Y n tyF   | tdƒ¡\}
}Y nw | 	|
¡ | 
|¡ qi | j¥|¥}|d urb||d< n| d| j¡ |pq| d| j¡}|pz| d| j¡}| |¡ |d< |d< || |fS )Nró   TÚfunctionÚtemplaterQ  r’   r¬   )r&  r2  rÔ   r%  r   rS   rò   r0   r   r  rÞ   rI  Ú
setdefaultrY  rÒ   rZ  rQ  rR  )r   r   r   rY  rZ  rQ  r   Z	sql_partsr   r�   Zarg_sqlZ
arg_paramsró   Údatar   r   r   r   ³  s4   	
ÿÿ

zFunc.as_sqlc                    s*   t ƒ  ¡ }| jd d … |_| j ¡ |_|S rq   )r  r{   rÔ   rI  )r   r{   r  r   r   r{   Ú  s   
z	Func.copyrñ   )NNN)r!   r"   r#   r$   rY  rZ  rQ  rF  rx   r  rS  r„   rˆ   r.   r   r{   r/  r   r   r  r   rD  |  s$    

ÿ
ú'rD  zdjango.db.models.Valuec                       sb   e Zd ZdZdZd‡ fdd„	Zdd„ Zdd	„ Z	d‡ fdd„	Zdd„ Z	dd„ Z
edd„ ƒZ‡  ZS )r0   z9Represent a wrapped value as a node within an expression.FNc                    s   t ƒ j|d� || _dS )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().
        rv   N)r  rx   r¶   )r   r¶   r   r  r   r   rx   é  s   	
zValue.__init__c                 C   s   | j j› d| j›d�S )Nú(ú))r³   r!   r¶   r9   r   r   r   r  õ  r4  zValue.__repr__c                 C   s|   |j  | ¡ | j}| j}|d ur1| jr|j||d�}n|j||d�}t|dƒr1| |||¡|gfS |d u r9dg fS d|gfS )N)r   Úget_placeholderÚNULLz%s)	r&  r2  r¶   r°   r¨   Zget_db_prep_saveZget_db_prep_valuer/   r_  )r   r   r   rO  r   r   r   r   r   ø  s   

zValue.as_sqlTc                    s   t ƒ  |||||¡}||_|S rq   )r  r.   r¨   r§   r  r   r   r.   
  s   zValue.resolve_expressionc                 C   rƒ   rq   r   r9   r   r   r   rß     r…   zValue.get_group_by_colsc                 C   sè   t | jtƒr
t ¡ S t | jtƒrt ¡ S t | jtƒrt ¡ S t | jt	ƒr(t 
¡ S t | jtjƒr3t ¡ S t | jtjƒr>t ¡ S t | jtjƒrIt ¡ S t | jtjƒrTt ¡ S t | jtƒr^t ¡ S t | jtƒrht ¡ S t | jtƒrrt ¡ S d S rq   )r‹   r¶   rŒ   r   Z	CharFieldÚboolrª   r¿   r¾   r»   r¹   Údatetimer)  Údater+  Útimer*  Ú	timedeltar(  r   r   ÚbytesZBinaryFieldr   Z	UUIDFieldr9   r   r   r   r®     s.   ÿzValue._resolve_output_fieldc                 C   r«   rq   )r¶   r9   r   r   r   ró   ,  r­   zValue.empty_result_set_valuerq   rñ   )r!   r"   r#   r$   r¨   rx   r  r   r.   rß   r®   rõ   ró   r/  r   r   r  r   r0   á  s    ÿr0   c                       sF   e Zd Zd‡ fdd„	Zdd„ Zdd„ Zdd	„ Z	d‡ fdd„	Z‡  ZS )ÚRawSQLNc                    s0   |d u rt  ¡ }||| _| _tƒ j|d� d S r  )r   rþ   r   r   r  rx   )r   r   r   r   r  r   r   rx   2  s   zRawSQL.__init__c                 C   ó   d  | jj| j| j¡S ©NrP  )r  r³   r!   r   r   r9   r   r   r   r  8  r4  zRawSQL.__repr__c                 C   s   d| j  | jfS r$  )r   r   r”   r   r   r   r   ;  r;   zRawSQL.as_sqlc                 C   ó   | gS rq   r   r9   r   r   r   rß   >  rV  zRawSQL.get_group_by_colsTFc           
         sn   |j r-|j j ¡ D ]#}|jjD ]}| ¡ \}}	|	 ¡ | j ¡ v r+| |j|||¡  q	qq	t	ƒ  
|||||¡S rq   )rÿ   r   Zget_parent_listZlocal_fieldsZget_attname_columnÚlowerr   r:  rÆ   r  r.   )
r   r£   r¢   r¤   r¥   r¨   ÚparentZparent_fieldÚ_Zcolumn_namer  r   r   r.   A  s   
ÿüþ
ÿzRawSQL.resolve_expressionrq   rñ   )	r!   r"   r#   rx   r  r   rß   r.   r/  r   r   r  r   rg  1  s    ÿrg  c                   @   s   e Zd Zdd„ Zdd„ ZdS )ÚStarc                 C   s   dS )Nz'*'r   r9   r   r   r   r  T  r…   zStar.__repr__c                 C   s   dg fS )Nr(   r   r”   r   r   r   r   W  rt   zStar.as_sqlN)r!   r"   r#   r  r   r   r   r   r   rn  S  s    rn  c                       sN   e Zd ZdZdZd‡ fdd„	Zdd„ Zdd	„ Zd
d„ Zdd„ Z	dd„ Z
‡  ZS )ÚColTFNc                    s,   |d u r|}t ƒ j|d� ||| _| _d S r  )r  rx   ÚaliasÚtarget)r   rp  rq  r   r  r   r   rx   _  s   zCol.__init__c                 C   s>   | j | j}}|r|t|ƒfnt|ƒf}d | jjd |¡¡S )Nr8  r#  )rp  rq  rŒ   r  r³   r!   rR  )r   rp  rq  Úidentifiersr   r   r   r  e  s   zCol.__repr__c                 C   s<   | j | jj}}|r||fn|f}d t|j|ƒ¡}|g fS )Nr3  )rp  rq  ÚcolumnrR  ÚmapZquote_name_unless_alias)r   r   r   rp  rs  rr  r   r   r   r   r   j  s   z
Col.as_sqlc                 C   s,   | j d u r| S |  | | j | j ¡| j| j¡S rq   )rp  r³   rÒ   rq  r   rB  r   r   r   rÈ   p  s
   
ÿzCol.relabeled_clonec                 C   rj  rq   r   r9   r   r   r   rß   w  rV  zCol.get_group_by_colsc                 C   s0   | j | jkr| j |¡S | j |¡| j  |¡ S rq   )rq  r   r�   r‚   r   r   r   r�   z  s   ÿ
þzCol.get_db_convertersrq   )r!   r"   r#   r    r@  rx   r  r   rÈ   rß   r�   r/  r   r   r  r   ro  [  s    ro  c                       sd   e Zd ZdZ‡ fdd„Zdd„ Zdd„ Zdd	„ Z	ddd„Zdd„ Z	dd„ Z
dd„ Zdd„ 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 rq   )r  rx   r×   r±   )r   r×   r±   r  r   r   rx   ˆ  s   
zRef.__init__c                 C   rh  ri  )r  r³   r!   r×   r±   r9   r   r   r   r  Œ  r4  zRef.__repr__c                 C   ó   | j gS rq   ©r±   r9   r   r   r   r„   �  rt   zRef.get_source_expressionsc                 C   s   |\| _ d S rq   rw  r†   r   r   r   rˆ   ’  r‰   zRef.set_source_expressionsNTFc                 C   r´   rq   r   r;  r   r   r   r.   •  s   zRef.resolve_expressionc                 C   s   | j hS rq   )r×   r9   r   r   r   rÖ   œ  rt   zRef.get_refsc                 C   r´   rq   r   rB  r   r   r   rÈ   Ÿ  r…   zRef.relabeled_clonec                 C   s   |j  | j¡g fS rq   )r&  Z
quote_namer×   r”   r   r   r   r   ¢  r9  z
Ref.as_sqlc                 C   rj  rq   r   r9   r   r   r   rß   ¥  rV  zRef.get_group_by_colsrñ   )r!   r"   r#   r$   rx   r  r„   rˆ   r.   rÖ   rÈ   r   rß   r/  r   r   r  r   ru  ‚  s    
ÿru  c                       s4   e Zd ZdZdZ‡ fdd„Zdd„ Zd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*   |s
t d| jj ƒ‚tƒ j|i |¤Ž d S )Nz$%s requires at least one expression.)r>  r³   r!   r  rx   ©r   r’   rI  r  r   r   rx   ²  s
   
ÿzExpressionList.__init__c                 C   s   | j  dd„ | jD ƒ¡S )Nc                 s   rJ  rq   rK  rŽ   r   r   r   rš   º  rL  z)ExpressionList.__str__.<locals>.<genexpr>)rQ  rR  rÔ   r9   r   r   r   r  ¹  r<  zExpressionList.__str__c                 K   s   | j ||fi |¤ŽS rq   )r   )r   r   r   r   r   r   r   r    ¼  s   zExpressionList.as_sqlite)	r!   r"   r#   r$   rZ  rx   r  r    r/  r   r   r  r   rx  ©  s    rx  c                       s4   e Zd ZdZ‡ fdd„Z‡ fdd„Zdd„ Z‡  ZS )ÚOrderByListzORDER BY %(expressions)sc                    s$   dd„ |D ƒ}t ƒ j|i |¤Ž d S )Nc                 s   sB   � | ]}t |tƒr|d  dkrtt|dd… ƒdd�n|V  qdS )r   r'   rE  NT©rê   )r‹   rŒ   rä   r�   r˜   r   r   r   rš   Å  s   € ýÿ
ÿ
üz'OrderByList.__init__.<locals>.<genexpr>)r  rx   ry  r  r   r   rx   Ä  s   úzOrderByList.__init__c                    s   | j sdS tƒ j|i |¤ŽS )N)Ú r   )rÔ   r  r   r?  r  r   r   r   Ï  s   zOrderByList.as_sqlc                 C   ó$   g }|   ¡ D ]	}| | ¡ ¡ q|S rq   ©r„   rÞ   rß   )r   Úgroup_by_colsÚorder_byr   r   r   rß   Ô  ó   zOrderByList.get_group_by_cols)r!   r"   r#   rZ  rx   r   rß   r/  r   r   r  r   rz  Á  s
    rz  z"django.db.models.ExpressionWrapperc                       sL   e Zd ZdZ‡ fdd„Zdd„ Zdd„ Z‡ fdd	„Zd
d„ Zd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  rx   r·   )r   r·   r   r  r   r   rx   â  s   
zExpressionWrapper.__init__c                 C   ó   |d | _ d S ©Nr   ©r·   r†   r   r   r   rˆ   æ  ó   z(ExpressionWrapper.set_source_expressionsc                 C   rv  rq   r…  r9   r   r   r   r„   é  rt   z(ExpressionWrapper.get_source_expressionsc                    s0   t | jtƒr| j ¡ }| j|_| ¡ S tƒ  ¡ S rq   )r‹   r·   r÷   r{   r   rß   r  ©r   r·   r  r   r   rß   ì  s
   

z#ExpressionWrapper.get_group_by_colsc                 C   s   |  | j¡S rq   )r%  r·   r”   r   r   r   r   õ  r‰   zExpressionWrapper.as_sqlc                 C   r6  r7  )r  r³   r!   r·   r9   r   r   r   r  ø  r9  zExpressionWrapper.__repr__)r!   r"   r#   r$   rx   rˆ   r„   rß   r   r  r/  r   r   r  r   r‚  Û  s    	r‚  c                       sL   e Zd ZdZ‡ fdd„Zdd„ Z‡ fdd„Z	
d‡ fdd„	Zdd„ Z‡  Z	S )rr   z1The logical negation of a conditional expression.c                    s   t ƒ j|t ¡ d� d S r  )r  rx   r   rª   r‡  r  r   r   rx   ÿ  r<  zNegatedExpression.__init__c                 C   ó
   | j  ¡ S rq   )r·   r{   r9   r   r   r   rs     rÚ   zNegatedExpression.__invert__c                    s~   zt ƒ  ||¡\}}W n ty%   |jj}|jsY dS | tdƒ¡ Y S w |jj}| 	| j
¡s8d|› d�|fS d|› �|fS )N)z1=1r   Tz
CASE WHEN z = 0 THEN 1 ELSE 0 ENDzNOT )r  r   r   r   r1  Ú&supports_boolean_expr_in_select_clauser%  r0   r&  Ú0conditional_expression_supported_in_where_clauser·   )r   r   r   r   r   r1  r&  r  r   r   r     s   üzNegatedExpression.as_sqlNTFc                    s.   t ƒ  |||||¡}t|jddƒstdƒ‚|S )NrP   Fz*Cannot negate non-conditional expressions.)r  r.   rS   r·   rH  )r   r£   r¢   r¤   r¥   r¨   Úresolvedr  r   r   r.     s   
ÿz$NegatedExpression.resolve_expressionc                 C   s0   |j jj}|j jjs|| jƒrd |¡}||fS ©NzCASE WHEN {} THEN 1 ELSE 0 END)r   r&  rŠ  r1  r‰  r·   r  )r   r   r   r   Z$expression_supported_in_where_clauser   r   r   rï     s   ÿÿý
zNegatedExpression.select_formatrñ   )
r!   r"   r#   r$   rx   rs   r   r.   rï   r/  r   r   r  r   rr   ü  s    ÿ
rr   zdjango.db.models.Whenc                       sl   e Zd ZdZdZd‡ fdd„	Zdd„ Zdd	„ Zd
d„ Zdd„ Z	dd„ Z
	ddd„Zddd„Zdd„ Z‡  ZS )ÚWhenz"WHEN %(condition)s THEN %(result)sFNc                    s¢   |r"|d u rt di |¤Žd }}nt|ddƒr"t |fi |¤Žd }}|d u s.t|ddƒr.|r2tdƒ‚t|t ƒr=|s=tdƒ‚tƒ jd d� || _|  |¡d | _	d S )NrP   FzLWhen() supports a Q object, a boolean expression, or lookups as a condition.z1An empty Q() can't be used as a When() condition.rv   r   r   )
r   rS   rH  r‹   r>  r  rx   Ú	conditionr“   r  )r   rŽ  ÚthenÚlookupsr  r   r   rx   5  s   ÿzWhen.__init__c                 C   s   d| j | jf S )NzWHEN %r THEN %r©rŽ  r  r9   r   r   r   r  F  r;   zWhen.__str__c                 C   ó   d| j j| f S ©Nz<%s: %s>©r³   r!   r9   r   r   r   r  I  r;   zWhen.__repr__c                 C   r   rq   r‘  r9   r   r   r   r„   L  r‰   zWhen.get_source_expressionsc                 C   r"  rq   r‘  r†   r   r   r   rˆ   O  r;   zWhen.set_source_expressionsc                 C   s
   | j jgS rq   )r  r°   r9   r   r   r   r²   R  s   
zWhen.get_source_fieldsTc                 C   sJ   |   ¡ }||_t|jdƒr|j ||||d¡|_|j |||||¡|_|S )Nr.   F)r{   r¦   r/   rŽ  r.   r  r§   r   r   r   r.   V  s   
ÿ
ÿzWhen.resolve_expressionc                 K   sh   |j  | ¡ |}g }| | j¡\}}||d< | | j¡\}	}
|	|d< |p&| j}|| g |¢|¢|
¢R fS )NrŽ  r  )r&  r2  r%  rŽ  r  rZ  )r   r   r   rZ  r   Útemplate_paramsÚ
sql_paramsZcondition_sqlZcondition_paramsZ
result_sqlZresult_paramsr   r   r   r   d  s   
ÿþýzWhen.as_sqlc                 C   r}  rq   r~  rà   r   r   r   rß   s  s   zWhen.get_group_by_cols©NNrñ   rq   )r!   r"   r#   rZ  rP   rx   r  r  r„   rˆ   r²   r.   r   rß   r/  r   r   r  r   r�  /  s    
ÿ
r�  zdjango.db.models.Casec                       s€   e Zd ZdZdZdZdddœ‡ fdd„
Zdd	„ Zd
d„ Zdd„ Z	dd„ Z
	ddd„Z‡ fdd„Z	ddd„Z‡ fdd„Z‡  ZS )Ú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 dd„ |D ƒƒstdƒ‚tƒ  |¡ t|ƒ| _|  |¡d | _|| _d S )Nc                 s   s   � | ]}t |tƒV  qd S rq   )r‹   r�  )r�   Úcaser   r   r   rš   �  s   € z Case.__init__.<locals>.<genexpr>z.Positional arguments must all be When objects.r   )	ÚallrH  r  rx   ÚlistÚcasesr“   rš  rI  )r   rš  r   rž  rI  r  r   r   rx   Œ  s   

zCase.__init__c                 C   s    dd  dd„ | jD ƒ¡| jf S )NzCASE %s, ELSE %rr#  c                 s   rJ  rq   rK  )r�   r©   r   r   r   rš   –  rL  zCase.__str__.<locals>.<genexpr>)rR  rž  rš  r9   r   r   r   r  ”  s   þzCase.__str__c                 C   r’  r“  r”  r9   r   r   r   r  š  r;   zCase.__repr__c                 C   s   | j | jg S rq   ©rž  rš  r9   r   r   r   r„   �  r†  zCase.get_source_expressionsc                 C   s   |�^ | _ | _d S rq   rŸ  r†   r   r   r   rˆ      r9  zCase.set_source_expressionsTFc           	      C   sT   |   ¡ }||_t|jƒD ]\}}| |||||¡|j|< q|j |||||¡|_|S rq   )r{   r¦   rW  rž  r.   rš  )	r   r£   r¢   r¤   r¥   r¨   r©   rX  r›  r   r   r   r.   £  s   
ÿ
ÿzCase.resolve_expressionc                    s   t ƒ  ¡ }|jd d … |_|S rq   )r  r{   rž  )r   r©   r  r   r   r{   ±  s   
z	Case.copyc              	   K   s   |j  | ¡ | js| | j¡S i | j¥|¥}g }g }| | j¡\}	}
| jD ]0}z	| |¡\}}W n ty9   Y q% tyJ   | |j¡\}	}
Y  qVw | 	|¡ | 
|¡ q%|s\|	|
fS |p`| j}| |¡|d< |	|d< | 
|
¡ |py| d| j¡}|| }| jd urŒ|j  | j¡| }||fS )Nrž  rš  rZ  )r&  r2  rž  r%  rš  rI  r   r   r  r  rÞ   Úcase_joinerrR  rÒ   rZ  r°   Zunification_cast_sqlr   )r   r   r   rZ  r   r   r•  Z
case_partsr–  Zdefault_sqlZdefault_paramsr›  Zcase_sqlZcase_paramsr   r   r   r   r   ¶  s:   
þ



zCase.as_sqlc                    s   | j s| j ¡ S tƒ  ¡ S rq   )rž  rš  rß   r  r9   r  r   r   rß   Ö  s   

zCase.get_group_by_colsrñ   r—  )r!   r"   r#   r$   rZ  r   rx   r  r  r„   rˆ   r.   r{   r   rß   r/  r   r   r  r   r˜  {  s    
ÿ
ÿ r˜  c                       sx   e Zd ZdZdZdZdZd‡ fdd„	Zdd„ Zd	d
„ Z	dd„ Z
‡ fdd„Zedd„ ƒZdd„ Zddd„Zdd„ Z‡  ZS )Ú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                    s0   t |d|ƒ ¡ | _d| j_|| _tƒ  |¡ d S )Nr£   T)rS   rÎ   r£   ÚsubqueryrI  r  rx   )r   Úquerysetr   rI  r  r   r   rx   æ  s   zSubquery.__init__c                 C   rv  rq   ©r£   r9   r   r   r   r„   í  rt   zSubquery.get_source_expressionsc                 C   rƒ  r„  r¤  r†   r   r   r   rˆ   ð  r†  zSubquery.set_source_expressionsc                 C   ó   | j jS rq   )r£   r   r9   r   r   r   r®   ó  rt   zSubquery._resolve_output_fieldc                    s   t ƒ  ¡ }|j ¡ |_|S rq   )r  r{   r£   rÎ   )r   rÎ   r  r   r   r{   ö  r   zSubquery.copyc                 C   r¥  rq   )r£   Úexternal_aliasesr9   r   r   r   r¦  û  s   zSubquery.external_aliasesc                 C   rˆ  rq   )r£   Úget_external_colsr9   r   r   r   r§  ÿ  rÚ   zSubquery.get_external_colsc           	      K   s^   |j  | ¡ i | j¥|¥}| j ||¡\}}|dd… |d< |p&| d| j¡}|| }||fS )NrE  r6   r¢  rZ  )r&  r2  rI  r£   r   rÒ   rZ  )	r   r   r   rZ  r   r•  Zsubquery_sqlr–  r   r   r   r   r     s   zSubquery.as_sqlc                 C   s   | j j| d�S )N)Úwrapper)r£   rß   r9   r   r   r   rß     r†  zSubquery.get_group_by_colsrq   )r!   r"   r#   r$   rZ  r—   ró   rx   r„   rˆ   r®   r{   rõ   r¦  r§  r   rß   r/  r   r   r  r   r¡  Ü  s    


r¡  c                       s4   e Zd ZdZe ¡ ZdZ‡ fdd„Zdd„ Z	‡  Z
S )ÚExistszEXISTS(%(subquery)s)Fc                    s$   t ƒ j|fi |¤Ž | j ¡ | _d S rq   )r  rx   r£   Úexists)r   r£  ræ   r  r   r   rx     s   zExists.__init__c                 C   s   |j jjs
d |¡}||fS rŒ  )r   r1  r‰  r  rð   r   r   r   rï     s   

zExists.select_format)r!   r"   r#   rZ  r   rª   r   ró   rx   rï   r/  r   r   r  r   r©    s    r©  zdjango.db.models.OrderByc                   @   sh   e Zd ZdZdZddd„Zdd„ Zdd	„ Zd
d„ Zddd„Z	dd„ Z
dd„ Zdd„ Zdd„ Zdd„ ZdS )rä   z%(expression)s %(ordering)sFNc                 C   s^   |r|rt dƒ‚|du s|du rtjdtdd� || _|| _|| _t|dƒs*t 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   rx   '  s   ü

zOrderBy.__init__c                 C   rh  )Nz{}({}, descending={}))r  r³   r!   r·   rê   r9   r   r   r   r  <  s   ÿzOrderBy.__repr__c                 C   rƒ  r„  r…  r†   r   r   r   rˆ   A  r†  zOrderBy.set_source_expressionsc                 C   rv  rq   r…  r9   r   r   r   r„   D  rt   zOrderBy.get_source_expressionsc                 K   s¾   |p| j }|jjr| jrd| }n%| jrd| }n| jr(| jr#|jjs(d| }n| jr6| js2|jjs6d| }|j | ¡ | 	| j
¡\}}|| jrJdnddœ|¥}|| d¡9 }||  ¡ |fS )	Nz%s NULLS LASTz%s NULLS FIRSTz%%(expression)s IS NULL, %sz%%(expression)s IS NOT NULL, %sZDESCÚASC)r·   Zorderingz%(expression)s)rZ  r1  Z supports_order_by_nulls_modifierr°  r¯  rê   Zorder_by_nulls_firstr&  r2  r%  r·   ÚcountÚrstrip)r   r   r   rZ  r   Zexpression_sqlr   Zplaceholdersr   r   r   r   G  s8   

€ÿÿ
ÿÿþýzOrderBy.as_sqlc                 C   sF   |j  | j¡r|  ¡ }tt| jdd�dd�|_| ||¡S |  ||¡S )NT)r�  F)rš  )r&  rŠ  r·   r{   r˜  r�  r   )r   r   r   r{   r   r   r   Ú	as_oraclea  s   ÿþzOrderBy.as_oraclec                 C   r}  rq   r~  rà   r   r   r   rß   o  r�  zOrderBy.get_group_by_colsc                 C   s6   | j  | _ | jrd| _d | _| S | jrd| _d | _| S rc   )rê   r¯  r°  r9   r   r   r   rí   u  s   
ýzOrderBy.reverse_orderingc                 C   ó
   d| _ d S r=   r{  r9   r   r   r   rç     rÚ   zOrderBy.ascc                 C   rµ  rc   r{  r9   r   r   r   rë   ‚  rÚ   zOrderBy.desc)FNNrq   )r!   r"   r#   rZ  rP   rx   r  rˆ   r„   r   r´  rß   rí   rç   rë   r   r   r   r   rä   "  s    


rä   c                       sx   e Zd ZdZdZdZ				d‡ fdd„	Zdd„ Zd	d
„ Zdd„ Z	ddd„Z
‡ fdd„Zdd„ Zdd„ Zdd„ Z‡  ZS )ÚWindowz %(expression)s OVER (%(window)s)FTNc                    sÎ   || _ || _|| _t|ddƒstd|jj ƒ‚| j d ur/t| j tt	fƒs)| j f| _ t
| j Ž | _ | jd urVt| jt	tfƒrCt| jŽ | _nt| jttfƒrRt| jƒ| _ntdƒ‚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.rv   r   )Úpartition_byr€  ÚframerS   r>  r³   r!   r‹   r  r�  rx  rz  ru   rŒ   r  rx   r“   Úsource_expression)r   r·   r·  r€  r¸  r   r  r   r   rx   Ž  s.   ÿÿ


ÿzWindow.__init__c                 C   r¥  rq   )r¹  r   r9   r   r   r   r®   ²  rt   zWindow._resolve_output_fieldc                 C   s   | j | j| j| jgS rq   ©r¹  r·  r€  r¸  r9   r   r   r   r„   µ  rì   zWindow.get_source_expressionsc                 C   s   |\| _ | _| _| _d S rq   rº  r†   r   r   r   rˆ   ¸  r<  zWindow.set_source_expressionsc                 C   sø   |j  | ¡ |jjstdƒ‚| | j¡\}}g d}}| jd ur6| jj||dd�\}}	| 	|¡ |t
|	ƒ7 }| jd urN| | j¡\}
}| 	|
¡ |t
|ƒ7 }| jrd| | j¡\}}| 	|¡ |t
|ƒ7 }|ph| j}||d |¡ ¡ dœ g |¢|¢R fS )Nz1This backend does not support window expressions.r   zPARTITION BY %(expressions)s)r   r   rZ  r™  )r·   Zwindow)r&  r2  r1  Zsupports_over_clauser
   r%  r¹  r·  r   r  r  r€  r¸  rZ  rR  Ústrip)r   r   r   rZ  Zexpr_sqlr   Z
window_sqlZwindow_paramsZsql_exprr–  Z	order_sqlZorder_paramsZ	frame_sqlZframe_paramsr   r   r   r   »  s2   


ý




þzWindow.as_sqlc                    sT   t | jtjƒr$|  ¡ }| ¡ }t ¡ |d _| |¡ tt	|ƒ 
||¡S |  ||¡S r„  )r‹   r   r   r   r{   r„   r¹   rˆ   r  r¶  r    r   )r   r   r   r{   rÔ   r  r   r   r    Ü  s   
zWindow.as_sqlitec                 C   s>   d  t| jƒ| jrdt| jƒ ndt| jpdƒt| jpdƒ¡S )Nz{} OVER ({}{}{})zPARTITION BY r|  )r  rŒ   r¹  r·  r€  r¸  r9   r   r   r   r  æ  s   üzWindow.__str__c                 C   r’  r“  r”  r9   r   r   r   r  î  r;   zWindow.__repr__c                 C   s8   g }| j r| | j  ¡ ¡ | jd ur| | j ¡ ¡ |S rq   )r·  rÞ   rß   r€  )r   r  r   r   r   rß   ñ  s   
zWindow.get_group_by_cols)NNNNrq   )r!   r"   r#   rZ  r—   rŸ   rx   r®   r„   rˆ   r   r    r  r  rß   r/  r   r   r  r   r¶  †  s"    ú$
!
r¶  c                   @   sV   e Zd ZdZdZddd„Zdd„ Zdd	„ Zd
d„ Zdd„ Z	dd„ Z
dd„ Zdd„ ZdS )Ú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 rq   )r0   ÚstartÚend©r   r½  r¾  r   r   r   rx     s   
zWindowFrame.__init__c                 C   r"  rq   ©r½  r¾  r†   r   r   r   rˆ   	  r;   z"WindowFrame.set_source_expressionsc                 C   r   rq   rÀ  r9   r   r   r   r„     r‰   z"WindowFrame.get_source_expressionsc                 C   s>   |j  | ¡ |  || jj| jj¡\}}| j| j||dœ g fS )N©Ú
frame_typer½  r¾  )r&  r2  Úwindow_frame_start_endr½  r¶   r¾  rZ  rÂ  )r   r   r   r½  r¾  r   r   r   r     s   ÿýÿùzWindowFrame.as_sqlc                 C   r’  r“  r”  r9   r   r   r   r    r;   zWindowFrame.__repr__c                 C   rƒ   rq   r   r9   r   r   r   rß   !  r…   zWindowFrame.get_group_by_colsc                 C   sÈ   | j jd ur| j jdk rdt| j jƒtjjf }n| j jd ur*| j jdkr*tjj}ntjj}| jjd urE| jjdkrEd| jjtjj	f }n| jjd urV| jjdkrVtjj}ntjj
}| j| j||dœ S )Nr   z%d %srÁ  )r½  r¶   Úabsr   r&  Z	PRECEDINGZCURRENT_ROWZUNBOUNDED_PRECEDINGr¾  Z	FOLLOWINGZUNBOUNDED_FOLLOWINGrZ  rÂ  r¿  r   r   r   r  $  s   

ýzWindowFrame.__str__c                 C   rj   )Nz3Subclasses must implement window_frame_start_end().rl   ©r   r   r½  r¾  r   r   r   rÃ  8  rt   z"WindowFrame.window_frame_start_endr—  )r!   r"   r#   r$   rZ  rx   rˆ   r„   r   r  rß   r  rÃ  r   r   r   r   r¼  ú  s    
r¼  c                   @   r   )ÚRowRangeZROWSc                 C   ó   |j  ||¡S rq   )r&  Z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Ç  rq   )r&  Zwindow_frame_range_start_endrÅ  r   r   r   rÃ  F  r†  z!ValueRange.window_frame_start_endNrÈ  r   r   r   r   rÊ  C  rÉ  rÊ  )\r{   rb  Ú	functoolsrø   r­  Úcollectionsr   Údecimalr   Úuuidr   Zdjango.core.exceptionsr   r   r   Z	django.dbr	   r
   r   Zdjango.db.modelsr   Zdjango.db.models.constantsr   Zdjango.db.models.query_utilsr   Zdjango.utils.deconstructr   Zdjango.utils.deprecationr   Zdjango.utils.functionalr   Zdjango.utils.hashabler   r   r%   ru   r÷   r  r  r?   rC   r8   rG   rJ   rM   rW   ra   rY   r[   r^   r+  r(  r)  r*  Z_connector_combinationsr�  r  r  Údrý   r3   Zfield_typesr  r  r  Ú	lru_cacher  r1   r,  r-  r�   r=  rC  rD  r0   rg  rn  ro  ru  rx  rz  r‚  rr   r�  r˜  r¡  r©  rä   r¶  r¼  rÆ  rÊ  r   r   r   r   Ú<module>   sú       2%øúûùûüúûöÿôÿ±aÿÿ

	b3%%dO"'' 3K`4ctB