3
W­E^Ÿ*  ã               @   s,  d dl mZmZ d dl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	ƒZG d
d„ dƒZG dd„ 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ƒZG dd„ deƒZG dd„ deeƒZG dd„ deƒZG dd„ deeƒZG d d!„ d!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eeƒZG d0d1„ d1eeeƒZ G d2d3„ d3eeeeƒZ!G d4d5„ d5eeeeƒZ"G d6d7„ d7eeeeƒZ#G d8d9„ d9eƒZ$G d:d;„ d;eƒZ%G d<d=„ d=eƒZ&G d>d?„ d?eƒZ'd@S )Aé    )ÚFuncÚValue)ÚIntegerField)ÚCoalesce)Ú	Transform)ÚNotSupportedErrorc                   s    e Zd ZdZ‡ fdd„Z‡  ZS )ÚBytesToCharFieldConversionMixina"  
    Convert CharField results from bytes to str.

    MySQL returns long data types (bytes) instead of chars when it can't
    determine the length of the result string. For example:
        LPAD(column1, CHAR_LENGTH(column2), ' ')
    returns the LONGTEXT (bytes) instead of VARCHAR.
    c                s8   |j jr(| jjƒ dkr(t|tƒr(|jƒ S tƒ j|||ƒS )NZ	CharField)	ÚfeaturesZ!db_functions_convert_bytes_to_strÚoutput_fieldZget_internal_typeÚ
isinstanceÚbytesÚdecodeÚsuperÚconvert_value)ÚselfÚvalueÚ
expressionÚ
connection)Ú	__class__© úA/tmp/pip-build-78s3knkw/Django/django/db/models/functions/text.pyr      s    z-BytesToCharFieldConversionMixin.convert_value)Ú__name__Ú
__module__Ú__qualname__Ú__doc__r   Ú__classcell__r   r   )r   r   r      s   r   c                   s   e Zd Z‡ fdd„Z‡  ZS )ÚMySQLSHA2Mixinc                s(   t ƒ j||fdd| jdd …  i|—ŽS )NÚtemplatezSHA2(%%(expressions)s, %s)é   )r   Úas_sqlÚfunction)r   Úcompilerr   Úextra_content)r   r   r   Úas_mysql   s
    zMySQLSHA2Mixin.as_mysql)r   r   r   r#   r   r   r   )r   r   r      s   r   c                   s   e Zd Z‡ fdd„Z‡  ZS )ÚOracleHashMixinc                s   t ƒ j||fddi|—ŽS )Nr   zcLOWER(RAWTOHEX(STANDARD_HASH(UTL_I18N.STRING_TO_RAW(%(expressions)s, 'AL32UTF8'), '%(function)s'))))r   r   )r   r!   r   Úextra_context)r   r   r   Ú	as_oracle#   s
    zOracleHashMixin.as_oracle)r   r   r   r&   r   r   r   )r   r   r$   "   s   r$   c                   s   e Zd Z‡ fdd„Z‡  ZS )ÚPostgreSQLSHAMixinc                s"   t ƒ j||fd| jjƒ dœ|—ŽS )Nz6ENCODE(DIGEST(%(expressions)s, '%(function)s'), 'hex'))r   r    )r   r   r    Úlower)r   r!   r   r"   )r   r   r   Úas_postgresql0   s    z PostgreSQLSHAMixin.as_postgresql)r   r   r   r)   r   r   r   )r   r   r'   /   s   r'   c                   s<   e Zd ZdZdZ‡ fdd„Z‡ fdd„Z‡ fdd„Z‡  ZS )	ÚChrZCHRÚchrc                s   t ƒ j||fdddœ|—ŽS )NÚCHARz)%(function)s(%(expressions)s USING utf16))r    r   )r   r   )r   r!   r   r%   )r   r   r   r#   >   s    zChr.as_mysqlc                s   t ƒ j||fddi|—ŽS )Nr   z,%(function)s(%(expressions)s USING NCHAR_CS))r   r   )r   r!   r   r%   )r   r   r   r&   E   s    zChr.as_oraclec                s   t ƒ j||fddi|—ŽS )Nr    r,   )r   r   )r   r!   r   r%   )r   r   r   Ú	as_sqliteL   s    zChr.as_sqlite)	r   r   r   r    Úlookup_namer#   r&   r-   r   r   r   )r   r   r*   :   s
   r*   c                   s8   e Zd ZdZdZ‡ fdd„Z‡ fdd„Zdd„ Z‡  ZS )	Ú
