3
W­E^r!  ã               @   sÎ   d dl Z d dlZd dlZ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 ejdƒZG dd„ dƒZG d	d
„ d
eƒ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S )é    N)Úcontextmanager)Úsettings)ÚNotSupportedError)Úutczdjango.db.backendsc               @   sx   e Zd Zdd„ ZeddddgƒZdd„ Zd	d
„ Zdd„ Zdd„ Z	ddd„Z
ddd„Zdd„ Zdd„ Zdd„ Zdd„ ZdS )ÚCursorWrapperc             C   s   || _ || _d S )N)ÚcursorÚdb)Úselfr   r   © r
   ú:/tmp/pip-build-78s3knkw/Django/django/db/backends/utils.pyÚ__init__   s    zCursorWrapper.__init__ZfetchoneZ	fetchmanyZfetchallZnextsetc             C   s*   t | j|ƒ}|tjkr"| jj|ƒS |S d S )N)Úgetattrr   r   ÚWRAP_ERROR_ATTRSr   Úwrap_database_errors)r	   ÚattrZcursor_attrr
   r
   r   Ú__getattr__   s    
zCursorWrapper.__getattr__c          	   c   s$   | j j� | jE d H  W d Q R X d S )N)r   r   r   )r	   r
   r
   r   Ú__iter__   s    
zCursorWrapper.__iter__c             C   s   | S )Nr
   )r	   r
   r
   r   Ú	__enter__"   s    zCursorWrapper.__enter__c             C   s,   y| j ƒ  W n | jjjk
r&   Y nX d S )N)Úcloser   ZDatabaseÚError)r	   ÚtypeÚvalueÚ	tracebackr
   r
   r   Ú__exit__%   s    zCursorWrapper.__exit__Nc             C   sˆ   |d k	r| j jj rtdƒ‚| j jƒ  | j j�P |d krL|d krL| jj|ƒS |d krb| jj||ƒS |phf }| jj|||ƒS W d Q R X d S )NzKKeyword parameters for callproc are not supported on this database backend.)r   ÚfeaturesZsupports_callproc_kwargsr   Úvalidate_no_broken_transactionr   r   Úcallproc)r	   ZprocnameÚparamsZkparamsr
   r
   r   r   1   s    

zCursorWrapper.callprocc             C   s   | j ||d| jd�S )NF)ÚmanyÚexecutor)Ú_execute_with_wrappersÚ_execute)r	   Úsqlr   r
   r
   r   ÚexecuteC   s    zCursorWrapper.executec             C   s   | j ||d| jd�S )NT)r   r   )r    Ú_executemany)r	   r"   Ú
param_listr
   r
   r   ÚexecutemanyF   s    zCursorWrapper.executemanyc             C   s<   | j | dœ}x t| j jƒD ]}tj||ƒ}qW |||||ƒS )N)Ú
connectionr   )r   ÚreversedZexecute_wrappersÚ	functoolsÚpartial)r	   r"   r   r   r   ÚcontextÚwrapperr
   r
   r   r    I   s    z$CursorWrapper._execute_with_wrappersc          
   G   sD   | j jƒ  | j j�( |d kr(| jj|ƒS | jj||ƒS W d Q R X d S )N)r   r   r   r   r#   )r	   r"   r   Úignored_wrapper_argsr
   r
   r   r!   O   s
    

zCursorWrapper._executec          
   G   s,   | j jƒ  | j j� | jj||ƒS Q R X d S )N)r   r   r   r   r&   )r	   r"   r%   r-   r
   r
   r   r$   X   s    

zCursorWrapper._executemany)NN)N)Ú__name__Ú
__module__Ú__qualname__r   Ú	frozensetr   r   r   r   r   r   r#   r&   r    r!   r$   r
   r
   r
   r   r      s   

	r   c                   s8   e Zd Zd	‡ fdd„	Z‡ fdd„Zed
dd„ƒZ‡  ZS )ÚCursorDebugWrapperNc          
      s*   | j ||dd�� tƒ j||ƒS Q R X d S )NT)Úuse_last_executed_query)Ú	debug_sqlÚsuperr#   )r	   r"   r   )Ú	__class__r
   r   r#   b   s    zCursorDebugWrapper.executec          
      s*   | j ||dd�� tƒ j||ƒS Q R X d S )NT)r   )r4   r5   r&   )r	   r"   r%   )r6   r
   r   r&   f   s    zCursorDebugWrapper.executemanyFc       	      c   s´   t jƒ }z
