3
W­E^®6  ã               @   sÈ   d dl Z d dlZ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 d dlmZ d dlmZmZ d d	lmZ d d
lmZ d dlmZmZmZ d dlmZ d dlmZ G dd„ deƒZdS )é    N)Ú	lru_cache)Úchain)Úsettings)Ú
FieldError)Úutils)ÚBaseDatabaseOperations)Ú
aggregatesÚfields)ÚCol)Útimezone)Ú
parse_dateÚparse_datetimeÚ
parse_time)Úduration_microseconds)Úcached_propertyc                   sV  e Zd ZdZdd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d%d&„ Zd'd(„ Zd)d*„ Zed+d,„ ƒZdNd.d/„Zd0d1„ Zd2d3„ Z‡ fd4d5„Zd6d7„ Zd8d9„ Z d:d;„ Z!d<d=„ Z"d>d?„ Z#d@dA„ Z$dBdC„ Z%‡ fdDdE„Z&dFdG„ Z'dHdI„ Z(dJdK„ Z)dO‡ fdLdM„	Z*‡  Z+S )PÚDatabaseOperationsÚtextZTEXT)Ú	DateFieldÚDateTimeFieldzEXPLAIN QUERY PLANc             C   s:   t |ƒdkrdS t |ƒdkr.| jjjt |ƒ S t |ƒS dS )zà
        SQLite has a compile-time default (SQLITE_LIMIT_VARIABLE_NUMBER) of
        999 variables per query.

        If there's only a single field to insert, the limit is 500
        (SQLITE_MAX_COMPOUND_SELECT).
        é   iô  N)ÚlenÚ
connectionÚfeaturesZmax_query_params)Úselfr	   Úobjs© r   úG/tmp/pip-build-78s3knkw/Django/django/db/backends/sqlite3/operations.pyÚbulk_batch_size   s
    z"DatabaseOperations.bulk_batch_sizec             C   sœ   t jt jt jf}tjtjtjtjf}t	||ƒrtxD|j
ƒ D ]8}y
|j}W n tk
rZ   Y q8X t	||ƒr8tjdƒ‚q8W t	|tjƒr˜t|jƒdkr˜tjdƒ‚d S )Nz{You cannot use Sum, Avg, StdDev, and Variance aggregations on date/time fields in sqlite3 since date/time is saved as text.r   zTSQLite doesn't support DISTINCT on aggregate functions accepting multiple arguments.)r	   r   r   Ú	TimeFieldr   ZSumZAvgZVarianceZStdDevÚ
isinstanceZget_source_expressionsÚoutput_fieldr   r   ZNotSupportedErrorZ	Aggregater   Zsource_expressions)r   Ú
expressionZ
bad_fieldsZbad_aggregatesÚexprr    r   r   r   Úcheck_expression_support*   s    



z+DatabaseOperations.check_expression_supportc             C   s   d|j ƒ |f S )zè
        Support EXTRACT with a user-defined function django_date_extract()
        that's registered in connect(). Use single quotes because this is a
        string and could otherwise cause a collision with a field name.
        zdjango_date_extract('%s', %s))Úlower)r   Úlookup_typeÚ
