/usr/local/lib/python3.9/site-packages/django/db/backends/sqlite3/__pycache__
a Ӱ�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� Zd)dd�Zd*� fdd� Zd+� fdd� Zd,dd�Zd-� fdd� Z� fdd �Z� fd d �Zd.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 �� std��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__� �K/usr/local/lib/python3.9/site-packages/django/db/backends/sqlite3/schema.pyr s �z DatabaseSchemaEditor.__enter__c s( | j �� t� �|||� | j �� d S �N)r Zcheck_constraintsr �__exit__�enable_constraint_checking)r �exc_type� exc_value� tracebackr r r r ' s z DatabaseSchemaEditor.__exit__c C s� zdd l }|�|�}W n$ ty( Y n |jy: Y n0 t|t�rRtt|��S t|tt tf�rjt|�S t|t�r�d|� dd� S |d u r�dS t|t t t f�r�d|�� S td|t|�f ��d S )Nr z'%s'�'z''ZNULLzX'%s'z*Cannot quote parameter value %r of type %s)�sqlite3Zadapt� ImportErrorZProgrammingError� 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 �� ��}| j j�|�D ]d}|r.|j|kr.q| j j�||j�}|�� D ]4\}}||krH|du sh||krH W d � dS qHqW d � n1 s�0 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 �cursorZ introspectionZget_table_list�nameZ get_relations�values) r � table_nameZ column_name� ignore_selfr- Z other_tableZ relationsZconstraint_columnZconstraint_tabler r r � _is_referenced_by_fk_constraintN s ���6z4DatabaseSchemaEditor._is_referenced_by_fk_constraintTc sf | j jjsR|rR| �|�rR| j jr,td| ��| j �� t� �|||� | j � � nt� �|||� 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_renamer2 �in_atomic_blockr r r �alter_db_tabler )r �modelZ old_db_tableZ new_db_table�disable_constraintsr r r r6 e s ����� z#DatabaseSchemaEditor.alter_db_tablec s� | � ||�sd S |j}|jj}|�� \}}|j|k�r�| jjj�s�| j||dd��r�| jj rpt d|jj|f ��t | jj ��� t � j||||d� | j�� ��} | �d��� d } | �d� d| } |�� d } | | } | | }| �d | |f� | �d | d � | �d � | �d � W d � n1 �s*0 Y W d � n1 �sJ0 Y | j�� �} | �d� W d � n1 �s�0 Y nt � j||||d� d S )NT)r1 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_checkZVACUUM)Z_field_should_be_alteredr. �_meta�db_tableZget_attname_columnr r3 r4 r2 r5 r r �aliasr � alter_fieldr- �executeZfetchone)r r7 � old_field� new_fieldr9 Zold_field_namer0 �_Zold_column_namer- Zschema_versionZreferences_templateZnew_column_name�search� replacementr r r r> | sP ���� �� � � J ,z DatabaseSchemaEditor.alter_fieldc sr �fdd���fdd��j jD �}�fdd��j jD �}i �d}|pFg }t|dd�sftd d � |D ��r�t|�� �D ]B\�}|jrrt�fd d �|D ��srd|_|}|jrr|�= ||j= qr|r�|||j < |j s�|j r�� �� |��||j< |D ]�} | \} } |�| j d� |�| jd� | || j < | j�rZ| j�sZd ��| j��� �� | ��d � } | || j< n��| j�|| j< | j �| j < q� �r�|� j = |� j= � j �r�� jjj j�r���� 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 ]}��#|� �qJg �_'|�rnd |_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 )Z is_relation� remote_fieldr7 )�f)r7 r r �is_self_referential� s z?DatabaseSchemaEditor._remake_table.<locals>.is_self_referentialc s$ i | ] }|j � |�r |�� n|�qS r )r. �clone��.0rF )rG r r � <dictcomp>� s �z6DatabaseSchemaEditor._remake_table.<locals>.<dictcomp>c s i | ]}|j � �|j ��qS r )�column� quote_namerI r r r rK � s �N� primary_keyFc s s | ]\}}t |d d�V qdS )rN FN)�getattr�rJ rB rA r r r � <genexpr>� s z5DatabaseSchemaEditor._remake_table.<locals>.<genexpr>c 3 s | ]\}}� |j kV qd S r �r. rP rR r r rQ � s �z coalesce(%(col)s, %(default)s))�col�defaultc s g | ]}� fd d�|D ��qS )c s g | ]}� � ||��qS r ��get�rJ �n��rename_mappingr r � <listcomp> � �ADatabaseSchemaEditor._remake_table.<locals>.<listcomp>.<listcomp>r )rJ �uniquerY r r r[ s �z6DatabaseSchemaEditor._remake_table.<locals>.<listcomp>c s g | ]}� fd d�|D ��qS )c s g | ]}� � ||��qS r rU rW rY r r r[ r\ r] r �rJ �indexrY r r r[ s �c s g | ]}� j |jvr|�qS r )r. �fieldsr_ �� delete_fieldr r r[ s )� app_labelr< �unique_together�index_together�indexes� constraints�appsZMetar � __module__znew__%szNew%s�%INSERT INTO %s (%s) SELECT %s FROM %s�, c 3 s | ]}� � |�V qd S r )rM )rJ �xr r r rQ T r\ )�handle_autom2m)r8 T)(r; Zlocal_concrete_fieldsrO �any�list�itemsrN � auto_createdrL r. � many_to_manyZconcreter, �effective_default�pop�nullrM rE �through� delete_modelr re rf rg rh �copy�deepcopyrd r< r) rj Z object_name� __bases__r � create_modelr? �joinr/ r6 � deferred_sql)r r7 � create_fieldrc � alter_fields�body�mappingZrestore_pk_field�fieldr> r@ rA Zcase_sqlri re rf rg rh Z body_copyZ meta_contents�metaZ new_model�sqlr )rc rG r7 r. rZ r r � _remake_table� s� � ��� � � � � � � � � � ��� � z"DatabaseSchemaEditor._remake_tablec sh |rt � �|� nR| �| jd| �|jj�i � t| j�D ](}t |t �r:|� |jj�r:| j� |� q:d S )N�table) r rx r? �sql_delete_tablerM r; r< rp r~ r r Zreferences_table�remove)r r7 rn r� r r r rx m s ����z!DatabaseSchemaEditor.delete_modelc sd |j r"|jjjjr"| �|jj� n>|jsB|jsB|jrB| � |�durR| j ||d� nt � � ||� dS )zCreate a field on a model.N)r ) rs rE rw r; rr r| rN r^ rv rt r� r � add_field�r r7 r� r r r r� s �� � � z DatabaseSchemaEditor.add_fieldc s� |j r"|jjjjr�| �|jj� n`| jjjrZ|j sZ|j sZ|j sZ|jrJ|j sZt � �||� n(|j| jd�d du rtdS | 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) Nrb )rs rE rw r; rr rx r r3 Zcan_alter_table_drop_columnrN r^ Zdb_index� db_constraintr � remove_fieldZ db_parametersr� r� r r r r� � s& ������ z!DatabaseSchemaEditor.remove_fieldc C s` | j jjr`|j|jkr`| �||�| �||�kr`|jr:|js`|jrF|js`| �| �|j j |||��S | j |||fgd� |� d�} |� d�} |j �r\||ks�| | k�r\t� } |jj } | jD ]L} | j|kr�q�| js�| j|jkr�| �| j� q�|jr�| jj jr�| �| j� q�|j�rF| jD ]2}|j|k�r&�q|jjj j�r| �|jj� �q| D ]}| � |� �qJdS )z3Perform a "physical" (non-ManyToMany) field update.�r� � collationN)r r3 Z can_alter_table_rename_columnrL Z column_sqlrE r� r? Z_rename_field_sqlr; r< r� rV r^ �setr7 Zrelated_objects� related_modelrs � field_namer. �addrN rw rr )r r7 r@ rA Zold_type�new_typeZ old_db_paramsZ new_db_paramsr9 Z old_collationZ new_collationZrelated_models�optsrE rs r� r r r � _alter_field� sZ � ������ �� �� z!DatabaseSchemaEditor._alter_fieldc C s� |j jjj|j jjjkrz| 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� Nrk rl �id)rE rw r; r< r� � get_fieldZm2m_reverse_field_nameZm2m_field_namer| r? rM r} Zm2m_column_nameZm2m_reverse_namerx )r r7 r@ rA r9 r r r �_alter_many_to_many� sX �� � �� � �����������z(DatabaseSchemaEditor._alter_many_to_manyc s@ t |t�r2|js"|js"|js"|jr2t� �||� n | �|� d S r ) r r � condition�contains_expressions�include� deferrabler �add_constraintr� �r r7 � constraintr r r r� + s ����z#DatabaseSchemaEditor.add_constraintc s@ t |t�r2|js"|js"|js"|jr2t� �||� n | �|� d S r ) r r r� r� r� r� r �remove_constraintr� r� r r r r� 6 s ����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)T)F) �__name__rj � __qualname__r� Z sql_create_fkZsql_create_inline_fkZsql_create_column_inline_fkZsql_delete_columnZsql_create_uniqueZsql_delete_uniqueZsql_alter_table_commentZsql_alter_column_commentr r r+ r, r2 r6 r> r� rx r� r� r� r� r� r� r� � __classcell__r r r r r s> � � �6 � = % � ;@ r )ry �decimalr Zdjango.apps.registryr Z django.dbr Z django.db.backends.base.schemar Z!django.db.backends.ddl_referencesr Zdjango.db.backends.utilsr Zdjango.db.modelsr Zdjango.db.transactionr r r r r r �<module> s
.
Edit
..
Edit
__init__.cpython-39.pyc
Edit
_functions.cpython-39.pyc
Edit
base.cpython-39.pyc
Edit
client.cpython-39.pyc
Edit
creation.cpython-39.pyc
Edit
features.cpython-39.pyc
Edit
introspection.cpython-39.pyc
Edit
operations.cpython-39.pyc
Edit
schema.cpython-39.pyc
Edit