U
     5øiU  ã                   @   sò   d Z ddlmZ ddlmZmZmZmZ ddlm	Z	 ddl
mZ ddlmZmZ ddd	d
ddddgZG dd„ deƒZG dd„ de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eƒZG dd„ deeƒZG dd„ deeƒZdS )z>
Classes to represent the definitions of aggregate functions.
é    )Ú
FieldError)ÚCaseÚFuncÚStarÚWhen)ÚIntegerField)ÚCoalesce)ÚFixDurationInputMixinÚNumericOutputFieldMixinÚ	AggregateÚAvgÚCountÚMaxÚMinÚStdDevÚSumÚVariancec                       s¢   e Zd ZdZdZdZdZdZdZdZ	ddddœ‡ fdd„
Z
‡ fd	d
„Z‡ fdd„Z‡ fdd„Zd‡ fdd„	Zedd„ ƒZddd„Z‡ fdd„Z‡ fdd„Z‡  ZS )r   z)%(function)s(%(distinct)s%(expressions)s)TNz%s FILTER (WHERE %%(filter)s)F)ÚdistinctÚfilterÚdefaultc                   sb   |r| j std| jj ƒ‚|d k	r>| jd k	r>t| jj› d�ƒ‚|| _|| _|| _tƒ j	||Ž d S )Nz%s does not allow distinct.z does not allow default.)
Úallow_distinctÚ	TypeErrorÚ	__class__Ú__name__Úempty_result_set_valuer   r   r   ÚsuperÚ__init__)Úselfr   r   r   ÚexpressionsÚextra©r   © ú?/tmp/pip-unpacked-wheel-gcyiijx6/django/db/models/aggregates.pyr      s    
zAggregate.__init__c                    s   dd„ t ƒ  ¡ D ƒS )Nc                 S   s   g | ]
}|j ‘qS r!   )Ú_output_field_or_none)Ú.0Úer!   r!   r"   Ú
<listcomp>&   s     z/Aggregate.get_source_fields.<locals>.<listcomp>)r   Úget_source_expressions©r   r    r!   r"   Úget_source_fields$   s    zAggregate.get_source_fieldsc                    s    t ƒ  ¡ }| jr|| jg S |S ©N)r   r'   r   )r   Úsource_expressionsr    r!   r"   r'   (   s    
z Aggregate.get_source_expressionsc                    s   | j o| ¡ | _ tƒ  |¡S r*   )r   Úpopr   Úset_source_expressions)r   Úexprsr    r!   r"   r-   .   s    z Aggregate.set_source_expressionsc                    sÐ   t ƒ  ||||¡}|jo(|j ||||¡|_|sŽt t|ƒ ¡ }t|ƒD ]F\}}	|	jrF|  ¡ | }
t|
dƒrp|
jnt	|
ƒ}t
d|j||f ƒ‚qF|j }d kr |S t|dƒrº| ||||¡}d |_t|||jd�S )NÚnamez-Cannot compute %s('%s'): '%s' is an aggregateÚresolve_expression)Úoutput_field)r   r0   r   r   r'   Ú	enumerateÚcontains_aggregateÚhasattrr/   Úreprr   r   r   r#   )r   ÚqueryZallow_joinsZreuseZ	summarizeZfor_saveÚcr   ÚindexÚexprZbefore_resolvedr/   r   r    r!   r"   r0   2   s    
zAggregate.resolve_expressionc                 C   sF   |   ¡ }t|ƒdkr:t|d dƒr:d|d j| j ¡ f S tdƒ‚d S )Né   r   r/   z%s__%sz$Complex expressions require an alias)r'   Úlenr4   r/   Úlowerr   )r   r   r!   r!   r"   Údefault_aliasF   s    zAggregate.default_aliasc                 C   s   g S r*   r!   )r   Úaliasr!   r!   r"   Úget_group_by_colsM   s    zAggregate.get_group_by_colsc                    sÞ   | j r
dnd|d< | jrÌ|jjrr| j ||¡\}}| j| d| j¡ }tƒ j||f||dœ|—Ž\}}||| fS |  	¡ }	d |	_|	 
¡ }
t| j|
d d�}|	 t|ƒg|
dd …  ¡ tt|	ƒj||f|ŽS tƒ j||f|ŽS )	Nz	DISTINCT Ú r   Útemplate)rA   r   r   )Zthenr:   )r   r   ÚfeaturesZ supports_aggregate_filter_clauseÚas_sqlÚfilter_templateÚgetrA   r   Úcopyr'   r   r-   r   r   )r   ÚcompilerÚ
connectionZextra_contextZ
filter_sqlZfilter_paramsrA   ZsqlÚparamsrF   r+   Ú	conditionr    r!   r"   rC   P   s,     ÿ ÿþ
zAggregate.as_sqlc                    s.   t ƒ  ¡ }| jr| j|d< | jr*| j|d< |S )Nr   r   )r   Ú_get_repr_optionsr   r   )r   Úoptionsr    r!   r"   rK   d   s    


