a Qh@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. cKsN|j||fi|\}}z|jdkr0d|}WntyDYn0||fS)N DecimalFieldzCAST(%s AS NUMERIC))as_sql output_fieldget_internal_typer)selfcompilerr extra_contextsqlparamsrU/var/www/sistema_ama/venv/lib/python3.9/site-packages/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@sLeZdZdZeZdZdZdZdZ dEddZ ddZ d d Z d d Z d dZddZddZeddZeddZeddZdFddZeddZeddZedd Zed!d"Zd#d$Zed%d&Zed'd(Zd)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,dS)GBaseExpressionz%Base class for all query expressions.FTNcCs|dur||_dSrkrrrrrr__init__szBaseExpression.__init__cCs|j}|dd|S)N convert_value)__dict__copypop)rstaterrr __getstate__s  zBaseExpression.__getstate__cCs$|j|jurgn|jg|j|Srk)rr_convert_value_nooprget_db_convertersrr rrrrys   z BaseExpression.get_db_converterscCsgSrkrr8rrrget_source_expressionssz%BaseExpression.get_source_expressionscCs |rJdSrkrrexprsrrrset_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_referencescs4|}|_|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_summaryr~r{rrrrrfor_savecrrrr-sz!BaseExpression.resolve_expressioncCst|jtjSrk)rrr BooleanFieldr8rrrrMszBaseExpression.conditionalcCs|jSrkror8rrrfield#szBaseExpression.fieldcCs"|}|durd|_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|jWSty"|jsYn0dS)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_none0s  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|]}|dur|VqdSrkr)rsourcerrrrJsz7BaseExpression._resolve_output_field..zCExpression contains mixed types: %s, %s. You must set output_field.N)get_source_fieldsr __class__rr )rZ sources_iterrrrrrr<s z$BaseExpression._resolve_output_fieldcCs|Srkrvalue expressionr rrrrxZsz"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|dur dSt|Srk)floatrrrrisz.BaseExpression.convert_value.. IntegerFieldcSs|dur dSt|Srk)intrrrrrosrcSs|dur dSt|Srkrrrrrrus)rrendswithrx)rrZ internal_typerrrrr^s zBaseExpression.convert_valuecCs |j|Srk)r get_lookup)rlookuprrrr{szBaseExpression.get_lookupcCs |j|Srk)r get_transformrnamerrrr~szBaseExpression.get_transformcs(|}|fdd|D|S)Ncs"g|]}|dur|ndqSrk)relabeled_clonere change_maprrrsz2BaseExpression.relabeled_clone..rtr~r{)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)rrrrrrz4BaseExpression.get_source_fields..)r{r8rrrrsz BaseExpression.get_source_fieldscKst|fi|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{r~rrrrrrr-propertyrMrrrr staticmethodrxrrrrrrrrtrrrrrrrrrrrrrns`               rnc@s,eZdZdZeddZddZddZdS) Expressionz:An expression that can be combined with other expressions.c Cst|j}|j\}}|j|i|}||j}|jg}|D]R\}}t |t j r|j rv|j rv|j jj|j f}qt|}nt|}|||fqDt|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_typerrrr2s cCst||||fdS)z Register combinable types: lhs rhs -> result e.g. register_combinable_fields( IntegerField, Combinable.ADD, FloatField, FloatField ) N)_connector_combinatorsr)lhsr2rhsresultrrrregister_combinable_fieldses r)maxsizecCs<t|d}|D]&\}}}t||rt||r|SqdS)Nr)rr issubclass)r2lhs_typerhs_typeZ combinatorsZcombinator_lhs_typeZcombinator_rhs_type combined_typerrr_resolve_combined_typews   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|rrrr~sz)CombinedExpression.set_source_expressionscCsZt|jt|jjt|jj}|durTtd|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|ttfsz|j}Wntt fy^d}Yn0z|j} Wntt fyd} Yn0d|| hvr|| krt|j|j |j|||||Shd} |j |j kr|| vr|| krt|j|j|||||S| } || _ || _|| _| S)N DurationField> DateTimeField DateField TimeField)rr-rrDurationExpressionTemporalSubtractionrrAttributeErrorrr2r@rtr) rrrrrrrrrrZdatetime_fieldsrrrrr-sX       z%CombinedExpression.resolve_expression)N)NTNFF) r r!r"rqrrr{r~rrr- __classcell__rrrrr0sr0cs,eZdZddZfddZddZZS)r cCsRz |j}WntyYn,0|dkrH||\}}|j||fS||S)Nr )rrrrrZformat_for_duration_arithmetic)rsiderr outputrrrrrrs   zDurationExpression.compilecs|jjrt||S|j|g}g}||j||\}}||| |||j ||\}}||| |d}|j |j |}|||fSr) featuresZhas_native_duration_fieldrrrcheck_expression_supportrrrrrZcombine_duration_expressionr2rrrrrs     zDurationExpression.as_sqlc Ks|j||fi|\}}|jtjtjhvrz|jj}|jj}Wnt t fy\Yn,0hd}||vsv||vrt d|jd||fS)N>rrr rzInvalid arguments for operator .) rr2r$r7rDrrrrrrr ) rrr rrrrrZallowed_fieldsrrrrs  zDurationExpression.as_sqlite)r r!r"rrrrrrrrr s r cs,eZdZeZfddZddZZS)rcst||j|dSrk)rrqr@)rrrrrrrqszTemporalSubtraction.__init__cCs<|j|||j}||j}|j|jj||Srk)rrrrrZsubtract_temporalsrr)rrr rrrrrrs    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)rrrrrrq)sz F.__init__cCsd|jj|jSN{}({}))rrr rr8rrrr0sz F.__repr__NTFcCs||j|||Srk) resolve_refrrrrrrrrrrr-3szF.resolve_expressioncCs |||Srk)r)rrrrrr8szF.replace_expressionscKst|fi|Srkrrrrrr;szF.asccKst|fddi|Srrrrrrr>szF.desccCs|j|jko|j|jkSrk)rrr=rrrrAszF.__eq__cCs t|jSrk)rrr8rrrrDsz F.__hash__cCs t|Srkrr8rrrrtGszF.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.) ValueErrorrrrrrrrVszResolvedOuterRef.as_sqlcs:tj|i|}|jr*td|jdt|jv|_|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.rr8rrrr1szFunc._get_repr_optionscCs|jSrkrr8rrrr{szFunc.get_source_expressionscCs ||_dSrkr3r|rrrr~szFunc.set_source_expressionsTFc Cs>|}||_t|jD] \}}|||||||j|<q|Srk)rtr enumeraterr-) rrrrrrrposrrrrr-s zFunc.resolve_expressionc Ks|j|g}g}|jD]} z|| \} } Wn\tyjt| dt} | turT|t| \} } Yn$ty|td\} } Yn0| | | | qi|j |} |dur|| d<n| d|j |p| d|j}|p| d|j}||| d<| d<|| |fS)NrTfunctiontemplater/rr)rrrrrrPrr/rrrr) setdefaultr6rr7r/r0)rrr r6r7r/rZ sql_partsrrZarg_sqlZ arg_paramsrdatarrrrs2       z Func.as_sqlcs*t}|jdd|_|j|_|Srk)rrtrr))rrtrrrrts  z Func.copy)NTNFF)NNN)r r!r"r#r6r7r/r&rqrr1r{r~r-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}|durb|jr6|j||d}n|j||d}t|drb|||||gfS|durrdgfSd|gfS)N)r get_placeholderZNULLz%s) rrrrrZget_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 r0)rrKrL identifiersrrrrfsz Col.__repr__cCs<|j|jj}}|r||fn|f}dt|j|}|gfS)Nr)rKrLcolumnr0mapZquote_name_unless_alias)rrr rKrNrMrrrrrksz Col.as_sqlcCs,|jdur|S|||j|j|j|jSrk)rKrrrLrr rrrrqs  zCol.relabeled_clonecCs|gSrkrr8rrrrxszCol.get_group_by_colscCs0|j|jkr|j|S|j||j|Srk)rLrryrzrrrry{s   zCol.get_db_converters)N) r r!r"rrrqrrrrryrrrrrrJ\srJcsbeZdZdZfddZddZddZdd 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|jSrD)rrr rrr8rrrrsz Ref.__repr__cCs|jgSrkrr8rrrr{szRef.get_source_expressionscCs |\|_dSrkrQr|rrrr~szRef.set_source_expressionsNTFcCs|Srkrrrrrr-szRef.resolve_expressioncCs|jhSrk)rr8rrrrsz Ref.get_refscCs|}|j||_|Srk)rtrr)rr!rrrrrszRef.relabeled_clonecCs|j|jgfSrk)rZ quote_namerrrrrrsz Ref.as_sqlcCs|gSrkrr8rrrrszRef.get_group_by_cols)NTNFF)r r!r"r#rqrr{r~r-rrrrrrrrrrPs  rPcs4eZdZdZdZfddZddZddZZS) 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|i|dS)Nz$%s requires at least one expression.)rrr rrqrrr)rrrrqs  zExpressionList.__init__cCs|jdd|jDS)Ncss|]}t|VqdSrkr*rrrrrrz)ExpressionList.__str__..)r/r0rr8rrrrszExpressionList.__str__cKs|j||fi|Srk)r)rrr rrrrrszExpressionList.as_sqlite) r r!r"r#r7rqrrrrrrrrRs  rRcs4eZdZdZfddZfddZddZZS) OrderByListzORDER BY %(expressions)scs$dd|D}tj|i|dS)Ncss@|]8}t|tr4|ddkr4tt|ddddn|VqdS)rr&r$NTr)rrrrrrrrrs  z'OrderByList.__init__..)rrqrSrrrrqszOrderByList.__init__cs|js dStj|i|S)N)r)rrrrrrrrszOrderByList.as_sqlcCs$g}|D]}||q |Srkr{rr)r group_by_colsorder_byrrrrs zOrderByList.get_group_by_cols)r r!r"r7rqrrrrrrrrTs rTz"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|rrrr~sz(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#rqr~r{rrrrrrrrrZs  rZcsJeZdZdZfddZddZfddZdfd d Zd dZZ S)rlz1The logical negation of a conditional expression.cstj|tddSr)rrqr rr]rrrrqszNegatedExpression.__init__cCs |jSrk)rrtr8rrrrmszNegatedExpression.__invert__cs~zt||\}}Wn4tyJ|jj}|js8YdS|tdYS0|jj}| |j spd|d|fSd||fS)N)z1=1rTz CASE WHEN z = 0 THEN 1 ELSE 0 ENDzNOT ) rrrr r&supports_boolean_expr_in_select_clauserr/r0conditional_expression_supported_in_where_clauser)rrr rrrrrrrrs  zNegatedExpression.as_sqlNTFcs.t|||||}t|jdds*td|S)NrMFz*Cannot negate non-conditional expressions.)rr-rPrr()rrrrrrresolvedrrrr-s  z$NegatedExpression.resolve_expressioncCs0|jjj}|jjjs(||jr(d|}||fSNzCASE WHEN {} THEN 1 ELSE 0 END)r rr_rr^rr)rrrrZ$expression_supported_in_where_clauserrrr"s zNegatedExpression.select_format)NTNFF) r r!r"r#rqrmrr-rrrrrrrls   rlzdjango.db.models.WhencsjeZdZdZdZdfdd ZddZdd Zd d Zd d Z ddZ dddZ dddZ ddZ ZS)Whenz"WHEN %(condition)s THEN %(result)sFNc s|rD|dur"tfi|d}}n"t|ddrDt|fi|d}}|dus\t|ddr\|rdtdt|trz|sztdtjdd||_||d|_ dS)NrMFzLWhen() supports a Q object, a boolean expression, or lookups as a condition.z1An empty Q() can't be used as a When() condition.ror) rrPr(rrrrq conditionrr)rrcthenlookupsrrrrq8s z When.__init__cCsd|j|jfS)NzWHEN %r THEN %rrcrr8rrrrIsz When.__str__cCsd|jj|fSNz<%s: %s>rr r8rrrrLsz When.__repr__cCs |j|jgSrkrfr8rrrr{OszWhen.get_source_expressionscCs|\|_|_dSrkrfr|rrrr~RszWhen.set_source_expressionscCs |jjgSrk)rrr8rrrrUszWhen.get_source_fieldsTcCsJ|}||_t|jdr0|j||||d|_|j||||||_|S)Nr-F)rtrr.rcr-rrrrrr-Ys   zWhen.resolve_expressionc Ksh|j||}g}||j\}}||d<||j\} } | |d<|pL|j}||g||| RfS)Nrcr)rrrrcrr7) rrr r7rtemplate_params sql_paramsZ condition_sqlZcondition_paramsZ result_sqlZ result_paramsrrrrgs  z When.as_sqlcCs$g}|D]}||q |SrkrWrrrrrvs zWhen.get_group_by_cols)NN)NTNFF)N)r r!r"r7rMrqrrr{r~rr-rrrrrrrrb2s  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)rcaserrrrrz Case.__init__..z.Positional arguments must all be When objects.r) allr(rrqlistcasesrrmr))rrmrrqr)rrrrqs   z Case.__init__cCs dddd|jD|jfS)NzCASE %s, ELSE %rrcss|]}t|VqdSrkr*)rrrrrrrzCase.__str__..)r0rqrmr8rrrrsz Case.__str__cCsd|jj|fSrgrhr8rrrrsz Case.__repr__cCs|j|jgSrkrqrmr8rrrr{szCase.get_source_expressionscCs|^|_|_dSrkrrr|rrrr~szCase.set_source_expressionsTFc CsT|}||_t|jD] \}}|||||||j|<q|j||||||_|Srk)rtrr4rqr-rm) rrrrrrrr5rnrrrr-s  zCase.resolve_expressioncst}|jdd|_|Srk)rrtrq)rrrrrrts z Case.copyc Ks*|j||js||jSi|j|}g}g}||j\} } |jD]h} z|| \} } Wn<tyvYqJYn(ty|| j\} } YqYn0| | | | qJ|s| | fS|p|j }| ||d<| |d<| | |p| d|j}||}|jdur"|j|j|}||fS)Nrqrmr7)rrrqrrmr)rrrrr case_joinerr0rr7rZunification_cast_sqlr)rrr r7rsrriZ case_partsrjZ default_sqlZdefault_paramsrnZcase_sqlZ case_paramsrrrrrs8           z Case.as_sqlcs|js|jStSrk)rqrmrrr8rrrrs zCase.get_group_by_cols)NTNFF)NN)r r!r"r#r7rsrqrrr{r~r-rtrrrrrrrrk~s    rkcs|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)rPrrsubqueryr)rrq)rquerysetrr)rrrrqszSubquery.__init__cCs|jgSrkrr8rrrr{szSubquery.get_source_expressionscCs|d|_dSr[rwr|rrrr~szSubquery.set_source_expressionscCs|jjSrk)rrr8rrrrszSubquery._resolve_output_fieldcst}|j|_|Srk)rrtrr)rrrrrrts  z Subquery.copycCs|jjSrk)rexternal_aliasesr8rrrrxszSubquery.external_aliasescCs |jSrk)rget_external_colsr8rrrryszSubquery.get_external_colsc Ks^|j|i|j|}|j||\}}|dd|d<|pL|d|j}||}||fS)Nr$r5rur7)rrr)rrrr7) rrr r7rriZ subquery_sqlrjrrrrrs zSubquery.as_sqlcCs|jj|dS)N)wrapper)rrr8rrrrszSubquery.get_group_by_cols)N)N)r r!r"r#r7rrrurqr{r~rrtrrxryrrrrrrrrts   rtcs4eZdZdZeZdZfddZddZ Z S)ExistszEXISTS(%(subquery)s)Fc s$tj|fi||j|_dSrk)rrqrexists)rrvrrrrrqszExists.__init__cCs|jjjsd|}||fSra)r rr^rrrrrrs  zExists.select_format) r r!r"r7r rrrrqrrrrrrr{s  r{zdjango.db.models.OrderByc@sheZdZdZdZdddZddZdd Zd d Zdd d Z ddZ ddZ ddZ ddZ ddZdS)rz%(expression)s %(ordering)sFNcCs^|r|rtd|dus |dur0tjdtdd||_||_||_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)rrrrrrrrrq+s zOrderBy.__init__cCsd|jj|j|jS)Nz{}({}, descending={}))rrr rrr8rrrr@szOrderBy.__repr__cCs|d|_dSr[r\r|rrrr~EszOrderBy.set_source_expressionscCs|jgSrkr\r8rrrr{HszOrderBy.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, %sZDESCZASC)rZorderingz%(expression)s) r7rZ supports_order_by_nulls_modifierrrrZorder_by_nulls_firstrrrrcountrstrip)rrr r7rZexpression_sqlrZ placeholdersrrrrKs6      zOrderBy.as_sqlcCsF|j|jr:|}tt|jdddd|_|||S|||S)NT)rdF)rm)rr_rrtrkrbr)rrr rtrrr as_oraclees  zOrderBy.as_oraclecCs$g}|D]}||q |SrkrWrrrrrss zOrderBy.get_group_by_colscCs4|j |_|jrd|_d|_n|jr0d|_d|_|Sr_)rrrr8rrrrys zOrderBy.reverse_orderingcCs d|_dSr:rUr8rrrrsz OrderBy.asccCs d|_dSr_rUr8rrrrsz OrderBy.desc)FNN)N)r r!r"r7rMrqrr~r{rrrrrrrrrrr&s   rcspeZdZdZdZdZdfdd ZddZd d Zd d Z dd dZ fddZ ddZ ddZ ddZZS)Windowz %(expression)s OVER (%(window)s)FTNcs||_||_||_t|dds.td|jj|jdur^t|jtt fsR|jf|_t |j|_|jdurt|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_byrYframerPrrr rrrprRrTrnrrrqrsource_expression)rrrrYrrrrrrqs.     zWindow.__init__cCs|jjSrk)rrr8rrrrszWindow._resolve_output_fieldcCs|j|j|j|jgSrkrrrYrr8rrrr{szWindow.get_source_expressionscCs|\|_|_|_|_dSrkrr|rrrr~szWindow.set_source_expressionscCs|j||jjstd||j\}}gd}}|jdurl|jj||dd\}} | ||t | 7}|j dur||j \} } | | |t | 7}|j r||j \} } | | |t | 7}|p|j }||d|dg||RfS)Nz1This backend does not support window expressions.rzPARTITION BY %(expressions)s)rr r7rl)rZwindow)rrrZsupports_over_clauser rrrrrrrYrr7r0strip)rrr r7Zexpr_sqlrZ window_sqlZ window_paramsZsql_exprrjZ order_sqlZ order_paramsZ frame_sqlZ frame_paramsrrrrs2             z Window.as_sqlcsTt|jtjrH|}|}t|d_||tt | ||S| ||Sr[) rrr rrtr{rr~rrrr)rrr rtrrrrrs zWindow.as_sqlitecCs>dt|j|jr dt|jndt|jp,dt|jp8dS)Nz{} OVER ({}{}{})z PARTITION BY rV)rrrrrYrr8rrrrs   zWindow.__str__cCsd|jj|fSrgrhr8rrrrszWindow.__repr__cCs8g}|jr||j|jdur4||j|Srk)rrrrY)rrXrrrrs  zWindow.get_group_by_cols)NNNN)N)r r!r"r7rrrqrr{r~rrrrrrrrrrrs $ ! 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/startendrrrrrrrq s zWindowFrame.__init__cCs|\|_|_dSrkrrr|rrrr~ sz"WindowFrame.set_source_expressionscCs |j|jgSrkrr8rrrr{sz"WindowFrame.get_source_expressionscCs>|j||||jj|jj\}}|j|j||dgfS)N frame_typerr)rrwindow_frame_start_endrrrr7r)rrr rrrrrrs zWindowFrame.as_sqlcCsd|jj|fSrgrhr8rrrr"szWindowFrame.__repr__cCsgSrkrr8rrrr%szWindowFrame.get_group_by_colscCs|jjdur2|jjdkr2dt|jjtjjf}n*|jjdurT|jjdkrTtjj}ntjj}|jjdur|jjdkrd|jjtjj f}n*|jjdur|jjdkrtjj}ntjj }|j |j ||dS)Nrz%d %sr) rrabsr rZ PRECEDINGZ CURRENT_ROWZUNBOUNDED_PRECEDINGrZ FOLLOWINGZUNBOUNDED_FOLLOWINGr7rrrrrr(s  zWindowFrame.__str__cCs tddS)Nz3Subclasses must implement window_frame_start_end().rgrr rrrrrr<sz"WindowFrame.window_frame_start_end)NN) r r!r"r#r7rqr~r{rrrrrrrrrrs rc@seZdZdZddZdS)RowRangeZROWScCs|j||Srk)rZwindow_frame_rows_start_endrrrrrCszRowRange.window_frame_start_endNr r!r"rrrrrrr@src@seZdZdZddZdS) ValueRangeRANGEcCs|j||Srk)rZwindow_frame_range_start_endrrrrrJsz!ValueRange.window_frame_start_endNrrrrrrGsr)\rtr> functoolsrr collectionsrdecimalrZuuidrdjango.core.exceptionsrrr django.dbr r r django.db.modelsr Zdjango.db.models.constantsr django.db.models.query_utilsrZdjango.utils.deconstructrdjango.utils.deprecationrdjango.utils.functionalrdjango.utils.hashablerrr$rnrrrr<r@r7rDrGrJrSr]rUrWrZr r r r Z_connector_combinationsrprrdrr2Z field_typesrrr lru_cacherr0r rrrr"r#r/rCrIrJrPrRrTrZrlrbrkrtr{rrrrrrrrrs          2% a   b3%% dO"') 3K`5ctB