3
W­E^,M  ã               @   s  d dl Z d dlZd dlmZ d dlmZ d dlmZmZmZm	Z	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 G d	d
„ d
ƒZG dd„ deeƒZG dd„ deƒZG dd„ dƒZG dd„ deƒZejG dd„ deeƒƒZejG dd„ deƒƒZejG dd„ deeƒƒZejG dd„ deeƒƒZejG dd„ deeƒƒZ ejG dd„ deeƒƒZ!G dd „ d ƒZ"ejG d!d"„ d"e"eƒƒZ#ejG d#d$„ d$e"e ƒƒZ$ejG d%d&„ d&eeƒƒZ%G d'd(„ d(eƒZ&ejG d)d*„ d*e&ƒƒZ'ejG d+d,„ d,e'ƒƒZ(ejG d-d.„ d.e&ƒƒZ)ejG d/d0„ d0e)ƒƒZ*ejG d1d2„ d2e&ƒƒZ+ejG d3d4„ d4e+ƒƒZ,ejG d5d6„ d6eeƒƒZ-ejG d7d8„ d8eƒƒZ.ejG d9d:„ d:eƒƒZ/ejG d;d<„ d<e/ƒƒZ0G d=d>„ d>eƒZ1G d?d@„ d@e1eƒZ2G dAdB„ dBe1eƒZ3G dCdD„ dDe1eƒZ4G dEdF„ dFe1e ƒZ5G dGdH„ dHe1e!ƒZ6dS )Ié    N)Úcopy)ÚEmptyResultSet)ÚCaseÚExistsÚFuncÚValueÚWhen)ÚBooleanFieldÚDateTimeFieldÚFieldÚIntegerField)ÚRegisterLookupMixin)Ú
OrderedSet)Úcached_propertyc               @   s²   e Zd ZdZdZdZdd„ Zdd„ Zd&dd	„Zd
d„ Z	dd„ Z
dd„ Zdd„ Zd'dd„Zdd„ Zdd„ Zdd„ Zd(dd„Zdd„ Zdd„ Zed d!„ ƒZed"d#„ ƒZed$d%„ ƒZdS ))ÚLookupNTFc             C   s`   || | _ | _| jƒ | _t| j dƒr0| j jƒ }ng }|rVddlm} t||ƒrVtdƒ‚|| _	d S )NÚget_bilateral_transformsr   )ÚQueryzBBilateral transformations on nested querysets are not implemented.)
ÚlhsÚrhsÚget_prep_lookupÚhasattrr   Údjango.db.models.sql.queryr   Ú
isinstanceÚNotImplementedErrorÚbilateral_transforms)Úselfr   r   r   r   © r   ú:/tmp/pip-build-78s3knkw/Django/django/db/models/lookups.pyÚ__init__   s    

zLookup.__init__c             C   s   x| j D ]}||ƒ}qW |S )N)r   )r   ÚvalueZ	transformr   r   r   Úapply_bilateral_transforms#   s    z!Lookup.apply_bilateral_transformsc             C   s¢   |d kr| j }| jrvg g  }}xz|D ]L}t|| jjd�}| j|ƒ}|j|jƒ}|j|ƒ\}}	|j	|ƒ |j
|	ƒ q$W n$| j||ƒ\}
}dgt|ƒ | }}||fS )N)Úoutput_fieldz%s)r   r   r   r   r!   r    Úresolve_expressionÚqueryÚcompileÚappendÚextendÚget_db_prep_lookupÚlen)r   ÚcompilerÚ
connectionr   ÚsqlsÚsqls_paramsÚpr   ÚsqlZ
sql_paramsÚ_Úparamsr   r   r   Úbatch_process_rhs(   s    



zLookup.batch_process_rhsc             C   s   | j ƒ r| jgS | j| jgS )N)Úrhs_is_direct_valuer   r   )r   r   r   r   Úget_source_expressions9   s    zLookup.get_source_expressionsc             C   s(   t |ƒdkr|d | _n|\| _| _d S )Né   r   )r(   r   r   )r   Z	new_exprsr   r   r   Úset_source_expressions>   s    zLookup.set_source_expressionsc             C   s<   t | jdƒr| jS | jr6t | jjdƒr6| jjj| jƒS | jS )Nr"   Úget_prep_value)r   r   Úprepare_rhsr   r!   r6   )r   r   r   r   r   D   s
    zLookup.get_prep_lookupc             C   s
   d|gfS )Nz%sr   )r   r   r*   r   r   r   r'   K   s    zLookup.get_db_prep_lookupc             C   s*   |p| j }t|dƒr |j|jƒ}|j|ƒS )Nr"   )r   r   r"   r#   r$   )r   r)   r*   r   r   r   r   Úprocess_lhsN   s    

