3
W­E^'4  ã               @   sX   d dl Z d dl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eƒZdS )	é    N)Úsettings)ÚBaseDatabaseOperations)Útimezone)Úduration_microseconds)Ú	force_strc                   s^  e Zd ZdZejdOdPdœ–Zdddddd	dddd
d
dœZd	ZdZdd„ Z	dd„ Z
dd„ Zdd„ Zdd„ Zdd„ Zdd„ Zdd„ Zdd„ Zdd „ Zd!d"„ Zd#d$„ Zd%d&„ Zd'd(„ Zd)d*„ Zd+d,„ ZdQd.d/„Zd0d1„ Zd2d3„ Zd4d5„ Zd6d7„ Zd8d9„ Z‡ fd:d;„Z‡ fd<d=„Z d>d?„ Z!d@dA„ Z"dBdC„ Z#dDdE„ Z$dFdG„ Z%dR‡ fdIdJ„	Z&dKdL„ Z'dS‡ fdMdN„	Z(‡  Z)S )TÚDatabaseOperationsz!django.db.backends.mysql.compilerr   éÿÿ  ì   ÿÿ )ÚPositiveSmallIntegerFieldÚPositiveIntegerFieldzsigned integerzchar(%(max_length)s)z+decimal(%(max_digits)s, %(decimal_places)s)Úcharzunsigned integer)Z	AutoFieldZBigAutoFieldZSmallAutoFieldZ	CharFieldZDecimalFieldZ	TextFieldZIntegerFieldZBigIntegerFieldZSmallIntegerFieldr   r
   ZEXPLAINc             C   sD   |dkrd| S |dkr d| S |dkr0d| S d|j ƒ |f S d S )NZweek_dayzDAYOFWEEK(%s)ÚweekzWEEK(%s, 3)Ziso_yearz#TRUNCATE(YEARWEEK(%s, 3), -2) / 100zEXTRACT(%s FROM %s))Úupper)ÚselfÚlookup_typeÚ
field_name© r   úE/tmp/pip-build-78s3knkw/Django/django/db/backends/mysql/operations.pyÚdate_extract_sql#   s    z#DatabaseOperations.date_extract_sqlc             C   sZ   dddœ}||kr&|| }d||f S |dkr:d||f S |dkrNd||f S d	| S d S )
Nz	%%Y-01-01z
%%Y-%%m-01)ÚyearÚmonthz#CAST(DATE_FORMAT(%s, '%s') AS DATE)ÚquarterzIMAKEDATE(YEAR(%s), 1) + INTERVAL QUARTER(%s) QUARTER - INTERVAL 1 QUARTERr   z&DATE_SUB(%s, INTERVAL WEEKDAY(%s) DAY)zDATE(%s)r   )r   r   r   ÚfieldsÚ
format_strr   r   r   Údate_trunc_sql6   s    

z!DatabaseOperations.date_trunc_sqlc             C   s8   d|kr||j dƒd … S d|kr4||j dƒd … S |S )Nú+ú-)Úfind)r   Útznamer   r   r   Ú_prepare_tzname_deltaI   s
    z(DatabaseOperations._prepare_tzname_deltac             C   s.   t jr*| jj|kr*d|| jj| j|ƒf }|S )NzCONVERT_TZ(%s, '%s', '%s'))r   ÚUSE_TZÚ
connectionZtimezone_namer   )r   r   r   r   r   r   Ú_convert_field_to_tzP   s    z'DatabaseOperations._convert_field_to_tzc             C   s   | j ||ƒ}d| S )NzDATE(%s))r"   )r   r   r   r   r   r   Údatetime_cast_date_sqlY   s    z)DatabaseOperations.datetime_cast_date_sqlc             C   s   | j ||ƒ}d| S )NzTIME(%s))r"   )r   r   r   r   r   r   Údatetime_cast_time_sql]   s    z)DatabaseOperations.datetime_cast_time_sqlc             C   s   | j ||ƒ}| j||ƒS )N)r"   r   )r   r   r   r   r   r   r   Údatetime_extract_sqla   s    z'DatabaseOperations.datetime_extract_sqlc       
      C   s¦   | j ||ƒ}ddddddg}d}d}|dkr8dj|d�S |dkrLdj|d�S y|j|ƒd }W n tk
