
    WiH                    D   d Z ddlmZ ddlmZmZmZ dZdZ G d dej                        Z
 G d d	ej                        Zd
Z G d de      Z G d de      Z G d de      Z G d de      Z G d dee      Z G d dee      Z G d de      Z G d de      Z G d de      Z G d de      Z G d d e      Z G d! d"e      Z G d# d$e      Z G d% d&e      Z G d' d(e      Z G d) d*e      Z G d+ d,e      Z G d- d.e      Z G d/ d0e      Z G d1 d2e      Z y3)4z-
Package for SQL analytic functions wrappers
    )annotations)AnalyticFunctionIgnoreNullsAnalyticFunctionWindowFrameAnalyticFunctionzTimothy Heysztheys@kayak.comc                      e Zd ZdZy)	Preceding	PRECEDINGN__name__
__module____qualname__modifier     Z/home/obispo/Crisostomo_bridge/mision_env/lib/python3.12/site-packages/pypika/analytics.pyr   r          Hr   r   c                      e Zd ZdZy)	Following	FOLLOWINGNr
   r   r   r   r   r      r   r   r   zCURRENT ROWc                       e Zd Z fdZ xZS )Rankc                $    t        |   di | y )N)RANKsuper__init__selfkwargs	__class__s     r   r   zRank.__init__   s    *6*r   r   r   r   r   __classcell__r    s   @r   r   r      s    + +r   r   c                       e Zd Z fdZ xZS )	DenseRankc                $    t        |   di | y )N)
DENSE_RANKr   r   s     r   r   zDenseRank.__init__"       00r   r!   r#   s   @r   r%   r%   !       1 1r   r%   c                       e Zd Z fdZ xZS )	RowNumberc                $    t        |   di | y )N)
ROW_NUMBERr   r   s     r   r   zRowNumber.__init__'   r(   r   r!   r#   s   @r   r+   r+   &   r)   r   r+   c                       e Zd Z fdZ xZS )NTilec                (    t        |   d|fi | y )NNTILEr   r   termr   r    s      r   r   zNTile.__init__,       $1&1r   r!   r#   s   @r   r/   r/   +       2 2r   r/   c                       e Zd Z fdZ xZS )
FirstValuec                ,    t        |   dg|i | y )NFIRST_VALUEr   r   termsr   r    s      r   r   zFirstValue.__init__1   s    99&9r   r!   r#   s   @r   r7   r7   0   s    : :r   r7   c                       e Zd Z fdZ xZS )	LastValuec                ,    t        |   dg|i | y )N
LAST_VALUEr   r:   s      r   r   zLastValue.__init__6   s    888r   r!   r#   s   @r   r=   r=   5   s    9 9r   r=   c                       e Zd Z fdZ xZS )Medianc                (    t        |   d|fi | y )NMEDIANr   r2   s      r   r   zMedian.__init__;       4262r   r!   r#   s   @r   rA   rA   :       3 3r   rA   c                       e Zd Z fdZ xZS )Avgc                (    t        |   d|fi | y )NAVGr   r2   s      r   r   zAvg.__init__@       //r   r!   r#   s   @r   rG   rG   ?       0 0r   rG   c                       e Zd Z fdZ xZS )StdDevc                (    t        |   d|fi | y )NSTDDEVr   r2   s      r   r   zStdDev.__init__E   rD   r   r!   r#   s   @r   rM   rM   D   rE   r   rM   c                       e Zd Z fdZ xZS )	StdDevPopc                (    t        |   d|fi | y )N
STDDEV_POPr   r2   s      r   r   zStdDevPop.__init__J   s    t6v6r   r!   r#   s   @r   rQ   rQ   I   s    7 7r   rQ   c                       e Zd Z fdZ xZS )
StdDevSampc                (    t        |   d|fi | y )NSTDDEV_SAMPr   r2   s      r   r   zStdDevSamp.__init__O   s    77r   r!   r#   s   @r   rU   rU   N   s    8 8r   rU   c                       e Zd Z fdZ xZS )Variancec                (    t        |   d|fi | y )NVARIANCEr   r2   s      r   r   zVariance.__init__T       T4V4r   r!   r#   s   @r   rY   rY   S       5 5r   rY   c                       e Zd Z fdZ xZS )VarPopc                (    t        |   d|fi | y )NVAR_POPr   r2   s      r   r   zVarPop.__init__Y   s    D3F3r   r!   r#   s   @r   r_   r_   X   s    4 4r   r_   c                       e Zd Z fdZ xZS )VarSampc                (    t        |   d|fi | y )NVAR_SAMPr   r2   s      r   r   zVarSamp.__init__^   r\   r   r!   r#   s   @r   rc   rc   ]   r]   r   rc   c                       e Zd Z fdZ xZS )Countc                (    t        |   d|fi | y )NCOUNTr   r2   s      r   r   zCount.__init__c   r4   r   r!   r#   s   @r   rg   rg   b   r5   r   rg   c                       e Zd Z fdZ xZS )Sumc                (    t        |   d|fi | y )NSUMr   r2   s      r   r   zSum.__init__h   rJ   r   r!   r#   s   @r   rk   rk   g   rK   r   rk   c                       e Zd Z fdZ xZS )Maxc                (    t        |   d|fi | y )NMAXr   r2   s      r   r   zMax.__init__m   rJ   r   r!   r#   s   @r   ro   ro   l   rK   r   ro   c                       e Zd Z fdZ xZS )Minc                (    t        |   d|fi | y )NMINr   r2   s      r   r   zMin.__init__r   rJ   r   r!   r#   s   @r   rs   rs   q   rK   r   rs   c                       e Zd Z fdZ xZS )Lagc                ,    t        |   dg|i | y )NLAGr   r   argsr   r    s      r   r   zLag.__init__w   s    000r   r!   r#   s   @r   rw   rw   v   r)   r   rw   c                       e Zd Z fdZ xZS )Leadc                ,    t        |   dg|i | y )NLEADr   rz   s      r   r   zLead.__init__|   s    1$1&1r   r!   r#   s   @r   r}   r}   {   r5   r   r}   N)!__doc__
__future__r   pypika.termsr   r   r   
__author__	__email__Edger   r   CURRENT_ROWr   r%   r+   r/   r7   r=   rA   rG   rM   rQ   rU   rY   r_   rc   rg   rk   ro   rs   rw   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   