zLookup.process_lhsc             C   s^   | j }| jr:| jƒ r$t|| jjd�}| j|ƒ}|j|jƒ}t	|dƒrN|j
|ƒS | j||ƒS d S )N)r!   Úas_sql)r   r   r2   r   r   r!   r    r"   r#   r   r$   r'   )r   r)   r*   r   r   r   r   Úprocess_rhsT   s    


zLookup.process_rhsc             C   s   t | jdƒ S )Nr9   )r   r   )r   r   r   r   r2   b   s    zLookup.rhs_is_direct_valuec             C   s4   t | ƒ}|jj|ƒ|_t|jdƒr0|jj|ƒ|_|S )NÚrelabeled_clone)r   r   r;   r   r   )r   ZrelabelsÚnewr   r   r   r;   e   s
    zLookup.relabeled_clonec             C   s*   | j jƒ }t| jdƒr&|j| jjƒ ƒ |S )NÚget_group_by_cols)r   r=   r   r   r&   )r   ÚaliasÚcolsr   r   r   r=   l   s    
zLookup.get_group_by_colsc             C   s   t ‚d S )N)r   )r   r)   r*   r   r   r   r9   r   s    zLookup.as_sqlc             C   sn   d}g }xD| j | jfD ]4}t|tƒr@tt|dd�dtƒ d�}d}|j|ƒ qW |r^t| ƒ|Ž n| }|j	||ƒS )NFT)Zthen)Údefaultr!   )
r   r   r   r   r   r   r	   r%   Útyper9   )r   r)   r*   ÚwrappedÚexprsÚexprÚlookupr   r   r   Ú	as_oracleu   s    
zLookup.as_oraclec             C   s   | j jpt| jddƒS )NÚcontains_aggregateF)r   rG   Úgetattrr   )r   r   r   r   rG   ‚   s    zLookup.contains_aggregatec             C   s   | j jpt| jddƒS )NÚcontains_over_clauseF)r   rI   rH   r   )r   r   r   r   rI   †   s    zLookup.contains_over_clausec             C   s   | j jpt| jddƒS )NÚ
is_summaryF)r   rJ   rH   r   )r   r   r   r   rJ   Š   s    zLookup.is_summary)N)N)N)Ú__name__Ú
__module__Ú__qualname__Úlookup_namer7   Zcan_use_none_as_rhsr   r    r1   r3   r5   r   r'   r8   r:   r2   r;   r=   r9   rF   r   rG   rI   ÚpropertyrJ   r   r   r   r   r      s(   


r   c               @   s,   e Zd ZdZdZdZedd„ ƒZdd„ ZdS )	Ú	Transformz…
    RegisterLookupMixin() is first so that get_lookup() and get_transform()
    first examine self and then check output_field.
    Fr4   c             C   s   | j ƒ d S )Nr   )r3   )r   r   r   r   r   —   s    zTransform.lhsc             C   s2   t | jdƒr| jjƒ }ng }| jr.|j| jƒ |S )Nr   )r   r   r   Ú	bilateralr%   Ú	__class__)r   r   r   r   r   r   ›   s    z"Transform.get_bilateral_transformsN)	rK   rL   rM   Ú__doc__rQ   ÚarityrO   r   r   r   r   r   r   rP   �   s
   rP   c                   s.   e Zd Zd‡ fdd„	Zdd„ Zdd„ Z‡  ZS )	ÚBuiltinLookupNc                sb   t ƒ j|||ƒ\}}| jjjƒ }| jjj|d�}|jj||ƒ| }|jj| j	|ƒ| }|t
