
    JiH                    D   S r SSKJr  SSKJrJrJr  SrSr " S S\R                  5      r
 " S S	\R                  5      rS
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 " S% S&\5      r " S' S(\5      r " S) S*\5      r " S+ S,\5      r " S- S.\5      r " S/ S0\5      r " S1 S2\5      r g3)4z-
Package for SQL analytic functions wrappers
    )annotations)AnalyticFunctionIgnoreNullsAnalyticFunctionWindowFrameAnalyticFunctionzTimothy Heysztheys@kayak.comc                      \ rS rSrSrSrg)	Preceding   	PRECEDING N__name__
__module____qualname____firstlineno__modifier__static_attributes__r       R/var/www/html/dynamic-report/venv/lib/python3.13/site-packages/pypika/analytics.pyr   r          Hr   r   c                      \ rS rSrSrSrg)	Following   	FOLLOWINGr   Nr   r   r   r   r   r      r   r   r   zCURRENT ROWc                  (   ^  \ rS rSrU 4S jrSrU =r$ )Rank   c                &   > [         TU ]  " S0 UD6  g )N)RANKsuper__init__selfkwargs	__class__s     r   r!   Rank.__init__   s    *6*r   r   r   r   r   r   r!   r   __classcell__r%   s   @r   r   r      s    + +r   r   c                  (   ^  \ rS rSrU 4S jrSrU =r$ )	DenseRank!   c                &   > [         TU ]  " S0 UD6  g )N)
DENSE_RANKr   r"   s     r   r!   DenseRank.__init__"       00r   r   r'   r)   s   @r   r+   r+   !       1 1r   r+   c                  (   ^  \ rS rSrU 4S jrSrU =r$ )	RowNumber&   c                &   > [         TU ]  " S0 UD6  g )N)
ROW_NUMBERr   r"   s     r   r!   RowNumber.__init__'   r0   r   r   r'   r)   s   @r   r3   r3   &   r1   r   r3   c                  (   ^  \ rS rSrU 4S jrSrU =r$ )NTile+   c                *   > [         TU ]  " SU40 UD6  g )NNTILEr   r#   termr$   r%   s      r   r!   NTile.__init__,       $1&1r   r   r'   r)   s   @r   r9   r9   +       2 2r   r9   c                  (   ^  \ rS rSrU 4S jrSrU =r$ )
FirstValue0   c                .   > [         TU ]  " S/UQ70 UD6  g )NFIRST_VALUEr   r#   termsr$   r%   s      r   r!   FirstValue.__init__1   s    99&9r   r   r'   r)   s   @r   rC   rC   0   s    : :r   rC   c                  (   ^  \ rS rSrU 4S jrSrU =r$ )	LastValue5   c                .   > [         TU ]  " S/UQ70 UD6  g )N
LAST_VALUEr   rG   s      r   r!   LastValue.__init__6   s    888r   r   r'   r)   s   @r   rK   rK   5   s    9 9r   rK   c                  (   ^  \ rS rSrU 4S jrSrU =r$ )Median:   c                *   > [         TU ]  " SU40 UD6  g )NMEDIANr   r=   s      r   r!   Median.__init__;       4262r   r   r'   r)   s   @r   rQ   rQ   :       3 3r   rQ   c                  (   ^  \ rS rSrU 4S jrSrU =r$ )Avg?   c                *   > [         TU ]  " SU40 UD6  g )NAVGr   r=   s      r   r!   Avg.__init__@       //r   r   r'   r)   s   @r   rY   rY   ?       0 0r   rY   c                  (   ^  \ rS rSrU 4S jrSrU =r$ )StdDevD   c                *   > [         TU ]  " SU40 UD6  g )NSTDDEVr   r=   s      r   r!   StdDev.__init__E   rV   r   r   r'   r)   s   @r   ra   ra   D   rW   r   ra   c                  (   ^  \ rS rSrU 4S jrSrU =r$ )	StdDevPopI   c                *   > [         TU ]  " SU40 UD6  g )N
STDDEV_POPr   r=   s      r   r!   StdDevPop.__init__J   s    t6v6r   r   r'   r)   s   @r   rg   rg   I   s    7 7r   rg   c                  (   ^  \ rS rSrU 4S jrSrU =r$ )
StdDevSampN   c                *   > [         TU ]  " SU40 UD6  g )NSTDDEV_SAMPr   r=   s      r   r!   StdDevSamp.__init__O   s    77r   r   r'   r)   s   @r   rm   rm   N   s    8 8r   rm   c                  (   ^  \ rS rSrU 4S jrSrU =r$ )VarianceS   c                *   > [         TU ]  " SU40 UD6  g )NVARIANCEr   r=   s      r   r!   Variance.__init__T       T4V4r   r   r'   r)   s   @r   rs   rs   S       5 5r   rs   c                  (   ^  \ rS rSrU 4S jrSrU =r$ )VarPopX   c                *   > [         TU ]  " SU40 UD6  g )NVAR_POPr   r=   s      r   r!   VarPop.__init__Y   s    D3F3r   r   r'   r)   s   @r   r{   r{   X   s    4 4r   r{   c                  (   ^  \ rS rSrU 4S jrSrU =r$ )VarSamp]   c                *   > [         TU ]  " SU40 UD6  g )NVAR_SAMPr   r=   s      r   r!   VarSamp.__init__^   rx   r   r   r'   r)   s   @r   r   r   ]   ry   r   r   c                  (   ^  \ rS rSrU 4S jrSrU =r$ )Countb   c                *   > [         TU ]  " SU40 UD6  g )NCOUNTr   r=   s      r   r!   Count.__init__c   r@   r   r   r'   r)   s   @r   r   r   b   rA   r   r   c                  (   ^  \ rS rSrU 4S jrSrU =r$ )Sumg   c                *   > [         TU ]  " SU40 UD6  g )NSUMr   r=   s      r   r!   Sum.__init__h   r^   r   r   r'   r)   s   @r   r   r   g   r_   r   r   c                  (   ^  \ rS rSrU 4S jrSrU =r$ )Maxl   c                *   > [         TU ]  " SU40 UD6  g )NMAXr   r=   s      r   r!   Max.__init__m   r^   r   r   r'   r)   s   @r   r   r   l   r_   r   r   c                  (   ^  \ rS rSrU 4S jrSrU =r$ )Minq   c                *   > [         TU ]  " SU40 UD6  g )NMINr   r=   s      r   r!   Min.__init__r   r^   r   r   r'   r)   s   @r   r   r   q   r_   r   r   c                  (   ^  \ rS rSrU 4S jrSrU =r$ )Lagv   c                .   > [         TU ]  " S/UQ70 UD6  g )NLAGr   r#   argsr$   r%   s      r   r!   Lag.__init__w   s    000r   r   r'   r)   s   @r   r   r   v   r1   r   r   c                  (   ^  \ rS rSrU 4S jrSrU =r$ )Lead{   c                .   > [         TU ]  " S/UQ70 UD6  g )NLEADr   r   s      r   r!   Lead.__init__|   s    1$1&1r   r   r'   r)   s   @r   r   r   {   rA   r   r   N)!__doc__
__future__r   pypika.termsr   r   r   
__author__	__email__Edger   r   CURRENT_ROWr   r+   r3   r9   rC   rK   rQ   rY   ra   rg   rm   rs   r{   r   r   r   r   r   r   r   r   r   r   <module>r      s\   #  
	+00 +00  + +
1  1
1  1
2 2
:,.I :
9+-H 9
3 3
0
% 0
3( 3
7+ 7
8, 8
5* 5
4( 4
5) 5
2' 2
0
% 0
0
% 0
0
% 0
1
 1
2 2r   