U eS@sddlZddlZddlZddlZddlZddlmZddlmZddl m Z ddl m Z m Z mZddlmZmZmZddlmZddlmZdd lmZdd lmZdd lmZdd lmZdd lm Z GdddZ!GdddZ"GdddZ#eGddde#e"Z$e%dZ&dde"j'e"j(e"j)e"j*e"j+e"j,fDdde"j'e"j(e"j)e"j*e"j+fDdde"j-e"j.e"j/e"j0e"j1fDdde"j'e"j(e"j)e"j*e"j+e"j,fDe"j'ej2ej3ej4fej4ej3ej4fej3ej2ej4fej3ej4ej4fej3ej3ej3fej5ej3ej5fej3ej5ej5fgie"j(ej2ej3ej4fej4ej3ej4fej2ej2ej3fej2ej4ej3fej4ej2ej3fej4ej4ej3fej3ej3ej3fej5ej3ej5fej5ej5ej3fg igZ6ee7Z8ddZ9e6D]:Z:e:;D]*\ZZ?Z@e9e>ed>eIZOGd?d@d@eIZPedAd(GdBdCdCe!e$ZQGdDdEdEeQZRedFd(GdGdHdHe$ZSedId(GdJdKdKe!e$ZTGdLdMdMe#e"ZUGdNdOdOeUZVedPd(GdQdRdRe$ZWGdSdTdTe!e$ZXGdUdVdVe$ZYGdWdXdXeYZZGdYdZdZeYZ[dS)[N) defaultdictDecimal)UUID)EmptyResultSet FieldError FullResultSet) DatabaseErrorNotSupportedError connection)fields) LOOKUP_SEP)Q)deconstructible)RemovedInDjango50Warning)cached_property) make_hashablec@seZdZdZddZdS)SQLiteNumericMixinzp Some expressions with output_field=DecimalField() must be cast to numeric to be properly filtered. cKsL|j||f|\}}z|jdkr,d|}Wntk rBYnX||fS)N DecimalFieldzCAST(%s AS NUMERIC))as_sql output_fieldget_internal_typer)selfcompilerr extra_contextsqlparamsr@/tmp/pip-unpacked-wheel-lctamlir/django/db/models/expressions.py as_sqlites zSQLiteNumericMixin.as_sqliteN)__name__ __module__ __qualname____doc__rrrrrrsrc@s eZdZdZdZdZdZdZdZdZ dZ d Z d Z d Z d Zd dZddZddZddZddZddZddZddZddZdd Zd!d"Zd#d$Zd%d&Zd'd(Zd)d*Zd+d,Zd-d.Zd/d0Z d1d2Z!d3d4Z"d5d6Z#d7d8Z$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<>#cCs.t|dst|}|r"t|||St|||S)Nresolve_expression)hasattrValueCombinedExpression)rother connectorreversedrrr_combine>s   zCombinable._combinecCs|d|jdS)NFr4MULrrrr__neg__KszCombinable.__neg__cCs|||jdSNFr4ADDrr1rrr__add__NszCombinable.__add__cCs|||jdSr:r4SUBr=rrr__sub__QszCombinable.__sub__cCs|||jdSr:r6r=rrr__mul__TszCombinable.__mul__cCs|||jdSr:r4DIVr=rrr __truediv__WszCombinable.__truediv__cCs|||jdSr:r4MODr=rrr__mod__ZszCombinable.__mod__cCs|||jdSr:r4POWr=rrr__pow__]szCombinable.__pow__cCs4t|ddr(t|ddr(t|t|@StddSN conditionalFFUse .bitand(), .bitor(), and .bitxor() for bitwise logical operations.getattrrNotImplementedErrorr=rrr__and__`s zCombinable.__and__cCs|||jdSr:)r4BITANDr=rrrbitandgszCombinable.bitandcCs|||jdSr:)r4 BITLEFTSHIFTr=rrr bitleftshiftjszCombinable.bitleftshiftcCs|||jdSr:)r4 BITRIGHTSHIFTr=rrr bitrightshiftmszCombinable.bitrightshiftcCs4t|ddr(t|ddr(t|t|AStddSrLrOr=rrr__xor__ps zCombinable.__xor__cCs|||jdSr:)r4BITXORr=rrrbitxorwszCombinable.bitxorcCs4t|ddr(t|ddr(t|t|BStddSrLrOr=rrr__or__zs zCombinable.__or__cCs|||jdSr:)r4BITORr=rrrbitorszCombinable.bitorcCs|||jdSNTr;r=rrr__radd__szCombinable.__radd__cCs|||jdSr_r?r=rrr__rsub__szCombinable.__rsub__cCs|||jdSr_r6r=rrr__rmul__szCombinable.__rmul__cCs|||jdSr_rCr=rrr __rtruediv__szCombinable.__rtruediv__cCs|||jdSr_rFr=rrr__rmod__szCombinable.__rmod__cCs|||jdSr_rIr=rrr__rpow__szCombinable.__rpow__cCs tddSNrNrQr=rrr__rand__szCombinable.__rand__cCs tddSrfrgr=rrr__ror__szCombinable.__ror__cCs tddSrfrgr=rrr__rxor__szCombinable.__rxor__cCst|SN)NegatedExpressionr8rrr __invert__szCombinable.__invert__N))r r!r"r#r<r@r7rDrJrGrSr]rUrWrZr4r9r>rArBrErHrKrRrTrVrXrYr[r\r^r`rarbrcrdrerhrirjrmrrrrr$%sL r$c@sXeZdZdZeZdZdZdZdZ dGddZ ddZ d d Z d d Z d dZddZddZeddZeddZeddZeddZdHddZeddZedd Zed!d"Zed#d$Zd%d&Zed'd(Zed)d*Zd+d,Z d-d.Z!d/d0Z"d1d2Z#d3d4Z$d5d6Z%d7d8Z&d9d:Z'd;d<Z(d=d>Z)d?d@Z*dAdBZ+dCdDZ,dEdFZ-dS)IBaseExpressionz%Base class for all query expressions.FTNcCs|dk r||_dSrkrrrrrr__init__szBaseExpression.__init__cCs|j}|dd|S)N convert_value)__dict__copypop)rstaterrr __getstate__s  zBaseExpression.__getstate__cCs$|j|jkrgn|jg|j|Srk)rr_convert_value_nooprget_db_convertersrr rrrrys   z BaseExpression.get_db_converterscCsgSrkrr8rrrget_source_expressionssz%BaseExpression.get_source_expressionscCs |rtdSrk)AssertionErrorrexprsrrrset_source_expressionssz%BaseExpression.set_source_expressionscGsdd|DS)NcSs4g|],}t|dr|nt|tr(t|nt|qSr-)r. isinstancestrFr/.0argrrr sz5BaseExpression._parse_expressions..r)r expressionsrrr_parse_expressionssz!BaseExpression._parse_expressionscCs tddS)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()Nrgrrr rrrrszBaseExpression.as_sqlcCstdd|DS)Ncss|]}|o|jVqdSrk)contains_aggregaterexprrrr sz4BaseExpression.contains_aggregate..anyr{r8rrrrsz!BaseExpression.contains_aggregatecCstdd|DS)Ncss|]}|o|jVqdSrk)contains_over_clauserrrrrsz6BaseExpression.contains_over_clause..rr8rrrrsz#BaseExpression.contains_over_clausecCstdd|DS)Ncss|]}|o|jVqdSrk)contains_column_referencesrrrrrsz.rr8rrrrsz)BaseExpression.contains_column_referencescCstdd|DS)Ncss$|]}|ot|ddp|jVqdS)subqueryFN)rPcontains_subqueryrrrrrsz3BaseExpression.contains_subquery..rr8rrrrsz BaseExpression.contains_subquerycs4|}|_|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. cs$g|]}|r|ndqSrkrr allow_joinsqueryreuse summarizerrrsz5BaseExpression.resolve_expression..)rt is_summaryrr{rrrrrfor_savecrrrr- sz!BaseExpression.resolve_expressioncCst|jtjSrk)rrr BooleanFieldr8rrrrM&szBaseExpression.conditionalcCs|jSrkror8rrrfield*szBaseExpression.fieldcCs"|}|dkrd|_td|S)z+Return the output type of this expressions.NTz4Cannot resolve expression type, unknown output_field)_resolve_output_field_output_field_resolved_to_nonerrprrrr.s zBaseExpression.output_fieldcCs*z|jWStk r$|js YnXdS)z Return the output field of this expression, or None if _resolve_output_field() didn't return an output type. N)rrrr8rrr_output_field_or_none7s z$BaseExpression._output_field_or_nonecCsTdd|D}|D]8}|D](}t||jstd|jj|jjfq|SdS)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. css|]}|dk r|VqdSrkr)rsourcerrrrQsz7BaseExpression._resolve_output_field..zCExpression contains mixed types: %s, %s. You must set output_field.N)get_source_fieldsr __class__rr )rZ sources_iterrrrrrrCs z$BaseExpression._resolve_output_fieldcCs|Srkrvalue expressionr rrrrxasz"BaseExpression._convert_value_noopcCsF|j}|}|dkrddS|dr0ddS|dkr@ddS|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. FloatFieldcSs|dkr dSt|Srk)floatrrrrpsz.BaseExpression.convert_value.. IntegerFieldcSs|dkr dSt|Srk)intrrrrrvsrcSs|dkr dSt|Srkrrrrrr|s)rrendswithrx)rrZ internal_typerrrrres zBaseExpression.convert_valuecCs |j|Srk)r get_lookup)rlookuprrrrszBaseExpression.get_lookupcCs |j|Srk)r get_transformrnamerrrrszBaseExpression.get_transformcs(|}|fdd|D|S)Ncs"g|]}|dk r|ndqSrk)relabeled_clonere change_maprrrsz2BaseExpression.relabeled_clone..rtrr{)rrclonerrrrs zBaseExpression.relabeled_clonecs>|}r|S|}|}|fdd|D|S)Ncsg|]}|r|ndqSrk)replace_expressionsr replacementsrrrsz6BaseExpression.replace_expressions..)getrtr{r)rr replacementrsource_expressionsrrrrs z"BaseExpression.replace_expressionscCs$t}|D]}||O}q|Srk)setr{get_refs)rrefsrrrrrs zBaseExpression.get_refscCs t|Srkrtr8rrrrtszBaseExpression.copycs(|}|fdd|D|S)Ncs2g|]*}t|tr$t|jn|qSr)rrrprefix_referencesrprefixrrrsz4BaseExpression.prefix_references..r)rrrrrrrs z BaseExpression.prefix_referencescCs0|js |gSg}|D]}||q|Srk)rr{extendget_group_by_colsrcolsrrrrrs  z BaseExpression.get_group_by_colscCsdd|DS)z9Return the underlying field types used by this aggregate.cSsg|] }|jqSr)rrrrrrsz4BaseExpression.get_source_fields..)r{r8rrrrsz BaseExpression.get_source_fieldscKs t|f|SrkOrderByrkwargsrrrascszBaseExpression.asccKst|fddi|SN descendingTrrrrrdescszBaseExpression.desccCs|Srkrr8rrrreverse_orderingszBaseExpression.reverse_orderingccs<|V|D](}|rt|dr0|EdHq|VqdS)zi Recursively yield this expression and all subexpressions, in depth-first order. flattenN)r{r.r)rrrrrrs   zBaseExpression.flattencCs$t|jdr|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.rrrrrrrrrrs zBaseExpression.select_format)N)NTNFF).r r!r"r#NotImplementedempty_result_set_valuerrZ filterablewindow_compatiblerqrwryr{rrrrrrrrr-propertyrMrrrr staticmethodrxrrrrrrrrtrrrrrrrrrrrrrnsl                rnc@s,eZdZdZeddZddZddZdS) Expressionz:An expression that can be combined with other expressions.c Cst|j}|j\}}|j||}||j}|jg}|D]R\}}t |t j r||j rr|j rr|j jj|j f}qt|}nt|}|||fq@t|Srk)inspect signaturerqZ_constructor_args bind_partialapply_defaults argumentsitemsrrr Fieldrmodel_metalabeltyperappendtuple) rZconstructor_signatureargsrrridentityrrrrrrs        zExpression.identitycCst|tstS|j|jkSrk)rrrrr=rrr__eq__s zExpression.__eq__cCs t|jSrk)hashrr8rrr__hash__szExpression.__hash__N)r r!r"r#rrrrrrrrrs  rcCs<i|]4}|tjtjtjftjtjtjftjtjtjfgqSr)r rrrrr2rrr s rc CsJi|]B}|tjtjtjftjtjtjftjtjtjftjtjtjfgqSr)r rrrrrrrrscCs i|]}|tjtjtjfgqSr)r rrrrrr,scCs8i|]0}tjtjtjfD]}||t|ft||fgqqSr)r rrrNoneType)rr2Z field_typerrrr9scCst||||fdS)z Register combinable types: lhs rhs -> result e.g. register_combinable_fields( IntegerField, Combinable.ADD, FloatField, FloatField ) N)_connector_combinatorsr)lhsr2rhsresultrrrregister_combinable_fieldsls r)maxsizecCs<t|d}|D]&\}}}t||rt||r|SqdS)Nr)rr issubclass)r2lhs_typerhs_typeZ combinatorsZcombinator_lhs_typeZcombinator_rhs_type combined_typerrr_resolve_combined_type~s  rcsXeZdZdfdd ZddZddZdd Zd d Zd d ZddZ dddZ Z S)r0Ncs$tj|d||_||_||_dSNro)superrqr2rr)rrr2rrrrrrqszCombinedExpression.__init__cCsd|jj|S)Nz<{}: {}>)formatrr r8rrr__repr__szCombinedExpression.__repr__cCsd|j|j|jS)Nz{} {} {})rrr2rr8rrr__str__szCombinedExpression.__str__cCs |j|jgSrkrrr8rrrr{sz)CombinedExpression.get_source_expressionscCs|\|_|_dSrkrr}rrrrsz)CombinedExpression.set_source_expressionscCsZt|jt|jjt|jj}|dkrTtd|jd|jjjj d|jjjj d|S)NzCannot infer type of z# expression involving these types: , z. You must set output_field.) rr2rrrrrrrr )rrrrrrs  (z(CombinedExpression._resolve_output_fieldcCspg}g}||j\}}||||||j\}}||||d}|j|j|}|||fSNz(%s))compilerrrropsZcombine_expressionr2rrr rZexpression_paramsrrZexpression_wrapperrrrrs    zCombinedExpression.as_sqlTFc Cs*|j|||||}|j|||||}t|ttfs z|j}Wntt fk rbd}YnXz|j} Wntt fk rd} YnXd|| hkr|| krt|j|j |j|||||Sdddh} |j |j kr || kr || kr t|j|j|||||S| } || _ || _|| _| S)N DurationField DateField DateTimeField TimeField)rr-rrDurationExpressionTemporalSubtractionrrAttributeErrorrr2r@rtr) rrrrrrrrrrZdatetime_fieldsrrrrr-sl    z%CombinedExpression.resolve_expression)N)NTNFF) r r!r"rqrrr{rrrr- __classcell__rrrrr0sr0cs,eZdZddZfddZddZZS)rcCsTz |j}Wntk rYn,X|dkrJ||\}}|j||fS||S)Nr )rrrrr Zformat_for_duration_arithmetic)rZsiderr outputrrrrrrs  zDurationExpression.compilecs|jjrt||S|j|g}g}||j||\}}||| |||j ||\}}||| |d}|j |j |}|||fSr) featuresZhas_native_duration_fieldrrr check_expression_supportrrrrrZcombine_duration_expressionr2r rrrrs     zDurationExpression.as_sqlc Ks|j||f|\}}|jtjtjhkrz|jj}|jj}Wnt t fk rZYn0Xddddh}||ksx||krt d|jd||fS)Nrr rrzInvalid arguments for operator .) rr2r$r7rDrrrrrrr ) rrr rrrrrZallowed_fieldsrrrrs"  zDurationExpression.as_sqlite)r r!r"rrrrrrrrrs rcs,eZdZeZfddZddZZS)rcst||j|dSrk)rrqr@)rrrrrrrq szTemporalSubtraction.__init__cCs<|j|||j}||j}|j|jj||Srk)r rrrrZsubtract_temporalsrr)rrr rrrrrr#s    zTemporalSubtraction.as_sql) r r!r"r r rrqrrrrrrrs rzdjango.db.models.F)pathc@sZeZdZdZddZddZdd d Zd d Zd dZddZ ddZ ddZ ddZ dS)rzDAn object capable of resolving references to existing query objects.cCs ||_dS)z^ Arguments: * name: the name of the field this expression references N)rrrrrrq0sz F.__init__cCsd|jj|jSN{}({}))rrr rr8rrrr7sz F.__repr__NTFcCs||j|||Srk) resolve_refrrrrrrrrrrr-:szF.resolve_expressioncCs |||Srk)r)rrrrrr?szF.replace_expressionscKs t|f|SrkrrrrrrBszF.asccKst|fddi|SrrrrrrrEszF.desccCs|j|jko|j|jkSrk)rrr=rrrrHszF.__eq__cCs t|jSrk)rrr8rrrrKsz F.__hash__cCs t|Srkrr8rrrrtNszF.copy)NTNFF) r r!r"r#rqrr-rrrrrrtrrrrr,s rcs@eZdZdZdZdZddZfddZddZd 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. FcOs tddS)NzXThis queryset contains a reference to an outer query and may only be used in a subquery.) ValueErrorrrrrrrr]szResolvedOuterRef.as_sqlcs6tj||}|jr&td|jdt|jk|_|S)Nz.rcss&|]\}}t|dt|VqdS)=Nr+)rkeyvalrrrrs {}({}, {})r) arg_joinerjoinrr*_get_repr_optionssortedrrrr )rrr*rrrrs  z Func.__repr__cCsiS)zAReturn a dict of extra __init__() options to include in the repr.rr8rrrr2szFunc._get_repr_optionscCs|jSrkrr8rrrr{szFunc.get_source_expressionscCs ||_dSrkr4r}rrrrszFunc.set_source_expressionsTFc Cs>|}||_t|jD] \}}|||||||j|<q|Srk)rtr enumeraterr-) rrrrrrrposrrrrr-s zFunc.resolve_expressionc Ks|j|g}g}|jD]} z|| \} } Wn`tk rlt| dt} | tkrV|t| \} } Yn&tk r|td\} } YnX| | | | q|j |} |dk r|| d<n| d|j |p| d|j}|p| d|j}||| d<| d<|| |fS)NrTfunctiontemplater0rr)r rrrrrPrr/rrrr* setdefaultr7rr8r0r1)rrr r7r8r0rZ sql_partsrrZarg_sqlZ arg_paramsrdatarrrrs6      z Func.as_sqlcs*t}|jdd|_|j|_|Srk)rrtrr*)rrtrrrrts  z Func.copy)NTNFF)NNN)r r!r"r#r7r8r0r'rqrr2r{rr-rrtrrrrrr$s*   'r$zdjango.db.models.Valuecs`eZdZdZdZdfdd ZddZdd Zdfd d Zd dZ ddZ e ddZ Z S)r/z9Represent a wrapped value as a node within an expression.FNcstj|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(). roN)rrqr)rrrrrrrqs zValue.__init__cCs|jjd|jdS)N())rr rr8rrrrszValue.__repr__cCs||j||j}|j}|dk rb|jr6|j||d}n|j||d}t|drb|||||gfS|dkrrdgfSd|gfS)N)r get_placeholderZNULLz%s) r rrrrZget_db_prep_saveZget_db_prep_valuer.r=)rrr r.rrrrrs  z Value.as_sqlTcst|||||}||_|Srk)rr-rrrrrr-szValue.resolve_expressioncCsgSrkrr8rrrrszValue.get_group_by_colscCst|jtrtSt|jtr(tSt|jtr|j|j}}|r|t|fnt|f}d|jjd|S)Nrr)rKrLrrrr r1)rrKrL identifiersrrrrmsz Col.__repr__cCs<|j|jj}}|r||fn|f}dt|j|}|gfS)Nr)rKrLcolumnr1mapZquote_name_unless_alias)rrr rKrNrMrrrrrrsz Col.as_sqlcCs,|jdkr|S|||j|j|j|jSrk)rKrrrLrr!rrrrxs zCol.relabeled_clonecCs|gSrkrr8rrrrszCol.get_group_by_colscCs0|j|jkr|j|S|j||j|Srk)rLrryrzrrrrys   zCol.get_db_converters)N) r r!r"rrrqrrrrryrrrrrrJcsrJcsbeZdZdZfddZddZddZdd Zdd dZddZ ddZ ddZ ddZ Z S)Refz~ Reference to column alias of the query. For example, Ref('sum_cost') in qs.annotate(sum_cost=Sum('cost')) query. cst|||_|_dSrk)rrqrr)rrrrrrrqs z Ref.__init__cCsd|jj|j|jSrE)rrr rrr8rrrrsz Ref.__repr__cCs|jgSrkrr8rrrr{szRef.get_source_expressionscCs |\|_dSrkrQr}rrrrszRef.set_source_expressionsNTFcCs|Srkrrrrrr-szRef.resolve_expressioncCs|jhSrk)rr8rrrrsz Ref.get_refscCs|}|j||_|Srk)rtrr)rr"rrrrrszRef.relabeled_clonecCs|j|jgfSrk)r Z quote_namerrrrrrsz Ref.as_sqlcCs|gSrkrr8rrrrszRef.get_group_by_cols)NTNFF)r r!r"r#rqrr{rr-rrrrrrrrrrPs  rPcs<eZdZdZdZfddZddZddZd d ZZ 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)scs&|std|jjtj||dS)Nz$%s requires at least one expression.)rrr rrqrrr*rrrrqs  zExpressionList.__init__cCs|jdd|jDS)Ncss|]}t|VqdSrkr+rrrrrsz)ExpressionList.__str__..)r0r1rr8rrrrszExpressionList.__str__cKs|j||f|Srk)r)rrr rrrrrszExpressionList.as_sqlitecCs$g}|D]}||q |Srkr{rr)r group_by_cols partitionrrrrs z ExpressionList.get_group_by_cols) r r!r"r#r8rqrrrrrrrrrRs  rRcs4eZdZdZfddZfddZddZZS) OrderByListzORDER BY %(expressions)scs dd|D}tj||dS)Ncss@|]8}t|tr4|ddkr4tt|ddddn|VqdS)rr&r%NTr)rrrrrrrrrs  z'OrderByList.__init__..)rrqrSrrrrqszOrderByList.__init__cs|js dStj||S)N)r)rrrrrrrrszOrderByList.as_sqlcCs$g}|D]}||q |SrkrT)rrUorder_byrrrrs zOrderByList.get_group_by_cols)r r!r"r8rqrrrrrrrrWs rWz"django.db.models.ExpressionWrappercsLeZdZdZfddZddZddZfdd 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. cstj|d||_dSr)rrqr)rrrrrrrqszExpressionWrapper.__init__cCs|d|_dSNrrr}rrrrsz(ExpressionWrapper.set_source_expressionscCs|jgSrkr]r8rrrr{sz(ExpressionWrapper.get_source_expressionscs0t|jtr&|j}|j|_|StSrk)rrrrtrrrrrrrrrs   z#ExpressionWrapper.get_group_by_colscCs ||jSrk)rrrrrrrszExpressionWrapper.as_sqlcCsd|jj|jSr)rrr rr8rrrrszExpressionWrapper.__repr__) r r!r"r#rqrr{rrrrrrrrr[s  r[csJeZdZdZfddZddZfddZdfd d Zd dZZ S)rlz1The logical negation of a conditional expression.cstj|tddSr)rrqr rr^rrrrqszNegatedExpression.__init__cCs |jSrk)rrtr8rrrrmszNegatedExpression.__invert__cszt||\}}Wn6tk rL|jj}|js:YdS|tdYSX|jj}| |j srd|d|fSd||fS)N)z1=1rTz CASE WHEN z = 0 THEN 1 ELSE 0 ENDzNOT ) rrrr r&supports_boolean_expr_in_select_clauserr/r 0conditional_expression_supported_in_where_clauser)rrr rrrr rrrrs zNegatedExpression.as_sqlNTFcs.t|||||}t|jdds*td|S)NrMFz*Cannot negate non-conditional expressions.)rr-rPrr))rrrrrrZresolvedrrrr-%sz$NegatedExpression.resolve_expressioncCs0|jjj}|jjjs(||jr(d|}||fSNzCASE WHEN {} THEN 1 ELSE 0 END)r r r`rr_rr)rrrrZ$expression_supported_in_where_clauserrrr/s zNegatedExpression.select_format)NTNFF) r r!r"r#rqrmrr-rrrrrrrl s   rlzdjango.db.models.WhencsjeZdZdZdZdfdd ZddZdd Zd d Zd d Z ddZ dddZ dddZ ddZ ZS)Whenz"WHEN %(condition)s THEN %(result)sFNc s|r<|dkrtf|d}}nt|ddrrr r8rrrrYsz When.__repr__cCs |j|jgSrkrer8rrrr{\szWhen.get_source_expressionscCs|\|_|_dSrkrer}rrrr_szWhen.set_source_expressionscCs |jjgSrk)rrr8rrrrbszWhen.get_source_fieldsTcCsJ|}||_t|jdr0|j||||d|_|j||||||_|S)Nr-F)rtrr.rcr-rrrrrr-fs$ zWhen.resolve_expressionc Ks`|j||}g}||j\}}||d<||j\} } | |d<|pL|j}||||| fS)Nrcr)r rrrcrr8) rrr r8rtemplate_params sql_paramsZ condition_sqlZcondition_paramsZ result_sqlZ result_paramsrrrrts  z When.as_sqlcCs$g}|D]}||q |SrkrTrrrrrs zWhen.get_group_by_cols)NN)NTNFF)N)r r!r"r8rMrqrrr{rrr-rrrrrrrrb?s   rbzdjango.db.models.Casecs|eZdZdZdZdZdddfdd Zdd Zd d Zd d Z ddZ dddZ fddZ dddZ fddZZS)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)defaultrcsJtdd|Dstdt|t||_||d|_||_dS)Ncss|]}t|tVqdSrk)rrb)rcaserrrrsz Case.__init__..z.Positional arguments must all be When objects.r) allr)rrqlistcasesrrlr*)rrlrrpr*rrrrqs   z Case.__init__cCs dddd|jD|jfS)NzCASE %s, ELSE %rrcss|]}t|VqdSrkr+)rrrrrrszCase.__str__..)r1rprlr8rrrrsz Case.__str__cCsd|jj|fSrfrgr8rrrrsz Case.__repr__cCs|j|jgSrkrprlr8rrrr{szCase.get_source_expressionscCs|^|_|_dSrkrqr}rrrrszCase.set_source_expressionsTFc CsT|}||_t|jD] \}}|||||||j|<q|j||||||_|Srk)rtrr5rpr-rl) rrrrrrrr6rmrrrr-s$ zCase.resolve_expressioncst}|jdd|_|Srk)rrtrp)rrrrrrts z Case.copyc Ks*|j||js||jS|j|}g}g}||j\} } |jD]l} z|| \} } Wn@tk rtYqFYn*tk r|| j\} } YqYnX| | | | qF|s| | fS|p|j }| ||d<| |d<| | |p| d|j}||}|jdk r"|j|j|}||fS)Nrprlr8)r rrprrlr*rrrrr case_joinerr1rr8rZunification_cast_sqlr)rrr r8rrrrhZ case_partsriZ default_sqlZdefault_paramsrmZcase_sqlZ case_paramsrrrrrs8          z Case.as_sqlcs|js|jStSrk)rprlrrr8rrrrs zCase.get_group_by_cols)NTNFF)NN)r r!r"r#r8rrrqrrr{rr-rtrrrrrrrrjs&    rjcs|eZdZdZdZdZdZdZdfdd Zdd Z d d Z d d Z fddZ e ddZddZdddZddZZS)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 s0t|d||_d|j_||_t|dS)NrT)rPrrrr*rrq)rquerysetrr*rrrrqszSubquery.__init__cCs|jgSrkrr8rrrr{szSubquery.get_source_expressionscCs|d|_dSr\rur}rrrrszSubquery.set_source_expressionscCs|jjSrk)rrr8rrrrszSubquery._resolve_output_fieldcst}|j|_|Srk)rrtrr)rrrrrrts  z Subquery.copycCs|jjSrk)rexternal_aliasesr8rrrrv szSubquery.external_aliasescCs |jSrk)rget_external_colsr8rrrrwszSubquery.get_external_colsc KsZ|j||j|}|j||\}}|dd|d<|pH|d|j}||}||fS)Nr%r5rr8)r rr*rrrr8) rrr r8rrhZ subquery_sqlrirrrrrs  zSubquery.as_sqlcCs|jj|dS)N)wrapper)rrr8rrrrszSubquery.get_group_by_cols)N)N)r r!r"r#r8rrrrqr{rrrtrrvrwrrrrrrrrss   rscs4eZdZdZeZdZfddZddZ Z S)ExistszEXISTS(%(subquery)s)Fc s tj|f||j|_dSrk)rrqrexists)rrtrrrrrq&szExists.__init__cCs|jjjsd|}||fSra)r rr_rrrrrr*s  zExists.select_format) r r!r"r8r rrrrqrrrrrrry!s  ryzdjango.db.models.OrderByc@sheZdZdZdZdddZddZdd Zd d Zdd d Z ddZ ddZ ddZ ddZ ddZdS)rz%(expression)s %(ordering)sFNcCs^|r|rtd|dks |dkr0tjdtdd||_||_||_t|dsTtd||_dS)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) rwarningswarnr nulls_first nulls_lastrr.r)rrrrrrrrrq8s zOrderBy.__init__cCsd|jj|j|jS)Nz{}({}, descending={}))rrr rrr8rrrrMs zOrderBy.__repr__cCs|d|_dSr\r]r}rrrrRszOrderBy.set_source_expressionscCs|jgSrkr]r8rrrr{UszOrderBy.get_source_expressionscKs|p|j}|jjr2|jr"d|}ql|jrld|}n:|jrP|jrF|jjsPd|}n|jrl|jsd|jjsld|}|j|| |j \}}||jrdndd|}|| d9}|| |fS) Nz %s NULLS LASTz%s NULLS FIRSTz%%(expression)s IS NULL, %sz%%(expression)s IS NOT NULL, %sZDESCASC)rZorderingz%(expression)s) r8rZ supports_order_by_nulls_modifierrrrZorder_by_nulls_firstr rrrcountrstrip)rrr r8rZexpression_sqlrZ placeholdersrrrrXs6      zOrderBy.as_sqlcCsF|j|jr:|}tt|jdddd|_|||S|||S)NT)rdF)rl)r r`rrtrjrbr)rrr rtrrr as_oraclers  zOrderBy.as_oraclecCs$g}|D]}||q |SrkrTrrrrrs zOrderBy.get_group_by_colscCs4|j |_|jrd|_d|_n|jr0d|_d|_|Sr_)rrrr8rrrrs zOrderBy.reverse_orderingcCs d|_dSr:rXr8rrrrsz OrderBy.asccCs d|_dSr_rXr8rrrrsz OrderBy.desc)FNN)N)r r!r"r8rMrqrrr{rrrrrrrrrrr3s   rcspeZdZdZdZdZdfdd ZddZd d Zd d Z dd dZ fddZ ddZ ddZ ddZZS)Windowz %(expression)s OVER (%(window)s)FTNcs||_||_||_t|dds.td|jj|jdk r^t|jtt fsR|jf|_t |j|_|jdk rt|jt tfrt |j|_n&t|jt t frt |j|_ntdtj|d||d|_dS)NrFz3Expression '%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.ror) partition_byrZframerPrrr rrrorRrWrnrrrqrsource_expression)rrrrZrrrrrrqs.     zWindow.__init__cCs|jjSrk)rrr8rrrrszWindow._resolve_output_fieldcCs|j|j|j|jgSrkrrrZrr8rrrr{szWindow.get_source_expressionscCs|\|_|_|_|_dSrkrr}rrrrszWindow.set_source_expressionscCs|j||jjstd||j\}}gd}}|jdk rl|jj||dd\}} | ||t | 7}|j dk r||j \} } | | |t | 7}|j r||j \} } | | |t | 7}|p|j }||d|d||fS)Nz1This backend does not support window expressions.rzPARTITION BY %(expressions)s)rr r8rk)rZwindow)r rrZsupports_over_clauser rrrrrrrZrr8r1strip)rrr r8Zexpr_sqlrZ window_sqlZ window_paramsZsql_exprriZ order_sqlZ order_paramsZ frame_sqlZ frame_paramsrrrrs2            z Window.as_sqlcsTt|jtjrH|}|}t|d_||tt | ||S| ||Sr\) rrr rrtr{rrrrrr)rrr rtrrrrrs zWindow.as_sqlitecCs>dt|j|jr dt|jndt|jp,dt|jp8dS)Nz{} OVER ({}{}{})z PARTITION BY rY)rrrrrZrr8rrrrs   zWindow.__str__cCsd|jj|fSrfrgr8rrrrszWindow.__repr__cCs8g}|jr||j|jdk r4||j|Srk)rrrrZ)rrUrrrrs  zWindow.get_group_by_cols)NNNN)N)r r!r"r8rrrqrr{rrrrrrrrrrrrs $ ! rc@sVeZdZdZdZdddZddZdd Zd d Zd d Z ddZ ddZ ddZ 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)sNcCst||_t||_dSrk)r/startendrrrrrrrqs zWindowFrame.__init__cCs|\|_|_dSrkrrr}rrrrsz"WindowFrame.set_source_expressionscCs |j|jgSrkrr8rrrr{sz"WindowFrame.get_source_expressionscCs>|j||||jj|jj\}}|j|j||dgfS)N frame_typerr)r rwindow_frame_start_endrrrr8r)rrr rrrrrr s zWindowFrame.as_sqlcCsd|jj|fSrfrgr8rrrr/szWindowFrame.__repr__cCsgSrkrr8rrrr2szWindowFrame.get_group_by_colscCs|jjdk r2|jjdkr2dt|jjtjjf}n*|jjdk rT|jjdkrTtjj}ntjj}|jjdk r|jjdkrd|jjtjj f}n*|jjdk r|jjdkrtjj}ntjj }|j |j ||dS)Nrz%d %sr) rrabsr r Z PRECEDINGZ CURRENT_ROWZUNBOUNDED_PRECEDINGrZ FOLLOWINGZUNBOUNDED_FOLLOWINGr8rrrrrr5s  zWindowFrame.__str__cCs tddS)Nz3Subclasses must implement window_frame_start_end().rgrr rrrrrrIsz"WindowFrame.window_frame_start_end)NN) r r!r"r#r8rqrr{rrrrrrrrrr s rc@seZdZdZddZdS)RowRangeZROWScCs|j||Srk)r Zwindow_frame_rows_start_endrrrrrPszRowRange.window_frame_start_endNr r!r"rrrrrrrMsrc@seZdZdZddZdS) ValueRangeRANGEcCs|j||Srk)r Zwindow_frame_range_start_endrrrrrWsz!ValueRange.window_frame_start_endNrrrrrrTsr)\rtr? functoolsrr} collectionsrdecimalruuidrZdjango.core.exceptionsrrrZ django.dbr r r Zdjango.db.modelsr Zdjango.db.models.constantsr Zdjango.db.models.query_utilsrZdjango.utils.deconstructrZdjango.utils.deprecationrZdjango.utils.functionalrZdjango.utils.hashablerrr$rnrrrr<r@r7rDrGrJrSr]rUrWrZr r r rZ_connector_combinationsrorrdrr2Z field_typesrrr lru_cacherr0rrrrr#r$r/rDrIrJrPrRrWr[rlrbrjrsryrrrrrrrrrs          9% a   b3%% dO"') 3K`5ctB