ConcatPairz�
    Concatenate two arguments together. This is used by `Concat` because not
    all backend databases support more than two arguments.
    ZCONCATc                s(   | j ƒ }tt|ƒj||fdddœ|—ŽS )Nz%(expressions)sz || )r   Z
arg_joiner)Úcoalescer   r/   r   )r   r!   r   r%   Z	coalesced)r   r   r   r-   W   s    
zConcatPair.as_sqlitec                s   t ƒ j||fdddœ|—ŽS )NZ	CONCAT_WSz!%(function)s('', %(expressions)s))r    r   )r   r   )r   r!   r   r%   )r   r   r   r#   ^   s    zConcatPair.as_mysqlc             C   s$   | j ƒ }|jdd„ |jƒ D ƒƒ |S )Nc             S   s   g | ]}t |td ƒƒ‘qS )Ú )r   r   )Ú.0r   r   r   r   ú
<listcomp>j   s    z'ConcatPair.coalesce.<locals>.<listcomp>)ÚcopyZset_source_expressionsZget_source_expressions)r   Úcr   r   r   r0   f   s    zConcatPair.coalesce)	r   r   r   r   r    r-   r#   r0   r   r   r   )r   r   r/   P   s
   r/   c                   s0   e Zd ZdZdZdZ‡ fdd„Zdd„ Z‡  ZS )ÚConcatzÌ
    Concatenate text fields together. Backends that result in an entire
    null expression when any arguments are null will wrap each argument in
    coalesce functions to ensure a non-null result.
    Nz%(expressions)sc                s2   t |ƒdk rtdƒ‚| j|ƒ}tƒ j|f|Ž d S )Né   z)Concat must take at least two expressions)ÚlenÚ
ValueErrorÚ_pairedr   Ú__init__)r   ÚexpressionsÚextraZpaired)r   r   r   r;   x   s    
zConcat.__init__c             C   s0   t |ƒdkrt|Ž S t|d | j|dd … ƒƒS )Nr7   r   é   )r8   r/   r:   )r   r<   r   r   r   r:   ~   s    zConcat._paired)	r   r   r   r   r    r   r;   r:   r   r   r   )r   r   r6   o   s
   r6   c                   s<   e Zd ZdZdZ‡ fdd„Zdd„ Zdd„ Zd	d
„ Z‡  Z	S )ÚLeftÚLEFTr7   c                s0   t |dƒs|dk rtdƒ‚tƒ j||f|Ž dS )z¦
        expression: the name of a field, or an expression returning a string
        length: the number of characters to return from the start of the string
        Úresolve_expressionr>   z 'length' must be greater than 0.N)Úhasattrr9   r   r;   )r   r   Úlengthr=   )r   r   r   r;   ‹   s    