field_namer   r   r   Údate_extract_sqlB   s    z#DatabaseOperations.date_extract_sqlc             C   s   t t|ƒƒS )N)Ústrr   )r   Ú	timedeltar   r   r   Údate_interval_sqlJ   s    z$DatabaseOperations.date_interval_sqlc             C   s   |S )z>Do nothing since formatting is handled in the custom function.r   )r   Úsqlr   r   r   Úformat_for_duration_arithmeticM   s    z1DatabaseOperations.format_for_duration_arithmeticc             C   s   d|j ƒ |f S )Nzdjango_date_trunc('%s', %s))r$   )r   r%   r&   r   r   r   Údate_trunc_sqlQ   s    z!DatabaseOperations.date_trunc_sqlc             C   s   d|j ƒ |f S )Nzdjango_time_trunc('%s', %s))r$   )r   r%   r&   r   r   r   Útime_trunc_sqlT   s    z!DatabaseOperations.time_trunc_sqlc             C   s   t jrd| d| jj fS dS )Nz'%s'ÚNULL)r/   r/   )r   ÚUSE_TZr   Ztimezone_name)r   Útznamer   r   r   Ú_convert_tznames_to_sqlW   s    z*DatabaseOperations._convert_tznames_to_sqlc             C   s   d|f| j |ƒ˜ S )Nz%django_datetime_cast_date(%s, %s, %s))r2   )r   r&   r1   r   r   r   Údatetime_cast_date_sql\   s    z)DatabaseOperations.datetime_cast_date_sqlc             C   s   d|f| j |ƒ˜ S )Nz%django_datetime_cast_time(%s, %s, %s))r2   )r   r&   r1   r   r   r   Údatetime_cast_time_sqla   s    z)DatabaseOperations.datetime_cast_time_sqlc             C   s   d|j ƒ |f| j|ƒ˜ S )Nz)django_datetime_extract('%s', %s, %s, %s))r$   r2   )r   r%   r&   r1   r   r   r   Údatetime_extract_sqlf   s    z'DatabaseOperations.datetime_extract_sqlc             C   s   d|j ƒ |f| j|ƒ˜ S )Nz'django_datetime_trunc('%s', %s, %s, %s))r$   r2   )r   r%   r&   r1   r   r   r   Údatetime_trunc_sqlk   s    z%DatabaseOperations.datetime_trunc_sqlc             C   s   d|j ƒ |f S )Nzdjango_time_extract('%s', %s))r$   )r   r%   r&   r   r   r   Útime_extract_sqlp   s    z#DatabaseOperations.time_extract_sqlc             C   s   dS )Nr/   r   )r   r   r   r   Úpk_default_values   s    z#DatabaseOperations.pk_default_valuec          
   C   s”   d}t |ƒ|krPf }x6tdt |ƒ|ƒD ]"}|||| … }|| j|ƒ7 }q&W |S ddjdgt |ƒ ƒ }| jjjƒ }z|j||ƒjƒ S |jƒ  X dS )zV
        Only for last_executed_query! Don't use this to execute SQL queries!
        iç  r   zSELECT z, zQUOTE(?)N)	r   ÚrangeÚ%_quote_params_for_last_executed_queryÚjoinr   ÚcursorÚexecuteZfetchoneÚclose)r   ÚparamsZ
