3
W­E^b  ã               @   s,   d dl mZ d dlmZ G dd„ deƒZdS )é    )ÚBaseDatabaseSchemaEditor)ÚNOT_PROVIDEDc                   sÄ   e Zd ZdZdZdZdZdZdZdZ	dZ
d	Zd
ZdZdZdZedd„ ƒZdd„ Zdd„ Zdd„ Zedd„ ƒZ‡ fdd„Z‡ fdd„Z‡ fdd„Z‡ fdd„Zd d!„ Z‡ fd"d#„Z‡ fd$d%„Z‡  ZS )&ÚDatabaseSchemaEditorz+RENAME TABLE %(old_table)s TO %(new_table)szMODIFY %(column)s %(type)s NULLz#MODIFY %(column)s %(type)s NOT NULLzMODIFY %(column)s %(type)sz,ALTER TABLE %(table)s DROP COLUMN %(column)szCALTER TABLE %(table)s CHANGE %(old_column)s %(new_column)s %(type)sz)ALTER TABLE %(table)s DROP INDEX %(name)szY, ADD CONSTRAINT %(name)s FOREIGN KEY (%(column)s) REFERENCES %(to_table)s(%(to_column)s)z/ALTER TABLE %(table)s DROP FOREIGN KEY %(name)sz DROP INDEX %(name)s ON %(table)szGALTER TABLE %(table)s ADD CONSTRAINT %(name)s PRIMARY KEY (%(columns)s)z&ALTER TABLE %(table)s DROP PRIMARY KEYz9CREATE INDEX %(name)s ON %(table)s (%(columns)s)%(extra)sc             C   s   | j jrdS dS )Nz8ALTER TABLE %(table)s DROP CONSTRAINT IF EXISTS %(name)sz)ALTER TABLE %(table)s DROP CHECK %(name)s)Ú
connectionÚmysql_is_mariadb)Úself© r   úA/tmp/pip-build-78s3knkw/Django/django/db/backends/mysql/schema.pyÚsql_delete_check    s    z%DatabaseSchemaEditor.sql_delete_checkc             C   sV   | j jƒ  t|tƒr |jddƒ}| j j j|| j j jƒ}t|tƒrRt|tƒrR|jƒ }|S )Nú%z%%)	r   Zensure_connectionÚ
isinstanceÚstrÚreplaceÚescapeÚencodersÚbytesÚdecode)r   ÚvalueÚquotedr   r   r	   Úquote_value)   s    

z DatabaseSchemaEditor.quote_valuec             C   s$   |j | jƒ}|d k	o"|jƒ | jjkS )N)Údb_typer   ÚlowerZ_limited_data_types)r   Úfieldr   r   r   r	   Ú_is_limited_data_type3   s    z*DatabaseSchemaEditor._is_limited_data_typec             C   s   | j s| j|ƒS dS )NF)Ú$_supports_limited_data_type_defaultsr   )r   r   r   r   r	   Úskip_default7   s    
z!DatabaseSchemaEditor.skip_defaultc             C   s    | j jr| j jdkS | j jdkS )	Né
   é   é   é   r   é   )r   r   r   )r   r   r    )r   r   Zmysql_version)r   r   r   r	   r   <   s    z9DatabaseSchemaEditor._supports_limited_data_type_defaultsc                s*   | j j r| jr| j|ƒrdS tƒ j|ƒS )Nz(%s))r   r   r   r   ÚsuperÚ_column_default_sql)r   r   )Ú	__class__r   r	   r"   D   s
    

z(DatabaseSchemaEditor._column_default_sqlc                s^   t ƒ j||ƒ | j|ƒrZ|jd tfkrZ| j|ƒ}| jd| j|jj	ƒ| j|j
ƒdœ |gƒ d S )Nz%UPDATE %(table)s SET %(column)s = %%s)ÚtableÚcolumn)r!   Ú	add_fieldr   Údefaultr   Úeffective_defaultÚexecuteZ
quote_nameÚ_metaÚdb_tabler%   )r   Úmodelr   r(   )r#   r   r	   r&   O   s    
zDatabaseSchemaEditor.add_fieldc                sZ   t ƒ j||ƒ}| jjj| jjƒ |jjƒ}|dkrJ|rJ|jƒ dkrJ|j	rJdS | j
|ƒ oX|S )NZInnoDBÚ
ForeignKeyF)r!   Ú_field_should_be_indexedr   ZintrospectionZget_storage_engineÚcursorr*   r+   Úget_internal_typeZdb_constraintr   )r   r,   r   Zcreate_indexZstorage)r#   r   r	   r.   [   s    z-DatabaseSchemaEditor._field_should_be_indexedc                s`   |j j|d ƒ}|jƒ dkrL| j||jgdd�}|sL| j| j||gdd�ƒ tƒ j||f|žŽ S )a—  
        MySQL can remove an implicit FK index on a field when that field is
        covered by another index like a unique_together. "covered" here means
        that the more complex index starts like the simpler one.
        http://bugs.mysql.com/bug.php?id=37910 / Django ticket #24757
        We check here before removing the [unique|index]_together if we have to
        recreate a FK index.
        r   r-   T)ÚindexÚ )Úsuffix)	r*   Ú	get_fieldr0   Z_constraint_namesr%   r)   Z_create_index_sqlr!   Ú_delete_composed_index)r   r,   ÚfieldsÚargsZfirst_fieldZconstraint_names)r#   r   r	   r5   j   s    	z+DatabaseSchemaEditor._delete_composed_indexc             C   s   |j r|d7 }n|d7 }|S )zt
        Keep the null property of the old field. If it has changed, it will be
        handled separately.
        z NULLz	 NOT NULL)Únull)r   r   Únew_typer   r   r	   Ú_set_field_new_type_null_statusz   s    
z4DatabaseSchemaEditor._set_field_new_type_null_statusc                s   | j ||ƒ}tƒ j||||ƒS )N)r:   r!   Ú_alter_column_type_sql)r   r,   Ú	old_fieldÚ	new_fieldr9   )r#   r   r	   r;   …   s    z+DatabaseSchemaEditor._alter_column_type_sqlc                s   | j ||ƒ}tƒ j||||ƒS )N)r:   r!   Ú_rename_field_sql)r   r$   r<   r=   r9   )r#   r   r	   r>   ‰   s    z&DatabaseSchemaEditor._rename_field_sql)Ú__name__Ú
__module__Ú__qualname__Zsql_rename_tableZsql_alter_column_nullZsql_alter_column_not_nullZsql_alter_column_typeZsql_delete_columnZsql_rename_columnZsql_delete_uniqueZsql_create_column_inline_fkZsql_delete_fkZsql_delete_indexZsql_create_pkZsql_delete_pkZsql_create_indexÚpropertyr
   r   r   r   r   r"   r&   r.   r5   r:   r;   r>   Ú__classcell__r   r   )r#   r	   r      s2   	
r   N)Zdjango.db.backends.base.schemar   Zdjango.db.modelsr   r   r   r   r   r	   Ú<module>   s   