Ë
    ^QêjH  ã                  ó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© ó    úU/home/oem/CyberBrain26-unified/.venv/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Ñ2¨6Ó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Ñ6¨vÓ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Ñ4¨VÓ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Ñ3¨FÓ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   