|ƒfS )N)r*   )Úsuperr8   r   r!   Zget_internal_typeÚdb_typeÚopsZfield_cast_sqlZlookup_castrN   Úlist)r   r)   r*   r   Úlhs_sqlr0   Zfield_internal_typerW   )rR   r   r   r8   ¦   s    zBuiltinLookup.process_lhsc             C   sF   | j ||ƒ\}}| j||ƒ\}}|j|ƒ | j||ƒ}d||f |fS )Nz%s %s)r8   r:   r&   Ú
get_rhs_op)r   r)   r*   rZ   r0   Úrhs_sqlÚ
rhs_paramsr   r   r   r9   ¯   s
    
zBuiltinLookup.as_sqlc             C   s   |j | j | S )N)Ú	operatorsrN   )r   r*   r   r   r   r   r[   ¶   s    zBuiltinLookup.get_rhs_op)N)rK   rL   rM   r8   r9   r[   Ú__classcell__r   r   )rR   r   rU   ¥   s   	rU   c               @   s   e Zd ZdZdZdd„ ZdS )ÚFieldGetDbPrepValueMixinzZ
    Some lookups require Field.get_db_prep_value() to be called on their
    inputs.
    Fc                sT   t | jjdd ƒ}t |dd ƒp$| jjj‰d| jrB‡ ‡fdd„|D ƒnˆ|ˆ dd�gfS )NZtarget_fieldÚget_db_prep_valuez%sc                s   g | ]}ˆ|ˆ d d�‘qS )T)Úpreparedr   )Ú.0Úv)r*   ra   r   r   ú
<listcomp>È   s    z?FieldGetDbPrepValueMixin.get_db_prep_lookup.<locals>.<listcomp>T)rb   )rH   r   r!   ra   Ú$get_db_prep_lookup_value_is_iterable)r   r   r*   Úfieldr   )r*   ra   r   r'   Á   s
    z+FieldGetDbPrepValueMixin.get_db_prep_lookupN)rK   rL   rM   rS   rf   r'   r   r   r   r   r`   º   s   r`   c                   sB   e Zd ZdZdZdd„ Z‡ fdd„Zdd„ Zd‡ fd
d„	Z‡  Z	S )Ú FieldGetDbPrepValueIterableMixinzg
    Some lookups require Field.get_db_prep_value() to be called on each value
    in an iterable.
    Tc             C   sb   t | jdƒr| jS g }xF| jD ]<}t |dƒr.n"| jrPt | jjdƒrP| jjj|ƒ}|j|ƒ qW |S )Nr"   r6   )r   r   r7   r   r!   r6   r%   )r   Zprepared_valuesÚ	rhs_valuer   r   r   r   Õ   s    
z0FieldGetDbPrepValueIterableMixin.get_prep_lookupc                s&   | j ƒ r| j||ƒS tƒ j||ƒS d S )N)r2   r1   rV   r:   )r   r)   r*   )rR   r   r   r:   ã   s    z,FieldGetDbPrepValueIterableMixin.process_rhsc             C   s>   |g}t |dƒr|j|jƒ}t |dƒr6|j||ƒ\}}||fS )Nr"   r9   )r   r"   r#   r9   )r   r)   r*   r.   Úparamr0   r   r   r   Úresolve_expression_parameterë   s    

z=FieldGetDbPrepValueIterableMixin.resolve_expression_parameterNc                sJ   t ƒ jˆ ˆ|ƒ}t‡ ‡‡fdd„t|Ž D ƒŽ \}}tjj|ƒ}|t|ƒfS )Nc             3   s"   | ]\}}ˆj ˆ ˆ||ƒV  qd S )N)rk   )rc   r.   rj   )r)   r*   r   r   r   ú	<genexpr>ú   s   zEFieldGetDbPrepValueIterableMixin.batch_process_rhs.<locals>.<genexpr>)rV   r1   ÚzipÚ	itertoolsÚchainÚfrom_iterableÚtuple)r   r)   r*   r   Zpre_processedr.   r0   )rR   )r)   r*   r   r   r1   ó   s    z2FieldGetDbPrepValueIterableMixin.batch_process_rhs)N)
rK   rL   rM   rS   rf   r   r:   rk   r1   r_   r   r   )rR   r   rh   Î   s   rh   c                   s    e Zd ZdZ‡ fdd„Z‡  ZS )ÚExactÚexactc                sZ   ddl m} t| j|ƒrL| jjƒ rD| jjsL| jjƒ  | jjdgƒ ntdƒ‚t	ƒ j
||ƒS )Nr   )r   ÚpkzSThe QuerySet value for an exact lookup must be limited to one result using slicing.)r   r   r   r   Zhas_limit_oneÚhas_select_fieldsÚclear_select_clauseÚ
add_fieldsÚ
ValueErrorrV   r:   )r   r)   r*   r   )rR   r   r   r:     s    

