관리-도구
편집 파일: base.cpython-38.pyc
U 0?�f' � @ s� d dl mZ d dlZd dlmZ d dlmZ d dlmZ d dlmZ d dlm Z d dlm Z d d l m Z d d lmZ d d lmZ d d lmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ e�rFd dlmZ d dlmZ d dlm Z d dlm Z d dl m Z d dl m!Z! d dl"m#Z# ddl$m%Z% d d lm&Z& d d lm'Z' ed d d e(f Z)G d!d"� d"e�Z*G d#d$� d$e*�Z+G d%d&� d&e*�Z,G d'd(� d(e,�Z-G d)d*� d*e,�Z.G d+d,� d,e,�Z/G d-d.� d.e,�Z0G d/d0� d0e,�Z1G d1d2� d2e,�Z2G d3d4� d4e*�Z3G d5d6� d6e*�Z4G d7d8� d8e,�Z5e e+�d$d9d:d;�d<d=��Z6e e3�d4d9d:d;�d>d?��Z7e e4�d6d9d:d;�d@dA��Z8e e-�d(d9d:d;�dBdC��Z9e e.�d*d9d:d;�dDdE��Z:e e/�d,d9d:d;�dFdG��Z;e e0�d.d9d:d;�dHdI��Z<e e1�d0d9dJ�dKdL��Z=e e2�d2d9dJ�dMdN��Z>dOdPdOdQ�dRdS�Z?dTdOdUdOdV�dWdX�Z@d9dUdOdY�dZd[�ZAd9d\d:d]�d^d_�ZBd9d`d:da�dbdc�ZCd9d:ddd:dV�dedf�ZDd9d:d:dY�dgdh�ZEd9d:d:dY�didj�ZFd9dkd:dl�dmdn�ZGdS )o� )� annotationsN)�Optional)� TYPE_CHECKING)�Union)�exc)�Integer)�types)�compiles)�Column)� DDLElement)� quoted_name� )�_columns_for_constraint)� _find_columns)�_fk_spec)�_is_type_bound)�_table_for_constraint)�Any)�Compiled)� DDLCompiler)� TextClause)�Function)� FetchedValue)� TypeEngine� )� DefaultImpl)�Computed)�Identityr r z Function[Any]c @ s$ e Zd ZdZd dddd�dd�ZdS ) � AlterTablez�Represent an ALTER TABLE statement. Only the string name and optional schema name of the table is required, not a full Table object. N�str�!Optional[Union[quoted_name, str]]�None)� table_name�schema�returnc C s || _ || _d S �N)r" r# )�selfr" r# � r' �>/opt/hc_python/lib/python3.8/site-packages/alembic/ddl/base.py�__init__2 s zAlterTable.__init__)N)�__name__� __module__� __qualname__�__doc__r) r' r' r' r( r * s �r c s* e Zd Zd ddddd�� fdd� Z� ZS ) � RenameTableNr �Union[quoted_name, str]r r! )�old_table_name�new_table_namer# r$ c s t � j||d� || _d S �N)r# )�superr) r1 )r& r0 r1 r# �� __class__r' r( r) < s zRenameTable.__init__)N�r* r+ r, r) � __classcell__r' r' r4 r( r. ; s �r. c s2 e Zd Zd ddddddddd�� fd d � Z� ZS ) � AlterColumnNr � Optional[str]zOptional[TypeEngine]zOptional[bool]�Optional[_ServerDefault]r! )�name� column_namer# � existing_type�existing_nullable�existing_server_default�existing_commentr$ c sD t � j||d� || _|d k r(t�|�nd | _|| _|| _|| _d S r2 ) r3 r) r< �sqltypes� to_instancer= r> r? r@ )r& r; r< r# r= r> r? r@ r4 r' r( r) G s � �zAlterColumn.__init__)NNNNNr6 r' r' r4 r( r8 F s �r8 c s( e Zd Zddddd�� fdd� Z� ZS )�ColumnNullabler �boolr! )r; r< �nullabler$ c s t � j||f|� || _d S r% )r3 r) rE )r& r; r< rE �kwr4 r' r( r) ^ s zColumnNullable.__init__r6 r' r' r4 r( rC ] s rC c s( e Zd Zddddd�� fdd� Z� ZS )� ColumnTyper r r! )r; r< �type_r$ c s" t � j||f|� t�|�| _d S r% )r3 r) rA rB rH )r& r; r< rH rF r4 r' r( r) f s zColumnType.__init__r6 r' r' r4 r( rG e s rG c s( e Zd Zddddd�� fdd� Z� ZS )� ColumnNamer r! )r; r< �newnamer$ c s t � j||f|� || _d S r% )r3 r) rJ )r& r; r< rJ rF r4 r' r( r) n s zColumnName.__init__r6 r' r' r4 r( rI m s rI c s( e Zd Zddddd�� fdd� Z� ZS )� ColumnDefaultr r: r! �r; r< �defaultr$ c s t � j||f|� || _d S r% �r3 r) rM �r& r; r< rM rF r4 r' r( r) v s zColumnDefault.__init__r6 r' r' r4 r( rK u s rK c s( e Zd Zddddd�� fdd� Z� ZS )�ComputedColumnDefaultr zOptional[Computed]r! rL c s t � j||f|� || _d S r% rN rO r4 r' r( r) � s z ComputedColumnDefault.__init__r6 r' r' r4 r( rP � s rP c s* e Zd Zdddddd�� fdd� Z� ZS )�IdentityColumnDefaultr zOptional[Identity]r r! )r; r< rM �implr$ c s" t � j||f|� || _|| _d S r% )r3 r) rM rR )r& r; r< rM rR rF r4 r' r( r) � s z IdentityColumnDefault.__init__r6 r' r' r4 r( rQ � s rQ c s* e Zd Zd ddddd�� fdd� Z� ZS ) � AddColumnNr � Column[Any]r r! �r; �columnr# r$ c s t � j||d� || _d S r2 �r3 r) rV �r& r; rV r# r4 r' r( r) � s zAddColumn.__init__)Nr6 r' r' r4 r( rS � s �rS c s* e Zd Zd ddddd�� fdd� Z� ZS ) � DropColumnNr rT r9 r! rU c s t � j||d� || _d S r2 rW rX r4 r' r( r) � s zDropColumn.__init__)Nr6 r' r' r4 r( rY � s �rY c s( e Zd Zddddd�� fdd� Z� ZS )� ColumnCommentr r9 r! )r; r< �commentr$ c s t � j||f|� || _d S r% )r3 r) r[ )r& r; r< r[ rF r4 r' r( r) � s zColumnComment.__init__r6 r' r' r4 r( rZ � s rZ r r )�element�compilerr$ c K s$ dt || j| j�t|| j| j�f S )Nz%s RENAME TO %s)� alter_tabler" r# �format_table_namer1 �r\ r] rF r' r' r( �visit_rename_table� s �ra c K s$ dt || j| j�t|| jf|�f S �Nz%s %s)r^ r" r# � add_columnrV r` r' r' r( �visit_add_column� s �rd c K s& dt || j| j�t|| jjf|�f S rb )r^ r" r# � drop_columnrV r; r` r' r' r( �visit_drop_column� s �rf c K s, dt || j| j�t|| j�| jr$dndf S )N�%s %s %sz DROP NOT NULLz SET NOT NULL)r^ r" r# � alter_columnr< rE r` r' r' r( �visit_column_nullable� s �ri c K s. dt || j| j�t|| j�dt|| j� f S )Nrg zTYPE %s)r^ r" r# rh r< � format_typerH r` r' r' r( �visit_column_type� s �rk c K s* dt || j| j�t|| j�t|| j�f S )Nz%s RENAME %s TO %s)r^ r" r# �format_column_namer< rJ r` r' r' r( �visit_column_name� s �rm c K s< dt || j| j�t|| j�| jd k r4dt|| j� ndf S )Nrg zSET DEFAULT %sz DROP DEFAULT)r^ r" r# rh r< rM �format_server_defaultr` r' r' r( �visit_column_default� s ��ro )r\ r] c K s t �d��d S )NztAdding or removing a "computed" construct, e.g. GENERATED ALWAYS AS, to or from an existing column is not supported.�r � CompileErrorr` r' r' r( �visit_computed_column� s �rr c K s t �d��d S )Nz�Adding, removing or modifying an "identity" construct, e.g. GENERATED AS IDENTITY, to or from an existing column is not supported in this dialect.rp r` r' r' r( �visit_identity_column s �rs r/ zfunctools.partial)r; �quoter$ c s4 t | t�r� | �S d�� fdd�| �d�D ��}|S )z#quote the elements of a dotted name�.c s g | ] }� |��qS r' r' )�.0�x�rt r' r( � <listcomp> s z quote_dotted.<locals>.<listcomp>)� isinstancer �join�split)r; rt �resultr' rx r( � quote_dotted s r~ r r )r] r; r# r$ c C s4 t �| jj�}|r(t||�d ||� S ||�S d S )Nru )� functools�partial�preparerrt r~ )r] r; r# rt r' r' r( r_ s r_ )r] r; r$ c C s | j �|�S r% )r� rt �r] r; r' r' r( rl $ s rl r: )r] rM r$ c C s | � tdt|d��S )Nrw )Zserver_default)Zget_column_default_stringr r )r] rM r' r' r( rn * s �rn r )r] rH r$ c C s | j j�|�S r% )�dialectZ type_compiler�process)r] rH r' r' r( rj 3 s rj r9 c C s dt | ||� S )NzALTER TABLE %s)r_ )r] r; r# r' r' r( r^ 7 s r^ c K s dt | |� S )NzDROP COLUMN %s�rl )r] r; rF r' r' r( re ? s re c C s dt | |� S )NzALTER COLUMN %sr� r� r' r' r( rh C s rh rT )r] rV r$ c s@ d� j |f|� }d�� fdd�|jD ��}|r<|d| 7 }|S )Nz ADD COLUMN %s� c 3 s | ]}� � |�V qd S r% )r� )rv � constraint�r] r' r( � <genexpr>J s z add_column.<locals>.<genexpr>)Zget_column_specificationr{ � constraints)r] rV rF �text�constr' r� r( rc G s � rc )H� __future__r r �typingr r r Z sqlalchemyr r r rA Zsqlalchemy.ext.compilerr Zsqlalchemy.schemar r Zsqlalchemy.sql.elementsr Zutil.sqla_compatr r r r r r Zsqlalchemy.sql.compilerr r r Zsqlalchemy.sql.functionsr Zsqlalchemy.sql.schemar Zsqlalchemy.sql.type_apir rR r r r r Z_ServerDefaultr r. r8 rC rG rI rK rP rQ rS rY rZ ra rd rf ri rk rm ro rr rs r~ r_ rl rn rj r^ re rh rc r' r' r' r( �<module> s