jC<SrSSKJrJr SSKJr SSKJrJrJ r J r J r J r J r SSKJrJr SSKJr SSKJrJr /SQr"S S \ 5r"S S \ 5r"S S\ 5r"SS\5r"SS\\\5r"SS\5r"SS\5r"SS\5r"SS\5r"SS\5r "SS\5r!"SS \5r""S!S"\\5r#"S#S$\ 5r$"S%S&\5r%"S'S(\\5r&"S)S*\\5r'g+),z> Classes to represent the definitions of aggregate functions. ) FieldError FullResultSet)NotSupportedError)CaseColPairsFunc OrderByListStarValueWhen) IntegerField TextField)Coalesce)FixDurationInputMixinNumericOutputFieldMixin) AggregateAnyValueAvgBitAndBitOrBitXorCountMaxMinStdDev StringAggSumVariancecF^\rSrSrSrSrU4Sjr\S5rSr Sr U=r $)AggregateFilter(z FILTER (WHERE %(expressions)s)c >URR(d [S5e[TU]"X40UD6$![ a gf=f)NzDAggregate filter clauses are not supported on this database backend.))features supports_aggregate_filter_clausersuperas_sqlrselfcompiler connection extra_context __class__s S/var/www/html/KUNJ/venv/lib/python3.13/site-packages/django/db/models/aggregates.pyr)AggregateFilter.as_sql,sM""CC#V  7>(H-H H  s: AAc URS$)Nr)source_expressionsr+s r0 conditionAggregateFilter.condition6s&&q))cZURRSUR55$)Nc38# UHn[U5v M g7fN)str).0args r0 *AggregateFilter.__str__..;s#P8OCHH8Os) arg_joinerjoinr3r4s r0__str__AggregateFilter.__str__:s####P8O8O#PPPr7r%) __name__ __module__ __qualname____firstlineno__aritytemplater)propertyr5rB__static_attributes__ __classcell__r/s@r0r r (s2 E0H**QQr7r c,^\rSrSrSrU4SjrSrU=r$)AggregateOrderBy>z ORDER BY %(expressions)sc r>URR(d [S5e[TU]"X40UD6$)NzIThis database backend does not support specifying an order on aggregates.)r&"supports_aggregate_order_by_clauserr(r)r*s r0r)AggregateOrderBy.as_sqlAs:""EE#  w~hDmDDr7r%)rDrErFrGrIr)rKrLrMs@r0rOrO>s*HEEr7rOc^\rSrSrSrSrSrSrSrSr Sr SSSSS.U4Sjjr U4Sjr U4S jr U4S jrSU4S jjr\S 5rS rU4SjrU4SjrSrU=r$)rK?%(function)s(%(distinct)s%(expressions)s%(order_by)s)%(filter)sTNF)distinctfilterdefaultorder_byc>U(a3UR(d"[SURR-5eU(a3UR(d"[SURR-5eUb/UR b"[URRS35eXlUcSO [U5UlX0l [RURRS3U5Ul [TU]8"U0UD6 g)Nz%s does not allow distinct.z%s does not allow order_by.z does not allow default.z .order_by)allow_distinct TypeErrorr/rDallow_order_byempty_result_set_valuerWr rXrYrO from_paramrZr(__init__)r+rWrXrYrZ expressionsextrar/s r0raAggregate.__init__Ts D//9DNN#>#Jt~~6677OPQ Q $nd/&2I  (33~~&&'y 18   +//r7c^>[TU]5Vs/sHoRPM sn$s snfr:)r(get_source_expressions_output_field_or_none)r+er/s r0get_source_fieldsAggregate.get_source_fieldsls+271O1QR1QA''1QRRRs*cX>[TU]5n/UQURPURP$r:)r(rfrXrZ)r+r3r/s r0rf Aggregate.get_source_expressionsqs/"W;=@#@T[[@$--@@r7c@>UGtolUl[TU] U5$r:)rXrZr(set_source_expressions)r+exprsr/s r0rn Aggregate.set_source_expressionsus!-2* T]w-e44r7c R>[TU]XX45nU(aUUR5H@nURUR(dM#[ SUR SUSUS35e OUR(d[[U]#5n[U5HsupU R(dMUR5U n [U S5(a U R O [U 5n [ SUR <SU <SU <S35e UR=n cU$[U S5(a1U RXX45n U RcURU lO[!XR5n SUl [#XmURS9nURUlU$)NzCannot compute z('z'): 'z' is an aggregatenameresolve_expression) output_field)r(rsget_refs annotations is_summaryrrrrrf enumeratecontains_aggregatehasattrreprrYrgrtr r)r+query allow_joinsreuse summarizefor_savecrefrbindexexprbefore_resolvedrrrYcoalescer/s r0rsAggregate.resolve_expressionys G &u5 L zz|$$S)444$)!&&C5cUBST$  1DFK(5 ***&*&A&A&CE&JO#?F;;(,,!/2 %664/ 6yy G )H 70 1 100UVG,,4'('>'>$G%<%<=G AQ5L5LMllr7c UR5Vs/sH ocMUPM nn[U5S:XaB[USS5(a.USR<SURR 5<3$[ S5es snf)Nr"rrr__z$Complex expressions require an alias)rflenrzrrlowerr])r+rrbs r0 default_aliasAggregate.default_aliassz"88: :TD:   { q W[^V%D%D*1~22DIIOO4EF F>??  s BBc/$r:r%r4s r0get_group_by_colsAggregate.get_group_by_colss r7c >UR(aNURR(d3[[TU]55S:a[ URS35eUR(aSOSnSn/nSn/nUR=n bURU 5upVURbURUR5upxUR#UUUS9 [TU]@"X40UD6upU /UQUQUQ74$![ a UR5n SU l U R 5n [URRU SS9n U R[U 5/U SS-5 U R "X40UD6s$f=f)Nr"zN does not support distinct with multiple expressions on this database backend.z DISTINCT r$r)then)rWrXrZ)rWr&-supports_aggregate_distinct_multiple_argumentrr(rfrrrrZcompilerXcopyr r5rnrr)update)r+r,r-r. distinct_sql order_by_sqlorder_by_params filter_sql filter_paramsrZrr3r5sqlparamsr/s r0r)Aggregate.as_sqls MM''UUEG2459#99+)*  '+mm{     %H 2,4,<,[TU]5nUR(aURUS'UR(aURUS'UR(aURUS'U$)NrWrXrZ)r(_get_repr_optionsrWrXrZ)r+optionsr/s r0rAggregate._get_repr_optionssT'+- =="&--GJ  ;; $ GH  =="&--GJ r7)rYrWrXrZ)NTNFF)rDrErFrGrIryrrwindow_compatibler\r^r_rarirfrnrsrJrrr)rrKrLrMs@r0rrKsPH DNN!  000S A5 SX'R@@'@Rr7rc8^\rSrSrSrSrSrSrU4SjrSr U=r $)r ANY_VALUEr"Fc r>URR(d [S5e[TU]"X40UD6$)Nz4ANY_VALUE is not supported on this database backend.)r&supports_any_valuerr(r)r*s r0r)AnyValue.as_sqls8""55#F w~hDmDDr7r%) rDrErFrGfunctionrrrHrr)rKrLrMs@r0rrs$H D EEEr7rc$\rSrSrSrSrSrSrSrg)rAVGTr"r%N rDrErFrGrrrr\rHrKr%r7r0rrH DN Er7rc>^\rSrSrSrU4SjrU4SjrSrSrU=r $) BitAggregater"c N>[TU]"U40UD6 URSLUlgr:)r(rarY _has_default)r+ expressionrcr/s r0raBitAggregate.__init__s( -u-!LL4r7c H>URR(d%[URSURS35eUR (a@URR (d%[URSURS35e[TU] "X40UD6$)Nz is not supported on .z+ does not support the default parameter on ) r&supports_bit_aggregationsrrrvendorr$supports_default_in_bit_aggregationsr(r)r*s r0r)BitAggregate.as_sqls""<<#99+2:3D3D2EQG    ''LL#99+H$$%Q( w~hDmDDr7c HUR"UU4SURS30UD6$)Nr_AGG)r)r)r+r,r-r.s r0 as_oracleBitAggregate.as_oracles8{{    d+    r7)r) rDrErFrGrHrar)rrKrLrMs@r0rrs E5 E  r7rc\rSrSrSrSrSrg)riBIT_ANDr%NrDrErFrGrrrrKr%r7r0rr H Dr7rc\rSrSrSrSrSrg)riBIT_ORr%Nrr%r7r0rrs H Dr7rc\rSrSrSrSrSrg)ri"BIT_XORr%Nrr%r7r0rr"rr7rc^^\rSrSrSrSr\"5rSrSr Sr Sr S U4Sjjr U4Sjr SrU=r$) ri'COUNTTrr"c >US:Xa [5n[U[5(aUb [S5e[TU]"U4SU0UD6 g)N*z8Star cannot be used with filter. Please specify a field.rX)r isinstance ValueErrorr(ra)r+rrXrcr/s r0raCount.__init__0sG  J j$ ' 'F,>WX X [TU]"U0UD6nUR5n[US=n[5(aCUR (a [ S5eUR5SUS'URU5 U$)Nrz6COUNT(DISTINCT) doesn't support composite primary keys) r(rsrfrrrWrget_colsrn)r+argskwargsresultr3rr/s r0rsCount.resolve_expression7s+T >}} L%)MMOA$6 q !  ) )*< = r7r%r:)rDrErFrGrrrr rtr\r_rHallows_composite_expressionsrarsrKrLrMs@r0rr's9H D>LN E#' =r7rc \rSrSrSrSrSrSrg)riHMAXr"r%NrDrErFrGrrrrHrKr%r7r0rrHH D Er7rc \rSrSrSrSrSrSrg)riNMINr"r%Nrr%r7r0rrNrr7rc@^\rSrSrSrSrSU4SjjrU4SjrSrU=r $)riTr"c H>U(aSOSUl[TU]"U40UD6 g)N STDDEV_SAMP STDDEV_POPrr(rar+rsamplercr/s r0raStdDev.__init__Xs )/ \  -u-r7cF>0[TU]5ESURS:H0E$)Nrrr(rrr+r/s r0rStdDev._get_repr_options\s&X%'+-Xx-9WXXr7rF rDrErFrGrrrHrarrKrLrMs@r0rrTs D E.YYr7rc6^\rSrSrSrSrU4SjrSrSrU=r $)StringAggDelimiteri`r"z%(expressions)sc0>Xl[TU] U5 gr:)valuer(ra)r+rr/s r0raStringAggDelimiter.__init__ds  r7c 2SnUR"UU4SU0UD6$)Nz SEPARATOR %(expressions)srI)r)r+r,r-r.rIs r0as_mysqlStringAggDelimiter.as_mysqlhs2/{{       r7)r) rDrErFrGrHrIrarrKrLrMs@r0rr`s E H   r7rc\^\rSrSrSrSrSrSrSr\ "5r U4Sjr Sr Sr SrS rU=r$) risrV STRING_AGGTc \>[U5Ul[TU] "XR40UD6 gr:)r delimiterr(ra)r+rrrcr/s r0raStringAgg.__init__{s%+I6 ^^=u=r7c \UR(aSnOSnUR"UU4SUS.UD6$)NzO%(function)s(%(distinct)s%(expressions)s) WITHIN GROUP (%(order_by)s)%(filter)sz3%(function)s(%(distinct)s%(expressions)s)%(filter)sLISTAGG)rrI)rZr)rs r0rStringAgg.as_oraclesI ==  MH{{        r7c SUS'SnXCS'UR5n/nUR(a5URUR5upvURSSUlXsS'UR"X40UD6upU/U QUQ74$)N GROUP_CONCATrzB%(function)s(%(distinct)s%(expressions)s%(order_by)s%(delimiter)s)rIr)rrrr3r)) r+r,r-r.rIrdelimiter_params delimiter_sqlrrs r0rStringAgg.as_mysqls$2 j!W$,j! IIK  ;;.6.>.>q{{.K +M#$#7#7#>//77$$**c1IIKE!&!=!=!?   ( ("2A&);AB)?? <<(    * * ,w 6;;(  {{8A=AAr7)r)rDrErFrGrIrrrr\r^rrtrarrr rKrLrMs@r0rrss>PHH DNN;L> "1,BBr7rc$\rSrSrSrSrSrSrSrg)riSUMTr"r%Nrr%r7r0rrrr7rc@^\rSrSrSrSrSU4SjjrU4SjrSrU=r $)rir"c H>U(aSOSUl[TU]"U40UD6 g)NVAR_SAMPVAR_POPrrs r0raVariance.__init__s &, )  -u-r7cF>0[TU]5ESURS:H0E$)Nrrrrs r0rVariance._get_repr_optionss&U%'+-Ux*9TUUr7rrrrMs@r0rrs D E.VVr7rN)(__doc__django.core.exceptionsrr django.dbrdjango.db.models.expressionsrrrr r r r django.db.models.fieldsr rdjango.db.models.functionsr!django.db.models.functions.mixinsrr__all__r rOrrrrrrrrrrrrrrrr%r7r0rs$='</  "QdQ, E{ ETTn Ey E !8) 9 B\ L \ IB) ) Y $i Y  &NB NBb  V& Vr7