rv   |}Y n,X dj|d |… ||d …  ƒ}	d||	f }|S )Nr   r   ÚdayÚhourÚminuteÚsecondú%%Y-ú%%mú-%%dú %%H:ú%%iú:%%sú0000-Ú01ú-01ú 00:Ú00ú:00r   z\CAST(DATE_FORMAT(MAKEDATE(YEAR({field_name}), 1) + INTERVAL QUARTER({field_name}) QUARTER - z7INTERVAL 1 QUARTER, '%%Y-%%m-01 00:00:00') AS DATETIME))r   r   zqCAST(DATE_FORMAT(DATE_SUB({field_name}, INTERVAL WEEKDAY({field_name}) DAY), '%%Y-%%m-%%d 00:00:00') AS DATETIME)é   Ú z'CAST(DATE_FORMAT(%s, '%s') AS DATETIME))r*   r+   r,   r-   r.   r/   )r0   r1   r2   r3   r4   r5   z“CAST(DATE_FORMAT(MAKEDATE(YEAR({field_name}), 1) + INTERVAL QUARTER({field_name}) QUARTER - INTERVAL 1 QUARTER, '%%Y-%%m-01 00:00:00') AS DATETIME))r"   ÚformatÚindexÚ
ValueErrorÚjoin)
r   r   r   r   r   r8   Z
format_defÚiÚsqlr   r   r   r   Údatetime_trunc_sqle   s$     
z%DatabaseOperations.datetime_trunc_sqlc             C   s4   ddddœ}||kr(|| }d||f S d| S d S )Nz	%%H:00:00z
%%H:%%i:00z%%H:%%i:%%s)r'   r(   r)   z#CAST(DATE_FORMAT(%s, '%s') AS TIME)zTIME(%s)r   )r   r   r   r   r   r   r   r   Útime_trunc_sql   s    z!DatabaseOperations.time_trunc_sqlc             C   s   dt |ƒ S )NzINTERVAL %s MICROSECOND)r   )r   Ú	timedeltar   r   r   Údate_interval_sql‹   s    z$DatabaseOperations.date_interval_sqlc             C   s   d| S )NzINTERVAL %s MICROSECONDr   )r   r=   r   r   r   Úformat_for_duration_arithmeticŽ   s    z1DatabaseOperations.format_for_duration_arithmeticc             C   s   ddg dffgS )zÅ
        "ORDER BY NULL" prevents MySQL from implicitly ordering by grouped
        columns. If no ordering would otherwise be applied, we don't want any
        implicit sorting going on.
        NZNULLFr   )r   r   r   r   Úforce_no_ordering‘   s    z$DatabaseOperations.force_no_orderingc             C   s   t t|dd ƒdd�S )NZ	_executedÚreplace)Úerrors)r   Úgetattr)r   Úcursorr=   Úparamsr   r   r   Úlast_executed_query™   s    z&DatabaseOperations.last_executed_queryc             C   s   dS )Nl   ÿÿÿÿ r   )r   r   r   r   Úno_limit_value    s    z!DatabaseOperations.no_limit_valuec             C   s    |j dƒr|jdƒr|S d| S )Nú`z`%s`)Ú
startswithÚendswith)r   Únamer   r   r   Ú
quote_name¤   s    zDatabaseOperations.quote_namec             C   s   dS )NzRAND()r   )r   r   r   r   Úrandom_function_sql©   s    z&DatabaseOperations.random_function_sqlFc             C   sd   |r\dg}x0|D ](}|j d|jdƒ|j| j|ƒƒf ƒ qW |j dƒ |j| j||ƒƒ |S g S d S )NzSET FOREIGN_KEY_CHECKS = 0;z%s %s;ZTRUNCATEzSET FOREIGN_KEY_CHECKS = 1;)ÚappendZSQL_KEYWORDZ	SQL_FIELDrO   ÚextendZsequence_reset_by_name_sql)r   ÚstyleZtablesÚ	sequencesZallow_cascader=   Útabler   r   r   Ú	sql_flush¬   s    

zDatabaseOperations.sql_flushc             C   s   |dkrt dƒ‚|S )Nr   z@The database backend does not accept 0 as a value for AutoField.)r:   )r   Úvaluer   r   r   Úvalidate_autopk_value½   s    z(DatabaseOperations.validate_autopk_valuec             C   sL   |d krd S t |dƒr|S tj|ƒrDtjr<tj|| jjƒ}ntdƒ‚t|ƒS )NÚresolve_expressionzMMySQL backend does not support timezone-aware datetimes when USE_TZ is False.)	Úhasattrr   Úis_awarer   r    Z
make_naiver!   r:   Ústr)r   rW   r   r   r   Úadapt_datetimefield_valueÄ   s    

z,DatabaseOperations.adapt_datetimefield_valuec             C   s4   |d krd S t |dƒr|S tj|ƒr,tdƒ‚t|ƒS )NrY   z4MySQL backend does not support timezone-aware times.)rZ   r   r[   r:   r\   )r   rW   r   r   r   Úadapt_timefield_valueÔ   s    

z(DatabaseOperations.adapt_timefield_valuec             C   s   dS )Né@   r   )r   r   r   r   Úmax_name_lengthâ   s    z"DatabaseOperations.max_name_lengthc             C   s*   dd„ |D ƒ}dj dd„ |D ƒƒ}d| S )Nc             s   s   | ]}d j |ƒV  qdS )z, N)r;   )Ú.0Úrowr   r   r   ú	<genexpr>æ   s    z5DatabaseOperations.bulk_insert_sql.<locals>.<genexpr>z, c             s   s   | ]}d | V  qdS )z(%s)Nr   )ra   r=   r   r   r   rc   ç   s    zVALUES )r;   )r   r   Zplaceholder_rowsZplaceholder_rows_sqlZ
values_sqlr   r   r   Úbulk_insert_sqlå   s    z"DatabaseOperations.bulk_insert_sqlc                sX   |dkrddj |ƒ S |dkr,d|j |ƒ S |dkrJ|\}}d	||d
œ S tƒ j||ƒS )Nú^zPOW(%s)ú,ú&ú|ú<<zCONVERT(%s, SIGNED)z>>z FLOOR(%(lhs)s / POW(2, %(rhs)s)))ÚlhsÚrhs)rg   rh   ri   )r;   ÚsuperÚcombine_expression)r   Z	connectorZsub_expressionsrj   rk   )Ú	__class__r   r   rm   ê   s    z%DatabaseOperations.combine_expressionc                s`   t ƒ j|ƒ}|jjƒ }|dkr,|j| jƒ n0|dkrHtjr\|j| jƒ n|dkr\|j| j	ƒ |S )NÚBooleanFieldÚNullBooleanFieldZDateTimeFieldZ	UUIDField)ro   rp   )
rl   Úget_db_convertersZoutput_fieldZget_internal_typerQ   Úconvert_booleanfield_valuer   r    Úconvert_datetimefield_valueÚconvert_uuidfield_value)r   Ú
expressionÚ
convertersÚinternal_type)rn   r   r   rq   ö   s    
z$DatabaseOperations.get_db_convertersc             C   s   |dkrt |ƒ}|S )Nr   r6   )r   r6   )Úbool)r   rW   ru   r!   r   r   r   rr     s    z-DatabaseOperations.convert_booleanfield_valuec             C   s   |d k	rt j|| jj ƒ}|S )N)r   Z
make_awarer!   )r   rW   ru   r!   r   r   r   rs     s    z.DatabaseOperations.convert_datetimefield_valuec             C   s   |d k	rt j|ƒ}|S )N)ÚuuidÚUUID)r   rW   ru   r!   r   r   r   rt     s    
z*DatabaseOperations.convert_uuidfield_valuec             C   s   |d k	rt |dƒ rdS dS )NZas_sqlz
_binary %sz%s)rZ   )r   rW   r   r   r   Úbinary_placeholder_sql  s    z)DatabaseOperations.binary_placeholder_sqlc       	      C   st   |\}}|\}}|dkr\| j jr6d||dœ ||˜fS d||dœ t|ƒd t|ƒd  fS ||˜}d||f |fS )NZ	TimeFieldzGCAST((TIME_TO_SEC(%(lhs)s) - TIME_TO_SEC(%(rhs)s)) * 1000000 AS SIGNED))rj   rk   zs((TIME_TO_SEC(%(lhs)s) * 1000000 + MICROSECOND(%(lhs)s)) - (TIME_TO_SEC(%(rhs)s) * 1000000 + MICROSECOND(%(rhs)s)))é   z"TIMESTAMPDIFF(MICROSECOND, %s, %s))r!   Úmysql_is_mariadbÚtuple)	r   rw   rj   rk   Zlhs_sqlZ
lhs_paramsZrhs_sqlZ
rhs_paramsrH   r   r   r   Úsubtract_temporals  s    

