
    MȂi4                        S r SSKJrJr  SSKJr  SSKJrJrJ	r	J
r
JrJrJr  SSKJrJr  SSKJr  SSKJrJr  / SQr " S	 S
\	5      r " S S\
5      r " S S\	5      r " S S\5      r " S S\\\5      r " S S\5      r " S S\5      r " S S\5      r " S S\\5      r " S S\	5      r  " S S\5      r! " S S \\5      r" " S! S"\\5      r#g#)$z>
Classes to represent the definitions of aggregate functions.
    )
FieldErrorFullResultSet)NotSupportedError)CaseColPairsFuncOrderByListStarValueWhen)IntegerField	TextField)Coalesce)FixDurationInputMixinNumericOutputFieldMixin)
	AggregateAnyValueAvgCountMaxMinStdDev	StringAggSumVariancec                   F   ^  \ rS rSrSrSrU 4S jr\S 5       rS r	Sr
U =r$ )AggregateFilter%      z FILTER (WHERE %(expressions)s)c                    > UR                   R                  (       d  [        S5      e [        TU ]  " X40 UD6$ ! [
         a     gf = f)NzDAggregate filter clauses are not supported on this database backend.)  )features supports_aggregate_filter_clauser   superas_sqlr   selfcompiler
connectionextra_context	__class__s       LD:\sksbv-state-backend\venv\Lib\site-packages\django/db/models/aggregates.pyr&   AggregateFilter.as_sql)   sM    ""CC#V 	7>(H-HH 		s   : 
AAc                      U R                   S   $ )Nr   )source_expressionsr(   s    r-   	conditionAggregateFilter.condition3   s    &&q))    c                 Z    U R                   R                  S U R                   5       5      $ )Nc              3   6   #    U H  n[        U5      v   M     g 7fN)str).0args     r-   	<genexpr>*AggregateFilter.__str__.<locals>.<genexpr>8   s     #P8OCHH8Os   )
arg_joinerjoinr0   r1   s    r-   __str__AggregateFilter.__str__7   s#    ###P8O8O#PPPr4   r"   )__name__
__module____qualname____firstlineno__aritytemplater&   propertyr2   r?   __static_attributes____classcell__r,   s   @r-   r   r   %   s2    E0H * *Q Qr4   r   c                   ,   ^  \ rS rSrSrU 4S jrSrU =r$ )AggregateOrderBy;   z ORDER BY %(expressions)sc                 r   > UR                   R                  (       d  [        S5      e[        TU ]  " X40 UD6$ )NzIThis database backend does not support specifying an order on aggregates.)r#   "supports_aggregate_order_by_clauser   r%   r&   r'   s       r-   r&   AggregateOrderBy.as_sql>   s:    ""EE# 
 w~hDmDDr4   r"   )rA   rB   rC   rD   rF   r&   rH   rI   rJ   s   @r-   rL   rL   ;   s    *HE Er4   rL   c                      ^  \ rS rSrSrSrSrSrSrSr	Sr
SSSSS.U 4S jjrU 4S jrU 4S	 jrU 4S
 jr SU 4S jjr\S 5       rS rU 4S jrU 4S jrSrU =r$ )r   H   ?%(function)s(%(distinct)s%(expressions)s%(order_by)s)%(filter)sTNF)distinctfilterdefaultorder_byc                  > U(       a3  U R                   (       d"  [        SU R                  R                  -  5      eU(       a3  U R                  (       d"  [        SU R                  R                  -  5      eUb/  U R
                  b"  [        U R                  R                   S35      eXl        Uc  S O
[        U5      U l        X0l	        [        R                  U R                  R                   S3U5      U l        [        TU ]8  " U0 UD6  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,   rA   allow_order_byempty_result_set_valuerT   r   rU   rV   rL   
from_paramrW   r%   __init__)r(   rT   rU   rV   rW   expressionsextrar,   s          r-   r^   Aggregate.__init__Q   s     D//9DNN<S<SSTTD//9DNN<S<SSTT4#>#>#Jt~~6677OPQQ $nd/&2I(33~~&&'y18
 	+//r4   c                 \   > [         TU ]  5        Vs/ sH  oR                  PM     sn$ s  snf r7   )r%   get_source_expressions_output_field_or_none)r(   er,   s     r-   get_source_fieldsAggregate.get_source_fieldsi   s+     271O1QR1QA''1QRRRs   )c                 X   > [         TU ]  5       n/ UQU R                  PU R                  P$ r7   )r%   rc   rU   rW   )r(   r0   r,   s     r-   rc    Aggregate.get_source_expressionsn   s/    "W;=@#@T[[@$--@@r4   c                 @   > UGt ol         U l        [        TU ]  U5      $ r7   )rU   rW   r%   set_source_expressions)r(   exprsr,   s     r-   rk    Aggregate.set_source_expressionsr   s!    -2*T]w-e44r4   c           
      R  > [         TU ]  XX45      nU(       aU  UR                  5        H@  nUR                  U   R                  (       d  M#  [        SUR                   SU SU S35      e   OU R                  (       d  [         [        U]#  5       n[        U5       Hs  u  pU
R                  (       d  M  U R                  5       U	   n[        US5      (       a  UR                  O
[        U5      n[        SUR                  < SU< SU< S35      e   UR                  =nc  U$ [        US5      (       a1  UR                  XX45      nUR                  c  UR                  Ul        O[!        XR                  5      nS Ul        [#        XmUR                  S9nUR                  Ul        U$ )NzCannot compute z('z'): 'z' is an aggregatenameresolve_expression)output_field)r%   rp   get_refsannotations
is_summaryr   ro   r   rc   	enumeratecontains_aggregatehasattrreprrV   rd   rq   r   r   )r(   queryallow_joinsreuse	summarizefor_savecrefr_   indexexprbefore_resolvedro   rV   coalescer,   s                  r-   rp   Aggregate.resolve_expressionv   s    G&u5Lzz|$$S)444$)!&&C5cUBST  $
   	1DFK(5***&*&A&A&CE&JO #?F;; (,,!/2 
 %664/   6 yy G)H701100UVG,,4'('>'>$G%<%<=G	AQ5L5LMllr4   c                 
   U R                  5        Vs/ sH	  oc  M  UPM     nn[        U5      S:X  aB  [        US   S5      (       a.  US   R                  < SU R                  R	                  5       < 3$ [        S5      es  snf )Nr   r   ro   __z$Complex expressions require an alias)rc   lenrw   ro   lowerrZ   )r(   r   r_   s      r-   default_aliasAggregate.default_alias   sz     "88:
:TD: 	 
 {q W[^V%D%D*1~22DIIOO4EFF>??
s
   B B c                     / $ r7   r"   r1   s    r-   get_group_by_colsAggregate.get_group_by_cols   s    	r4   c                   > U R                   (       aN  UR                  R                  (       d3  [        [        TU ]  5       5      S:  a  [        U R                   S35      eU R                   (       a  SOSnSn/ nSn/ nU R                  =n	b  UR                  U	5      u  pVU R                  b   UR                  U R                  5      u  pxUR#                  UUUS9  [        TU ]@  " X40 UD6u  pU/ UQUQUQ74$ ! [         a    U R                  5       n
S U
l
        U
R                  5       n[        U R                  R                  US   S9nU
R                  [        U5      /USS  -   5        U
R                   " X40 UD6s $ f = f)Nr   zN does not support distinct with multiple expressions on this database backend.z	DISTINCT r!   r   )then)rT   rU   rW   )rT   r#   -supports_aggregate_distinct_multiple_argumentr   r%   rc   r   ro   rW   compilerU   copyr   r2   rk   r   r&   update)r(   r)   r*   r+   distinct_sqlorder_by_sqlorder_by_params
filter_sqlfilter_paramsrW   r   r0   r2   sqlparamsr,   s                  r-   r&   Aggregate.as_sql   s   MM''UUEG2459#99+ ) * 
 '+mm{
%H2,4,<,<X,F)L;;"
J,4,<,<T[[,I)
 	!! 	 	

 gnXK]K?f?????! % J yy{"%)%@%@%B" !6!6=OPQ=RS	++T)_,=@RSTSU@V,VW{{8I=IIJs   .C: :BFFc                    > [         TU ]  5       nU R                  (       a  U R                  US'   U R                  (       a  U R                  US'   U R                  (       a  U R                  US'   U$ )NrT   rU   rW   )r%   _get_repr_optionsrT   rU   rW   )r(   optionsr,   s     r-   r   Aggregate._get_repr_options   sT    '+-=="&--GJ;; $GH=="&--GJr4   )rV   rT   rU   rW   )NTNFF)rA   rB   rC   rD   rF   rv   ro   window_compatiblerY   r[   r\   r^   rf   rc   rk   rp   rG   r   r   r&   r   rH   rI   rJ   s   @r-   r   r   H   s    PHDNN!
 0 00S
A5
 SX'R @ @'@R r4   r   c                   8   ^  \ rS rSrSrS rSrSrU 4S jrSr	U =r
$ )r      	ANY_VALUEr   Fc                 r   > UR                   R                  (       d  [        S5      e[        TU ]  " X40 UD6$ )Nz4ANY_VALUE is not supported on this database backend.)r#   supports_any_valuer   r%   r&   r'   s       r-   r&   AnyValue.as_sql   s8    ""55#F  w~hDmDDr4   r"   )rA   rB   rC   rD   functionro   rE   r   r&   rH   rI   rJ   s   @r-   r   r      s$    HDEE Er4   r   c                   $    \ rS rSrSrS rSrSrSrg)r      AVGTr   r"   N	rA   rB   rC   rD   r   ro   rY   rE   rH   r"   r4   r-   r   r          HDNEr4   r   c                   ^   ^  \ rS rSrSrS r\" 5       rSrSr	Sr
SrS	U 4S jjrU 4S jrSrU =r$ )
r      COUNTTr   r   c                    > US:X  a
  [        5       n[        U[         5      (       a  Ub  [        S5      e[        TU ]  " U4SU0UD6  g )N*z8Star cannot be used with filter. Please specify a field.rU   )r
   
isinstance
ValueErrorr%   r^   )r(   
expressionrU   r`   r,   s       r-   r^   Count.__init__   sG    Jj$''F,>WXX<F<e<r4   c                   > [         TU ]  " U0 UD6nUR                  5       n[        US   =n[        5      (       aC  U R
                  (       a  [        S5      eUR                  5       S   US'   UR                  U5        U$ )Nr   z6COUNT(DISTINCT) doesn't support composite primary keys)	r%   rp   rc   r   r   rT   r   get_colsrk   )r(   argskwargsresultr0   r   r,   s         r-   rp   Count.resolve_expression  s    +T<V<#::< 033dX>>}} L  %)MMOA$6q!))*<=r4   r"   r7   )rA   rB   rC   rD   r   ro   r   rq   rY   r\   rE   allows_composite_expressionsr^   rp   rH   rI   rJ   s   @r-   r   r      s9    HD>LNE#' = r4   r   c                        \ rS rSrSrS rSrSrg)r   i  MAXr   r"   NrA   rB   rC   rD   r   ro   rE   rH   r"   r4   r-   r   r         HDEr4   r   c                        \ rS rSrSrS rSrSrg)r   i  MINr   r"   Nr   r"   r4   r-   r   r     r   r4   r   c                   @   ^  \ rS rSrS rSrSU 4S jjrU 4S jrSrU =r	$ )r   i!  r   c                 H   > U(       a  SOSU l         [        TU ]  " U40 UD6  g )NSTDDEV_SAMP
STDDEV_POPr   r%   r^   r(   r   sampler`   r,   s       r-   r^   StdDev.__init__%  s     )/\-u-r4   c                 F   > 0 [         TU ]  5       ESU R                  S:H  0E$ )Nr   r   r%   r   r   r(   r,   s    r-   r   StdDev._get_repr_options)  s&    X%'+-Xx-9WXXr4   r   F
rA   rB   rC   rD   ro   rE   r^   r   rH   rI   rJ   s   @r-   r   r   !  s    DE.Y Yr4   r   c                   6   ^  \ rS rSrSrSrU 4S jrS rSrU =r	$ )StringAggDelimiteri-  r   z%(expressions)sc                 0   > Xl         [        TU ]	  U5        g r7   )valuer%   r^   )r(   r   r,   s     r-   r^   StringAggDelimiter.__init__1  s    
r4   c                 2    SnU R                   " UU4SU0UD6$ )Nz SEPARATOR %(expressions)srF   )r&   r(   r)   r*   r+   rF   s        r-   as_mysqlStringAggDelimiter.as_mysql5  s2    /{{
 
 	
 	
r4   )r   )
rA   rB   rC   rD   rE   rF   r^   r   rH   rI   rJ   s   @r-   r   r   -  s    E H 
 
r4   r   c                   \   ^  \ rS rSrSrSrS rSrSr\	" 5       r
U 4S jrS rS rS rS	rU =r$ )
r   i@  rS   
STRING_AGGTc                 \   > [        U5      U l        [        TU ]  " XR                  40 UD6  g r7   )r   	delimiterr%   r^   )r(   r   r   r`   r,   s       r-   r^   StringAgg.__init__H  s%    +I6^^=u=r4   c                 \    U R                   (       a  SnOSnU R                  " UU4SUS.UD6$ )NzO%(function)s(%(distinct)s%(expressions)s) WITHIN GROUP (%(order_by)s)%(filter)sz3%(function)s(%(distinct)s%(expressions)s)%(filter)sLISTAGG)r   rF   )rW   r&   r   s        r-   	as_oracleStringAgg.as_oracleL  sI    == 
 MH{{
 	

 
 	
r4   c                    SUS'   SnXCS'   U R                  5       n/ nUR                  (       a5  UR                  UR                  5      u  pvUR                  S S Ul        XsS'   UR                  " X40 UD6u  pU/ U	QUQ74$ )NGROUP_CONCATr   zB%(function)s(%(distinct)s%(expressions)s%(order_by)s%(delimiter)s)rF   r   )r   r   r   r0   r&   )
r(   r)   r*   r+   rF   r~   delimiter_paramsdelimiter_sqlr   r   s
             r-   r   StringAgg.as_mysql]  s    $2j!W$,j!IIK
 ;;.6.>.>q{{.K+M#$#7#7#<A )6+&hhxE}E0f0/000r4   c                 |    UR                  5       S:  a  U R                  " UU4SS0UD6$ U R                  " X40 UD6$ )N)   ,   r   r   )get_database_versionr&   )r(   r)   r*   r+   s       r-   	as_sqliteStringAgg.as_sqlites  sT    **,w6;; (  	  {{8A=AAr4   )r   )rA   rB   rC   rD   rF   r   ro   rY   r[   r   rq   r^   r   r   r   rH   rI   rJ   s   @r-   r   r   @  s>    PHHDNN;L>
"1,	B 	Br4   r   c                   $    \ rS rSrSrS rSrSrSrg)r   i  SUMTr   r"   Nr   r"   r4   r-   r   r     r   r4   r   c                   @   ^  \ rS rSrS rSrSU 4S jjrU 4S jrSrU =r	$ )r   i  r   c                 H   > U(       a  SOSU l         [        TU ]  " U40 UD6  g )NVAR_SAMPVAR_POPr   r   s       r-   r^   Variance.__init__  s     &,
)-u-r4   c                 F   > 0 [         TU ]  5       ESU R                  S:H  0E$ )Nr   r   r   r   s    r-   r   Variance._get_repr_options  s&    U%'+-Ux*9TUUr4   r   r   r   rJ   s   @r-   r   r     s    DE.V Vr4   r   N)$__doc__django.core.exceptionsr   r   	django.dbr   django.db.models.expressionsr   r   r   r	   r
   r   r   django.db.models.fieldsr   r   django.db.models.functionsr   !django.db.models.functions.mixinsr   r   __all__r   rL   r   r   r   r   r   r   r   r   r   r   r   r"   r4   r-   <module>r     s    = '   < /
Qd Q,
E{ 
ET TnEy E
!8) I B) ) 	Y$i 	Y
 
&<B	 <B~
 	V&	 	Vr4   