File manager - Edit - /usr/local/CyberPanel/lib/python3.10/site-packages/django/db/backends/postgresql/__pycache__/schema.cpython-310.pyc
Back
o �h : � @ sD d dl mZ d dlmZ d dlmZ d dlmZ G dd� de�ZdS )� )�BaseDatabaseSchemaEditor)� IndexColumns)�sql)� strip_quotesc s e Zd ZdZdZdZdZdZdZdZ dZ d Z d Z d4� fd d � Z dZdZdd� Z� fdd�Zdd� Zdd� Zdd� Zdd� Zd d � Z� fd d �Zd d!� Z "d5� fd#d$� Z� fd%d&�Zd5d'd(�Zd5d)d*�Z d6� fd,d-� Z d+d+d.d.d+d d+d d+d"d+d+d/� � fd0d1� Z d2d3� Z � Z S )7�DatabaseSchemaEditorzeUPDATE %(table)s SET %(column)s = %(default)s WHERE %(column)s IS NULL; SET CONSTRAINTS ALL IMMEDIATEz1ALTER SEQUENCE IF EXISTS %(sequence)s AS %(type)sz,DROP SEQUENCE IF EXISTS %(sequence)s CASCADEzZCREATE INDEX %(name)s ON %(table)s%(using)s (%(columns)s)%(include)s%(extra)s%(condition)szgCREATE INDEX CONCURRENTLY %(name)s ON %(table)s%(using)s (%(columns)s)%(include)s%(extra)s%(condition)sz DROP INDEX IF EXISTS %(name)sz*DROP INDEX CONCURRENTLY IF EXISTS %(name)szyCONSTRAINT %(name)s REFERENCES %(to_table)s(%(to_column)s)%(deferrable)s; SET CONSTRAINTS %(namespace)s%(name)s IMMEDIATEzRSET CONSTRAINTS %(name)s IMMEDIATE; ALTER TABLE %(table)s DROP CONSTRAINT %(name)sz,DROP FUNCTION %(procedure)s(%(param_types)s)� c s8 |d u r t � �||�S | jj�t|�|�}t � �|d �S �N)�super�execute� connection�ops� compose_sql�str)�selfr �params�� __class__r �Z/usr/local/CyberPanel/lib/python3.10/site-packages/django/db/backends/postgresql/schema.pyr * s z DatabaseSchemaEditor.executezRALTER TABLE %(table)s ALTER COLUMN %(column)s ADD GENERATED BY DEFAULT AS IDENTITYzEALTER TABLE %(table)s ALTER COLUMN %(column)s DROP IDENTITY IF EXISTSc C s& t |t�r |�dd�}t�|| jj�S )N�%z%%)� isinstancer �replacer �quoter )r �valuer r r � quote_value: s z DatabaseSchemaEditor.quote_valuec s0 t � �||�}| �||�}|d ur|�|� |S r )r �_field_indexes_sql�_create_like_index_sql�append)r �model�field�output�like_index_statementr r r r ? s z'DatabaseSchemaEditor._field_indexes_sqlc C s. |j r |�| j�S | jj�|�� |�| j��S r )� is_relation� rel_db_typer � data_types�get�get_internal_type�db_type�r r r r r �_field_data_typeF s �z%DatabaseSchemaEditor._field_data_typec c s8 � |j �� dkr| �|j �E d H d S | �|j �V d S )N� ArrayField)� base_fieldr% �_field_base_data_typesr( r' r r r r+ N s �z+DatabaseSchemaEditor._field_base_data_typesc C s� |j | jd�}|durF|js|jrFd|v rdS t|dd�}|r&| �|�s&dS |�d�r6| j||gddgd�S |�d �rF| j||gdd gd�S dS ) z� Return the statement to create an index with varchar operator pattern when the column type is 'varchar' or 'text', otherwise return None. �r N�[� db_collation�varchar�_like�varchar_pattern_ops)�fields�suffix� opclasses�text�text_pattern_ops)r& r �db_index�unique�getattr�_is_collation_deterministic� startswith�_create_index_sql)r r r r& �collation_namer r r r U s, � �z+DatabaseSchemaEditor._create_like_index_sqlc C sd d}|� � }|� � }|dkr$||kr$t| �|��t| �|��kr"|S dS | �|�| �|�kr0|S dS )Nz USING %(column)s::%(type)sr) � )r% �listr+ r( )r � new_field� old_field� using_sql�new_internal_type�old_internal_typer r r � _using_sqlz s ��z DatabaseSchemaEditor._using_sqlc C sl | j �� �'}| j j�||�D ]}|d |kr#|d W d � S qW d � d S 1 s/w Y d S )N�column�name)r �cursor� introspection� get_sequences)r �tablerF rH �sequencer r r �_get_sequence_name� s �� ��z'DatabaseSchemaEditor._get_sequence_namec sT |j | jd�}|d }|js|jrD|�d�r|�d�r/|�d�r%|�d�r/|�d�rD|�d�sD| j|jj|jgdd�} | � | � || �� d| _ | � ||� } rV| j | 7 _ |� � } |� � } t|jj�} h d �}| |v }| |v }|r�|s�t|j�}| j | �|�|d d � g f| j| �| �| �|�d � g fgfS |r�|s�| � | j| �| �| �t|j��d � � t|j�}t� �||||||�\}}g }| �| |� }r�| jd | �|�i g fg}||fS |�r |�r | | k�r t� �||||||�\}}t|j�}dddd�}g }| �| |� }�r| j| �|�|| d� g fg}||fS t� �||||||�S )Nr, �typer/ r5 �citextr0 �r3 z2ALTER COLUMN %(column)s TYPE %(type)s%(collation)s> � AutoField� BigAutoField�SmallAutoFieldr> �rF rN � collation)rK rF rL �integer�bigint�smallint)rQ rR rS )rL rN )� db_parametersr r7 r8 r; �_create_index_name�_meta�db_tablerF r �_delete_index_sql�sql_alter_column_typerE r% r � quote_name�sql_add_identity�sql_drop_indentityr �_alter_column_type_sqlrM �sql_delete_sequence�sql_alter_sequence_type)r r rA r@ �new_type� old_collation� new_collation� old_db_params�old_type� index_namerB rC rD rK �auto_field_types� old_is_auto� new_is_autorF �fragment�_� other_actions� sequence_name�db_typesr r r rb � s� �������� ��� �������� � ���� � ����� �z+DatabaseSchemaEditor._alter_column_type_sqlc C sL | j }| �||� }r||7 }|| �|j�||r d| �|� ndd� g fS )N� r> rT )�sql_alter_column_collaterE r_ rF � _collate_sql)r r r@ re rg rA r rB r r r �_alter_column_collation_sql s ����z0DatabaseSchemaEditor._alter_column_collation_sqlFc s� t � �||||||||� |js|js|js |js+|jr+| �||�} | d ur+| �| � |jrK|jsM|jsO| j|jj|j gdd�} | �| � || �� d S d S d S d S )Nr0 rP ) r � _alter_fieldr7 r8 r r rZ r[ r\ rF r] ) r r rA r@ ri re rh � new_db_params�strictr �index_to_remover r r rw s0 � �� � �z!DatabaseSchemaEditor._alter_fieldc s* |r t ||| j||d�S t� �||||�S )N)� col_suffixesr4 )r r_ r �_index_columns)r rK �columnsr{ r4 r r r r| 9 s �z#DatabaseSchemaEditor._index_columnsc C s | j |j|| |d�d d� d S )N�� concurrently)r )r � create_sql�r r �indexr r r r � add_indexD s �z DatabaseSchemaEditor.add_indexc C s | � |j|| |d�� d S )Nr~ )r � remove_sqlr� r r r � remove_indexI s z!DatabaseSchemaEditor.remove_indexNc s |r| j n| j}t� �|||�S r )� sql_delete_index_concurrently�sql_delete_indexr r] )r r rG r r r r r r] L s ��z&DatabaseSchemaEditor._delete_index_sqlr> ) r2 rG r3 �using� db_tablespacer{ r r4 � conditionr �include� expressionsc s8 |p | s| j n| j}t� j||||||||| | | | d� S )N) r2 rG r3 r� r� r{ r r4 r� r� r� )�sql_create_index� sql_create_index_concurrentlyr r< )r r r2 rG r3 r� r� r{ r r4 r� r r� r� r r r r< T s& ���z&DatabaseSchemaEditor._create_index_sqlc C sT | j �� �}|�d|g� |�� }|r|d nd W d � S 1 s#w Y d S )Nz� SELECT collisdeterministic FROM pg_collation WHERE collname = %s r )r rH r �fetchone)r r= rH �rowr r r r: y s �$�z0DatabaseSchemaEditor._is_collation_deterministic)r )F)NF)!�__name__� __module__� __qualname__�sql_update_with_defaultrd rc r� r� r� r� �sql_create_column_inline_fk� sql_delete_fk�sql_delete_procedurer r` ra r r r( r+ r rE rM rb rv rw r| r� r� r] r< r: � __classcell__r r r r r sd ����� �� % s � $ �%r N) � django.db.backends.base.schemar �!django.db.backends.ddl_referencesr �)django.db.backends.postgresql.psycopg_anyr �django.db.backends.utilsr r r r r r �<module> s
| ver. 1.4 |
Github
|
.
| PHP 8.2.28 | Generation time: 0.02 |
proxy
|
phpinfo
|
Settings