OwlCyberSecurity - MANAGER
Edit File: schema.cpython-39.pyc
a ���e�% � @ s@ d dl mZ d dlmZmZmZ d dlmZ G dd� de�ZdS )� )�BaseDatabaseSchemaEditor)� NOT_PROVIDED�F�UniqueConstraint)� LOOKUP_SEPc s" e Zd ZdZdZdZdZdZdZdZ dZ d Z d Z d Z d Zd ZdZdZdZedd� �Ze� fdd��Zdd� Zdd� Zdd� Zdd � Zed d � �Z� fd d �Z� fd!d"�Z � fd#d$�Z � fd%d&�Z � fd'd(�Z dd)�d*d+�Z � fd,d-�Z!d.d/� Z"� fd0d1�Z#� fd2d3�Z$d4d5� Z%� fd6d7�Z&� Z'S )8�DatabaseSchemaEditorz+RENAME TABLE %(old_table)s TO %(new_table)sz MODIFY %(column)s %(type)s NULLz#MODIFY %(column)s %(type)s NOT NULLz2MODIFY %(column)s %(type)s%(collation)s%(comment)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)sz?ALTER TABLE %(table)s RENAME INDEX %(old_name)s TO %(new_name)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)sz+ALTER TABLE %(table)s COMMENT = %(comment)sNc C s | j jr dS 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 �`/home/gouroczh/virtualenv/pat/3.9/lib/python3.9/site-packages/django/db/backends/mysql/schema.py�sql_delete_check% s z%DatabaseSchemaEditor.sql_delete_checkc s6 | j jr | j jdkr2t� jS n| j jdkr2t� 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�rRt|t�rR|�� }|S )N�%z%%) r Zensure_connection� isinstance�str�replace�escape�encoders�bytes�decode)r �value�quotedr r r � quote_value9 s �z DatabaseSchemaEditor.quote_valuec C s$ |� | j�}|d uo"|�� | jjv S �N)�db_typer �lowerZ_limited_data_types)r �fieldr% r r r �_is_limited_data_typeE 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_defaultL s z!DatabaseSchemaEditor.skip_defaultc C s | � |�r| jjsdS dS )NTF)r( r r r* r r r �skip_default_on_alterQ s z*DatabaseSchemaEditor.skip_default_on_alterc C s | j jr dS | j jdkS )NT)r r � )r r r r r r r r) X s z9DatabaseSchemaEditor._supports_limited_data_type_defaultsc s( | j js | jr | �|�r dS t� �|�S )Nz(%s))r r r) r( r �_column_default_sqlr* r r r r. _ s ���z(DatabaseSchemaEditor._column_default_sqlc s^ t � �||� | �|�rZ|jd tfvrZ| �|�}| �d| �|jj �| �|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_tabler0 )r �modelr' r3 r r r r1 j s ���z DatabaseSchemaEditor.add_fieldc s@ t |t�r.|�|| �d ur.| j||j|jd� t� �||� d S )N��fields� expressions)r r Z create_sql�_create_missing_fk_indexr9 r: r �remove_constraint)r r7 � constraintr r r r< z s ���z&DatabaseSchemaEditor.remove_constraintc s0 | j |dd� |jD �|jd� t� �||� d S )Nc S s g | ] \}}|�qS r r )�.0� field_name�_r r r � <listcomp>� � z5DatabaseSchemaEditor.remove_index.<locals>.<listcomp>r8 )r; Z fields_ordersr: r � remove_index)r r7 �indexr r r rC � s �z!DatabaseSchemaEditor.remove_indexc sV t � �||�sdS | jj�| j�� |jj�}|dkrJ|�� dkrJ|j rJdS | � |� S )NFZInnoDB� ForeignKey) r �_field_should_be_indexedr � introspectionZget_storage_engine�cursorr5 r6 �get_internal_typeZ db_constraintr( )r r7 r' Zstorager r r rF � s �� ��z-DatabaseSchemaEditor._field_should_be_indexed)r: c s� d}|r|d }n4|rF| j jjrFt|d t�rFt|d jvrF|d j}|sNdS |j�|�}|� � dkr�| j j � |j �� | j � � �6}� fdd�| j j �||jj��� D �}W d � n1 s�0 Y t|�dkr�| �| j||gdd�� dS ) 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 has the FK field as its first field (see https://bugs.mysql.com/bug.php?id=37910). Manually create an implicit FK index to make it possible to remove the composed index. Nr rE c s, g | ]$\}}|d r|d d � kr|�qS )rD �columnsr r )r> �nameZinfodict�r0 r r rA � s �zADatabaseSchemaEditor._create_missing_fk_index.<locals>.<listcomp>� � )r9 �suffix)r �featuresZsupports_expression_indexesr r r rK r5 � get_fieldrI rG Zidentifier_converterr0 rH Zget_constraintsr6 �items�lenr4 Z_create_index_sql)r r7 r9 r: Zfirst_field_nameZ first_fieldrH Zconstraint_namesr rL r r; � s: �� � � � ��$ �z-DatabaseSchemaEditor._create_missing_fk_indexc s$ | j ||d� t� j||g|�R � S )N)r9 )r; r �_delete_composed_index)r r7 r9 �argsr r r rT � s z+DatabaseSchemaEditor._delete_composed_indexc C s |j r|d7 }n|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 s" | � ||�}t� �||||||�S r$ )rX r �_alter_column_type_sql)r r7 � old_field� new_fieldrW Z old_collationZ new_collationr r r rY � s �z+DatabaseSchemaEditor._alter_column_type_sqlc s | � ||�}t� �||||�S r$ )rX r �_rename_field_sql)r r/ rZ r[ rW r r r r\ � s z&DatabaseSchemaEditor._rename_field_sqlc C s dg fS )NrN r )r r7 r[ rW Znew_db_commentr r r �_alter_column_comment_sql� s z.DatabaseSchemaEditor._alter_column_comment_sqlc s t � �|�}d|� �S )Nz COMMENT )r � _comment_sql)r �commentZ comment_sqlr r r r^ � s z!DatabaseSchemaEditor._comment_sql)(�__name__� __module__� __qualname__Zsql_rename_tableZsql_alter_column_nullZsql_alter_column_not_nullZsql_alter_column_typeZ sql_alter_column_no_default_nullZsql_delete_columnZsql_delete_uniqueZsql_create_column_inline_fkZ sql_delete_fkZsql_delete_indexZsql_rename_indexZ sql_create_pkZ sql_delete_pkZsql_create_indexZsql_alter_table_commentZsql_alter_column_comment�propertyr r r# r( r+ r, r) r. r1 r< rC rF r; rT rX rY r\ r] r^ � __classcell__r r r r r sR �� � 2 r N) Z django.db.backends.base.schemar Zdjango.db.modelsr r r Zdjango.db.models.constantsr r r r r r �<module> s