zExact.process_rhs)rK   rL   rM   rN   r:   r_   r   r   )rR   r   rr     s   rr   c                   s$   e Zd ZdZdZ‡ fdd„Z‡  ZS )ÚIExactZiexactFc                s2   t ƒ j||ƒ\}}|r*|jj|d ƒ|d< ||fS )Nr   )rV   r:   rX   Zprep_for_iexact_query)r   Úqnr*   r   r0   )rR   r   r   r:     s    zIExact.process_rhs)rK   rL   rM   rN   r7   r:   r_   r   r   )rR   r   ry     s   ry   c               @   s   e Zd ZdZdS )ÚGreaterThanÚgtN)rK   rL   rM   rN   r   r   r   r   r{      s   r{   c               @   s   e Zd ZdZdS )ÚGreaterThanOrEqualZgteN)rK   rL   rM   rN   r   r   r   r   r}   %  s   r}   c               @   s   e Zd ZdZdS )ÚLessThanÚltN)rK   rL   rM   rN   r   r   r   r   r~   *  s   r~   c               @   s   e Zd ZdZdS )ÚLessThanOrEqualZlteN)rK   rL   rM   rN   r   r   r   r   r€   /  s   r€   c                   s    e Zd ZdZ‡ fdd„Z‡  ZS )ÚIntegerFieldFloatRoundingzŽ
    Allow floats to work as query values for IntegerField. Without this, the
    decimal portion of the float would always be discarded.
    c                s$   t | jtƒrtj| jƒ| _tƒ jƒ S )N)r   r   ÚfloatÚmathÚceilrV   r   )r   )rR   r   r   r   9  s    z)IntegerFieldFloatRounding.get_prep_lookup)rK   rL   rM   rS   r   r_   r   r   )rR   r   r�   4  s   r�   c               @   s   e Zd ZdS )ÚIntegerGreaterThanOrEqualN)rK   rL   rM   r   r   r   r   r…   ?  s   r…   c               @   s   e Zd ZdS )ÚIntegerLessThanN)rK   rL   rM   r   r   r   r   r†   D  s   r†   c                   s<   e Zd ZdZ‡ fdd„Zdd„ Z‡ fdd„Zdd	„ Z‡  ZS )
ÚInÚinc                sÆ   t | jdd ƒ}|d k	r(||jkr(tdƒ‚| jƒ rŽyt| jƒ}W n tk
rX   | j}Y nX |sbt‚| j|||ƒ\}}ddj	|ƒ d }||fS t | jddƒs´| jj
ƒ  | jjdgƒ tƒ j||ƒS d S )	NÚ_dbzvSubqueries aren't allowed across different databases. Force the inner query to be evaluated using `list(inner_query)`.ú(z, ú)ru   Trt   )rH   r   r>   rx   r2   r   Ú	TypeErrorr   r1   Újoinrv   rw   rV   r:   )r   r)   r*   Zdb_rhsr   r+   r,   Úplaceholder)rR   r   r   r:   M  s$    
zIn.process_rhsc             C   s   d| S )NzIN %sr   )r   r*   r   r   r   r   r[   i  s    zIn.get_rhs_opc                s>   |j jƒ }| jƒ r0|r0t| jƒ|kr0| j||ƒS tƒ j||ƒS )N)rX   Úmax_in_list_sizer2   r(   r   Úsplit_parameter_list_as_sqlrV   r9   )r   r)   r*   r�   )rR   r   r   r9   l  s    
z	In.as_sqlc             C   sØ   |j jƒ }| j||ƒ\}}| j||ƒ\}}dg}g }	xŠtdt|ƒ|ƒD ]v}
|
dkr\|jdƒ |jd| ƒ |	j|ƒ ||
|
| … }||
|
| … }dj|ƒ}|j|ƒ |jdƒ |	j|ƒ qFW |jdƒ dj|ƒ|	fS )NrŠ   r   z OR z%s IN (z, r‹   Ú )	rX   r�   r8   r1   Úranger(   r%   r&   r�   )r   r)   r*   r�   r   Ú
lhs_paramsr   r]   Zin_clause_elementsr0   Úoffsetr+   r,   Zparam_groupr   r   r   r�   r  s$    






