3
W­E^´1  ã               @   sÀ  d 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 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 yddlZddlZddlZW n. ek
rÞ Z zede ƒ‚W Y ddZ[X nX dd„ Z e ƒ Z!e!d"k �redej" ƒ‚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/m0Z0 ej1j2eej1j3ƒ ej4j5ƒ  dZ6ej1j7e6fdej1j8ƒZ9ej1j:e9ƒ G dd„ deƒZ;G d d!„ d!eƒZdS )#zW
PostgreSQL database backend for Django.

Requires psycopg 2: https://www.psycopg.org/
é    N)Úsettings)ÚImproperlyConfigured)Úconnections)ÚBaseDatabaseWrapper)ÚCursorDebugWrapper)ÚDatabaseError)Úasync_unsafe)Úcached_property)Ú
SafeString)Úget_version_tuplez!Error loading psycopg2 module: %sc              C   s   t jjddƒd } t| ƒS )Nú é   r   )Úpsycopg2Ú__version__Úsplitr   )Úversion© r   úD/tmp/pip-build-78s3knkw/Django/django/db/backends/postgresql/base.pyÚpsycopg2_version    s    r   é   é   é   z8psycopg2_version 2.5.4 or newer is required; you have %sr   )ÚDatabaseClient)ÚDatabaseCreation)ÚDatabaseFeatures)ÚDatabaseIntrospection)ÚDatabaseOperations)ÚDatabaseSchemaEditor)Úutc_tzinfo_factoryi  Ú	INETARRAYc                   s0  e Zd ZdZdZddddddd	d
dddddddddddddddddddœZdddœZddddddddd d!ddddd"œZd#Zd$d%d&d'd(d)d*œZ	e
Z
eZeZeZeZeZeZd+Zd,d-„ Zed.d/„ ƒZd0d1„ Zd2d3„ ZedEd5d6„ƒZed7d8„ ƒZd9d:„ ZdFd;d<„Z d=d>„ Z!e"‡ fd?d@„ƒZ#e$dAdB„ ƒZ%dCdD„ Z&‡  Z'S )GÚDatabaseWrapperÚ
postgresqlZ
PostgreSQLÚserialZ	bigserialZbyteaÚbooleanzvarchar(%(max_length)s)Údateztimestamp with time zonez+numeric(%(max_digits)s, %(decimal_places)s)Úintervalzdouble precisionÚintegerZbigintZinetZsmallintZsmallserialÚtextÚtimeÚuuid)Z	AutoFieldZBigAutoFieldZBinaryFieldZBooleanFieldZ	CharFieldZ	DateFieldZDateTimeFieldZDecimalFieldZDurationFieldZ	FileFieldZFilePathFieldZ
FloatFieldZIntegerFieldZBigIntegerFieldZIPAddressFieldZGenericIPAddressFieldZNullBooleanFieldZOneToOneFieldÚPositiveIntegerFieldÚPositiveSmallIntegerFieldZ	SlugFieldZSmallAutoFieldZSmallIntegerFieldZ	TextFieldZ	TimeFieldZ	UUIDFieldz"%(column)s" >= 0)r*   r+   z= %sz= UPPER(%s)zLIKE %szLIKE UPPER(%s)z~ %sz~* %sz> %sz>= %sz< %sz<= %s)ÚexactZiexactÚcontainsÚ	icontainsÚregexZiregexÚgtZgteÚltZlteÚ
startswithÚendswithÚistartswithÚ	iendswithzKREPLACE(REPLACE(REPLACE({}, E'\\', E'\\\\'), E'%%', E'\\%%'), E'_', E'\\_')zLIKE '%%' || {} || '%%'zLIKE '%%' || UPPER({}) || '%%'zLIKE {} || '%%'zLIKE UPPER({}) || '%%'zLIKE '%%' || {}zLIKE '%%' || UPPER({}))r-   r.   r2   r4   r3   r5   r   c             C   sÐ   | j }|d dkrtdƒ‚t|d p&dƒ| jjƒ krXtd|d t|d ƒ| jjƒ f ƒ‚d|d pddi|d –}|jdd ƒ |d	 r�|d	 |d
< |d r¤|d |d< |d r¸|d |d< |d rÌ|d |d< |S )NÚNAMEÚ zJsettings.DATABASES is improperly configured. Please supply the NAME value.z‡The database name '%s' (%d characters) is longer than PostgreSQL's limit of %d characters. Supply a shorter NAME in settings.DATABASES.ZdatabaseÚpostgresÚOPTIONSÚisolation_levelÚUSERÚuserZPASSWORDÚpasswordZHOSTÚhostZPORTÚport)Úsettings_dictr   ÚlenÚopsZmax_name_lengthÚpop)Úselfr@   Úconn_paramsr   r   r   Úget_connection_params—   s,    

