o
    ÏÉviH  ã                   @  sœ  d Z ddlmZ ddlmZmZmZ dZdZG dd„ dej	ƒZ
G dd	„ d	ej	ƒZd
ZG dd„ deƒZG dd„ deƒZG dd„ deƒZG dd„ deƒZG dd„ deeƒZG dd„ deeƒZG dd„ deƒZG dd„ deƒZG dd„ deƒZG dd„ deƒZG dd „ d eƒZG d!d"„ d"eƒZG d#d$„ d$eƒZG d%d&„ d&eƒZG d'd(„ d(eƒZG d)d*„ d*eƒZG d+d,„ d,eƒZG d-d.„ d.eƒZG d/d0„ d0eƒZG d1d2„ d2eƒZ d3S )4z-
Package for SQL analytic functions wrappers
é    )Úannotations)ÚAnalyticFunctionÚIgnoreNullsAnalyticFunctionÚWindowFrameAnalyticFunctionzTimothy Heysztheys@kayak.comc                   @  ó   e Zd ZdZdS )Ú	PrecedingÚ	PRECEDINGN©Ú__name__Ú
__module__Ú__qualname__Úmodifier© r   r   úO/home/air/biblejyuku/back/venv/lib/python3.10/site-packages/pypika/analytics.pyr      ó    r   c                   @  r   )Ú	FollowingÚ	FOLLOWINGNr	   r   r   r   r   r      r   r   zCURRENT ROWc                      ó   e Zd Z‡ fdd„Z‡  ZS )ÚRankc                   ó   t ƒ jdi |¤Ž d S )NÚRANK)r   ©ÚsuperÚ__init__©ÚselfÚkwargs©Ú	__class__r   r   r      ó   zRank.__init__©r
   r   r   r   Ú__classcell__r   r   r   r   r      ó    r   c                      r   )Ú	DenseRankc                   r   )NÚ
DENSE_RANK)r$   r   r   r   r   r   r   "   r   zDenseRank.__init__r    r   r   r   r   r#   !   r"   r#   c                      r   )Ú	RowNumberc                   r   )NÚ
ROW_NUMBER)r&   r   r   r   r   r   r   '   r   zRowNumber.__init__r    r   r   r   r   r%   &   r"   r%   c                      r   )ÚNTilec                   ó   t ƒ jd|fi |¤Ž d S )NÚNTILEr   ©r   Útermr   r   r   r   r   ,   ó   zNTile.__init__r    r   r   r   r   r'   +   r"   r'   c                      r   )Ú
FirstValuec                   ó   t ƒ jdg|¢R i |¤Ž d S )NÚFIRST_VALUEr   ©r   Útermsr   r   r   r   r   1   ó   zFirstValue.__init__r    r   r   r   r   r-   0   r"   r-   c                      r   )Ú	LastValuec                   r.   )NÚ
LAST_VALUEr   r0   r   r   r   r   6   r2   zLastValue.__init__r    r   r   r   r   r3   5   r"   r3   c                      r   )ÚMedianc                   r(   )NÚMEDIANr   r*   r   r   r   r   ;   r,   zMedian.__init__r    r   r   r   r   r5   :   r"   r5   c                      r   )ÚAvgc                   r(   )NÚAVGr   r*   r   r   r   r   @   r,   zAvg.__init__r    r   r   r   r   r7   ?   r"   r7   c                      r   )ÚStdDevc                   r(   )NÚSTDDEVr   r*   r   r   r   r   E   r,   zStdDev.__init__r    r   r   r   r   r9   D   r"   r9   c                      r   )Ú	StdDevPopc                   r(   )NÚ
STDDEV_POPr   r*   r   r   r   r   J   r,   zStdDevPop.__init__r    r   r   r   r   r;   I   r"   r;   c                      r   )Ú
StdDevSampc                   r(   )NÚSTDDEV_SAMPr   r*   r   r   r   r   O   r,   zStdDevSamp.__init__r    r   r   r   r   r=   N   r"   r=   c                      r   )ÚVariancec                   r(   )NÚVARIANCEr   r*   r   r   r   r   T   r,   zVariance.__init__r    r   r   r   r   r?   S   r"   r?   c                      r   )ÚVarPopc                   r(   )NÚVAR_POPr   r*   r   r   r   r   Y   r,   zVarPop.__init__r    r   r   r   r   rA   X   r"   rA   c                      r   )ÚVarSampc                   r(   )NÚVAR_SAMPr   r*   r   r   r   r   ^   r,   zVarSamp.__init__r    r   r   r   r   rC   ]   r"   rC   c                      r   )ÚCountc                   r(   )NÚCOUNTr   r*   r   r   r   r   c   r,   zCount.__init__r    r   r   r   r   rE   b   r"   rE   c                      r   )ÚSumc                   r(   )NÚSUMr   r*   r   r   r   r   h   r,   zSum.__init__r    r   r   r   r   rG   g   r"   rG   c                      r   )ÚMaxc                   r(   )NÚMAXr   r*   r   r   r   r   m   r,   zMax.__init__r    r   r   r   r   rI   l   r"   rI   c                      r   )ÚMinc                   r(   )NÚMINr   r*   r   r   r   r   r   r,   zMin.__init__r    r   r   r   r   rK   q   r"   rK   c                      r   )ÚLagc                   r.   )NÚLAGr   ©r   Úargsr   r   r   r   r   w   r2   zLag.__init__r    r   r   r   r   rM   v   r"   rM   c                      r   )ÚLeadc                   r.   )NÚLEADr   rO   r   r   r   r   |   r2   zLead.__init__r    r   r   r   r   rQ   {   r"   rQ   N)!Ú__doc__Ú
__future__r   Úpypika.termsr   r   r   Ú
__author__Ú	__email__ÚEdger   r   ÚCURRENT_ROWr   r#   r%   r'   r-   r3   r5   r7   r9   r;   r=   r?   rA   rC   rE   rG   rI   rK   rM   rQ   r   r   r   r   Ú<module>   s8    