3
W­E^a8  ã               @   sX  d 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 yddlZW n, ek
rŒ Z zedƒe‚W Y ddZ[X nX 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 ddlmZ ddlm Z  ddl!m"Z" ddl#m$Z$ ej%Z&e&dk �redej' ƒ‚eej(ej)i–Z*ej+dƒZ,G dd„ dƒZ-G dd„ de	ƒZ.dS )za
MySQL database backend for Django.

Requires mysqlclient: https://pypi.org/project/mysqlclient/
é    N)ÚImproperlyConfigured)Úutils)ÚBaseDatabaseWrapper)Úasync_unsafe)Úcached_propertyz:Error loading MySQLdb module.
Did you install mysqlclient?)ÚCLIENTÚ
FIELD_TYPE)Úconversionsé   )ÚDatabaseClient)ÚDatabaseCreation)ÚDatabaseFeatures)ÚDatabaseIntrospection)ÚDatabaseOperations)ÚDatabaseSchemaEditor)ÚDatabaseValidationé   é   z5mysqlclient 1.3.13 or newer is required; you have %s.z(\d{1,2})\.(\d{1,2})\.(\d{1,2})c               @   s>   e Zd ZdZdZdd„ Zdd	d
„Zdd„ Zdd„ Zdd„ Z	dS )ÚCursorWrappera6  
    A thin wrapper around MySQLdb's normal cursor class that catches particular
    exception instances and reraises them with the correct types.

    Implemented as a wrapper, rather than a subclass, so that it isn't stuck
    to the particular underlying representation returned by Connection.cursor().
    é  éš  éë  é¹  c             C   s
   || _ d S )N)Úcursor)Úselfr   © r   ú?/tmp/pip-build-78s3knkw/Django/django/db/backends/mysql/base.pyÚ__init__D   s    zCursorWrapper.__init__Nc             C   sZ   y| j j||ƒS  tjk
rT } z(|jd | jkrBtjt|jƒŽ ‚‚ W Y d d }~X nX d S )Nr   )	r   ÚexecuteÚDatabaseÚOperationalErrorÚargsÚcodes_for_integrityerrorr   ÚIntegrityErrorÚtuple)r   Úqueryr!   Úer   r   r   r   G   s    zCursorWrapper.executec             C   sZ   y| j j||ƒS  tjk
rT } z(|jd | jkrBtjt|jƒŽ ‚‚ W Y d d }~X nX d S )Nr   )	r   Úexecutemanyr   r    r!   r"   r   r#   r$   )r   r%   r!   r&   r   r   r   r'   R   s    zCursorWrapper.executemanyc             C   s   t | j|ƒS )N)Úgetattrr   )r   Úattrr   r   r   Ú__getattr__\   s    zCursorWrapper.__getattr__c             C   s
   t | jƒS )N)Úiterr   )r   r   r   r   Ú__iter___   s    zCursorWrapper.__iter__)r   r   r   r   )N)
Ú__name__Ú
__module__Ú__qualname__Ú__doc__r"   r   r   r'   r*   r,   r   r   r   r   r   5   s      