zIn.split_parameter_list_as_sql)	rK   rL   rM   rN   r:   r[   r9   r�   r_   r   r   )rR   r   r‡   I  s
   r‡   c                   s0   e Zd ZdZdZ‡ fdd„Z‡ fdd„Z‡  ZS )ÚPatternLookupz%%%s%%Fc                sB   t | jdƒs| jr0|j| j j|jƒ}|j|ƒS tƒ j||ƒS d S )Nr9   )	r   r   r   Zpattern_opsrN   ÚformatZpattern_escrV   r[   )r   r*   r   Úpattern)rR   r   r   r[   �  s    

zPatternLookup.get_rhs_opc                sH   t ƒ j||ƒ\}}| jƒ r@|r@| j r@| j|jj|d ƒ |d< ||fS )Nr   )rV   r:   r2   r   Úparam_patternrX   Zprep_for_like_query)r   rz   r*   r   r0   )rR   r   r   r:   �  s    zPatternLookup.process_rhs)rK   rL   rM   r˜   r7   r[   r:   r_   r   r   )rR   r   r•   ‰  s   r•   c               @   s   e Zd ZdZdS )ÚContainsÚcontainsN)rK   rL   rM   rN   r   r   r   r   r™   ¤  s   r™   c               @   s   e Zd ZdZdS )Ú	IContainsZ	icontainsN)rK   rL   rM   rN   r   r   r   r   r›   ©  s   r›   c               @   s   e Zd ZdZdZdS )Ú
StartsWithÚ
startswithz%s%%N)rK   rL   rM   rN   r˜   r   r   r   r   rœ   ®  s   rœ   c               @   s   e Zd ZdZdS )ÚIStartsWithZistartswithN)rK   rL   rM   rN   r   r   r   r   rž   ´  s   rž   c               @   s   e Zd ZdZdZdS )ÚEndsWithÚendswithz%%%sN)rK   rL   rM   rN   r˜   r   r   r   r   rŸ   ¹  s   rŸ   c               @   s   e Zd ZdZdS )Ú	IEndsWithZ	iendswithN)rK   rL   rM   rN   r   r   r   r   r¡   ¿  s   r¡   c               @   s   e Zd ZdZdd„ ZdS )ÚRanger’   c             C   s   d|d |d f S )NzBETWEEN %s AND %sr   r4   r   )r   r*   r   r   r   r   r[   È  s    zRange.get_rhs_opN)rK   rL   rM   rN   r[   r   r   r   r   r¢   Ä  s   r¢   c               @   s   e Zd ZdZdZdd„ ZdS )ÚIsNullZisnullFc             C   s2   |j | jƒ\}}| jr"d| |fS d| |fS d S )Nz
%s IS NULLz%s IS NOT NULL)r$   r   r   )r   r)   r*   r.   r0   r   r   r   r9   Ñ  s    zIsNull.as_sqlN)rK   rL   rM   rN   r7   r9   r   r   r   r   r£   Ì  s   r£   c                   s$   e Zd ZdZdZ‡ fdd„Z‡  ZS )ÚRegexÚregexFc                s`   | j |jkrtƒ j||ƒS | j||ƒ\}}| j||ƒ\}}|jj| j ƒ}|||f || fS d S )N)rN   r^   rV   r9   r8   r:   rX   Zregex_lookup)r   r)   r*   r   r“   r   r]   Zsql_template)rR   r   r   r9   Þ  s    zRegex.as_sql)rK   rL   rM   rN   r7   r9   r_   r   r   )rR   r   r¤   Ù  s   r¤   c               @   s   e Zd ZdZdS )ÚIRegexZiregexN)rK   rL   rM   rN   r   r   r   r   r¦   è  s   r¦   c                   s4   e Zd Zdd„ Z‡ fdd„Zdd„ Zdd„ Z‡  ZS )	Ú
YearLookupc             C   s2   | j j j}t|tƒr"|jj|ƒ}n|jj|ƒ}|S )N)r   r!   r   r
   rX   Z%year_lookup_bounds_for_datetime_fieldZ!year_lookup_bounds_for_date_field)r   r*   Úyearr!   Zboundsr   r   r   Úyear_lookup_boundsî  s
    

zYearLookup.year_lookup_boundsc       	         s|   | j ƒ rn| j||| jjƒ\}}| j||ƒ\}}| j||ƒ}| j|| jƒ\}}|j| j||ƒƒ d||f |fS t	ƒ j
||ƒS )Nz%s %s)r2   r8   r   r:   Úget_direct_rhs_sqlr©   r   r&   Úget_bound_paramsrV   r9   )	r   r)   r*   rZ   r0   r\   r/   ÚstartÚfinish)rR   r   r   r9   ö  s    zYearLookup.as_sqlc             C   s   |j | j | S )N)r^   rN   )r   r*   r   r   r   r   rª     s    zYearLookup.get_direct_rhs_sqlc             C   s   t dƒ‚d S )NzAsubclasses of YearLookup must provide a get_bound_params() method)r   )r   r¬   r­   r   r   r   r«     s    zYearLookup.get_bound_params)rK   rL   rM   r©   r9   rª   r«   r_   r   r   )rR   r   r§   í  s   r§   c               @   s   e Zd Zdd„ Zdd„ ZdS )Ú	YearExactc             C   s   dS )NzBETWEEN %s AND %sr   )r   r*   r   r   r   r   rª     s    zYearExact.get_direct_rhs_sqlc             C   s   ||fS )Nr   )r   r¬   r­   r   r   r   r«     s    zYearExact.get_bound_paramsN)rK   rL   rM   rª   r«   r   r   r   r   r®     s   r®   c               @   s   e Zd Zdd„ ZdS )ÚYearGtc             C   s   |fS )Nr   )r   r¬   r­   r   r   r   r«     s    zYearGt.get_bound_paramsN)rK   rL   rM   r«   r   r   r   r   r¯     s   r¯   c               @   s   e Zd Zdd„ ZdS )ÚYearGtec             C   s   |fS )Nr   )r   r¬   r­   r   r   r   r«     s    zYearGte.get_bound_paramsN)rK   rL   rM   r«   r   r   r   r   r°     s   r°   c               @   s   e Zd Zdd„ ZdS )ÚYearLtc             C   s   |fS )Nr   )r   r¬   r­   r   r   r   r«      s    zYearLt.get_bound_paramsN)rK   rL   rM   r«   r   r   r   r   r±     s   r±   c               @   s   e Zd Zdd„ ZdS )ÚYearLtec             C   s   |fS )Nr   )r   r¬   r­   r   r   r   r«   %  s    zYearLte.get_bound_paramsN)rK   rL   rM   r«   r   r   r   r   r²   $  s   r²   )7rn   rƒ   r   Zdjango.core.exceptionsr   Zdjango.db.models.expressionsr   r   r   r   r   Zdjango.db.models.fieldsr	   r
   r   r   Zdjango.db.models.query_utilsr   Zdjango.utils.datastructuresr   Zdjango.utils.functionalr   r   rP   rU   r`   rh   Zregister_lookuprr   ry   r{   r}   r~   r€   r�   r…   r†   r‡   r•   r™   r›   rœ   rž   rŸ   r¡   r¢   r£   r¤   r¦   r§   r®   r¯   r°   r±   r²   r   r   r   r   Ú<module>   sx    3







?
 