z%DatabaseWrapper.get_connection_paramsc             C   s`   t jf |Ž}| jd }y|d | _W n tk
r@   |j| _Y nX | j|jkr\|j| jd� |S )Nr9   r:   )r:   )ÚDatabaseÚconnectr@   r:   ÚKeyErrorZset_session)rD   rE   Ú
connectionÚoptionsr   r   r   Úget_new_connection·   s    
z"DatabaseWrapper.get_new_connectionc          
   C   s^   | j d krdS | j jdƒ}| j}|rZ||krZ| j jƒ �}|j| jjƒ |gƒ W d Q R X dS dS )NFZTimeZoneT)rJ   Zget_parameter_statusÚtimezone_nameÚcursorÚexecuterB   Zset_time_zone_sql)rD   Zconn_timezone_namerM   rN   r   r   r   Úensure_timezoneÌ   s    
zDatabaseWrapper.ensure_timezonec             C   s.   | j jdƒ | jƒ }|r*| jƒ s*| j jƒ  d S )NÚUTF8)rJ   Zset_client_encodingrP   Zget_autocommitÚcommit)rD   Ztimezone_changedr   r   r   Úinit_connection_state×   s
    z%DatabaseWrapper.init_connection_stateNc             C   s:   |r| j j|d| j jd�}n
| j jƒ }tjr0tnd |_|S )NF)Z
scrollableZwithhold)rJ   rN   Ú
autocommitr   ZUSE_TZr   Ztzinfo_factory)rD   ÚnamerN   r   r   r   Úcreate_cursorà   s
    
zDatabaseWrapper.create_cursorc             C   s~   |  j d7  _ y"ttdƒr$tjƒ }n
tjjƒ }W n tk
rH   d }Y nX |r\tt|ƒƒ}nd}| jdt	j
ƒ j|| j f d�S )Nr   Úcurrent_taskÚsyncz_django_curs_%d_%s_%d)rU   )Ú_named_cursor_idxÚhasattrÚasynciorW   ZTaskÚRuntimeErrorÚstrÚidZ_cursorÚ	threadingÚcurrent_threadÚident)rD   rW   Z
task_identr   r   r   Úchunked_cursorë   s    


zDatabaseWrapper.chunked_cursorc          	   C   s   | j � || j_W d Q R X d S )N)Zwrap_database_errorsrJ   rT   )rD   rT   r   r   r   Ú_set_autocommit  s    zDatabaseWrapper._set_autocommitc             C   s    | j ƒ jdƒ | j ƒ jdƒ dS )zl
        Check constraints by setting them to immediate. Return them to deferred
        afterward.
        zSET CONSTRAINTS ALL IMMEDIATEzSET CONSTRAINTS ALL DEFERREDN)rN   rO   )rD   Ztable_namesr   r   r   Úcheck_constraints  s    z!DatabaseWrapper.check_constraintsc             C   s4   y| j jƒ jdƒ W n tjk
r*   dS X dS d S )NzSELECT 1FT)rJ   rN   rO   rG   ÚError)rD   r   r   r   Ú	is_usable  s
    zDatabaseWrapper.is_usablec                sŠ   t ƒ j}y|jƒ  W np tjtfk
r„   tjdtƒ xHt	j
ƒ D ]<}|jdkr@|jd dkr@| j| jd|jd i–| jd�S q@W Y nX |S )Na8  Normally Django will use a connection to the 'postgres' database to avoid running initialization queries against the production database when it's not needed (for example, when running tests). Django was unable to create a connection to the 'postgres' database and will use the first PostgreSQL database instead.r!   r6   r8   )Úalias)ÚsuperÚ_nodb_connectionZensure_connectionrG   r   ÚWrappedDatabaseErrorÚwarningsÚwarnÚRuntimeWarningr   ÚallÚvendorr@   Ú	__class__rg   )rD   Znodb_connectionrJ   )rp   r   r   ri      s    z DatabaseWrapper._nodb_connectionc          	   C   s   | j ƒ �
 | jjS Q R X d S )N)Ztemporary_connectionrJ   Zserver_version)rD   r   r   r   Ú
pg_version6  s    
zDatabaseWrapper.pg_versionc             C   s
   t || ƒS )N)r   )rD   rN   r   r   r   Úmake_debug_cursor;  s    z!DatabaseWrapper.make_debug_cursor)N)N)(Ú__name__Ú
__module__Ú__qualname__ro   Zdisplay_nameZ
data_typesZdata_type_check_constraintsÚ	operatorsZpattern_escZpattern_opsrG   r   ZSchemaEditorClassr   Zclient_classr   Zcreation_classr   Zfeatures_classr   Zintrospection_classr   Z	ops_classrY   rF   r   rL   rP   rS   rV   rb   rc   rd   rf   Úpropertyri   r	   rq   rr   Ú__classcell__r   r   )rp   r   r    B   s�    	
 
	r    c               @   s   e Zd Zdd„ Zdd„ ZdS )r   c          
   G   s*   | j |ƒ� | jj||f|žŽ S Q R X d S )N)Ú	debug_sqlrN   Úcopy_expert)rD   ÚsqlÚfileÚargsr   r   r   rz   @  s    zCursorDebugWrapper.copy_expertc          
   O   s2   | j d| d�� | jj||f|ž|ŽS Q R X d S )NzCOPY %s TO STDOUT)r{   )ry   rN   Úcopy_to)rD   r|   Útabler}   Úkwargsr   r   r   r~   D  s    zCursorDebugWrapper.copy_toN)rs   rt   ru   rz   r~   r   r   r   r   r   ?  s   r   )r   r   r   )<Ú__doc__r[   r_   rk   Zdjango.confr   Zdjango.core.exceptionsr   Z	django.dbr   Zdjango.db.backends.base.baser   Zdjango.db.backends.utilsr   ZBaseCursorDebugWrapperZdjango.db.utilsr   rj   Zdjango.utils.asyncior   Zdjango.utils.functionalr	   Zdjango.utils.safestringr
   Zdjango.utils.versionr   r   rG   Zpsycopg2.extensionsZpsycopg2.extrasÚImportErrorÚer   ZPSYCOPG2_VERSIONr   Úclientr   Zcreationr   Úfeaturesr   Zintrospectionr   Ú
operationsr   Zschemar   Úutilsr   Ú
extensionsZregister_adapterÚQuotedStringÚextrasZregister_uuidZINETARRAY_OIDZnew_array_typeÚUNICODEr   Zregister_typer    r   r   r   r   Ú<module>   sR   


 ~