r   c               @   sF  e 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dQZddd dd!d"d#d$d d ddd%œZd&Zd'd(d)d*d+d,d-œZd.d/d0d1hZ	e
Z
eZeZeZeZeZeZeZd2d3„ Zed4d5„ ƒZd6d7„ ZedRd9d:„ƒZd;d<„ Zd=d>„ Zd?d@„ Z dAdB„ Z!dSdCdD„Z"dEdF„ Z#e$dGdH„ ƒZ%e$dIdJ„ ƒZ&e$dKdL„ ƒZ'e$dMdN„ ƒZ(e$dOdP„ ƒZ)d8S )TÚDatabaseWrapperZmysqlzinteger AUTO_INCREMENTzbigint AUTO_INCREMENTÚlongblobÚboolzvarchar(%(max_length)s)Údatezdatetime(6)z+numeric(%(max_digits)s, %(decimal_places)s)Zbigintzdouble precisionÚintegerzchar(15)zchar(39)zinteger UNSIGNEDzsmallint UNSIGNEDzsmallint AUTO_INCREMENTZsmallintÚlongtextztime(6)zchar(32))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	UUIDFieldÚtinyblobÚblobÚ
mediumblobÚtinytextÚtextÚ
mediumtextÚjsonz= %szLIKE %szLIKE BINARY %sz> %sz>= %sz< %sz<= %s)ÚexactZiexactÚcontainsÚ	icontainsÚgtZgteÚltZlteÚ
startswithÚendswithÚistartswithÚ	iendswithzCREPLACE(REPLACE(REPLACE({}, '\\', '\\\\'), '%%', '\%%'), '_', '\_')z"LIKE BINARY CONCAT('%%', {}, '%%')zLIKE CONCAT('%%', {}, '%%')zLIKE BINARY CONCAT({}, '%%')zLIKE CONCAT({}, '%%')zLIKE BINARY CONCAT('%%', {})zLIKE CONCAT('%%', {}))rA   rB   rE   rG   rF   rH   zread uncommittedzread committedzrepeatable readZserializablec             C   s  t ddœ}| j}|d r$|d |d< |d r8|d |d< |d rL|d |d< |d	 jd
ƒrh|d	 |d< n|d	 r||d	 |d< |d r”t|d ƒ|d< tj|d< |d jƒ }|jddƒ}|rò|jƒ }|| j	kròt
d|djdd„ t| j	ƒD ƒƒf ƒ‚|| _|j|ƒ |S )NÚutf8)ÚconvÚcharsetÚUSERÚuserÚNAMEÚdbZPASSWORDÚpasswdZHOSTú/Zunix_socketÚhostZPORTÚportZclient_flagÚOPTIONSÚisolation_levelzread committedzKInvalid transaction isolation level '%s' specified.
Use one of %s, or None.z, c             s   s   | ]}d | V  qdS )z'%s'Nr   )Ú.0Úsr   r   r   ú	<genexpr>á   s    z8DatabaseWrapper.get_connection_params.<locals>.<genexpr>)Údjango_conversionsÚsettings_dictrE   Úintr   Z
FOUND_ROWSÚcopyÚpopÚlowerÚisolation_levelsr   ÚjoinÚsortedrU   Úupdate)r   ÚkwargsrZ   ÚoptionsrU   r   r   r   Úget_connection_paramsÂ   s8    

 
z%DatabaseWrapper.get_connection_paramsc             C   s   t jf |ŽS )N)r   Úconnect)r   Zconn_paramsr   r   r   Úget_new_connectionç   s    z"DatabaseWrapper.get_new_connectionc          
   C   s\   g }| j jr|jdƒ | jr0|jd| jjƒ  ƒ |rX| jƒ �}|jdj|ƒƒ W d Q R X d S )NzSET SQL_AUTO_IS_NULL = 0z*SET SESSION TRANSACTION ISOLATION LEVEL %sz; )ÚfeaturesZis_sql_auto_is_null_enabledÚappendrU   Úupperr   r   r`   )r   Zassignmentsr   r   r   r   Úinit_connection_stateë   s    

z%DatabaseWrapper.init_connection_stateNc             C   s   | j jƒ }t|ƒS )N)Ú
connectionr   r   )r   Únamer   r   r   r   Úcreate_cursorû   s    
zDatabaseWrapper.create_cursorc             C   s*   yt j| ƒ W n tjk
r$   Y nX d S )N)r   Ú	_rollbackr   ZNotSupportedError)r   r   r   r   ro      s    zDatabaseWrapper._rollbackc          	   C   s"   | j � | jj|ƒ W d Q R X d S )N)Zwrap_database_errorsrl   Ú
autocommit)r   rp   r   r   r   Ú_set_autocommit  s    zDatabaseWrapper._set_autocommitc             C   s   | j ƒ jdƒ dS )z¿
        Disable foreign key checks, primarily for use in adding rows with
        forward references. Always return True to indicate constraint checks
        need to be re-enabled.
        zSET foreign_key_checks=0T)r   r   )r   r   r   r   Údisable_constraint_checking
  s    z+DatabaseWrapper.disable_constraint_checkingc             C   s.   d| j  | _ }z| jƒ jdƒ W d|| _ X dS )zM
        Re-enable foreign key checks after they have been disabled.
        FzSET foreign_key_checks=1N)Úneeds_rollbackr   r   )r   rs   r   r   r   Úenable_constraint_checking  s    z*DatabaseWrapper.enable_constraint_checkingc       
      C   sÄ   | j ƒ �²}|dkr| jj|ƒ}x–|D ]Ž}| jj||ƒ}|s<q$| jj||ƒ}xf|D ]^\}}}|jd||||||||f ƒ x4|jƒ D ](}	tjd||	d |||	d ||f ƒ‚q‚W qPW q$W W dQ R X dS )a]  
        Check each table name in `table_names` for rows with invalid foreign
        key references. This method is intended to be used in conjunction with
        `disable_constraint_checking()` and `enable_constraint_checking()`, to
        determine if rows with invalid references were entered while constraint
        checks were off.
        Na0  
                        SELECT REFERRING.`%s`, REFERRING.`%s` FROM `%s` as REFERRING
                        LEFT JOIN `%s` as REFERRED
                        ON (REFERRING.`%s` = REFERRED.`%s`)
                        WHERE REFERRING.`%s` IS NOT NULL AND REFERRED.`%s` IS NULL
                        z–The row in table '%s' with primary key '%s' has an invalid foreign key: %s.%s contains a value '%s' that does not have a corresponding value in %s.%s.r   r
   )	r   ÚintrospectionÚtable_namesZget_primary_key_columnZget_key_columnsr   Zfetchallr   r#   )
r   rv   r   Z
table_nameZprimary_key_column_nameZkey_columnsZcolumn_nameZreferenced_table_nameZreferenced_column_nameZbad_rowr   r   r   Úcheck_constraints  s&    

z!DatabaseWrapper.check_constraintsc             C   s.   y| j jƒ  W n tjk
r$   dS X dS d S )NFT)rl   Zpingr   ÚError)r   r   r   r   Ú	is_usableG  s
    zDatabaseWrapper.is_usablec             C   s   | j r
dS dS )NZMariaDBZMySQL)Úmysql_is_mariadb)r   r   r   r   Údisplay_nameO  s    zDatabaseWrapper.display_namec             C   s   | j jrdddœS i S )Nz`%(column)s` >= 0)r7   r8   )rh   Z!supports_column_check_constraints)r   r   r   r   Údata_type_check_constraintsS  s    z+DatabaseWrapper.data_type_check_constraintsc          	   C   s*   | j ƒ �}|jdƒ |jƒ d S Q R X d S )NzSELECT VERSION()r   )Ztemporary_connectionr   Zfetchone)r   r   r   r   r   Úmysql_server_info\  s    

z!DatabaseWrapper.mysql_server_infoc             C   s4   t j| jƒ}|std| j ƒ‚tdd„ |jƒ D ƒƒS )Nz8Unable to determine MySQL version from version string %rc             s   s   | ]}t |ƒV  qd S )N)r[   )rV   Úxr   r   r   rX   g  s    z0DatabaseWrapper.mysql_version.<locals>.<genexpr>)Úserver_version_reÚmatchr}   Ú	Exceptionr$   Úgroups)r   r€   r   r   r   Úmysql_versionb  s    zDatabaseWrapper.mysql_versionc             C   s   d| j jƒ kS )NZmariadb)r}   r^   )r   r   r   r   rz   i  s    z DatabaseWrapper.mysql_is_mariadb)	r9   r:   r;   r2   r<   r=   r>   r6   r?   )N)N)*r-   r.   r/   ÚvendorZ
data_typesZ_limited_data_typesÚ	operatorsZpattern_escZpattern_opsr_   r   r   ZSchemaEditorClassr   Zclient_classr   Zcreation_classr   Zfeatures_classr   Zintrospection_classr   Z	ops_classr   Zvalidation_classre   r   rg   rk   rn   ro   rq   rr   rt   rw   ry   r   r{   r|   r}   rƒ   rz   r   r   r   r   r1   c   s˜   	 %	
(	r1   )r
   r   r   )/r0   ÚreZdjango.core.exceptionsr   Z	django.dbr   Zdjango.db.backendsZbackend_utilsZdjango.db.backends.base.baser   Zdjango.utils.asyncior   Zdjango.utils.functionalr   ZMySQLdbr   ÚImportErrorÚerrZMySQLdb.constantsr   r   ZMySQLdb.convertersr	   Úclientr   Zcreationr   rh   r   ru   r   Ú
operationsr   Zschemar   Z
validationr   Úversion_infoÚversionÚ__version__ZTIMEZtypecast_timerY   Úcompiler   r   r1   r   r   r   r   Ú<module>   s<   

.