File manager - Edit - /usr/local/CyberCP/lib/python3.10/site-packages/django/db/backends/mysql/__pycache__/schema.cpython-310.pyc
Back
o �h�% � @ 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 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 �R/usr/local/CyberCP/lib/python3.10/site-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_value9 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_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 | jjs dS dS )NTF)r* r r r, r r r �skip_default_on_alterQ s z*DatabaseSchemaEditor.skip_default_on_alterc C s | j jrdS | 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| �|�rdS t� �|�S )Nz(%s))r r r+ r* r �_column_default_sqlr, r r r r0 _ 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_tabler2 )r �modelr) r5 r r r r3 j s ����z DatabaseSchemaEditor.add_fieldc s@ t |t�r|�|| �d ur| j||j|jd� t� �||� d S )N��fields� expressions)r r � create_sql�_create_missing_fk_indexr< r= r �remove_constraint)r r: � 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>� s z5DatabaseSchemaEditor.remove_index.<locals>.<listcomp>r; )r? � fields_ordersr= r � remove_index)r r: �indexr r r rG � s �z!DatabaseSchemaEditor.remove_indexc sV t � �||�s dS | jj�| j�� |jj�}|dkr%|�� dkr%|j r%dS | � |� S )NF�InnoDB� ForeignKey) r �_field_should_be_indexedr � introspection�get_storage_engine�cursorr8 r9 �get_internal_type� db_constraintr* )r r: r) �storager r r rK � s � � z-DatabaseSchemaEditor._field_should_be_indexed)r= c s� d}|r |d }n|r#| j jjr#t|d t�r#t|d jvr#|d j}|s'dS |j�|�}|� � dkrw| j j � |j �� | j � � �}� fdd�| j j �||jj��� D �}W d � n1 s^w Y t|�dkry| �| j||gdd�� dS dS 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 rJ c s, g | ]\}}|d r|d d � kr|�qS )rH �columnsr r )rB �name�infodict�r2 r r rE � s ��zADatabaseSchemaEditor._create_missing_fk_index.<locals>.<listcomp>� � )r< �suffix)r �features�supports_expression_indexesr r r rS r8 � get_fieldrO rL �identifier_converterr2 rN �get_constraintsr9 �items�lenr6 �_create_index_sql)r r: r< r= �first_field_name� first_fieldrN �constraint_namesr rU r r? � s@ �� � � �� � ��z-DatabaseSchemaEditor._create_missing_fk_indexc s$ | j ||d� t� j||g|�R � S )N)r< )r? r �_delete_composed_index)r r: r< �argsr r r rd � 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 s" | � ||�}t� �||||||�S r% )rh r �_alter_column_type_sql)r r: � old_field� new_fieldrg � old_collation� new_collationr r r ri � s �z+DatabaseSchemaEditor._alter_column_type_sqlc s | � ||�}t� �||||�S r% )rh r �_rename_field_sql)r r1 rj rk rg r r r rn � s z&DatabaseSchemaEditor._rename_field_sqlc C s dg fS )NrW r )r r: rk rg �new_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 �comment� comment_sqlr r r rq � s z!DatabaseSchemaEditor._comment_sql)(�__name__� __module__� __qualname__�sql_rename_table�sql_alter_column_null�sql_alter_column_not_null�sql_alter_column_type� sql_alter_column_no_default_null�sql_delete_column�sql_delete_unique�sql_create_column_inline_fk� sql_delete_fk�sql_delete_index�sql_rename_index� sql_create_pk� sql_delete_pk�sql_create_index�sql_alter_table_comment�sql_alter_column_comment�propertyr r r$ r* r- r. r+ r0 r3 r@ rG rK r? rd rh ri rn rp rq � __classcell__r r r r r sT �� � 2 r N) � django.db.backends.base.schemar �django.db.modelsr r r �django.db.models.constantsr r r r r r �<module> s
| ver. 1.4 |
Github
|
.
| PHP 8.2.28 | Generation time: 0.02 |
proxy
|
phpinfo
|
Settings