$z%DatabaseOperations.subtract_temporalsNc                sR   |r|j ƒ dkrd}tƒ j|f|Ž}|r4|d| 7 }| jjjrN|d krN|d7 }|S )NZTEXTZTRADITIONALz
 FORMAT=%sz	 EXTENDED)r   rl   Úexplain_query_prefixr!   ÚfeaturesZneeds_explain_extended)r   r8   ÚoptionsÚprefix)rn   r   r   r€   %  s    z'DatabaseOperations.explain_query_prefixc             C   s<   | j jd	k s| j jr$|dkr dS dS |dkr0dnd}d| S )
Né   r   Úregexz%s REGEXP BINARY %sz%s REGEXP %sÚcr<   zREGEXP_LIKE(%%s, %%s, '%s'))r„   r   r   )r!   Zmysql_versionr}   )r   r   Zmatch_optionr   r   r   Úregex_lookup1  s    zDatabaseOperations.regex_lookupc                s   |rdS t ƒ j|ƒS )NzINSERT IGNORE INTO)rl   Úinsert_statement)r   Zignore_conflicts)rn   r   r   rˆ   <  s    z#DatabaseOperations.insert_statement)r   r   )r   r	   )F)N)F)*Ú__name__Ú
__module__Ú__qualname__Zcompiler_moduler   Zinteger_field_rangesZcast_data_typesZ"cast_char_field_without_max_lengthZexplain_prefixr   r   r   r"   r#   r$   r%   r>   r?   rA   rB   rC   rI   rJ   rO   rP   rV   rX   r]   r^   r`   rd   rm   rq   rr   rs   rt   r{   r   r€   r‡   rˆ   Ú__classcell__r   r   )rn   r   r   
   sb   
	
r   )ry   Zdjango.confr   Z"django.db.backends.base.operationsr   Zdjango.utilsr   Zdjango.utils.durationr   Zdjango.utils.encodingr   r   r   r   r   r   Ú<module>   s   