|
Server : Apache System : Linux iad1-shared-b8-43 6.6.49-grsec-jammy+ #10 SMP Thu Sep 12 23:23:08 UTC 2024 x86_64 User : dh_edsupp ( 6597262) PHP Version : 8.2.26 Disable Function : NONE Directory : /lib/python3/dist-packages/django/db/backends/mysql/__pycache__/ |
Upload File : |
o
3�a� � @ s, d dl mZ d dlmZ G dd� de�ZdS )� )�BaseDatabaseSchemaEditor)� NOT_PROVIDEDc s� e Zd ZdZdZdZdZdZdZdZ dZ
d Z d
Z d Z
d Zd
ZdZedd� �Ze� fdd��Zdd� Zdd� Zdd� Zdd� Zedd � �Z� fd d �Z� fd d �Z� fd!d"�Z� fd#d$�Z d%d&� Z � fd'd(�Z � fd)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 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)sc C s | j jrdS dS )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 s z%DatabaseSchemaEditor.sql_delete_checkc s8 | j jr| j jdkrt� jS dS | j jdkrt� jS dS )N)�
� � )� r � zCALTER TABLE %(table)s CHANGE %(old_column)s %(new_column)s %(type)s)r r �
mysql_version�super�sql_rename_columnr �� __class__r r
r ) s �z&DatabaseSchemaEditor.sql_rename_columnc C sV | j �� t|t�r|�dd�}| j j �|| j j j�}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_value4 s
z DatabaseSchemaEditor.quote_valuec C s$ |� | j�}|d uo|�� | jjv S �N)�db_typer �lower�_limited_data_types)r �fieldr# r r r
�_is_limited_data_type> s z*DatabaseSchemaEditor._is_limited_data_typec C s | j s| �|�S dS )NF)�$_supports_limited_data_type_defaultsr' �r r& r r r
� skip_defaultB s
z!DatabaseSchemaEditor.skip_defaultc C s | � |�r | jjs dS dS )NTF)r' r r r) r r r
�skip_default_on_alterG s z*DatabaseSchemaEditor.skip_default_on_alterc C s | j jr
| j jdkS | j jdkS )N)r r � )r r �
)r r r r r r r
r( N s z9DatabaseSchemaEditor._supports_limited_data_type_defaultsc s( | j js| jr| �|�rdS t� �|�S )Nz(%s))r r r( r' r �_column_default_sqlr) r r r
r. V s ��� z(DatabaseSchemaEditor._column_default_sqlc sf t � �||� | �|�r/|jd tfvr1| �|�}| �d| �|jj �| �|j
�d� |g� d S d S d S )Nz%UPDATE %(table)s SET %(column)s = %%s)�table�column) r � add_fieldr* �defaultr �effective_default�execute�
quote_name�_meta�db_tabler0 )r �modelr& r3 r r r
r1 a s
���z DatabaseSchemaEditor.add_fieldc sZ t � �||�}| jj�| j�� |jj�}|dkr%|r%|�� dkr%|j r%dS | �
|� o,|S )N�InnoDB�
ForeignKeyF) r �_field_should_be_indexedr �
introspection�get_storage_engine�cursorr6 r7 �get_internal_type�
db_constraintr' )r r8 r& � create_index�storager r r
r; m s �� �z-DatabaseSchemaEditor._field_should_be_indexedc sb |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.
r r: T)�index� )�fields�suffix) r6 � get_fieldr? �_constraint_namesr0 r4 �_create_index_sqlr �_delete_composed_index)r r8 rE �args� first_field�constraint_namesr r r
rJ | s �z+DatabaseSchemaEditor._delete_composed_indexc C s |j r |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)r r& �new_typer r r
� _set_field_new_type_null_status� s
�z4DatabaseSchemaEditor._set_field_new_type_null_statusc � | � ||�}t� �||||�S r" )rP r �_alter_column_type_sql)r r8 � old_field� new_fieldrO r r r
rR � � z+DatabaseSchemaEditor._alter_column_type_sqlc rQ r" )rP r �_rename_field_sql)r r/ rS rT rO r r r
rV � rU z&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�propertyr r r! r' r* r+ r( r. r1 r; rJ rP rR rV �
__classcell__r r r r
r sB �
r N)� django.db.backends.base.schemar �django.db.modelsr r r r r r
�<module> s