File manager - Edit - /usr/local/CyberCP/lib/python3.10/site-packages/django/db/backends/sqlite3/__pycache__/schema.cpython-310.pyc
Back
o �h�_ � @ s| d dl Z d dlmZ d dlmZ d dlmZ d dlmZ d dl m Z d dl m Z d dl mZ d d lmZ G d d � d e�ZdS ) � N)�Decimal)�Apps)�NotSupportedError)�BaseDatabaseSchemaEditor)� Statement)� strip_quotes)�UniqueConstraint)�atomicc s� e Zd ZdZdZdZeZdZdZdZ dZ dZ � fdd�Z � fd d �Z d d � Zd d� Z d)dd�Z d*� fdd� Zd+� fdd� Z d,dd�Zd*� fdd� Z� fdd �Z� fd d �Z d+d d �Zd!d"� Z� fd#d$�Z� fd%d&�Zd'd(� Z� Z S )-�DatabaseSchemaEditorzDROP TABLE %(table)sNzEREFERENCES %(to_table)s (%(to_column)s) DEFERRABLE INITIALLY DEFERREDz,ALTER TABLE %(table)s DROP COLUMN %(column)sz7CREATE UNIQUE INDEX %(name)s ON %(table)s (%(columns)s)zDROP INDEX %(name)sc s | j �� s td��t� �� S )Nz�SQLite schema editor cannot be used while foreign key constraint checks are enabled. Make sure to disable them before entering a transaction.atomic() context because SQLite does not support disabling them in the middle of a multi-statement transaction.)� connection�disable_constraint_checkingr �super� __enter__��self�� __class__� �T/usr/local/CyberCP/lib/python3.10/site-packages/django/db/backends/sqlite3/schema.pyr s � z DatabaseSchemaEditor.__enter__c s( | j �� t� �|||� | j �� d S �N)r �check_constraintsr �__exit__�enable_constraint_checking)r �exc_type� exc_value� tracebackr r r r ' s z DatabaseSchemaEditor.__exit__c C s� z dd l }|�|�}W n ty Y n |jy Y nw t|t�r)tt|��S t|tt tf�r5t|�S t|t�rBd|� dd� S |d u rHdS t|t t t f�rVd|�� S td|t|�f ��)Nr z'%s'�'z''�NULLzX'%s'z*Cannot quote parameter value %r of type %s)�sqlite3�adapt� ImportError�ProgrammingError� isinstance�bool�str�intr �float�replace�bytes� bytearray� memoryview�hex� ValueError�type)r �valuer r r r � quote_value, s* � �z DatabaseSchemaEditor.quote_valuec C s | � |�S r )r/ )r r. r r r �prepare_defaultK s z$DatabaseSchemaEditor.prepare_defaultFc C s� | j �� �C}| j j�|�D ]2}|r|j|krq | j j�||j�}|�� D ]\}}||kr>|du s4||kr> W d � dS q$q W d � dS 1 sKw Y dS )a Return whether or not the provided table name is referenced by another one. If `column_name` is specified, only references pointing to that column are considered. If `ignore_self` is True, self-referential constraints are ignored. NTF)r �cursor� introspection�get_table_list�name� get_relations�values) r � table_name� column_name� ignore_selfr1 � other_table� relations�constraint_column�constraint_tabler r r � _is_referenced_by_fk_constraintN s& ���� � � z4DatabaseSchemaEditor._is_referenced_by_fk_constraintTc sh | j jjs*|r*| �|�r*| j jrtd| ��| j �� t� �|||� | j � � d S t� �|||� d S )Nz�Renaming the %r table while in a transaction is not supported on SQLite < 3.26 because it would break referential integrity. Try adding `atomic = False` to the Migration class.) r �features�!supports_atomic_references_renamer> �in_atomic_blockr r r �alter_db_tabler )r �model� old_db_table� new_db_table�disable_constraintsr r r rB e s ����� z#DatabaseSchemaEditor.alter_db_tablec s� | � ||�sd S |j}|jj}|�� \}}|j|kr�| jjjs�| j||dd�r�| jj r5t d|jj|f ��t | jj ��b t � j||||d� | j�� �C} | �d��� d } | �d� d| } |�� d } | | } | | }| �d | |f� | �d | d � | �d � | �d � W d � n1 s�w Y W d � n1 s�w Y | j�� �} | �d� W d � d S 1 s�w Y d S t � j||||d� d S )NT)r9 z�Renaming the %r.%r column while in a transaction is not supported on SQLite < 3.26 because it would break referential integrity. Try adding `atomic = False` to the Migration class.)�strictzPRAGMA schema_versionr zPRAGMA writable_schema = 1z REFERENCES "%s" ("%%s") � z3UPDATE sqlite_master SET sql = replace(sql, %s, %s)zPRAGMA schema_version = %dzPRAGMA writable_schema = 0zPRAGMA integrity_check�VACUUM)�_field_should_be_alteredr4 �_meta�db_table�get_attname_columnr r? r@ r> rA r r �aliasr � alter_fieldr1 �execute�fetchone)r rC � old_field� new_fieldrG �old_field_namer7 �_�old_column_namer1 �schema_version�references_template�new_column_name�search� replacementr r r rO | sV ��� �� � � �� � "�z DatabaseSchemaEditor.alter_fieldc sj �fdd���fdd��j jD �}�fdd��j jD �}i �d}|p#g }t|dd�s3td d � |D ��r[t|�� �D ]!\�}|jrZt�fd d �|D ��sZd|_|}|jrZ|�= ||j= q9|rs|||j < |j ss|j rs�� �� |��||j< |D ]E} | \} } |�| j d� |�| jd� | || j < | jr�| js�d ��| j��� �� | ��d � } | || j< n ��| j�|| j< | j �| j < qu� r�|� j = |� j= � j rՈ jjj jrՈ�� jj�S t� } �fdd��j jD �}�fdd��j jD �}�j j}� r�� fdd�|D �}t�j j�}t�|�}�j j�j j ||||| d�}t dd|�}||d< �j |d< t �j j �j |� t�|�}�j jdt!�j j � ||||| d�}t dd|�}||d< �j |d< t d�j j �j |�}��"|� ��#d��|j j �d�$�fdd �|D ��d�$|�%� ����j j �f � �j�dd� �j&||j j �j j dd � �j'D ]}��#|� �q�g �_'|�r�d |_dS dS ) a| Shortcut to transform a model from old_model into new_model This follows the correct procedure to perform non-rename or column addition operations based on SQLite's documentation https://www.sqlite.org/lang_altertable.html#caution The essential steps are: 1. Create a table with the updated definition called "new__app_model" 2. Copy the data from the existing "app_model" table to the new table 3. Drop the "app_model" table 4. Rename the "new__app_model" table to "app_model" 5. Restore any index of the previous "app_model" table. c s | j o| jj� u S r )� is_relation� remote_fieldrC )�f)rC r r �is_self_referential� s z?DatabaseSchemaEditor._remake_table.<locals>.is_self_referentialc s$ i | ]}|j � |�r|�� n|�qS r )r4 �clone��.0r^ )r_ r r � <dictcomp>� s ��z6DatabaseSchemaEditor._remake_table.<locals>.<dictcomp>c s i | ] }|j � �|j ��qS r )�column� quote_namera r r r rc � s ��N� primary_keyFc s s � | ] \}}t |d d�V qdS )rf FN)�getattr�rb rU rS r r r � <genexpr>� s � �z5DatabaseSchemaEditor._remake_table.<locals>.<genexpr>c 3 s � | ] \}}� |j kV qd S r �r4 rh rj r r ri � s � � �z coalesce(%(col)s, %(default)s))�col�defaultc � g | ] }� fd d�|D ��qS )c � g | ]}� � ||��qS r ��get�rb �n��rename_mappingr r � <listcomp> � �ADatabaseSchemaEditor._remake_table.<locals>.<listcomp>.<listcomp>r )rb �uniquers r r ru � ��z6DatabaseSchemaEditor._remake_table.<locals>.<listcomp>c rm )c rn r ro rq rs r r ru rv rw r �rb �indexrs r r ru ry c s g | ] }� j |jvr|�qS r )r4 �fieldsrz �� delete_fieldr r ru s )� app_labelrL �unique_together�index_together�indexes� constraints�apps�Metar � __module__znew__%szNew%s�%INSERT INTO %s (%s) SELECT %s FROM %s�, c 3 s � | ]}� � |�V qd S r )re )rb �xr r r ri T s � )�handle_autom2m)rF T)(rK �local_concrete_fieldsrg �any�list�itemsrf � auto_createdrd r4 � many_to_many�concreter0 �effective_default�pop�nullre r] �through� delete_modelr r� r� r� r� �copy�deepcopyr rL r- r� � object_name� __bases__r � create_modelrP �joinr6 rB � deferred_sql)r rC � create_fieldr~ � alter_fields�body�mapping�restore_pk_field�fieldrO rR rS �case_sqlr� r� r� r� r� � body_copy� meta_contents�meta� new_model�sqlr )r~ r_ rC r4 rt r r � _remake_table� s� � ���� � � � � � � � � � ��� � �z"DatabaseSchemaEditor._remake_tablec sj |r t � �|� d S | �| jd| �|jj�i � t| j�D ]}t |t �r2|� |jj�r2| j� |� q d S )N�table) r r� rP �sql_delete_tablere rK rL r� r� r" r �references_table�remove)r rC r� r� r r r r� m s ���� ��z!DatabaseSchemaEditor.delete_modelc sh |j r|jjjjr| �|jj� dS |js"|js"|jr"| � |�dur+| j ||d� dS t � � ||� dS )zCreate a field on a model.N)r� ) r� r] r� rK r� r� rf rx r� r� r� r � add_field�r rC r� r r r r� s �� � z DatabaseSchemaEditor.add_fieldc s� |j r|jjjjr| �|jj� dS dS | jjjr1|j s1|j s1|j s1|jr(|j s1t � �||� dS |j| jd�d du r>dS | j||d� dS )z� Remove a field from a model. Usually involves deleting a column, but for M2Ms may involve deleting a table. )r r- Nr} )r� r] r� rK r� r� r r? �can_alter_table_drop_columnrf rx �db_index� db_constraintr � remove_field� db_parametersr� r� r r r r� � s( ������� z!DatabaseSchemaEditor.remove_fieldc C sX | j jjr0|j|jkr0| �||�| �||�kr0|jr |js0|jr#|js0| �| �|j j |||��S | j |||fgd� |� d�} |� d�} |j r�||ksO| | kr�t� } |jj } | jD ]&} | j|kraqY| jsq| j|jkrp| �| j� qY|jr| jj jr| �| j� qY|jr�| jD ]}|j|kr�q�|jjj jr�| �|jj� q�| D ] }| � |� q�dS dS dS )z3Perform a "physical" (non-ManyToMany) field update.�r� � collationN)r r? � can_alter_table_rename_columnrd � column_sqlr] r� rP �_rename_field_sqlrK rL r� rp rx �setrC �related_objects� related_modelr� � field_namer4 �addrf r� r� )r rC rR rS �old_type�new_type� old_db_params� new_db_paramsrG � old_collation� new_collation�related_models�optsr] r� r� r r r � _alter_field� s\ � ���� �� � � � �z!DatabaseSchemaEditor._alter_fieldc C s� |j jjj|j jjjkr=| j|j j|j jj�|�� �|j jj�|�� �f|j jj�|�� �|j jj�|�� �fgd� dS | �|j j� | � d| � |j jjj�d� d|� � |� � g�d� d|� � |� � g�| � |j jjj�f � | �|j j� dS )z*Alter M2Ms to repoint their to= endpoints.r� Nr� r� �id)r] r� rK rL r� � get_field�m2m_reverse_field_name�m2m_field_namer� rP re r� �m2m_column_name�m2m_reverse_namer� )r rC rR rS rG r r r �_alter_many_to_many� sV � � �� � �����������z(DatabaseSchemaEditor._alter_many_to_manyc �B t |t�r|js|js|js|jrt� �||� d S | �|� d S r ) r" r � condition�contains_expressions�include� deferrabler �add_constraintr� �r rC � constraintr r r r� + � ����z#DatabaseSchemaEditor.add_constraintc r� r ) r" r r� r� r� r� r �remove_constraintr� r� r r r r� 6 r� z&DatabaseSchemaEditor.remove_constraintc C s d| S )NzCOLLATE r )r r� r r r � _collate_sqlA s z!DatabaseSchemaEditor._collate_sql)NF)T)F)NNN) �__name__r� � __qualname__r� � sql_create_fk�sql_create_inline_fk�sql_create_column_inline_fk�sql_delete_column�sql_create_unique�sql_delete_unique�sql_alter_table_comment�sql_alter_column_commentr r r/ r0 r> rB rO r� r� r� r� r� r� r� r� r� � __classcell__r r r r r s@ � ��6 � = % �; @ r )r� �decimalr �django.apps.registryr � django.dbr � django.db.backends.base.schemar �!django.db.backends.ddl_referencesr �django.db.backends.utilsr �django.db.modelsr �django.db.transactionr r r r r r �<module> s
| ver. 1.4 |
Github
|
.
| PHP 8.2.28 | Generation time: 0.02 |
proxy
|
phpinfo
|
Settings