
    2i                     8   S 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. S/\5      r " S0 S1\5      rg2)3z-
Package for SQL analytic functions wrappers
    )AnalyticFunctionWindowFrameAnalyticFunctionIgnoreNullsAnalyticFunctionz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
       J/home/james-whalen/.local/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                 .   > [         [        U ]
  " S0 UD6  g )N)RANK)superr   __init__selfkwargs	__class__s     r   r   Rank.__init__   s    dD"4V4r   r
   r   r   r   r   r   r   __classcell__r#   s   @r   r   r      s    5 5r   r   c                   (   ^  \ rS rSrU 4S jrSrU =r$ )	DenseRank   c                 .   > [         [        U ]
  " S0 UD6  g )N)
DENSE_RANK)r   r)   r   r    s     r   r   DenseRank.__init__       i'??r   r
   r%   r'   s   @r   r)   r)          @ @r   r)   c                   (   ^  \ rS rSrU 4S jrSrU =r$ )	RowNumber#   c                 .   > [         [        U ]
  " S0 UD6  g )N)
ROW_NUMBER)r   r1   r   r    s     r   r   RowNumber.__init__$   r.   r   r
   r%   r'   s   @r   r1   r1   #   r/   r   r1   c                   (   ^  \ rS rSrU 4S jrSrU =r$ )NTile(   c                 2   > [         [        U ]
  " SU40 UD6  g )NNTILE)r   r7   r   r!   termr"   r#   s      r   r   NTile.__init__)       eT#GT<V<r   r
   r%   r'   s   @r   r7   r7   (       = =r   r7   c                   (   ^  \ rS rSrU 4S jrSrU =r$ )
FirstValue-   c                 6   > [         [        U ]
  " S/UQ70 UD6  g )NFIRST_VALUE)r   rA   r   r!   termsr"   r#   s      r   r   FirstValue.__init__.   s    j$(II&Ir   r
   r%   r'   s   @r   rA   rA   -   s    J Jr   rA   c                   (   ^  \ rS rSrU 4S jrSrU =r$ )	LastValue2   c                 6   > [         [        U ]
  " S/UQ70 UD6  g )N
LAST_VALUE)r   rI   r   rE   s      r   r   LastValue.__init__3   s    i'GuGGr   r
   r%   r'   s   @r   rI   rI   2       H Hr   rI   c                   (   ^  \ rS rSrU 4S jrSrU =r$ )Median7   c                 2   > [         [        U ]
  " SU40 UD6  g )NMEDIAN)r   rP   r   r;   s      r   r   Median.__init__8       fd$Xt>v>r   r
   r%   r'   s   @r   rP   rP   7       ? ?r   rP   c                   (   ^  \ rS rSrU 4S jrSrU =r$ )Avg<   c                 2   > [         [        U ]
  " SU40 UD6  g )NAVG)r   rX   r   r;   s      r   r   Avg.__init__=       c4!%88r   r
   r%   r'   s   @r   rX   rX   <       9 9r   rX   c                   (   ^  \ rS rSrU 4S jrSrU =r$ )StdDevA   c                 2   > [         [        U ]
  " SU40 UD6  g )NSTDDEV)r   r`   r   r;   s      r   r   StdDev.__init__B   rU   r   r
   r%   r'   s   @r   r`   r`   A   rV   r   r`   c                   (   ^  \ rS rSrU 4S jrSrU =r$ )	StdDevPopF   c                 2   > [         [        U ]
  " SU40 UD6  g )N
STDDEV_POP)r   rf   r   r;   s      r   r   StdDevPop.__init__G   s    i'dEfEr   r
   r%   r'   s   @r   rf   rf   F   s    F Fr   rf   c                   (   ^  \ rS rSrU 4S jrSrU =r$ )
StdDevSampK   c                 2   > [         [        U ]
  " SU40 UD6  g )NSTDDEV_SAMP)r   rl   r   r;   s      r   r   StdDevSamp.__init__L   s    j$(GGr   r
   r%   r'   s   @r   rl   rl   K   rN   r   rl   c                   (   ^  \ rS rSrU 4S jrSrU =r$ )VarianceP   c                 2   > [         [        U ]
  " SU40 UD6  g )NVARIANCE)r   rr   r   r;   s      r   r   Variance.__init__Q   s    h&z4B6Br   r
   r%   r'   s   @r   rr   rr   P   s    C Cr   rr   c                   (   ^  \ rS rSrU 4S jrSrU =r$ )VarPopU   c                 2   > [         [        U ]
  " SU40 UD6  g )NVAR_POP)r   rx   r   r;   s      r   r   VarPop.__init__V   s    fd$Y??r   r
   r%   r'   s   @r   rx   rx   U   r/   r   rx   c                   (   ^  \ rS rSrU 4S jrSrU =r$ )VarSampZ   c                 2   > [         [        U ]
  " SU40 UD6  g )NVAR_SAMP)r   r~   r   r;   s      r   r   VarSamp.__init__[   s    gt%j$A&Ar   r
   r%   r'   s   @r   r~   r~   Z   s    B Br   r~   c                   (   ^  \ rS rSrU 4S jrSrU =r$ )Count_   c                 2   > [         [        U ]
  " SU40 UD6  g )NCOUNT)r   r   r   r;   s      r   r   Count.__init__`   r>   r   r
   r%   r'   s   @r   r   r   _   r?   r   r   c                   (   ^  \ rS rSrU 4S jrSrU =r$ )Sumd   c                 2   > [         [        U ]
  " SU40 UD6  g )NSUM)r   r   r   r;   s      r   r   Sum.__init__e   r]   r   r
   r%   r'   s   @r   r   r   d   r^   r   r   c                   (   ^  \ rS rSrU 4S jrSrU =r$ )Maxi   c                 2   > [         [        U ]
  " SU40 UD6  g )NMAX)r   r   r   r;   s      r   r   Max.__init__j   r]   r   r
   r%   r'   s   @r   r   r   i   r^   r   r   c                   (   ^  \ rS rSrU 4S jrSrU =r$ )Minn   c                 2   > [         [        U ]
  " SU40 UD6  g )NMIN)r   r   r   r;   s      r   r   Min.__init__o   r]   r   r
   r%   r'   s   @r   r   r   n   r^   r   r   c                   (   ^  \ rS rSrU 4S jrSrU =r$ )Lags   c                 6   > [         [        U ]
  " S/UQ70 UD6  g )NLAG)r   r   r   r!   argsr"   r#   s      r   r   Lag.__init__t   s    c4!%9$9&9r   r
   r%   r'   s   @r   r   r   s   s    : :r   r   c                   (   ^  \ rS rSrU 4S jrSrU =r$ )Leadx   c                 6   > [         [        U ]
  " S/UQ70 UD6  g )NLEAD)r   r   r   r   s      r   r   Lead.__init__y   s    dD"6;D;F;r   r
   r%   r'   s   @r   r   r   x   s    < <r   r   N)__doc__pypika.termsr   r   r   
__author__	__email__Edger   r   CURRENT_ROWr   r)   r1   r7   rA   rI   rP   rX   r`   rf   rl   rr   rx   r~   r   r   r   r   r   r   r
   r   r   <module>r      si    
	+00 +00  5 5
@  @
@  @
= =
J,.I J
H+-H H
? ?
9
% 9
?( ?
F+ F
H, H
C* C
@( @
B) B
=' =
9
% 9
9
% 9
9
% 9
:
 :
< <r   