zLeft.__init__c             C   s   t | jd tdƒ| jd ƒS )Nr   r>   )ÚSubstrÚsource_expressionsr   )r   r   r   r   Ú
get_substr•   s    zLeft.get_substrc             K   s   | j ƒ j||f|ŽS )N)rF   r&   )r   r!   r   r%   r   r   r   r&   ˜   s    zLeft.as_oraclec             K   s   | j ƒ j||f|ŽS )N)rF   r-   )r   r!   r   r%   r   r   r   r-   ›   s    zLeft.as_sqlite)
r   r   r   r    Úarityr;   rF   r&   r-   r   r   r   )r   r   r?   ‡   s   
r?   c                   s.   e Zd ZdZdZdZeƒ Z‡ fdd„Z‡  Z	S )ÚLengthz2Return the number of characters in the expression.ZLENGTHrC   c                s   t ƒ j||fddi|—ŽS )Nr    ZCHAR_LENGTH)r   r   )r   r!   r   r%   )r   r   r   r#   ¥   s    zLength.as_mysql)
r   r   r   r   r    r.   r   r
   r#   r   r   r   )r   r   rH   Ÿ   s
   rH   c               @   s   e Zd ZdZdZdS )ÚLowerZLOWERr(   N)r   r   r   r    r.   r   r   r   r   rI   ©   s   rI   c                   s(   e Zd ZdZedƒf‡ fdd„	Z‡  ZS )ÚLPadZLPADú c                s<   t |dƒ r$|d k	r$|dk r$tdƒ‚tƒ j|||f|Ž d S )NrA   r   z''length' must be greater or equal to 0.)rB   r9   r   r;   )r   r   rC   Z	fill_textr=   )r   r   r   r;   ±   s    zLPad.__init__)r   r   r   r    r   r;   r   r   r   )r   r   rJ   ®   s   rJ   c               @   s   e Zd ZdZdZdS )ÚLTrimZLTRIMZltrimN)r   r   r   r    r.   r   r   r   r   rL   ·   s   rL   c               @   s   e Zd Zd ZdZdS )ÚMD5Úmd5N)r   r   r   r    r.   r   r   r   r   rM   ¼   s   rM   c                   s6   e Zd ZdZdZeƒ Z‡ fdd„Z‡ fdd„Z‡  Z	S )ÚOrdÚASCIIÚordc                s   t ƒ j||fddi|—ŽS )Nr    ZORD)r   r   )r   r!   r   r%   )r   r   r   r#   Æ   s    zOrd.as_mysqlc                s   t ƒ j||fddi|—ŽS )Nr    ÚUNICODE)r   r   )r   r!   r   r%   )r   r   r   r-   É   s    zOrd.as_sqlite)
r   r   r   r    r.   r   r
   r#   r-   r   r   r   )r   r   rO   Á   s
   rO   c                   s(   e Zd ZdZ‡ fdd„Zdd„ Z‡  ZS )ÚRepeatÚREPEATc                s:   t |dƒ r$|d k	r$|dk r$tdƒ‚tƒ j||f|Ž d S )NrA   r   z''number' must be greater or equal to 0.)rB   r9   r   r;   )r   r   Únumberr=   )r   r   r   r;   Ð   s    zRepeat.__init__c             K   s>   | j \}}|d krd n
