U `|e)@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_contextsqlparamsrY/var/www/website-v5/atlas_env/lib/python3.8/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|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_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_summaryrr{rrrrrfor_savecrrrr-sz!BaseExpression.resolve_expressioncCst|jtjSrk)rrr BooleanFieldr8rrrrMszBaseExpression.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_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|]}|dk r|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|dkr dSt|Srk)floatrrrrisz.BaseExpression.convert_value.. IntegerFieldcSs|dkr dSt|Srk)intrrrrrosrcSs|dkr 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|]}|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)rrZ 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{rrrrrrrr-propertyrMrrrr staticmethodrxrrrrrrrrtrrrrrrrrrrrrrnsh               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_typerrrr2scCst||||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}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)r cCsTz |j}Wntk rYn,X|dkrJ||\}}|j||fS||S)Nr)rrrrrZformat_for_duration_arithmetic)rZsiderr 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||f|\}}|jtjtjhkrz|jj}|jj}Wnt t fk rZYn0Xddddh}||ksx||krt d|jd||fS)NrrrrzInvalid arguments for operator .) rr2r$r7rDrrrrrrr ) rrr rrrrrZallowed_fieldsrrrrs"  zDurationExpression.as_sqlite)r r!r"rrrrrrrrr s r cs,eZdZeZfddZddZZS)r cst||j|dSrk)rrqr@)rrrrrrrqszTemporalSubtraction.__init__cCs<|j|||j}||j}|j|jj||Srk)rrrrrZsubtract_temporalsrr)rrr rrrrrrs    zTemporalSubtraction.as_sql) r r!r"r rrrqrrrrrrr s r zdjango.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_expressionscKs t|f|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_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.rr8rrrr-szFunc._get_repr_optionscCs|jSrkrr8rrrr{szFunc.get_source_expressionscCs ||_dSrkr/r}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)NrTfunctiontemplater+rr)rrrrrrPrr/rrrr% setdefaultr2rr3r+r,)rrr r2r3r+rZ sql_partsrrZarg_sqlZ arg_paramsrdatarrrrs6      z Func.as_sqlcs*t}|jdd|_|j|_|Srk)rrtrr%)rrtrrrrts  z Func.copy)NTNFF)NNN)r r!r"r#r2r3r+r"rqrr-r{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) rrrrrZget_db_prep_saveZget_db_prep_valuer.r8)rrr r)rrrrrs  z Value.as_sqlTcst|||||}||_|Srk)rr-rrrrrr- szValue.resolve_expressioncCsgSrkrr8rrrrszValue.get_group_by_colscCst|jtrtSt|jtr(tSt|jtrszRawSQL.get_group_by_colsTFc sn|jrZ|jjD]F}|jjD]8}|\}} | |jkr||j|||qqqt |||||Srk) rrZget_parent_list local_fieldsZget_attname_columnlowerrrrrr-) rrrrrrparentZ parent_field_Z column_namerrrr-As&  zRawSQL.resolve_expression)N)NTNFF) r r!r"rqrrrr-rrrrrr?1sr?c@seZdZddZddZdS)StarcCsdS)Nz'*'rr8rrrrTsz Star.__repr__cCsdgfS)Nr'rrrrrrWsz Star.as_sqlN)r r!r"rrrrrrrESsrEcsNeZdZdZdZdfdd ZddZdd Zd d Zd d Z ddZ Z S)ColTFNcs,|dkr |}tj|d|||_|_dSr)rrqaliastarget)rrGrHrrrrrq_sz Col.__init__cCs>|j|j}}|r|t|fnt|f}d|jjd|S)Nrr)rGrHrrrr r,)rrGrH identifiersrrrresz Col.__repr__cCs<|j|jj}}|r||fn|f}dt|j|}|gfS)Nr)rGrHcolumnr,mapZquote_name_unless_alias)rrr rGrJrIrrrrrjsz Col.as_sqlcCs,|jdkr|S|||j|j|j|jSrk)rGrrrHrrrrrrps zCol.relabeled_clonecCs|gSrkrr8rrrrwszCol.get_group_by_colscCs0|j|jkr|j|S|j||j|Srk)rHrryrzrrrryzs   zCol.get_db_converters)N) r r!r"rrrqrrrrryrrrrrrF[srFcsbeZdZdZfddZddZddZdd 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|jSr@)rrr rrr8rrrrsz Ref.__repr__cCs|jgSrkrr8rrrr{szRef.get_source_expressionscCs |\|_dSrkrMr}rrrrszRef.set_source_expressionsNTFcCs|Srkrrrrrr-szRef.resolve_expressioncCs|jhSrk)rr8rrrrsz Ref.get_refscCs|SrkrrrrrrszRef.relabeled_clonecCs|j|jgfSrk)rZ quote_namerrrrrrsz Ref.as_sqlcCs|gSrkrr8rrrrszRef.get_group_by_cols)NTNFF)r r!r"r#rqrr{rr-rrrrrrrrrrLs  rLcs4eZdZdZdZfddZddZddZZS) 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__..)r+r,rr8rrrrszExpressionList.__str__cKs|j||f|Srk)r)rrr rrrrrszExpressionList.as_sqlite) r r!r"r#r3rqrrrrrrrrNs  rNcs4eZdZdZfddZfddZddZZS) OrderByListzORDER BY %(expressions)scs dd|D}tj||dS)Ncss@|]8}t|tr4|ddkr4tt|ddddn|VqdS)rr&r!NTr)rrrrrrrrrs  z'OrderByList.__init__..)rrqrOrrrrqszOrderByList.__init__cs|js dStj||S)N)r)rrrrrrrrszOrderByList.as_sqlcCs$g}|D]}||q |Srkr{rr)r group_by_colsorder_byrrrrs zOrderByList.get_group_by_cols)r r!r"r3rqrrrrrrrrPs rPz"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|jgSrkrXr8rrrr{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{rrrrrrrrrVs  rVcsJeZdZdZfddZddZfddZdfd d Zd dZZ S)rlz1The logical negation of a conditional expression.cstj|tddSr)rrqr rrYrrrrqszNegatedExpression.__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/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-sz$NegatedExpression.resolve_expressioncCs0|jjj}|jjjs(||jr(d|}||fSNzCASE WHEN {} THEN 1 ELSE 0 END)r rr[rrZrr)rrrrZ$expression_supported_in_where_clauserrrrs 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|r<|dkrtf|d}}nt|ddrrr r8rrrrIsz When.__repr__cCs |j|jgSrkrar8rrrr{LszWhen.get_source_expressionscCs|\|_|_dSrkrar}rrrrOszWhen.set_source_expressionscCs |jjgSrk)rrr8rrrrRszWhen.get_source_fieldsTcCsJ|}||_t|jdr0|j||||d|_|j||||||_|S)Nr-F)rtrr.r_r-rrrrrr-Vs$ zWhen.resolve_expressionc Ks`|j||}g}||j\}}||d<||j\} } | |d<|pL|j}||||| fS)Nr_r)rrrr_rr3) rrr r3rtemplate_params sql_paramsZ condition_sqlZcondition_paramsZ result_sqlZ result_paramsrrrrds  z When.as_sqlcCs$g}|D]}||q |SrkrSrrrrrss zWhen.get_group_by_cols)NN)NTNFF)N)r r!r"r3rMrqrrr{rrr-rrrrrrrr^/s   r^zdjango.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)rr^)rcaserrrrsz Case.__init__..z.Positional arguments must all be When objects.r) allr$rrqlistcasesrrhr%)rrhrrlr%rrrrqs   z Case.__init__cCs dddd|jD|jfS)NzCASE %s, ELSE %rrcss|]}t|VqdSrkr&)rrrrrrszCase.__str__..)r,rlrhr8rrrrsz Case.__str__cCsd|jj|fSrbrcr8rrrrsz Case.__repr__cCs|j|jgSrkrlrhr8rrrr{szCase.get_source_expressionscCs|^|_|_dSrkrmr}rrrrszCase.set_source_expressionsTFc CsT|}||_t|jD] \}}|||||||j|<q|j||||||_|Srk)rtrr0rlr-rh) rrrrrrrr1rirrrr-s$ zCase.resolve_expressioncst}|jdd|_|Srk)rrtrl)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)Nrlrhr3)rrrlrrhr%rrrrr case_joinerr,rr3rZunification_cast_sqlr)rrr r3rnrrdZ case_partsreZ default_sqlZdefault_paramsriZcase_sqlZ case_paramsrrrrrs8          z Case.as_sqlcs|js|jStSrk)rlrhrrr8rrrrs zCase.get_group_by_cols)NTNFF)NN)r r!r"r#r3rnrqrrr{rr-rtrrrrrrrrf{s&    rfcs|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|_dSrWrrr}rrrrszSubquery.set_source_expressionscCs|jjSrk)rrr8rrrrszSubquery._resolve_output_fieldcst}|j|_|Srk)rrtrr)rrrrrrts  z Subquery.copycCs|jjSrk)rexternal_aliasesr8rrrrsszSubquery.external_aliasescCs |jSrk)rget_external_colsr8rrrrtszSubquery.get_external_colsc KsZ|j||j|}|j||\}}|dd|d<|pH|d|j}||}||fS)Nr!r5rpr3)rrr%rrrr3) rrr r3rrdZ subquery_sqlrerrrrrs  zSubquery.as_sqlcCs|jj|dS)N)wrapper)rrr8rrrr szSubquery.get_group_by_cols)N)N)r r!r"r#r3rrrprqr{rrrtrrsrtrrrrrrrros   rocs4eZdZdZeZdZfddZddZ Z S)ExistszEXISTS(%(subquery)s)Fc s tj|f||j|_dSrk)rrqrexists)rrqrrrrrqszExists.__init__cCs|jjjsd|}||fSr])r rrZrrrrrrs  zExists.select_format) r r!r"r3r rrrrqrrrrrrrvs  rvzdjango.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)rrrr|r}rrrrq(s zOrderBy.__init__cCsd|jj|j|jS)Nz{}({}, descending={}))rrr rrr8rrrr=s zOrderBy.__repr__cCs|d|_dSrWrXr}rrrrBszOrderBy.set_source_expressionscCs|jgSrkrXr8rrrr{EszOrderBy.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) r3rZ supports_order_by_nulls_modifierr}r|rZorder_by_nulls_firstrrrrcountrstrip)rrr r3rZexpression_sqlrZ placeholdersrrrrHs6      zOrderBy.as_sqlcCsF|j|jr:|}tt|jdddd|_|||S|||S)NT)r`F)rh)rr[rrtrfr^r)rrr rtrrr as_oraclebs  zOrderBy.as_oraclecCs$g}|D]}||q |SrkrSrrrrrps zOrderBy.get_group_by_colscCs4|j |_|jrd|_d|_n|jr0d|_d|_|Sr_)rr|r}r8rrrrvs zOrderBy.reverse_orderingcCs d|_dSr:rQr8rrrrsz OrderBy.asccCs d|_dSr_rQr8rrrrsz OrderBy.desc)FNN)N)r r!r"r3rMrqrrr{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|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_byrUframerPrrr rrrkrNrPrnrrrqrsource_expression)rrrrUrrrrrrqs.     zWindow.__init__cCs|jjSrk)rrr8rrrrszWindow._resolve_output_fieldcCs|j|j|j|jgSrkrrrUrr8rrrr{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 r3rg)rZwindow)rrrZsupports_over_clauser rrrrrrrUrr3r,strip)rrr r3Zexpr_sqlrZ window_sqlZ window_paramsZsql_exprreZ order_sqlZ order_paramsZ frame_sqlZ frame_paramsrrrrs2            z Window.as_sqlcsTt|jtjrH|}|}t|d_||tt | ||S| ||SrW) rrr rrtr{rrrrrr)rrr rtrrrrrs zWindow.as_sqlitecCs>dt|j|jr dt|jndt|jp,dt|jp8dS)Nz{} OVER ({}{}{})z PARTITION BY rR)rrrrrUrr8rrrrs   zWindow.__str__cCsd|jj|fSrbrcr8rrrrszWindow.__repr__cCs8g}|jr||j|jdk r4||j|Srk)rrrrU)rrTrrrrs  zWindow.get_group_by_cols)NNNN)N)r r!r"r3rrrqrr{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}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_endrrrr3r)rrr rrrrrrs zWindowFrame.as_sqlcCsd|jj|fSrbrcr8rrrrszWindowFrame.__repr__cCsgSrkrr8rrrr"szWindowFrame.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 rZ PRECEDINGZ CURRENT_ROWZUNBOUNDED_PRECEDINGrZ FOLLOWINGZUNBOUNDED_FOLLOWINGr3rrrrrr%s  zWindowFrame.__str__cCs tddS)Nz3Subclasses must implement window_frame_start_end().rgrr rrrrrr9sz"WindowFrame.window_frame_start_end)NN) r r!r"r#r3rqrr{rrrrrrrrrrs rc@seZdZdZddZdS)RowRangeZROWScCs|j||Srk)rZwindow_frame_rows_start_endrrrrr@szRowRange.window_frame_start_endNr r!r"rrrrrrr=src@seZdZdZddZdS) ValueRangeRANGEcCs|j||Srk)rZwindow_frame_range_start_endrrrrrGsz!ValueRange.window_frame_start_endNrrrrrrDsr)\rtr: functoolsrrz 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 rr r Z_connector_combinationsrkrrdrr2Z field_typesrrr lru_cacherr0r r rrrr r/r?rErFrLrNrPrVrlr^rfrorvrrrrrrrrrs          2% a   b3%% dO"'' 3K`5ctB