zAggregate._get_repr_options)NTNFF)N)r   Ú
__module__Ú__qualname__rA   r3   r/   rD   Zwindow_compatibler   r   r   r)   r'   r-   r0   Úpropertyr=   r?   rC   rK   Ú__classcell__r!   r!   r    r"   r      s"   


c                   @   s   e Zd ZdZd ZdZdS )r   ZAVGTN©r   rM   rN   Úfunctionr/   r   r!   r!   r!   r"   r   m   s   c                       s4   e Zd ZdZd Zeƒ ZdZdZd‡ fdd„	Z	‡  Z
S )r   ZCOUNTTr   Nc                    sD   |dkrt ƒ }t|t ƒr(|d k	r(tdƒ‚tƒ j|fd|i|—Ž d S )NÚ*z8Star cannot be used with filter. Please specify a field.r   )r   Ú
isinstanceÚ
ValueErrorr   r   )r   Ú
expressionr   r   r    r!   r"   r   z   s
    zCount.__init__)N)r   rM   rN   rR   r/   r   r1   r   r   r   rP   r!   r!   r    r"   r   s   s   c                   @   s   e Zd ZdZd ZdS )r   ÚMAXN©r   rM   rN   rR   r/   r!   r!   r!   r"   r   ‚   s   c                   @   s   e Zd ZdZd ZdS )r   ZMINNrX   r!   r!   r!   r"   r   ‡   s   c                       s.   e Zd Zd Zd‡ fdd„	Z‡ fdd„Z‡  ZS )r   Fc                    s"   |rdnd| _ tƒ j|f|Ž d S )NÚSTDDEV_SAMPZ
STDDEV_POP©rR   r   r   ©r   rV   Úsampler   r    r!   r"   r   �   s    zStdDev.__init__c                    s   t ƒ  ¡ d| jdki–S )Nr\   rY   ©r   rK   rR   r(   r    r!   r"   rK   “   s    zStdDev._get_repr_options)F©r   rM   rN   r/   r   rK   rP   r!   r!   r    r"   r   Œ   s   c                   @   s   e Zd ZdZd ZdZdS )r   ZSUMTNrQ   r!   r!   r!   r"   r   —   s   c                       s.   e Zd Zd Zd‡ fdd„	Z‡ fdd„Z‡  ZS )r   Fc                    s"   |rdnd| _ tƒ j|f|Ž d S )NÚVAR_SAMPZVAR_POPrZ   r[   r    r!   r"   r       s    zVariance.__init__c                    s   t ƒ  ¡ d| jdki–S )Nr\   r_   r]   r(   r    r!   r"   rK   ¤   s    zVariance._get_repr_options)Fr^   r!   r!   r    r"   r   �   s   N)Ú__doc__Zdjango.core.exceptionsr   Zdjango.db.models.expressionsr   r   r   r   Zdjango.db.models.fieldsr   Z%django.db.models.functions.comparisonr   Z!django.db.models.functions.mixinsr	   r
   Ú__all__r   r   r   r   r   r   r   r   r!   r!   r!   r"   Ú<module>   s,          ÿ\