0_c@sddlZddlZddlmZmZddlmZddlm Z ddl m Z ddl m Z ddlmZdefd YZd efd YZd eefd YZdefdYZdefdYZdefdYZdefdYZdefdYZdefdYZdefdYZdefdYZdefdYZd efd!YZd"efd#YZd$efd%YZd&efd'YZ d(efd)YZ!d*efd+YZ"d,efd-YZ#d.efd/YZ$d0efd1YZ%d2e%fd3YZ&d4efd5YZ'dS(6iN(tEmptyResultSett FieldError(tutils(tfields(tQ(tsix(tcached_propertyt CombinablecBseZdZdZdZdZdZdZdZdZ dZ d Z d Z d"d Zd Zd ZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZ dZ!dZ"d Z#d!Z$RS(#sv Provides the ability to combine one or two objects with some connector. For example F('foo') + F('bar'). t+t-t*t/t^s%%t&t|s<>cCsqt|dsKt|tjr<t|dtj}qKt|}n|rat|||St|||S(Ntresolve_expressiont output_field( thasattrt isinstancetdatetimet timedeltat DurationValueRt DurationFieldtValuetCombinedExpression(tselftothert connectortreversedtnode((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyt_combine$scCs|j||jtS(N(RtADDtFalse(RR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyt__add__4scCs|j||jtS(N(RtSUBR (RR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyt__sub__7scCs|j||jtS(N(RtMULR (RR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyt__mul__:scCs|j||jtS(N(RtDIVR (RR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyt __truediv__=scCst|j||S(N(ttypeR'(RR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyt__div__@scCs|j||jtS(N(RtMODR (RR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyt__mod__CscCs|j||jtS(N(RtPOWR (RR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyt__pow__FscCstddS(Ns:Use .bitand() and .bitor() for bitwise logical operations.(tNotImplementedError(RR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyt__and__IscCs|j||jtS(N(RtBITANDR (RR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pytbitandNscCs|j||jtS(N(Rt BITLEFTSHIFTR (RR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyt bitleftshiftQscCs|j||jtS(N(Rt BITRIGHTSHIFTR (RR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyt bitrightshiftTscCstddS(Ns:Use .bitand() and .bitor() for bitwise logical operations.(R.(RR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyt__or__WscCs|j||jtS(N(RtBITORR (RR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pytbitor\scCs|j||jtS(N(RRtTrue(RR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyt__radd___scCs|j||jtS(N(RR"R9(RR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyt__rsub__bscCs|j||jtS(N(RR$R9(RR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyt__rmul__escCs|j||jtS(N(RR&R9(RR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyt __rtruediv__hscCst|j||S(N(R(R=(RR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyt__rdiv__kscCs|j||jtS(N(RR*R9(RR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyt__rmod__nscCs|j||jtS(N(RR,R9(RR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyt__rpow__qscCstddS(Ns:Use .bitand() and .bitor() for bitwise logical operations.(R.(RR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyt__rand__tscCstddS(Ns:Use .bitand() and .bitor() for bitwise logical operations.(R.(RR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyt__ror__ysN(%t__name__t __module__t__doc__RR"R$R&R,R*R0R7R2R4tNoneRR!R#R%R'R)R+R-R/R1R3R5R6R8R:R;R<R=R>R?R@RARB(((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyR sD                      tBaseExpressioncBs+eZdZeZdZddZdZdZ dZ dZ dZ e dZe dZdedeed Zd Zed Ze d Ze d ZdZdZdZdZdZdZdZdZdZdZ dZ!dZ"RS(s/ Base class for all query expressions. cCs|dk r||_ndS(N(RFt _output_field(RR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyt__init__s cCs|jg|jj|S(N(t convert_valueRtget_db_converters(Rt connection((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRKscCsgS(N((R((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pytget_source_expressionsscCst|dkstdS(Ni(tlentAssertionError(Rtexprs((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pytset_source_expressionsscGsPg|D]E}t|dr"|n't|tjr@t|n t|^qS(NR(RRRt string_typestFR(Rt expressionstarg((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyt_parse_expressionsscCstddS(s 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(Expression, self).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. Returns: (sql, params) Where `sql` is a string containing ordered sql parameters to be replaced with the elements of the list `params`. s"Subclasses must implement as_sql()N(R.(RtcompilerRL((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pytas_sqlscCs.x'|jD]}|r |jr tSq WtS(N(RMtcontains_aggregateR9R (Rtexpr((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRYscCs.x'|jD]}|r |jr tSq WtS(N(RMtcontains_column_referencesR9R (RRZ((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyR[scCsQ|j}||_|jg|jD]}|j||||^q(|S(s  Provides 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 Returns: an Expression to be added to the query. (tcopyt is_summaryRQRMR(Rtqueryt allow_joinstreuset summarizetfor_savetcRZ((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRs   /cCs|S(sQ Hook used by Lookup.get_prep_lookup() to do custom preparation. ((Rtfield((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyt_preparescCs|jS(N(R(R((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRdscCs%|jdkrtdn|jS(s> Returns the output type of this expressions. s4Cannot resolve expression type, unknown output_fieldN(t_output_field_or_noneRFR(R((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRscCs#|jdkr|jn|jS(s Returns the output field of this expression, or None if no output type can be resolved. Note that the 'output_field' property will raise FieldError if no type can be resolved, but this attribute allows for None values. N(RHRFt_resolve_output_field(R((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRfs cCs|jdkr|j}t|}|dkr?d|_qx]|D]R}|jdkrg||_n|dk rFt|j|j rFtdqFqFWndS(s Attempts to infer the output type of the expression. If the output fields of all source fields match then we can simply infer the same type here. This isn't always correct, but it makes sense most of the time. Consider the difference between `2 + 2` and `2 / 3`. Inferring the type here is a convenience for the common case. The user should supply their own output_field with more complex computations. If a source does not have an `_output_field` then we exclude it from this check. If all sources are `None`, then an error will be thrown higher up the stack in the `output_field` property. is:Expression contains mixed types. You must set output_fieldN(RHRFtget_source_fieldsRNRt __class__R(Rtsourcest num_sourcestsource((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRgs      "cCsq|j}|j}|dkr%|S|dkr;t|S|jdrTt|S|dkrmtj|S|S(s 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. t FloatFieldt IntegerFieldt DecimalFieldN(Rtget_internal_typeRFtfloattendswithtintt backend_utilsttypecast_decimal(Rtvaluet expressionRLtcontextRdt internal_type((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRJs        cCs|jj|S(N(Rt get_lookup(Rtlookup((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRz*scCs|jj|S(N(Rt get_transform(Rtname((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyR|-scCs?|j}|jg|jD]}|j|^q|S(N(R\RQRMtrelabeled_clone(Rt change_maptclonete((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyR~0s )cCstj|}t|_|S(N(R\R9tcopied(RRc((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyR\6s cCsD|js|gSg}x'|jD]}|j|jq#W|S(N(RYRMtextendtget_group_by_cols(RtcolsRl((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyR;s  cCs g|jD]}|j^q S(sT Returns the underlying field types used by this aggregate. (RMRf(RR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRhCscKs t||S(N(tOrderBy(Rtkwargs((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pytascJscKst|dt|S(Nt descending(RR9(RR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pytdescMscCs|S(N((R((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pytreverse_orderingPsccsE|Vx9|jD]+}|rx|jD] }|Vq+WqqWdS(si Recursively yield this expression and all subexpressions, in depth-first order. N(RMtflatten(RRZt inner_expr((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRSs N(#RCRDRER R]RFRHRIRKRMRQRVRXRRYR[R9RRetpropertyRdRRfRgRJRzR|R~R\RRhRRRR(((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRGs8                   t ExpressioncBseZdZRS(sD An expression that can be combined with other expressions. (RCRDRE(((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyR_sRcBsYeZddZdZdZdZdZdZde de e dZ RS(cCs8tt|jd|||_||_||_dS(NR(tsuperRRIRtlhstrhs(RRRRR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRIhs  cCsdj|jj|S(Ns<{}: {}>(tformatRiRC(R((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyt__repr__nscCsdj|j|j|jS(Ns{} {} {}(RRRR(R((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyt__str__qscCs|j|jgS(N(RR(R((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRMtscCs|\|_|_dS(N(RR(RRP((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRQwsc Csy|jj}Wntk r)d}nXy|jj}Wntk rSd}nX|jj r|ry|jdks|r|jdkrt|j|j |jj ||S|r&|r&|j |j kr&|jdddhkr&|j|jkr&t |j|jj ||Sg}g}|j |j\}}|j||j||j |j\}}|j||j|d} |jj|j |}| ||fS(NRt DateFieldt DateTimeFieldt TimeFields(%s)(RRRRFRtfeaturesthas_native_duration_fieldRptDurationExpressionRRXR"tTemporalSubtractiontcompiletappendRtopstcombine_expression( RRWRLt lhs_outputt rhs_outputRTtexpression_paramstsqltparamstexpression_wrapper((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRXzs6     %    cCs[|j}||_|jj||||||_|jj||||||_|S(N(R\R]RRR(RR^R_R`RaRbRc((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRs   !!N( RCRDRFRIRRRMRQRXR9R R(((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRfs      RcBseZdZdZRS(cCs}t|tspy |j}Wntk r/qpX|jdkrp|j|\}}|jj||fSn|j|S(NR(RRRRRpRRtformat_for_duration_arithmetic(RtsideRWRLtoutputRR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRs  cCs|jj|g}g}|j|j||\}}|j||j||j|j||\}}|j||j|d}|jj|j|}|||fS(Ns(%s)( Rtcheck_expression_supportRRRRRtcombine_duration_expressionR(RRWRLRTRRRR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRXs    (RCRDRRX(((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRs RcBseZdZdZRS(cCs/tt|j||j|dtjdS(NR(RRRIR"RR(RRR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRIscCs\|jj||j|j|}|j|j|}|jj|jjj||S(N(RRRRRtsubtract_temporalsRRp(RRWRLRR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRXs(RCRDRIRX(((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRs RScBsJeZdZdZdZdedeedZdZ dZ RS(sN An object capable of resolving references to existing query objects. cCs ||_dS(s^ Arguments: * name: the name of the field this expression references N(R}(RR}((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRIscCsdj|jj|jS(Ns{}({})(RRiRCR}(R((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRscCs|j|j|||S(N(t resolve_refR}(RR^R_R`RaRb((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRscKs t||S(N(R(RR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRscKst|dt|S(NR(RR9(RR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRsN( RCRDRERIRRFR9R RRR(((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRSs    tResolvedOuterRefcBs#eZdZdZddZRS(s 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. cOstddS(NsXThis queryset contains a reference to an outer query and may only be used in a subquery.(t ValueError(RtargsR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRXscCs|S(N((RR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyResN(RCRDRERXRFRe(((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRs tOuterRefcBs,eZdedeedZddZRS(cCs)t|j|jr|jSt|jS(N(RR}RiR(RR^R_R`RaRb((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRscCs|S(N((RR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyResN(RCRDRFR9R RRe(((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRstFunccBseZdZd ZdZdZd ZdZdZ dZ dZ d e d e e dZd d d dZd Zd ZRS( s An SQL function call. s%(function)s(%(expressions)s)s, cOs|jdk rgt||jkrgtd|jj|j|jdkrNdndt|fn|jdd}tt|j d||j ||_ ||_ dS(Ns#'%s' takes exactly %s %s (%s given)itargumentt argumentsR( tarityRFRNt TypeErrorRiRCtpopRRRIRVtsource_expressionstextra(RRTRR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRIs$ cCsv|jjd|jD}djd|jjD}|r`dj|jj||Sdj|jj|S(Ncss|]}t|VqdS(N(tstr(t.0RU((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pys ss, css/|]%\}}t|dt|VqdS(t=N(R(Rtkeytval((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pys ss {}({}, {})s{}({})(t arg_joinertjoinRRtitemsRRiRC(RRR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRs "cCs|jS(N(R(R((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRMscCs ||_dS(N(R(RRP((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRQsc Cs[|j}||_x?t|jD].\}}|j||||||j|/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyR s   &c Ks|jj|g}g}x@|jD]5} |j| \} } |j| |j| q&W|jj} | j||dk r|| d/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRX's     cKs_|j|||\}}y&|jjdkr@d|}nWntk rTnX||fS(NRosCAST(%s AS NUMERIC)(RXRRpR(RRWRLRRR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyt as_sqlite=s cCs8tt|j}|j|_|jj|_|S(N(RRR\RR(RR\((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyR\Fs N(RCRDRERFRRRRRIRRMRQR9R RRXRR\(((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRs     RcBsMeZdZddZdZdZdedeedZ dZ RS(sC Represents a wrapped value as a node within an expression cCs&tt|jd|||_dS(s: 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(). RN(RRRIRv(RRvR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRIQs cCsdj|jj|jS(Ns{}({})(RRiRCRv(R((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyR]scCs|jj||j}|jdk r|jrL|jj|d|}n|jj|d|}t |jdr|jj ||||gfSn|dkrdgfSd|gfS(NRLtget_placeholdertNULLs%s( RRRvRHRFRbRtget_db_prep_savetget_db_prep_valueRR(RRWRLR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRX`s  "  cCs1tt|j|||||}||_|S(N(RRRRb(RR^R_R`RaRbRc((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRrs$ cCsgS(N((R((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRwsN( RCRDRERFRIRRXR9R RR(((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRMs   RcBseZdZRS(cCsH|jj||jjr5tt|j||S|jj|jS(N( RRRRRRRXtdate_interval_sqlRv(RRWRL((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRX|s (RCRDRX(((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyR{stRawSQLcBs/eZddZdZdZdZRS(cCsK|dkrtj}n|||_|_tt|jd|dS(NR(RFRtFieldRRRRRI(RRRR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRIs cCsdj|jj|j|jS(Ns {}({}, {})(RRiRCRR(R((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRscCsd|j|jfS(Ns(%s)(RR(RRWRL((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRXscCs|gS(N((R((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRsN(RCRDRFRIRRXR(((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRs   tStarcBseZdZdZRS(cCsdS(Ns'*'((R((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRscCs dgfS(NR ((RRWRL((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRXs(RCRDRRX(((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRs tRandomcBs#eZdZdZdZRS(cCs#tt|jdtjdS(NR(RRRIRRm(R((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRIscCsdS(NsRandom()((R((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRscCs|jjgfS(N(Rtrandom_function_sql(RRWRL((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRXs(RCRDRIRRX(((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRs  tColcBsGeZeZddZdZdZdZdZ dZ RS(cCsE|dkr|}ntt|jd||||_|_dS(NR(RFRRRItaliasttarget(RRRR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRIs  cCsdj|jj|j|jS(Ns {}({}, {})(RRiRCRR(R((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRscCs2|j}d||j||jjfgfS(Ns%s.%s(tquote_name_unless_aliasRRtcolumn(RRWRLtqn((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRXs cCs+|j|j|j|j|j|jS(N(RiRRRR(Rtrelabels((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyR~scCs|gS(N((R((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRscCsB|j|jkr"|jj|S|jj||jj|S(N(RRRK(RRL((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRKsN( RCRDR9R[RFRIRRXR~RRK(((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRs     tRefcBseeZdZdZdZdZdZd ed e e dZ dZ dZ dZ RS( s~ Reference to column alias of the query. For example, Ref('sum_cost') in qs.annotate(sum_cost=Sum('cost')) query. cCs*tt|j|||_|_dS(N(RRRItrefsRl(RRRl((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRIscCsdj|jj|j|jS(Ns {}({}, {})(RRiRCRRl(R((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRscCs |jgS(N(Rl(R((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRMscCs|\|_dS(N(Rl(RRP((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRQscCs|S(N((RR^R_R`RaRb((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRscCs|S(N((RR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyR~scCsd|jj|jgfS(Ns%s(Rt quote_nameR(RRWRL((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRXscCs|gS(N((R((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRsN(RCRDRERIRRMRQRFR9R RR~RXR(((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRs      tExpressionWrappercBs;eZdZdZdZdZdZdZRS(s An expression that can wrap another expression so that it can provide extra context to the inner expression, such as the output_field. cCs&tt|jd|||_dS(NR(RRRIRw(RRwR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRIscCs|d|_dS(Ni(Rw(RRP((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRQscCs |jgS(N(Rw(R((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRMscCs|jj||S(N(RwRX(RRWRL((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRXscCsdj|jj|jS(Ns{}({})(RRiRCRw(R((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRs(RCRDRERIRQRMRXR(((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRs     tWhencBsweZdZd d dZdZdZdZdZdZ d e d e e dZ d dZ d ZRS( s"WHEN %(condition)s THEN %(result)scKs|r(|dkr(t|d}}n|dksJt|t sJ|rYtdntt|jdd||_|j|d|_ dS(NsB__init__() takes either a Q object or lookups as keyword argumentsRi( RFRRRRRRIt conditionRVtresult(RRtthentlookups((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRIs" cCsd|j|jfS(NsWHEN %r THEN %r(RR(R((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyR scCsd|jj|fS(Ns<%s: %s>(RiRC(R((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyR scCs|j|jgS(N(RR(R((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRMscCs|\|_|_dS(N(RR(RRP((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRQscCs |jjgS(N(RRf(R((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRhscCsp|j}||_t|jdrK|jj||||t|_n|jj||||||_|S(NR(R\R]RRRR R(RR^R_R`RaRbRc((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRs   $!c Ks|jj||}g}|j|j\}}||d<|j||j|j\} } | |d<|j| |p|j}|||fS(NRR(RRRRRRR( RRWRLRRttemplate_paramst sql_paramst condition_sqltcondition_paramst result_sqlt result_params((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRX"s    cCs4g}x'|jD]}|j|jqW|S(N(RMRR(RRRl((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyR/sN(RCRDRRFRIRRRMRQRhR9R RRXR(((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRs      tCasecBsweZdZdZdZdZdZdZdZdZ d e d e e dZ d Zd d d ZRS( s An SQL searched CASE expression: CASE WHEN n > 0 THEN 'positive' WHEN n < 0 THEN 'negative' ELSE 'zero' END s#CASE %(cases)s ELSE %(default)s ENDt cOstd|Ds%tdn|jdd}|jdd}tt|j|t||_|j |d|_ ||_ dS(Ncss|]}t|tVqdS(N(RR(Rtcase((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pys Gss.Positional arguments must all be When objects.tdefaultRi( tallRRRFRRRItlisttcasesRVRR(RRRRR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRIFscCs'ddjd|jD|jfS(NsCASE %s, ELSE %rs, css|]}t|VqdS(N(R(RRc((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pys Qs(RRR(R((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRPscCsd|jj|fS(Ns<%s: %s>(RiRC(R((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRSscCs|j|jgS(N(RR(R((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRMVscCs|d |_|d|_dS(Ni(RR(RRP((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRQYs c Cs||j}||_x?t|jD].\}}|j||||||j|/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyR]s   &!cCs&tt|j}|j|_|S(N(RRR\R(RRc((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyR\es cKsj|jj||js)|j|jS|jj}|j|g}g}x[|jD]P} y|j| \} } Wntk rq[nX|j | |j | q[W|j|j\} } |s| | fS|p|j }|j ||d<| |d<|j | |p(|j d|j}||}|jdk r`|jj|j|}n||fS(NRRR(RRRRRRR\RRRRt case_joinerRRRRfRFtunification_cast_sqlR(RRWRLRRRRt case_partsRRtcase_sqlt case_paramst default_sqltdefault_paramsR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRXjs4        N(RCRDRERRRIRRRMRQRFR9R RR\RX(((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyR7s      tSubquerycBsheZdZdZd dZdZd ed eedZ dZ dZ d dZ dZ RS( s An explicit subquery. It may contain OuterRef() references to the outer query which will be resolved when it is applied to that query. s(%(subquery)s)cKsl||_||_|dkrRt|jjjdkrR|jjjdj}ntt|j |dS(Nii( tquerysetRRFRNR^tselectRdRRRI(RRRR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRIs   'cCs+tt|j}|jj|_|S(N(RRR\RR(RR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyR\scs|j_jjjfdfdjjjxNjjjjD]7\}}t|t r|jjj|/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRs#c st|dr|jddddd}t|dr|j|jjjjkrjjj j |jn|S|S(NRR^R_R`RaRbR( RRRRtmodelt_metatdb_tableRR^texternal_aliasestadd(Rtresolved(R_RRbR^R`Ra(s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRs *( R\R]RR^t bump_prefixtwheret annotationsRRR(RR^R_R`RaRbRRv((R_RRbR^RRR`Ras>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRs   " cCsHgg|jjjjD]}t|dd^qD]}|r2|^q2S(NR(RR^R RtgetattrRF(RRZtx((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRMs2csW|jjjj|j_jjjjfd|jDS(Nc3s*|] }|jjjkr|VqdS(N(RR^ttables(RR(R(s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pys s(R\RR^R~RRtvalues(RR((Rs>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyR~s  cKs|jj||jj}|j||jjjd|j\|d<}|pl|j d|j }||}||fS(NRLtsubqueryR( RRRR\RRR^t get_compilerRXRR(RRWRLRRRRR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRXs ( cCs,|jdkr(|j}d|_|S|S(Ns(%(subquery)s)s %(subquery)s(RR\(RRR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRes   N(RCRDRERRFRIR\R9R RRMR~RXRe(((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRs  !  tExistscBsSeZdZdZdZedZddZddZ ddZ RS(sEXISTS(%(subquery)s)cOs2|jdt|_tt|j||dS(Ntnegated(RR RRRRI(RRR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRIscCs)t||j|jd|j |jS(NR(R(RRRR(R((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyt __invert__scCs tjS(N(Rt BooleanField(R((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRscKs+|jj|_tt|j||S(N(Rtorder_byRRR(RR^R((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRscKsLtt|j||||\}}|jrBdj|}n||fS(NsNOT {}(RRRXRR(RRWRLRRRR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRXs' cKs7|j||||\}}dj|}||fS(NsCASE WHEN {} THEN 1 ELSE 0 END(RXR(RRWRLRRRR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyt as_oraclesN( RCRDRRIRRRRFRRXR(((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRs    RcBs}eZdZeeedZdZdZdZd dZ dZ dZ dZ d Z d Zd ZRS( s%(expression)s %(ordering)scCsa|r|rtdn||_||_||_t|dsTtdn||_dS(Ns1nulls_first and nulls_last are mutually exclusiveRs%expression must be an expression type(Rt nulls_firstt nulls_lastRRRw(RRwRRR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRIs    cCsdj|jj|j|jS(Ns{}({}, descending={})(RRiRCRwR(R((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRscCs|d|_dS(Ni(Rw(RRP((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRQscCs |jgS(N(Rw(R((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRMscKs|s;|jrd|j}q;|jr;d|j}q;n|jj||j|j\}}i|d6|jr|dndd6}|j||p|j}||j d9}||j |fS(Ns %s NULLS LASTs%s NULLS FIRSTRwtDESCtASCtorderings%(expression)s( RRRRRRRwRRtcounttrstrip(RRWRLRRtexpression_sqlRt placeholders((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRXs   cCs@d}|jrd}n|jr*d}n|j||d|S(Ns3%(expression)s IS NULL, %(expression)s %(ordering)ss7%(expression)s IS NOT NULL, %(expression)s %(ordering)sR(RFRRRX(RRWRLR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyR-s     cCs@d}|jrd}n|jr*d}n|j||d|S(Ns<IF(ISNULL(%(expression)s),1,0), %(expression)s %(ordering)s s<IF(ISNULL(%(expression)s),0,1), %(expression)s %(ordering)s R(RFRRRX(RRWRLR((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pytas_mysql5s     cCs4g}x'|jD]}|j|jqW|S(N(RMRR(RRRl((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyR=scCs@|j |_|js|jr<|j |_|j |_n|S(N(RRR(R((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRCs   cCs t|_dS(N(R R(R((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRJscCs t|_dS(N(R9R(R((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRMsN(RCRDRR RIRRQRMRFRXRR#RRRR(((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyRs         ((R\Rtdjango.core.exceptionsRRtdjango.db.backendsRRttdjango.db.modelsRtdjango.db.models.query_utilsRt django.utilsRtdjango.utils.functionalRtobjectRRGRRRRRSRRRRRRRRRRRRRRRR(((s>/tmp/pip-unpacked-wheel-BAJOf3/django/db/models/expressions.pyts<  s:  R. !9P[#