File manager - Edit - /usr/local/CyberPanel/lib/python3.10/site-packages/django/db/backends/base/__pycache__/schema.cpython-310.pyc
Back
o �hd � @ s� d dl Z d dlZd dlmZ d dlmZ d dlmZmZmZm Z m Z m Z d dl m Z mZmZ d dlmZmZ d dlmZ d dlmZmZ d d lmZ e �d �Zd d � Z d d� Z dd� Z G dd� d�Z dS )� N)�datetime)�settings)�Columns� Expressions�ForeignKeyName� IndexName� Statement�Table)� names_digest�split_identifier� truncate_name)� Deferrable�Index)�Query)�TransactionManagementError�atomic)�timezonezdjango.db.backends.schemac C s2 | j }|jrdS |jr|jdgkrdS |j|jv S )zz When altering the given field, must constraints on its model from the given relation be temporarily dropped? FNT)�field� many_to_many� primary_key� to_fields�name)�relation� altered_fieldr � r �T/usr/local/CyberPanel/lib/python3.10/site-packages/django/db/backends/base/schema.py�_is_relevant_relation s r c C s" t | jjddddd�t�d�d�S )NFT)�forward�reverse�include_hidden�include_parentsr )�key)�sorted�_meta� _get_fields�operator� attrgetter��modelr r r �_all_related_fields' s ��r) c # sd � t �fdd�t�j�D �� fdd�t� j�D ��}|D ]\}}||fV t|j|j�E d H q d S )Nc 3 � � | ] }t |� �r|V qd S �N�r ��.0�obj)� old_fieldr r � <genexpr>8 � � � �z+_related_non_m2m_objects.<locals>.<genexpr>c 3 r* r+ r, r- )� new_fieldr r r1 = r2 )�zipr) r( �_related_non_m2m_objects� remote_field)r0 r3 �related_fields�old_rel�new_relr )r3 r0 r r5 4 s � � �� ��r5 c @ sL e Zd ZdZdZdZdZdZdZdZ dZ d Z d Z d Z d ZeZd ZdZdZdZdZdZdZdZeZdZeZdZdZ dZ eZ dZ dZ dZ!dZ"d Z#eZ$d Z%d Z&d Z'd�d"d#�Z(d$d%� Z)d&d'� Z*d�d)d*�Z+d+d,� Z,d-d.� Z-d/d0� Z.d�d1d2�Z/d3d4� Z0d5d6� Z1d7d8� Z2d9d:� Z3e4d;d<� �Z5d=d>� Z6d?d@� Z7dAdB� Z8dCdD� Z9dEdF� Z:dGdH� Z;dIdJ� Z<dKdL� Z=dMdN� Z>dOdP� Z?dQdR� Z@dSdT� ZAdUdV� ZBdWdX� ZCdYdZ� ZDd[d\� ZEd]d^� ZFd�d_d`�ZG d�dadb�ZHdcdd� ZId�dedf�ZJdgdh� ZKdidj� ZLdkdl� ZMdmdn� ZNd�dpdq�ZOd�drds�ZPdtdu� ZQdvdw� ZRdddododd(dd(ddddx� dydz�ZSd�d{d|�ZTd}d~� ZUdd�� ZVd�d�� ZWd�d�� ZXd�d�d��ZYd�d�� ZZd�d�� Z[d�d�� Z\d�d�� Z]d�d�� Z^d�d�� Z_d�d�� Z`d�d�� Za d�d�d��Zb d�d�d��Zcd�d�d��Zd d�d�d��Zed�d�� Zfd�d�� Zgd�d�� Zhd�d�� Zi d�d�d��Zjd�d�d��Zkd�d�� Zld�d�� Zmd�d�d��Znd�d�d��ZodS )��BaseDatabaseSchemaEditorz� This class and its subclasses are responsible for emitting schema-changing statements to the databases - model creation/removal/alteration, field renaming, index fiddling, and so on. z'CREATE TABLE %(table)s (%(definition)s)z1ALTER TABLE %(old_table)s RENAME TO %(new_table)sz7ALTER TABLE %(table)s SET TABLESPACE %(new_tablespace)sz DROP TABLE %(table)s CASCADEz:ALTER TABLE %(table)s ADD COLUMN %(column)s %(definition)sz!ALTER TABLE %(table)s %(changes)sz2ALTER COLUMN %(column)s TYPE %(type)s%(collation)sz%ALTER COLUMN %(column)s DROP NOT NULLz$ALTER COLUMN %(column)s SET NOT NULLz/ALTER COLUMN %(column)s SET DEFAULT %(default)sz$ALTER COLUMN %(column)s DROP DEFAULTz4ALTER TABLE %(table)s DROP COLUMN %(column)s CASCADEzDALTER TABLE %(table)s RENAME COLUMN %(old_column)s TO %(new_column)szFUPDATE %(table)s SET %(column)s = %(default)s WHERE %(column)s IS NULLz"UNIQUE (%(columns)s)%(deferrable)szCHECK (%(check)s)z.ALTER TABLE %(table)s DROP CONSTRAINT %(name)sz"CONSTRAINT %(name)s %(constraint)sz?ALTER TABLE %(table)s ADD CONSTRAINT %(name)s CHECK (%(check)s)zPALTER TABLE %(table)s ADD CONSTRAINT %(name)s UNIQUE (%(columns)s)%(deferrable)sz|ALTER TABLE %(table)s ADD CONSTRAINT %(name)s FOREIGN KEY (%(column)s) REFERENCES %(to_table)s (%(to_column)s)%(deferrable)sNzQCREATE INDEX %(name)s ON %(table)s (%(columns)s)%(include)s%(extra)s%(condition)szOCREATE UNIQUE INDEX %(name)s ON %(table)s (%(columns)s)%(include)s%(condition)sz/ALTER INDEX %(old_name)s RENAME TO %(new_name)szDROP INDEX %(name)szGALTER TABLE %(table)s ADD CONSTRAINT %(name)s PRIMARY KEY (%(columns)s)z DROP PROCEDURE %(procedure)sz)COMMENT ON TABLE %(table)s IS %(comment)sz5COMMENT ON COLUMN %(table)s.%(column)s IS %(comment)sFTc C s, || _ || _| jr g | _| j jjo|| _d S r+ )� connection� collect_sql� collected_sql�features�can_rollback_ddl�atomic_migration)�selfr; r< r r r r �__init__� s z!BaseDatabaseSchemaEditor.__init__c C s( g | _ | jrt| jj�| _| j�� | S r+ )� deferred_sqlr@ r r; �alias� __enter__�rA r r r rE � s z"BaseDatabaseSchemaEditor.__enter__c C s< |d u r| j D ]}| �|� q| jr | j�|||� d S d S r+ )rC �executer@ r �__exit__)rA �exc_type� exc_value� traceback�sqlr r r rH � s �z!BaseDatabaseSchemaEditor.__exit__r c C s� | j s| jjr| jjjstd��t|�}tjd||||d�d� | j rN|� � � d�r,dnd}|durD| j � |t t| j|�� | � dS | j � || � dS | j�� �}|�||� W d � dS 1 sew Y dS )z:Execute the given SQL statement, with optional parameters.ziExecuting DDL statements while in a transaction on databases that can't perform a rollback is prohibited.z%s; (params %r))�paramsrL )�extra�;� N)r< r; �in_atomic_blockr> r? r �str�logger�debug�rstrip�endswithr= �append�tuple�map� quote_value�cursorrG )rA rL rM �endingr[ r r r rG � s. ������ "�z BaseDatabaseSchemaEditor.executec C s | j j�|�S r+ )r; �ops� quote_name)rA r r r r r^ � � z#BaseDatabaseSchemaEditor.quote_namec s� � j jD ]}� fdd�|D �}�j���� |�� qg }g }� j jD ]�}��� |�\}}|du r1q"|j�jd�} | d rE|d�j | 7 }|j �jd�} | rT|d| 7 }|� |� |j r�|j r�|j jj j} |j jj �|j j�j} �jr�|d�j��| ���| �d� 7 }n�jjjr��j���� |d �� |�d ��|j�|f � |�� d v r��jj�� j j|j�} | r��j� | � q"� �fd d�� j jD �}�j ��� j j�d � dd� g |�|�R D ��d� }� j j r��jj� � j j �}|r�|d| 7 }||fS )z-Take a model and return its table definition.c � g | ]}� j �|��qS r �r# � get_field�r. r r' r r � <listcomp>� � z6BaseDatabaseSchemaEditor.table_sql.<locals>.<listcomp>N�r; �check� z %s)�to_table� to_column� _fk_%(to_table)s_%(to_column)sz%s %s)� AutoField� BigAutoField�SmallAutoFieldc s g | ]}|� � ���qS r )�constraint_sql�r. � constraint�r( rA r r rd s ���, c s s � | ] }|rt |�V qd S r+ )rR rp r r r r1 s � � �z5BaseDatabaseSchemaEditor.table_sql.<locals>.<genexpr>)�table� definition) r# �unique_togetherrC rW �_create_unique_sql� local_fields� column_sql� db_parametersr; �sql_check_constraint�db_type_suffix�extendr6 � db_constraintr( �db_tablerb � field_name�column�sql_create_inline_fkr^ r> �supports_foreign_keys�_create_fk_sql�get_internal_typer] � autoinc_sql� constraints�sql_create_table�join� db_tablespace�tablespace_sql)rA r( � field_names�fields� column_sqlsrM r ru � extra_params� db_params�col_type_suffixri rj r� r� rL r� r rr r � table_sql� s� ��� �� ��� � � � ��� z"BaseDatabaseSchemaEditor.table_sqlc c sL � |V |� d� }r| �|�V | jjjr |jr | �|j�V |j}|o2| �|� o2|o1| � |� }|r[| � |�} | d ur[d| � |� } | jjj rS| | � | � V n| V |�| � |jrh|jsh| jjjrhd}|sndV n| jjjsvdV |jr}dV n|jr�dV |jp�|jj} | r�| jjjr�|jr�| jjj| dd�V d S d S d S d S ) N� collationzDEFAULT TzNOT NULL�NULLz PRIMARY KEY�UNIQUE)�inline)�get� _collate_sqlr; r> �supports_comments_inline� db_comment� _comment_sql�null� skip_default�skip_default_on_alter�effective_default�_column_default_sql�requires_literal_defaults�prepare_defaultrW �empty_strings_allowedr �!interprets_empty_strings_as_nulls�implied_column_null�uniquer� r# �supports_tablespacesr] r� ) rA �column_db_typerM r( r �field_db_params�include_defaultr� r� � default_value�column_default� tablespacer r r �_iter_column_sql! sX � �� ��� ��� �z)BaseDatabaseSchemaEditor._iter_column_sqlc C sD |j | jd�}|d }|du rdS g }d�| �||||||��|fS )z� Return the column definition for a field. The field must already have had set_attributes_from_name() called. rf �typeN�NNrh )rz r; r� r� )rA r( r r� r� r� rM r r r ry Z s" �� �z#BaseDatabaseSchemaEditor.column_sqlc C � dS )z� Some backends don't accept default values for certain columns types (i.e. MySQL longtext and longblob). Fr �rA r r r r r� u � z%BaseDatabaseSchemaEditor.skip_defaultc C r� )z� Some backends don't accept default values for certain columns types (i.e. MySQL longtext and longblob) in the ALTER COLUMN statement. Fr r� r r r r� | r� z.BaseDatabaseSchemaEditor.skip_default_on_alterc C s t d��)zU Only used for backends which have requires_literal_defaults feature z�subclasses of BaseDatabaseSchemaEditor for backends which have requires_literal_defaults must provide a prepare_default() method��NotImplementedError�rA �valuer r r r� � s �z(BaseDatabaseSchemaEditor.prepare_defaultc C r� )z� Return the SQL to use in a DEFAULT clause. The resulting string should contain a '%s' placeholder for a default value. �%sr r� r r r r� � r� z,BaseDatabaseSchemaEditor._column_default_sqlc C s� | � � r | �� }|S | js!| jr!| jr!| �� dkr d}|S d}|S t| dd�s-t| dd�rS| �� }|dkr;t�� }|S t �� }|dkrI|� � }|S |d krQ|� � }|S d }|S ) N� BinaryField� rP �auto_nowF� auto_now_add� DateTimeField� DateField� TimeField) � has_default� get_defaultr� �blankr� r� �getattrr �nowr �date�time)r �default� internal_typer r r �_effective_default� s. � � � ���z+BaseDatabaseSchemaEditor._effective_defaultc C s |� | �|�| j�S )z2Return a field's effective database default value.)�get_db_prep_saver� r; r� r r r r� � s z*BaseDatabaseSchemaEditor.effective_defaultc C s t � �)aX Return a quoted version of the value so it's safe to use in an SQL string. This is not safe against injection from user code; it is intended only for use in making SQL scripts or preparing default values for particularly tricky backends (defaults are not user-defined, though, so this is safe). r� r� r r r rZ � s z$BaseDatabaseSchemaEditor.quote_valuec C s� | � |�\}}| �||p d� | jjjrG|jjr!| �|d|jj� | jjjsG|jj D ] }|j rF|j | jd�}|d }| j| � ||||j �� q*| j �| �|�� |jjD ]}|jjjjrc| �|jj� qTdS )zr Create a table and any accompanying indexes or unique constraints for the given `model`. Nrf r� )r� rG r; r> �supports_commentsr# �db_table_comment�alter_db_table_commentr� rx r� rz �_alter_column_comment_sqlrC r} �_model_indexes_sql�local_many_to_manyr6 �through� auto_created� create_model)rA r( rL rM r r� � field_typer r r r� � s0 � ��� ��z%BaseDatabaseSchemaEditor.create_modelc C s~ |j jD ]}|jjj jr| �|jj� q| �| jd| �|j j �i � t | j �D ]}t |t �r<|�|j j �r<| j �|� q(dS )z!Delete a model from the database.rt N)r# r� r6 r� r� � delete_modelrG �sql_delete_tabler^ r �listrC � isinstancer �references_table�remove)rA r( r rL r r r r� � s" ����� ��z%BaseDatabaseSchemaEditor.delete_modelc C s. |j r | jjjs dS | j|�|| �dd� dS )zAdd an index on a model.N�rM )�contains_expressionsr; r> �supports_expression_indexesrG � create_sql�rA r( �indexr r r � add_index� s ��z"BaseDatabaseSchemaEditor.add_indexc C s* |j r | jjjs dS | �|�|| �� dS )z Remove an index from a model.N)r� r; r> r� rG � remove_sqlr� r r r � remove_index� s ��z%BaseDatabaseSchemaEditor.remove_indexc C sF | j jjr| j| �||j|j�d d� d S | �||� | �||� d S )Nr� )r; r> �can_rename_indexrG �_rename_index_sqlr r� r� )rA r( � old_index� new_indexr r r � rename_index s � z%BaseDatabaseSchemaEditor.rename_indexc C s& |� || �}|r| j|dd� dS dS )z Add a constraint to a model.Nr� )r� rG �rA r( rq rL r r r �add_constraint s �z'BaseDatabaseSchemaEditor.add_constraintc C s" |� || �}|r| �|� dS dS )z!Remove a constraint from a model.N)r� rG r� r r r �remove_constraint s �z*BaseDatabaseSchemaEditor.remove_constraintc s| dd� |D �}dd� |D �}|� |�D ]}| �� |ddd�| j� q|� |�D ]}� fdd�|D �}| �| �� |�� q'd S ) z� Deal with a model changing its unique_together. The input unique_togethers must be doubly-nested, not the single-nested ["foo", "bar"] format. c S � h | ]}t |��qS r �rX �r. r� r r r � <setcomp>& � zABaseDatabaseSchemaEditor.alter_unique_together.<locals>.<setcomp>c S r� r r� r� r r r r� ' r� TF)r� r c r` r ra rc r' r r rd 2 re zBBaseDatabaseSchemaEditor.alter_unique_together.<locals>.<listcomp>N)� difference�_delete_composed_index�sql_delete_uniquerG rw )rA r( �old_unique_together�new_unique_together�olds�newsr� r� r r' r �alter_unique_together s ��z.BaseDatabaseSchemaEditor.alter_unique_togetherc s� dd� |D �}dd� |D �}|� |�D ]}| �� |ddd�| j� q|� |�D ]}� fdd�|D �}| �| j� |d d �� q'd S ) z� Deal with a model changing its index_together. The input index_togethers must be doubly-nested, not the single-nested ["foo", "bar"] format. c S r� r r� r� r r r r� ; r� z@BaseDatabaseSchemaEditor.alter_index_together.<locals>.<setcomp>c S r� r r� r� r r r r� < r� TF)r� r� c r` r ra rc r' r r rd G re zABaseDatabaseSchemaEditor.alter_index_together.<locals>.<listcomp>�_idx�r� �suffixN)r� r� �sql_delete_indexrG �_create_index_sql)rA r( �old_index_together�new_index_togetherr� r� r� r� r r' r �alter_index_together5 s ��z-BaseDatabaseSchemaEditor.alter_index_togetherc s� dd� � j jD �}dd� � j jD �}� fdd�|D �}| j� |fd||B i|��}|�d�du rJ|rJ| jjjrJt| j � j j |d d ��} | |v rJ| g}t |�d kr`t d t |�� j j d � |�f ��| �| �|� |d �� d S )Nc S � h | ]}|j �qS r �r rp r r r r� K � �zBBaseDatabaseSchemaEditor._delete_composed_index.<locals>.<setcomp>c S r r r rp r r r r� N � c s g | ] }� j �|�j�qS r )r# rb r� rc r' r r rd O s zCBaseDatabaseSchemaEditor._delete_composed_index.<locals>.<listcomp>�excluder� TF��quote� z1Found wrong number (%s) of constraints for %s(%s)rs r )r# r� �indexes�_constraint_namesr� r; r> �*allows_multiple_constraints_on_same_fieldsrR �_unique_constraint_namer �len� ValueErrorr� rG �_delete_constraint_sql) rA r( r� �constraint_kwargsrL �meta_constraint_names�meta_index_names�columns�constraint_names� default_namer r' r r� J sB ������� ��� z/BaseDatabaseSchemaEditor._delete_composed_indexc C sn ||ks| j jjr|�� |�� krdS | �| j| �|�| �|�d� � | jD ] }t|t �r4|� ||� q'dS )z#Rename the table a model points to.N)� old_table� new_table) r; r> �ignores_table_name_case�lowerrG �sql_rename_tabler^ rC r� r �rename_table_references)rA r( � old_db_table� new_db_tablerL r r r �alter_db_tablel s" ���� ��z'BaseDatabaseSchemaEditor.alter_db_tablec C sF | j r | jjjr!| �| j | �|jj�| �|pd�d� � d S d S d S )NrP )rt �comment) �sql_alter_table_commentr; r> r� rG r^ r# r rZ )rA r( �old_db_table_comment�new_db_table_commentr r r r� s ����z/BaseDatabaseSchemaEditor.alter_db_table_commentc C s2 | � | j| �|jj�| �|�| �|�d� � dS )z)Move a model's table between tablespaces.)rt �old_tablespace�new_tablespaceN)rG �sql_retablespace_tabler^ r# r )rA r( �old_db_tablespace�new_db_tablespacer r r �alter_db_tablespace� s ���z,BaseDatabaseSchemaEditor.alter_db_tablespacec C s@ |j r|jjjjr| �|jj�S | j||dd�\}}|du r dS |j| jd� }r0|d|� �7 }|j | jd�}|d rD|d| j | 7 }|jr�| jj j r�|j r�d}| jr�|jjjj}|jjj�|jj�j} t|jj�\} } |d| j| �|||�| r�d| �| � nd | �|j�| �|�| �| �| jj�� d � 7 }n | j�| �|||�� | j | �|jj�| �|j�|d � } | � | |� | � |�s�| � |�dur�| j |d|dd �\} }| j!| �|jj�| d � } | � | |� |j"�r| jj j#�r| jj j$�s|d }| j | �%||||j"�� | j�&| �'||�� | jj j(�r | j�)� dS dS )z� Create a field on a model. Usually involves adding a column, but may involve adding a table instead (for M2M fields). T)r� Nrf rh rg rk z%s.rP )r � namespacer� ri rj � deferrable)rt r� ru ��drop�rt �changesr� )*r r6 r� r# r� r� ry r| r; rz r{ r> r� r~ �sql_create_column_inline_fkr( r rb r� r� r �_fk_constraint_namer^ r] �deferrable_sqlrC rW r� �sql_create_columnrG r� r� �_alter_column_default_sql�sql_alter_columnr� r� r� r� r} �_field_indexes_sql� connection_persists_old_columns�close)rA r( r ru rM r� r� �constraint_suffixri rj r) �_rL � changes_sqlr� r r r � add_field� s� ��� �� � � � � � � � ��� �� �z"BaseDatabaseSchemaEditor.add_fieldc C s� |j r|jjjjr| �|jj�S |j| jd�d du r dS |jr8| j||j gdd�}|D ] }| � | � ||�� q,| j | � |jj�| � |j �d� }| � |� | jjjrX| j�� t| j�D ]}t|t�rs|�|jj|j �rs| j�|� q]dS )z� Remove a field from a model. Usually involves deleting a column, but for M2Ms may involve deleting a table. rf r� NT�� foreign_key)rt r� )r r6 r� r# r� r� rz r; r r� rG �_delete_fk_sql�sql_delete_columnr^ r r> r6 r7 r� rC r� r �references_columnr� )rA r( r �fk_names�fk_namerL r r r � remove_field� s, � � ��z%BaseDatabaseSchemaEditor.remove_fieldc C s0 | � ||�sdS |j| jd�}|d }|j| jd�}|d }|du r'|jdu s0|du r8|jdu r8td||f ��|du r\|du r\|jjr\|jjr\|jjjjr\|jjjjr\| �||||�S |du rz|du rz|jjrz|jjrz|jjjjsz|jjjjszdS |du s�|du r�td||f ��| � ||||||||� dS )a' Allow a field's type, uniqueness, nullability, default, column, constraints, etc. to be modified. `old_field` is required to compute the necessary changes. If `strict` is True, raise errors if the old column does not match `old_field` precisely. Nrf r� zqCannot alter field %s into %s - they do not properly define db_type (are you using a badly-written custom field?)z�Cannot alter field %s into %s - they are not compatible types (you cannot alter to or from M2M fields, or add or remove through= on M2M fields)) �_field_should_be_alteredrz r; r6 r r� r# r� �_alter_many_to_many� _alter_field) rA r( r0 r3 �strict� old_db_params�old_type� new_db_params�new_typer r r � alter_field sf ���� � ��� � � ���z$BaseDatabaseSchemaEditor.alter_fieldc / C s� t � } | jjjrL|jrL|jrL| j||dhd�rL| j||jgdd�} |r7t | �dkr7t dt | �|j j |jf ��| D ]} | � |jf� | �| �|| �� q9|jr�|jrX| �||�r�dd� |j jD �} | j||jgdd | d �} |r�t | �dkr�t d t | �|j j |jf ��| D ] }| �| �||�� q�|�d �}|�d �}| jjjo�|jr�|jp�|jo�|jo�||kp�||k}|r�t||�D ] \}}| j|j|jjgdd�}|D ] } | �| �|j| �� q�q�|j�r|j�s|jr�|j�rd d� |j jD �}| j||jgdtj |d�}|D ] }| �| � ||�� �q|d |d k�rX|d �rXdd� |j jD �} | j||jgd| d�} |�rIt | �dk�rIt dt | �|j j |jf ��| D ] }| �| � ||�� �qK|j|jk�r�| �| � |j j |||�� | j D ]}t!|t"��r�|�#|j j |j|j� �qog }g }g }|j$| jd�} |j$| jd�} ||k�s�| | k�s�||k�s�| jjj%�r�|j&|j&k�r�| �'||||||�\} } |�(| � |�)| � d } |j*�r�|j*�s�| �+|�}!| �+|�}"| �,|��s�|!|"k�r�|"du�r�d} |�(| �-|||�� |j*|j*k�r| �.|||�} | �r|�(| � |�/� �o |j*�o |j* }#|�s#|�r�|#�s*||7 }| jjj0�rF|�rFt1t2|� �\}}$d�3|�t4|$g �fg}|D ]\}}$| �| j5| �6|j j �|d� |$� �qH|#�r�| �| j7| �6|j j �| �6|j�dd� |"g� |D ]\}}$| �| j5| �6|j j �|d� |$� �q{|�r�|D ] \}}$| �||$� �q�|j�r�|j�s�| �8||� | �9||��r�| �| �:||g�� |j�r�|j�r�|j�r�|j�s�| �| j;||gd�� g }%|�r�|%�)t||�� | �||��r| �| �<||�� |%�)t||�� |%D ]V\}&}|jj=| jd�}'|'d }(|'�d �})|&jj=| jd�}*|*�d �}+| �'|j|&j|j|(|+|)�\} } | �| j5| �6|jj j �| d d� | d � | D ] \}}$| �||$� �qM�q| jjj�r~|j�r~| �sp|j�rp|j�s~|j�r~| �| �>||d �� |�r�|%D ]\},}-|-jj�r�| �| �>|-j|-jd �� �q�|d |d k�r�|d �r�| j?|j j |jgd d �}| �| �@|||d �� | �r�| j-|||dd �\}.}$| j5| �6|j j �|.d� }| �||$� | jjjA�r�| j�B� dS dS )!z3Perform a "physical" (non-ManyToMany) field update.r� )�ignoreTr< r z<Found wrong number (%s) of foreign key constraints for %s.%sc S r r r rp r r r r� v r z8BaseDatabaseSchemaEditor._alter_field.<locals>.<setcomp>F)r� r r z7Found wrong number (%s) of unique constraints for %s.%sr� c S r r r )r. r� r r r r� � r )r� �type_r rg c S r r r rp r r r r� � r )rg r z6Found wrong number (%s) of check constraints for %s.%srf Nrs r- r� )rt r� r� �r� r� r rk �_fk�_check�r� r+ )C�setr; r> r� r6 r~ rD r r� r r r# r �addrG r> r� �_field_became_primary_keyr� �_delete_unique_sqlr� r r5 � related_modelr �db_indexr r r� �_delete_index_sql�_delete_check_sql�_rename_field_sqlrC r� r �rename_column_referencesr| r� r� �_alter_column_type_sqlrW r} r� r� r� r3 �_alter_column_null_sqlr� �supports_combined_altersrX r4 r� �sumr4 r^ �sql_update_with_default�_delete_primary_key�_unique_should_be_addedrw r� �_create_primary_key_sqlrz r� �_create_index_name�_create_check_sqlr6 r7 )/rA r( r0 r3 rI rK rH rJ rG � fks_droppedrA rB r r �constraint_name� old_collation� new_collation�drop_foreign_keys�_old_relr9 � rel_fk_namesr � index_names� index_namerL �actions� null_actions� post_actions�old_type_suffix�new_type_suffix�fragment� other_actions�needs_database_default� old_default� new_default�four_way_default_alterationrM �rels_to_updater8 � rel_db_params�rel_type� rel_collation�old_rel_db_params�old_rel_collationr9 �relr: r r r rF J s, ����� ����� ������ ���� ����� ����� �� �� � � � � � ��� ��� ��� ���� ���� ������� � �� �� � � �z%BaseDatabaseSchemaEditor._alter_fieldc C sR | j jjr |jr dS |j| j d�}|jr| jn| j}|| �|j �|d d� g fS )z� Hook to specialize column null alteration. Return a (sql, params) fragment to set a column to null or non-null as required by new_field, or None if no changes are required. Nrf r� )r� r� ) r; r> r� r� rz r� �sql_alter_column_null�sql_alter_column_not_nullr^ r� )rA r( r0 r3 rJ rL r r r r^ � s" ���� ���z/BaseDatabaseSchemaEditor._alter_column_null_sqlc C s� | � |�}| �|�}|g}|rg }n | jjjr | �|�}g }|j| jd�}|r2|jr.| j} n| j } n| j } | | � |j �|d |d� |fS )z� Hook to specialize column default alteration. Return a (sql, params) fragment to add or drop (depending on the drop argument) a default to new_field's column. rf r� )r� r� r� ) r� r� r; r> r� r� rz r� � sql_alter_column_no_default_null�sql_alter_column_no_default�sql_alter_column_defaultr^ r� ) rA r( r0 r3 r, ry r� rM rJ rL r r r r3 � s, ���z2BaseDatabaseSchemaEditor._alter_column_default_sqlc C s� g }| � |||jj� }rd|� �}nd}d} | jjjrB|jsB|j|jkr9| �||||j�\} } | r9|� | | f� |jrB| � |j�} | j | � |j �||| d� g f|fS )a� Hook to specialize column type alteration for different backends, for cases when a creation type is different to an alteration type (e.g. SERIAL in PostgreSQL, PostGIS fields). Return a two-tuple of: an SQL fragment of (sql, params) to insert into an ALTER TABLE statement and a list of extra (sql, params) tuples to run once the field is altered. rh rP )r� r� r� r )r� r# r r; r> r� r r� r� rW r� �sql_alter_column_typer^ r� ) rA r( r0 r3 rK ri rj rv � collate_sql� comment_sqlrL rM r r r r] � s6 � � ��� �z/BaseDatabaseSchemaEditor._alter_column_type_sqlc C s. | j | �|jj�| �|j�| �|�d� g fS )N)rt r� r )�sql_alter_column_commentr^ r# r r� r� )rA r( r3 rK �new_db_commentr r r r� s ���z2BaseDatabaseSchemaEditor._alter_column_comment_sqlc C s | � |pd�S )NrP )rZ )rA r r r r r� r_ z%BaseDatabaseSchemaEditor._comment_sqlc C s� |j jjj|j jjjkr | �|j j|j jjj|j jjj� | �|j j|j jj�|�� �|j jj�|�� �� | �|j j|j jj�|�� �|j jj�|�� �� dS )z*Alter M2Ms to repoint their to= endpoints.N) r6 r� r# r r rL rb �m2m_reverse_field_name�m2m_field_name)rA r( r0 r3 rG r r r rE # s, � � � �� �z,BaseDatabaseSchemaEditor._alter_many_to_manyrP c C s� t |�\}}dt|g|�R ddi�|f }| jj�� p d}d|d�|�|f }t|�|kr/|S t|�|d kr?|d|d � }|t|� d d }d|d|� d�|�d|� |f }|d dksg|d �� rod |dd � }|S )z� Generate a unique name for an index/unique constraint. The name is divided into 3 parts: the table name, the column names, and a unique digest and suffix. z%s%s�length� �� z%s_%s_%sr9 � N� r r zD%s���)r r r; r] �max_name_lengthr� r �isdigit) rA � table_name� column_namesr� r9 �hash_suffix_part� max_lengthro � other_lengthr r r re C s( � �z+BaseDatabaseSchemaEditor._create_index_namec C sf |d u r$t |�dkr|d jr|d j}ntjr tj}n|jjr$|jj}|d ur1d| jj�|� S dS )Nr r rh rP )r r� r �DEFAULT_INDEX_TABLESPACEr# r; r] r� )rA r( r� r� r r r �_get_index_tablespace_sqlc s z2BaseDatabaseSchemaEditor._get_index_tablespace_sqlc C s |rd| S dS )Nz WHERE rP r )rA � conditionr r r �_index_condition_sqlo s z-BaseDatabaseSchemaEditor._index_condition_sqlc C s, |r| j jjs dS tdt|jj|| j�d�S )NrP z INCLUDE (%(columns)s))r )r; r> �supports_covering_indexesr r r# r r^ )rA r( r r r r �_index_include_sqlt s �z+BaseDatabaseSchemaEditor._index_include_sql) r� r r� �usingr� � col_suffixesrL � opclassesr� �include� expressionsc s� |pg }| pg } t |dd�j�jd�} �j|||d�}dd� |D �}|p&�j}|jj}� �fdd�}t|t|�j �t ||||�||rJ�� |||| �nt || | �j �|��| ���|| �d �S ) z� Return the SQL statement to create the index for one or several fields or expressions. `sql` can be specified if the syntax differs from the standard (GIS indexes, ...). F�� alias_colsrf )r� c S � g | ]}|j �qS r �r� rc r r r rd � r z>BaseDatabaseSchemaEditor._create_index_sql.<locals>.<listcomp>c s" � d u r �j | i |��� ��� �S r+ )re r^ ��args�kwargs�r rA r r �create_index_name� s zEBaseDatabaseSchemaEditor._create_index_sql.<locals>.create_index_name)rt r r� r rN r� r� )r � get_compilerr; r� �sql_create_indexr# r r r r^ r �_index_columnsr rZ r� r� )rA r( r� r r� r� r� r� rL r� r� r� r� �compilerr� r r� rt r� r r� r r� | s0 �� � �z*BaseDatabaseSchemaEditor._create_index_sqlc C s& t |p| jt|jj| j�| �|�d�S �N)rt r )r r� r r# r r^ )rA r( r rL r r r rY � s �z*BaseDatabaseSchemaEditor._delete_index_sqlc C s* t | jt|jj| j�| �|�| �|�d�S )N)rt �old_name�new_name)r �sql_rename_indexr r# r r^ )rA r( r� r� r r r r� � s �z*BaseDatabaseSchemaEditor._rename_index_sqlc C s t ||| j|d�S )N)r� )r r^ )rA rt r r� r� r r r r� � s z'BaseDatabaseSchemaEditor._index_columnsc s� � j jr � j js � j jrg S g }� j jD ] }|�| �� |�� q� j jD ]}� fdd�|D �}|�| j � |dd�� q$� j j D ]}|j rI| j j jrR|�|�� | �� q?|S )z� Return a list of all index SQL statements (field indexes, index_together, Meta.indexes) for the specified model. c r` r ra rc r' r r rd � re z?BaseDatabaseSchemaEditor._model_indexes_sql.<locals>.<listcomp>r� r� )r# �managed�proxy�swappedrx r} r5 �index_togetherrW r� r r� r; r> r� r� )rA r( �outputr r� r� r� r r' r r� � s ���z+BaseDatabaseSchemaEditor._model_indexes_sqlc C s* g }| � ||�r|�| j||gd�� |S )zT Return a list of all index SQL statements for the specified field. rO )�_field_should_be_indexedrW r� )rA r( r r� r r r r5 � s z+BaseDatabaseSchemaEditor._field_indexes_sqlc C s� |pt � }|�� \}}}}|�� \}}} } |�|j�D ]} |�| d � q|�|j�D ]} | �| d � q*| �|j�| �|j�kpH|||f|| | fkS r+ )rS � deconstruct�union� non_db_attrs�popr^ r� ) rA r0 r3 rM r9 �old_path�old_args� old_kwargs�new_path�new_args� new_kwargs�attrr r r rD � s ��z1BaseDatabaseSchemaEditor._field_should_be_alteredc C s |j o|j S r+ )rX r� �rA r( r r r r r� � r_ z1BaseDatabaseSchemaEditor._field_should_be_indexedc C s |j o|j S r+ �r �rA r0 r3 r r r rU � r_ z2BaseDatabaseSchemaEditor._field_became_primary_keyc C s |j o |jo |j p |j S r+ )r r� r� r r r rc � s � �z0BaseDatabaseSchemaEditor._unique_should_be_addedc C s* | j | �|�| �|j�| �|j�|d� S )N)rt � old_column� new_columnr� )�sql_rename_columnr^ r� )rA rt r0 r3 rK r r r r[ s �z*BaseDatabaseSchemaEditor._rename_field_sqlc C s� t |jj| j�}| �|||�}t|jj|jg| j�}t |jjjj| j�}t|jjjj|jjg| j�}| j j � � } t | j |||||| d�S )N)rt r r� ri rj r* )r r# r r^ r0 r r� � target_fieldr( r; r] r1 r � sql_create_fk) rA r( r r� rt r r� ri rj r* r r r r� s& � �z'BaseDatabaseSchemaEditor._create_fk_sqlc s< � fdd�}t |jj|jgt|jjjj�d |jjg||�S )Nc � � � � j| i |���S r+ �r^ re r� rF r r �create_fk_name � zDBaseDatabaseSchemaEditor._fk_constraint_name.<locals>.create_fk_namer )r r# r r� r r� r( )rA r( r r� r� r rF r r0 s �z,BaseDatabaseSchemaEditor._fk_constraint_namec C � | � | j||�S r+ )r � sql_delete_fk�rA r( r r r r r> , � z'BaseDatabaseSchemaEditor._delete_fk_sqlc C s, |d u rdS |t jkr dS |t jkrdS d S )NrP z DEFERRABLE INITIALLY DEFERREDz DEFERRABLE INITIALLY IMMEDIATE)r �DEFERRED� IMMEDIATE)rA r* r r r �_deferrable_constraint_sql/ s �z3BaseDatabaseSchemaEditor._deferrable_constraint_sqlc s� |r � j jjs d S |s|s|s|r'� j|||||||d�} | r%� j�| � d S � jd�� fdd�|D ��� �|�d� } � j � � |�| d� S )N)r r� r� r� r� rs c s g | ]}� � |j��qS r )r^ r� rc rF r r rd W re z8BaseDatabaseSchemaEditor._unique_sql.<locals>.<listcomp>)r r* �r rq ) r; r> �&supports_deferrable_unique_constraintsrw rC rW �sql_unique_constraintr� r� �sql_constraintr^ ) rA r( r� r r� r* r� r� r� rL rq r rF r � _unique_sql7 s4 ��� ��z$BaseDatabaseSchemaEditor._unique_sqlc C s |r| j jjr |r| j jjr |r| j jjr |r | j jjs d S t|dd�j| j d�} |jj } dd� |D �} |d u rA| j | | dd�}n| � |�}|sN|sN|sN|rR| j } n| j } | ra| j| | d|d �} nt| || | j�} t| t| | j �|| | �|�| �|�| �||�d �S ) NFr� rf c S r� r r� rc r r r rd { r z?BaseDatabaseSchemaEditor._create_unique_sql.<locals>.<listcomp>Tr r )r� r� )rt r r r� r* r� )r; r> r� �supports_partial_indexesr� r� r r� r# r r r^ �sql_create_unique_index�sql_create_uniquer� r rZ r r r� r� r� ) rA r( r� r r� r* r� r� r� r� rt r rL r r r rw _ sT �������� � � �z+BaseDatabaseSchemaEditor._create_unique_sqlc s& |r � fdd�}n� j }t||d|�S )Nc r� r+ r� r� rF r r �create_unique_name� r� zLBaseDatabaseSchemaEditor._unique_constraint_name.<locals>.create_unique_name�_uniq)re r )rA rt r r r� r rF r r � s z0BaseDatabaseSchemaEditor._unique_constraint_namec C sh |r| j jjr |r| j jjr |r| j jjr |r | j jjs d S |s&|s&|s&|r*| j}n| j}| �|||�S r+ ) r; r> r� r� r� r� r� r� r ) rA r( r r� r* r� r� r� rL r r r rV � s* �������� z+BaseDatabaseSchemaEditor._delete_unique_sqlc C s | j | �|�| jd|i d� S )Nrg r� )r� r^ r{ )rA r rg r r r � _check_sql� s �z#BaseDatabaseSchemaEditor._check_sqlc C s$ t | jt|jj| j�| �|�|d�S )N)rt r rg )r �sql_create_checkr r# r r^ )rA r( r rg r r r rf � s �z*BaseDatabaseSchemaEditor._create_check_sqlc C s | j jjsd S | �| j||�S r+ )r; r> � supports_table_check_constraintsr �sql_delete_checkr� r r r rZ � s z*BaseDatabaseSchemaEditor._delete_check_sqlc C s t |t|jj| j�| �|�d�S r� )r r r# r r^ )rA �templater( r r r r r � s �z/BaseDatabaseSchemaEditor._delete_constraint_sqlc s |dur � fdd�|D �}� j �� �} � j j�| |jj�} W d � n1 s'w Y g } | �� D ]Y\} }|du s@||d kr�|durK|d |krKq2|durV|d |krVq2|dura|d |kraq2|durl|d |krlq2|duru|d suq2|dur�|d |kr�q2| r�| | vr�| �| � q2| S ) z@Return all constraint names matching the columns and conditions.Nc s@ g | ] }� j jjr� j j�t|� j j�� ��n� j j�|��qS r )r; r> �truncates_names� introspection�identifier_converterr r] r� )r. r rF r r rd � s � �� �z>BaseDatabaseSchemaEditor._constraint_names.<locals>.<listcomp>r r� r r� rg r= r� )r; r[ r� �get_constraintsr# r �itemsrW )rA r( r� r� r r� r= rg rN r r[ r� �resultr �infodictr rF r r � s8 � � � �z*BaseDatabaseSchemaEditor._constraint_namesc C sV | j |dd�}|rt|�dkrtdt|�|jjf ��|D ] }| �| �||�� q d S )NTr� r z0Found wrong number (%s) of PK constraints for %s)r r r r# r rG �_delete_primary_key_sql)rA r( rG r rh r r r rb s ����z,BaseDatabaseSchemaEditor._delete_primary_keyc C sJ t | jt|jj| j�| �| j|jj|jgdd��t|jj|jg| j�d�S )N�_pkrR )rt r r ) r � sql_create_pkr r# r r^ re r� r r� r r r rd s ���z0BaseDatabaseSchemaEditor._create_primary_key_sqlc C r� r+ )r � sql_delete_pkr� r r r r� r� z0BaseDatabaseSchemaEditor._delete_primary_key_sqlc C s |r d| � |� S dS )NzCOLLATE rP )r^ )rA r� ri r� r r r r� r� z%BaseDatabaseSchemaEditor._collate_sqlc C s* | j | �|�d�|�d� }| �|� d S )N�,)� procedure� param_types)�sql_delete_procedurer^ r� rG )rA �procedure_namer� rL r r r �remove_procedure! s �z)BaseDatabaseSchemaEditor.remove_procedure)FT)r )F)rP r+ )NNNNN)NNNNNN)T)NNNNNNNNr� )p�__name__� __module__� __qualname__�__doc__r� r r% r� r2 r4 r� r� r� r� r� r� r? r� ra r� r{ �sql_delete_constraintr� r� r� r� r� r� r� r/ r� r� r� r� r� r� r� r� r r� rB rE rH rG r^ r� r� ry r� r� r� r� � staticmethodr� r� rZ r� r� r� r� r� r� r� r� r r� r r� r( r; rC rL rF r^ r3 r] r� r� rE re r� r� r� r� rY r� r� r� r5 rD r� rU rc r[ r� r0 r> r� r� rw r rV r� rf rZ r r rb rd r� r� r� r r r r r: K s6 ������� S 9 $ " V I � \ &. � 6 �, � 5 � � - r: ) �loggingr% r � django.confr �!django.db.backends.ddl_referencesr r r r r r �django.db.backends.utilsr r r �django.db.modelsr r �django.db.models.sqlr �django.db.transactionr r � django.utilsr � getLoggerrS r r) r5 r: r r r r �<module> s
| ver. 1.4 |
Github
|
.
| PHP 8.2.28 | Generation time: 0.02 |
proxy
|
phpinfo
|
Settings