t|ƒ| }t|||ƒ}|j||f|ŽS )N)rE   rH   ÚRPadr   )r   r!   r   r%   r   rU   rC   Zrpadr   r   r   r&   Õ   s    
zRepeat.as_oracle)r   r   r   r    r;   r&   r   r   r   )r   r   rS   Í   s   rS   c                   s(   e Zd ZdZedƒf‡ fdd„	Z‡  ZS )ÚReplaceZREPLACEr1   c                s   t ƒ j|||f|Ž d S )N)r   r;   )r   r   ÚtextÚreplacementr=   )r   r   r   r;   ß   s    zReplace.__init__)r   r   r   r    r   r;   r   r   r   )r   r   rW   Ü   s   rW   c                   s$   e Zd ZdZdZ‡ fdd„Z‡  ZS )ÚReverseZREVERSEÚreversec                s   t ƒ j||fddi|—ŽS )Nr   z¼(SELECT LISTAGG(s) WITHIN GROUP (ORDER BY n DESC) FROM (SELECT LEVEL n, SUBSTR(%(expressions)s, LEVEL, 1) s FROM DUAL CONNECT BY LEVEL <= LENGTH(%(expressions)s)) GROUP BY %(expressions)s))r   r   )r   r!   r   r%   )r   r   r   r&   ç   s    zReverse.as_oracle)r   r   r   r    r.   r&   r   r   r   )r   r   rZ   ã   s   rZ   c               @   s   e Zd ZdZdd„ ZdS )ÚRightÚRIGHTc             C   s   t | jd | jd tdƒ ƒS )Nr   r>   éÿÿÿÿ)rD   rE   r   )r   r   r   r   rF   ù   s    zRight.get_substrN)r   r   r   r    rF   r   r   r   r   r\   ö   s   r\   c               @   s   e Zd ZdZdS )rV   ZRPADN)r   r   r   r    r   r   r   r   rV   ý   s   rV   c               @   s   e Zd ZdZdZdS )ÚRTrimZRTRIMZrtrimN)r   r   r   r    r.   r   r   r   r   r_     s   r_   c               @   s   e Zd Zd ZdZdS )ÚSHA1Úsha1N)r   r   r   r    r.   r   r   r   r   r`     s   r`   c               @   s   e Zd Zd ZdZdd„ ZdS )ÚSHA224Úsha224c             K   s   t dƒ‚d S )Nz"SHA224 is not supported on Oracle.)r   )r   r!   r   r%   r   r   r   r&     s    zSHA224.as_oracleN)r   r   r   r    r.   r&   r   r   r   r   rb     s   rb   c               @   s   e Zd Zd ZdZdS )ÚSHA256Úsha256N)r   r   r   r    r.   r   r   r   r   rd     s   rd   c               @   s   e Zd Zd ZdZdS )ÚSHA384Úsha384N)r   r   r   r    r.   r   r   r   r   rf     s   rf   c               @   s   e Zd Zd ZdZdS )ÚSHA512Úsha512N)r   r   r   r    r.   r   r   r   r   rh     s   rh   c                   s.   e Zd ZdZdZdZeƒ Z‡ fdd„Z‡  Z	S )ÚStrIndexzµ
    Return a positive integer corresponding to the 1-indexed position of the
    first occurrence of a substring inside another string, or 0 if the
    substring is not found.
    ZINSTRr7   c                s   t ƒ j||fddi|—ŽS )Nr    ZSTRPOS)r   r   )r   r!   r   r%   )r   r   r   r)   ,  s    zStrIndex.as_postgresql)
r   r   r   r   r    rG   r   r
   r)   r   r   r   )r   r   rj   "  s
   rj   c                   s:   e Zd ZdZd	‡ fdd„	Z‡ fdd„Z‡ fdd„Z‡  ZS )
rD   Z	SUBSTRINGNc                sF   t |dƒs|dk rtdƒ‚||g}|dk	r4|j|ƒ tƒ j||Ž dS )zÔ
        expression: the name of a field, or an expression returning a string
        pos: an integer > 0, or an expression returning an integer
        length: an optional number of characters to return
        rA   r>   z'pos' must be greater than 0N)rB   r9   Úappendr   r;   )r   r   ÚposrC   r=   r<   )r   r   r   r;   3  s    

zSubstr.__init__c                s   t ƒ j||fddi|—ŽS )Nr    ÚSUBSTR)r   r   )r   r!   r   r%   )r   r   r   r-   A  s    zSubstr.as_sqlitec                s   t ƒ j||fddi|—ŽS )Nr    rm   )r   r   )r   r!   r   r%   )r   r   r   r&   D  s    zSubstr.as_oracle)N)r   r   r   r    r;   r-   r&   r   r   r   )r   r   rD   0  s   rD   c               @   s   e Zd ZdZdZdS )ÚTrimZTRIMZtrimN)r   r   r   r    r.   r   r   r   r   rn   H  s   rn   c               @   s   e Zd ZdZdZdS )ÚUpperZUPPERÚupperN)r   r   r   r    r.   r   r   r   r   ro   M  s   ro   N)(Zdjango.db.models.expressionsr   r   Zdjango.db.models.fieldsr   Zdjango.db.models.functionsr   Zdjango.db.models.lookupsr   Zdjango.db.utilsr   r   r   r$   r'   r*   r/   r6   r?   rH   rI   rJ   rL   rM   rO   rS   rW   rZ   r\   rV   r_   r`   rb   rd   rf   rh   rj   rD   rn   ro   r   r   r   r   Ú<module>   sB   

	