d V  W d t jƒ }|| }|r<| jjj| j||ƒ}y|rJt|ƒnd}W n tk
rh   d}Y nX | jjj	|r‚d||f n|d| dœƒ t
jd||||||dœd� X d S )	NÚ ú?z%s times: %sz%.3f)r"   Útimez(%.3f) %s; args=%s)Údurationr"   r   )Úextra)r9   Ú	monotonicr   ÚopsZlast_executed_queryr   ÚlenÚ	TypeErrorZqueries_logÚappendÚloggerÚdebug)	r	   r"   r   r3   r   ÚstartÚstopr:   Útimesr
   r
   r   r4   j   s(    

zCursorDebugWrapper.debug_sql)N)NNFF)r.   r/   r0   r#   r&   r   r4   Ú__classcell__r
   r
   )r6   r   r2   ^   s   r2   c             C   s   | rt jtt| jdƒƒŽ S d S )Nú-)ÚdatetimeÚdateÚmapÚintÚsplit)Úsr
   r
   r   Útypecast_dateŠ   s    rN   c             C   s`   | sd S | j dƒ\}}}d|kr0|j dƒ\}}nd}tjt|ƒt|ƒt|ƒt|d d d… ƒƒS )Nú:Ú.Ú0Ú000000é   )rL   rH   r9   rK   )rM   ÚhourÚminutesÚsecondsÚmicrosecondsr
   r
   r   Útypecast_timeŽ   s    rX   c       	      C   sð   | sd S d| krt | ƒS | jƒ \}}d|kr>|jddƒ\}}nd|krV|jddƒ\}}|jdƒ}|jdƒ}|d }d|krŠ|jdƒ\}}nd}tjr˜tnd }tjt|d	 ƒt|d ƒt|d ƒt|d	 ƒt|d ƒt|ƒt|d
 d d… ƒ|ƒS )Nú rG   é   ú+rO   é   rP   rQ   r   rR   rS   )rN   rL   r   ZUSE_TZr   rH   rK   )	rM   ÚdÚtÚ_ÚdatesrE   rV   rW   Útzinfor
   r
   r   Útypecast_timestamp™   s(    

rb   c             C   sF   y| j dƒ\}}W n tk
r0   d|  }}Y nX |jdƒ|jdƒfS )z´
    Split a SQL identifier into a two element tuple of (namespace, name).

    The identifier could be a table, column, or sequence name might be prefixed
    by a namespace.
    z"."r7   ú")rL   Ú
ValueErrorÚstrip)Ú
identifierÚ	namespaceÚnamer
   r
   r   Úsplit_identifier¹   s
    ri   é   c             C   sV   t | ƒ\}}|dks t|ƒ|kr$| S t||d�}d|r>d| nd|d|| … |f S )zÍ
    Shorten a SQL identifier to a repeatable mangled version with the given
    length.

    If a quote stripped name contains a namespace, e.g. USERNAME"."TABLE,
    truncate the table portion only.
    N)Úlengthz%s%s%sz%s"."r7   )ri   r>   Únames_digest)rf   rk   Zhash_lenrg   rh   Údigestr
   r
   r   Útruncate_nameÇ   s
    rn   c             G   s4   t jƒ }x|D ]}|j|jƒ ƒ qW |jƒ d| … S )zk
    Generate a 32-bit digest of a set of arguments that can be used to shorten
    identifying names.
    N)ÚhashlibÚmd5ÚupdateÚencodeÚ	hexdigest)rk   ÚargsÚhÚargr
   r
   r   rl   Ø   s    
rl   c             C   sl   | dkrdS t jƒ jƒ }|dk	r&||_|dk	rL| jt jdƒj| ƒ|d�} nd|jt j< |j	| ƒ} dj
| ƒS )zc
    Format a number into a string with the requisite number of digits and
    decimal places.
    NrZ   )r+   z{:f})ÚdecimalÚ
getcontextÚcopyÚprecÚquantizeÚDecimalÚscalebZtrapsÚRoundedÚcreate_decimalÚformat)r   Z
max_digitsZdecimal_placesr+   r
   r
   r   Úformat_numberã   s    
r�   c             C   s(   | j dƒo| jdƒ}|r$| dd… S | S )zÆ
    Strip quotes off of quoted table names to make them safe for use in index
    names, sequence names, etc. For example '"USER"."TABLE"' (an Oracle naming
    scheme) becomes 'USER"."TABLE'.
    rc   rZ   éÿÿÿÿ)Ú
startswithÚendswith)Z
table_nameZ
has_quotesr
   r
   r   Ústrip_quotesõ   s    r…   )Nrj   )rH   rw   r)   ro   Úloggingr9   Ú
contextlibr   Zdjango.confr   Zdjango.db.utilsr   Zdjango.utils.timezoner   Ú	getLoggerrA   r   r2   rN   rX   rb   ri   rn   rl   r�   r…   r
   r
   r
   r   Ú<module>   s(   
N, 