BATCH_SIZEÚresultsÚindexÚchunkr+   r<   r   r   r   r:   v   s    	z8DatabaseOperations._quote_params_for_last_executed_queryc             C   sR   |rJt |ttfƒr| j|ƒ}n$t|jƒ ƒ}| j|ƒ}tt||ƒƒ}|| S |S d S )N)r   ÚlistÚtupler:   ÚvaluesÚdictÚzip)r   r<   r+   r?   rE   r   r   r   Úlast_executed_query‘   s    
z&DatabaseOperations.last_executed_queryc             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 )Nr   éÿÿÿÿr   )r   r   r   r   Úno_limit_value¨   s    z!DatabaseOperations.no_limit_valuec          
   C   sB   d}|ddf}| j jƒ � }|j||ƒ}dd„ |jƒ D ƒS Q R X d S )Nz÷
        WITH tables AS (
            SELECT %s name
            UNION
            SELECT sqlite_master.name
            FROM sqlite_master
            JOIN tables ON (sql REGEXP %s || tables.name || %s)
        ) SELECT name FROM tables;
        z(?i)\s+references\s+("|\')?z("|\')?\s*\(c             S   s   g | ]}|d  ‘qS )r   r   )Ú.0Úrowr   r   r   ú
<listcomp>¼   s    z9DatabaseOperations.__references_graph.<locals>.<listcomp>)r   r<   r=   Zfetchall)r   Z
table_nameÚqueryr?   r<   r@   r   r   r   Z__references_graph«   s    	z%DatabaseOperations.__references_graphc             C   s   t dd�| jƒS )Ni   )Úmaxsize)r   Ú%_DatabaseOperations__references_graph)r   r   r   r   Ú_references_graph¾   s    z$DatabaseOperations._references_graphFc                s8   |r$|r$t tj‡ fdd„|D ƒƒƒ}‡ ‡fdd„|D ƒS )Nc             3   s   | ]}ˆ j |ƒV  qd S )N)rV   )rP   Útable)r   r   r   ú	<genexpr>È   s    z/DatabaseOperations.sql_flush.<locals>.<genexpr>c                s2   g | ]*}d ˆj dƒˆj dƒˆjˆ j|ƒƒf ‘qS )z	%s %s %s;ÚDELETEZFROM)ZSQL_KEYWORDZ	SQL_FIELDrM   )rP   rW   )r   Ústyler   r   rR   Ë   s   z0DatabaseOperations.sql_flush.<locals>.<listcomp>)Úsetr   Úfrom_iterable)r   rZ   ZtablesÚ	sequencesZallow_cascader   )r   rZ   r   Ú	sql_flushÄ   s    zDatabaseOperations.sql_flushc             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_expressionzNSQLite backend does not support timezone-aware datetimes when USE_TZ is False.)	Úhasattrr   Úis_awarer   r0   Z
make_naiver   Ú
ValueErrorr(   )r   Úvaluer   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 )Nr_   z5SQLite backend does not support timezone-aware times.)r`   r   ra   rb   r(   )r   rc   r   r   r   Úadapt_timefield_valueâ   s    

z(DatabaseOperations.adapt_timefield_valuec                s    t ƒ j|ƒ}|jjƒ }|dkr,|j| jƒ np|dkrB|j| jƒ nZ|dkrX|j| jƒ nD|dkrr|j| j|ƒƒ n*|dkrˆ|j| j	ƒ n|dkrœ|j| j
ƒ |S )	Nr   r   r   ZDecimalFieldZ	UUIDFieldÚNullBooleanFieldÚBooleanField)rf   rg   )ÚsuperÚget_db_convertersr    Zget_internal_typeÚappendÚconvert_datetimefield_valueÚconvert_datefield_valueÚconvert_timefield_valueÚget_decimalfield_converterÚconvert_uuidfield_valueÚconvert_booleanfield_value)r   r!   Ú
convertersÚinternal_type)Ú	__class__r   r   ri   ð   s    
z$DatabaseOperations.get_db_convertersc             C   sB   |d k	r>t |tjƒst|ƒ}tjr>tj|ƒ r>tj|| jjƒ}|S )N)	r   Údatetimer   r   r0   r   ra   Z
make_awarer   )r   rc   r!   r   r   r   r   rk     s    z.DatabaseOperations.convert_datetimefield_valuec             C   s    |d k	rt |tjƒst|ƒ}|S )N)r   rt   Údater   )r   rc   r!   r   r   r   r   rl   	  s    z*DatabaseOperations.convert_datefield_valuec             C   s    |d k	rt |tjƒst|ƒ}|S )N)r   rt   Útimer   )r   rc   r!   r   r   r   r   rm     s    z*DatabaseOperations.convert_timefield_valuec                sN   t jdd�j‰ t|tƒr>t jdƒj|jj ƒ‰‡ ‡fdd„}n‡ fdd„}|S )Né   )Úprecr   c                s"   | d k	rˆ | ƒj ˆ|jjd�S d S )N)Úcontext)Úquantizer    ry   )rc   r!   r   )Úcreate_decimalÚquantize_valuer   r   Ú	converter  s    z@DatabaseOperations.get_decimalfield_converter.<locals>.converterc                s   | d k	rˆ | ƒS d S )Nr   )rc   r!   r   )r{   r   r   r}      s    )	ÚdecimalÚContextÚcreate_decimal_from_floatr   r
   ÚDecimalÚscalebr    Zdecimal_places)r   r!   r}   r   )r{   r|   r   rn     s    
z-DatabaseOperations.get_decimalfield_converterc             C   s   |d k	rt j|ƒ}|S )N)ÚuuidÚUUID)r   rc   r!   r   r   r   r   ro   %  s    
z*DatabaseOperations.convert_uuidfield_valuec             C   s   |dkrt |ƒS |S )Nr   r   )r   r   )Úbool)r   rc   r!   r   r   r   r   rp   *  s    z-DatabaseOperations.convert_booleanfield_valuec             C   s   dj dd„ |D ƒƒS )Nz UNION ALL c             s   s   | ]}d dj |ƒ V  qdS )z	SELECT %sz, N)r;   )rP   rQ   r   r   r   rX   /  s   z5DatabaseOperations.bulk_insert_sql.<locals>.<genexpr>)r;   )r   r	   Zplaceholder_rowsr   r   r   Úbulk_insert_sql-  s    z"DatabaseOperations.bulk_insert_sqlc                s$   |dkrddj |ƒ S tƒ j||ƒS )Nú^z	POWER(%s)ú,)r;   rh   Úcombine_expression)r   Ú	connectorÚsub_expressions)rs   r   r   r‰   3  s    z%DatabaseOperations.combine_expressionc             C   sF   |d	krt jd| ƒ‚d| g| }t|ƒdkr8tdƒ‚ddj|ƒ S )
Nú+ú-z$Invalid connector for timedelta: %s.z'%s'é   z)Too many params for timedelta operations.zdjango_format_dtdelta(%s)z, )rŒ   r�   )r   ZDatabaseErrorr   rb   r;   )r   rŠ   r‹   Z	fn_paramsr   r   r   Úcombine_duration_expression:  s    z.DatabaseOperations.combine_duration_expressionc             C   s   dS )N)NNr   )r   rr   r   r   r   Úinteger_field_rangeB  s    z&DatabaseOperations.integer_field_rangec       	      C   s@   |\}}|\}}||˜}|dkr0d||f |fS d||f |fS )Nr   zdjango_time_diff(%s, %s)zdjango_timestamp_diff(%s, %s)r   )	r   rr   ÚlhsÚrhsZlhs_sqlZ
lhs_paramsZrhs_sqlZ
rhs_paramsr?   r   r   r   Úsubtract_temporalsF  s    z%DatabaseOperations.subtract_temporalsc                s   |rdS t ƒ j|ƒS )NzINSERT OR IGNORE INTO)rh   Úinsert_statement)r   Zignore_conflicts)rs   r   r   r”   N  s    z#DatabaseOperations.insert_statement)F)F),Ú__name__Ú
__module__Ú__qualname__Z"cast_char_field_without_max_lengthZcast_data_typesZexplain_prefixr   r#   r'   r*   r,   r-   r.   r2   r3   r4   r5   r6   r7   r8   r:   rH   rM   rO   rU   r   rV   r^   rd   re   ri   rk   rl   rm   rn   ro   rp   r†   r‰   r�   r�   r“   r”   Ú__classcell__r   r   )rs   r   r      sP   
r   )rt   r~   rƒ   Ú	functoolsr   Ú	itertoolsr   Zdjango.confr   Zdjango.core.exceptionsr   Z	django.dbr   Z"django.db.backends.base.operationsr   Zdjango.db.modelsr   r	   Zdjango.db.models.expressionsr
   Zdjango.utilsr   Zdjango.utils.dateparser   r   r   Zdjango.utils.durationr   Zdjango.utils.functionalr   r   r   r   r   r   Ú<module>   s   