U 2d)@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_contextsqlparamsrU/home/sam/Atlas/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)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{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)Nrr rrzInvalid 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_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 ||_dSrkr1r}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' setdefaultr4rr5r-r.)rrr r4r5r-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#r4r5r-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.r:)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_listZ local_fieldsZget_attname_columnlowerrrrrr-) rrrrrrparentZ parent_field_Z column_namerrrr-As&  zRawSQL.resolve_expression)N)NTNFF) r r!r"rqrrrr-rrrrrrA1srAc@seZdZddZddZdS)StarcCsdS)Nz'*'rr8rrrrTsz Star.__repr__cCsdgfS)Nr'rrrrrrWsz Star.as_sqlN)r r!r"rrrrrrrFSsrFcsNeZdZdZdZdfdd ZddZdd Zd d Zd d Z ddZ Z S)ColTFNcs,|dkr |}tj|d|||_|_dSr)rrqaliastarget)rrHrIrrrrrq_sz Col.__init__cCs>|j|j}}|r|t|fnt|f}d|jjd|S)Nrr)rHrIrrrr r.)rrHrI identifiersrrrresz Col.__repr__cCs<|j|jj}}|r||fn|f}dt|j|}|gfS)Nr)rHrIcolumnr.mapZquote_name_unless_alias)rrr rHrKrJrrrrrjsz Col.as_sqlcCs,|jdkr|S|||j|j|j|jSrk)rHrrrIrrrrrrps zCol.relabeled_clonecCs|gSrkrr8rrrrwszCol.get_group_by_colscCs0|j|jkr|j|S|j||j|Srk)rIrryrzrrrryzs   zCol.get_db_converters)N) r r!r"rrrqrrrrryrrrrrrG[srGcsbeZdZdZfddZddZddZdd 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|jSrB)rrr rrr8rrrrsz Ref.__repr__cCs|jgSrkrr8rrrr{szRef.get_source_expressionscCs |\|_dSrkrNr}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-rrrrrrrrrrMs  rMcs4eZdZdZdZfddZddZddZZS) 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#r5rqrrrrrrrrOs  rOcs4eZdZdZfddZfddZddZZS) OrderByListzORDER BY %(expressions)scs dd|D}tj||dS)Ncss@|]8}t|tr4|ddkr4tt|ddddn|VqdS)rr&r"NTr)rrrrrrrrrs  z'OrderByList.__init__..)rrqrPrrrrqszOrderByList.__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"r5rqrrrrrrrrQs rQz"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|jgSrkrYr8rrrr{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{rrrrrrrrrWs  rWcsJeZdZdZfddZddZfddZdfd d Zd dZZ S)rlz1The logical negation of a conditional expression.cstj|tddSr)rrqr rrZrrrrqszNegatedExpression.__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\rr[rr)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|jgSrkrcr8rrrr{LszWhen.get_source_expressionscCs|\|_|_dSrkrcr}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`rr5) rrr r5rtemplate_params sql_paramsZ condition_sqlZcondition_paramsZ result_sqlZ result_paramsrrrrds  z When.as_sqlcCs$g}|D]}||q |SrkrTrrrrrss zWhen.get_group_by_cols)NN)NTNFF)N)r r!r"r5rMrqrrr{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&rrqlistcasesrrjr')rrjrrnr'rrrrqs   z Case.__init__cCs dddd|jD|jfS)NzCASE %s, ELSE %rrcss|]}t|VqdSrkr()rrrrrrszCase.__str__..)r.rnrjr8rrrrsz Case.__str__cCsd|jj|fSrdrer8rrrrsz Case.__repr__cCs|j|jgSrkrnrjr8rrrr{szCase.get_source_expressionscCs|^|_|_dSrkror}rrrrszCase.set_source_expressionsTFc CsT|}||_t|jD] \}}|||||||j|<q|j||||||_|Srk)rtrr2rnr-rj) rrrrrrrr3rkrrrr-s$ zCase.resolve_expressioncst}|jdd|_|Srk)rrtrn)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)Nrnrjr5)rrrnrrjr'rrrrr case_joinerr.rr5rZunification_cast_sqlr)rrr r5rprrfZ case_partsrgZ default_sqlZdefault_paramsrkZcase_sqlZ case_paramsrrrrrs8          z Case.as_sqlcs|js|jStSrk)rnrjrrr8rrrrs zCase.get_group_by_cols)NTNFF)NN)r r!r"r#r5rprqrrr{rr-rtrrrrrrrrh{s&    rhcs|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|_dSrXrtr}rrrrszSubquery.set_source_expressionscCs|jjSrk)rrr8rrrrszSubquery._resolve_output_fieldcst}|j|_|Srk)rrtrr)rrrrrrts  z Subquery.copycCs|jjSrk)rexternal_aliasesr8rrrruszSubquery.external_aliasescCs |jSrk)rget_external_colsr8rrrrvszSubquery.get_external_colsc KsZ|j||j|}|j||\}}|dd|d<|pH|d|j}||}||fS)Nr"r5rrr5)rrr'rrrr5) rrr r5rrfZ subquery_sqlrgrrrrrs  zSubquery.as_sqlcCs|jj|dS)N)wrapper)rrr8rrrr szSubquery.get_group_by_cols)N)N)r r!r"r#r5rrrrrqr{rrrtrrurvrrrrrrrrqs   rqcs4eZdZdZeZdZfddZddZ Z S)ExistszEXISTS(%(subquery)s)Fc s tj|f||j|_dSrk)rrqrexists)rrsrrrrrqszExists.__init__cCs|jjjsd|}||fSr^)r rr[rrrrrrs  zExists.select_format) r r!r"r5r rrrrqrrrrrrrxs  rxzdjango.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~rrrrrq(s zOrderBy.__init__cCsd|jj|j|jS)Nz{}({}, descending={}))rrr rrr8rrrr=s zOrderBy.__repr__cCs|d|_dSrXrYr}rrrrBszOrderBy.set_source_expressionscCs|jgSrkrYr8rrrr{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, %sZDESCASC)rZorderingz%(expression)s) r5rZ supports_order_by_nulls_modifierrr~rZorder_by_nulls_firstrrrrcountrstrip)rrr r5rZexpression_sqlrZ placeholdersrrrrHs6      zOrderBy.as_sqlcCsF|j|jr:|}tt|jdddd|_|||S|||S)NT)raF)rj)rr\rrtrhr_r)rrr rtrrr as_oraclebs  zOrderBy.as_oraclecCs$g}|D]}||q |SrkrTrrrrrps zOrderBy.get_group_by_colscCs4|j |_|jrd|_d|_n|jr0d|_d|_|Sr_)rr~rr8rrrrvs zOrderBy.reverse_orderingcCs d|_dSr:rRr8rrrrsz OrderBy.asccCs d|_dSr_rRr8rrrrsz OrderBy.desc)FNN)N)r r!r"r5rMrqrrr{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_byrVframerPrrr rrrmrOrQrnrrrqrsource_expression)rrrrVrrrrrrqs.     zWindow.__init__cCs|jjSrk)rrr8rrrrszWindow._resolve_output_fieldcCs|j|j|j|jgSrkrrrVrr8rrrr{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 r5ri)rZwindow)rrrZsupports_over_clauser rrrrrrrVrr5r.strip)rrr r5Zexpr_sqlrZ window_sqlZ window_paramsZsql_exprrgZ order_sqlZ order_paramsZ frame_sqlZ frame_paramsrrrrs2            z Window.as_sqlcsTt|jtjrH|}|}t|d_||tt | ||S| ||SrX) rrr rrtr{rrrrrr)rrr rtrrrrrs zWindow.as_sqlitecCs>dt|j|jr dt|jndt|jp,dt|jp8dS)Nz{} OVER ({}{}{})z PARTITION BY rS)rrrrrVrr8rrrrs   zWindow.__str__cCsd|jj|fSrdrer8rrrrszWindow.__repr__cCs8g}|jr||j|jdk r4||j|Srk)rrrrV)rrUrrrrs  zWindow.get_group_by_cols)NNNN)N)r r!r"r5rrrqrr{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_endrrrr5r)rrr rrrrrrs zWindowFrame.as_sqlcCsd|jj|fSrdrer8rrrrszWindowFrame.__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_FOLLOWINGr5rrrrrr%s  zWindowFrame.__str__cCs tddS)Nz3Subclasses must implement window_frame_start_end().rgrr rrrrrr9sz"WindowFrame.window_frame_start_end)NN) r r!r"r#r5rqrr{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< 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 r Z_connector_combinationsrmrrdrr2Z field_typesrrr lru_cacherr0r rrrr r!r/rArFrGrMrOrQrWrlr_rhrqrxrrrrrrrrrs          2% a   b3%% dO"'' 3K`5ctB