HEX

File: //usr/lib/python3/dist-packages/django/db/backends/mysql/__pycache__/schema.cpython-310.pyc
o

3�a��@s,ddlmZddlmZGdd�de�ZdS)�)�BaseDatabaseSchemaEditor)�NOT_PROVIDEDcs�eZdZdZdZdZdZdZdZdZ	dZ
d	Zd
ZdZ
dZd
ZdZedd��Ze�fdd��Zdd�Zdd�Zdd�Zdd�Zedd��Z�fdd�Z�fdd �Z�fd!d"�Z�fd#d$�Zd%d&�Z�fd'd(�Z�fd)d*�Z�Z S)+�DatabaseSchemaEditorz+RENAME TABLE %(old_table)s TO %(new_table)szMODIFY %(column)s %(type)s NULLz#MODIFY %(column)s %(type)s NOT NULLzMODIFY %(column)s %(type)sz'MODIFY %(column)s %(type)s%(collation)sz(ALTER COLUMN %(column)s SET DEFAULT NULLz,ALTER TABLE %(table)s DROP COLUMN %(column)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)scCs|jjrdSdS)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/usr/lib/python3/dist-packages/django/db/backends/mysql/schema.py�sql_delete_check sz%DatabaseSchemaEditor.sql_delete_checkcs8|jjr|jjdkrt�jSdS|jjdkrt�jSdS)N)�
��)�r�zCALTER TABLE %(table)s CHANGE %(old_column)s %(new_column)s %(type)s)rr�
mysql_version�super�sql_rename_columnr��	__class__r	r
r)s�z&DatabaseSchemaEditor.sql_rename_columncCsV|j��t|t�r|�dd�}|jj�||jjj�}t|t�r)t|t�r)|��}|S)N�%z%%)	r�ensure_connection�
isinstance�str�replace�escape�encoders�bytes�decode)r�value�quotedr	r	r
�quote_value4s

z DatabaseSchemaEditor.quote_valuecCs$|�|j�}|duo|��|jjvS�N)�db_typer�lower�_limited_data_types)r�fieldr#r	r	r
�_is_limited_data_type>sz*DatabaseSchemaEditor._is_limited_data_typecCs|js|�|�SdS)NF)�$_supports_limited_data_type_defaultsr'�rr&r	r	r
�skip_defaultBs
z!DatabaseSchemaEditor.skip_defaultcCs|�|�r|jjsdSdS)NTF)r'rrr)r	r	r
�skip_default_on_alterGsz*DatabaseSchemaEditor.skip_default_on_altercCs |jjr
|jjdkS|jjdkS)N)rr�)rr�
)rrrrr	r	r
r(Nsz9DatabaseSchemaEditor._supports_limited_data_type_defaultscs(|jjs|jr|�|�rdSt��|�S)Nz(%s))rrr(r'r�_column_default_sqlr)rr	r
r.Vs���z(DatabaseSchemaEditor._column_default_sqlcsft��||�|�|�r/|jdtfvr1|�|�}|�d|�|jj	�|�|j
�d�|g�dSdSdS)Nz%UPDATE %(table)s SET %(column)s = %%s)�table�column)r�	add_fieldr*�defaultr�effective_default�execute�
quote_name�_meta�db_tabler0)r�modelr&r3rr	r
r1as

���zDatabaseSchemaEditor.add_fieldcsZt��||�}|jj�|j��|jj�}|dkr%|r%|��dkr%|j	r%dS|�
|�o,|S)N�InnoDB�
ForeignKeyF)r�_field_should_be_indexedr�
introspection�get_storage_engine�cursorr6r7�get_internal_type�
db_constraintr')rr8r&�create_index�storagerr	r
r;ms���z-DatabaseSchemaEditor._field_should_be_indexedcsb|j�|d�}|��dkr&|j||jgdd�}|s&|�|j||gdd��t�j||g|�R�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.
        rr:T)�index�)�fields�suffix)	r6�	get_fieldr?�_constraint_namesr0r4�_create_index_sqlr�_delete_composed_index)rr8rE�args�first_field�constraint_namesrr	r
rJ|s	�z+DatabaseSchemaEditor._delete_composed_indexcCs|jr	|d7}|S|d7}|S)zt
        Keep the null property of the old field. If it has changed, it will be
        handled separately.
        z NULLz	 NOT NULL)�null)rr&�new_typer	r	r
�_set_field_new_type_null_status�s
�z4DatabaseSchemaEditor._set_field_new_type_null_statusc�|�||�}t��||||�Sr")rPr�_alter_column_type_sql)rr8�	old_field�	new_fieldrOrr	r
rR��z+DatabaseSchemaEditor._alter_column_type_sqlcrQr")rPr�_rename_field_sql)rr/rSrTrOrr	r
rV�rUz&DatabaseSchemaEditor._rename_field_sql)!�__name__�
__module__�__qualname__�sql_rename_table�sql_alter_column_null�sql_alter_column_not_null�sql_alter_column_type�sql_alter_column_collate� sql_alter_column_no_default_null�sql_delete_column�sql_delete_unique�sql_create_column_inline_fk�
sql_delete_fk�sql_delete_index�
sql_create_pk�
sql_delete_pk�sql_create_index�propertyrrr!r'r*r+r(r.r1r;rJrPrRrV�
__classcell__r	r	rr
rsB�



rN)�django.db.backends.base.schemar�django.db.modelsrrr	r	r	r
�<module>s