R, t 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 er Z6 e
e3 d_d? Z7 e
e4 d`d@ Z8 e
e- dadA Z9 e
e. dbdB Z: e
e/ dcdC Z; e
e0 dddD Z< e
e1 dedE Z= e
e2 dfdF Z>dgdKZ?dhdOZ@didPZAdjdSZBdkdVZCdldXZDdmdYZEdmdZZFdnd]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 e Zd ZdZ d
d d ZdS )
AlterTablezRepresent an ALTER TABLE statement.
Only the string name and optional schema name of the table
is required, not a full Table object.
N
table_namestrschema!Optional[Union[quoted_name, str]]returnNonec " || _ || _ d S N)r! r# )selfr! r# s b/builddir/build/BUILD/cloudlinux-venv-1.0.10/venv/lib/python3.11/site-packages/alembic/ddl/base.py__init__zAlterTable.__init__0 s
% r( )r! r" r# r$ r% r& )__name__
__module__ __qualname____doc__r+ r, r* r r ' s< 59 r, r c $ e Zd Z d d fd
Z xZS )
RenameTableNold_table_namer" new_table_nameUnion[quoted_name, str]r# r$ r% r& c \ t || || _ d S N)r# )superr+ r5 )r) r4 r5 r# __class__s r* r+ zRenameTable.__init__: s0 777 ,r, r( )r4 r" r5 r6 r# r$ r% r& r- r. r/ r+
__classcell__r: s @r* r3 r3 9 sG
59 - - - - - - - - - - -r, r3 c , e Zd Z dd fd
Z xZS ) AlterColumnNnamer" column_namer#
Optional[str]
existing_typeOptional[TypeEngine]existing_nullableOptional[bool]existing_server_defaultOptional[_ServerDefault]existing_commentr% r& c t || || _ |t j | nd | _ || _ || _ || _ d S r8 ) r9 r+ rA sqltypes to_instancerC rE rG rI ) r) r@ rA r# rC rE rG rI r: s r* r+ zAlterColumn.__init__E sp f---& (
/ / /
"3 '>$ 0 r, )NNNNN)r@ r" rA r" r# rB rC rD rE rF rG rH rI rB r% r& r; r= s @r* r? r? D sS
!%.2,0<@*.1 1 1 1 1 1 1 1 1 1 1r, r? c e Zd Zd fd Z xZS )
ColumnNullabler@ r" rA nullableboolr% r& c L t j ||fi | || _ d S r( )r9 r+ rO )r) r@ rA rO kwr: s r* r+ zColumnNullable.__init__\ s1 {11b111
r, )r@ r" rA r" rO rP r% r& r; r= s @r* rN rN [ s= ! ! ! ! ! ! ! ! ! !r, rN c e Zd Zd fd Z xZS )
ColumnTyper@ r" rA type_r r% r& c p t j ||fi | t j | | _ d S r( )r9 r+ rK rL rU )r) r@ rA rU rR r: s r* r+ zColumnType.__init__d s< {11b111 )%00
r, )r@ r" rA r" rU r r% r& r; r= s @r* rT rT c s= 1 1 1 1 1 1 1 1 1 1r, rT c e Zd Zd fd Z xZS )
ColumnNamer@ r" rA newnamer% r& c L t j ||fi | || _ d S r( )r9 r+ rY )r) r@ rA rY rR r: s r* r+ zColumnName.__init__l 1 {11b111 r, )r@ r" rA r" rY r" r% r& r; r= s @r* rX rX k = r, rX c e Zd Zd fd Z xZS )
ColumnDefaultr@ r" rA defaultrH r% r& c L t j ||fi | || _ d S r( r9 r+ r_ r) r@ rA r_ rR r: s r* r+ zColumnDefault.__init__t s1 {11b111 r, )r@ r" rA r" r_ rH r% r& r; r= s @r* r^ r^ s s= r, r^ c e Zd Zd fd Z xZS )
ComputedColumnDefaultr@ r" rA r_ Optional[Computed]r% r& c L t j ||fi | || _ d S r( ra rb s r* r+ z ComputedColumnDefault.__init__ r[ r, )r@ r" rA r" r_ re r% r& r; r= s @r* rd rd r\ r, rd c e Zd Zd fd
Z xZS ) IdentityColumnDefaultr@ r" rA r_ Optional[Identity]implr r% r& c Z t j ||fi | || _ || _ d S r( )r9 r+ r_ rj )r) r@ rA r_ rj rR r: s r* r+ z IdentityColumnDefault.__init__ s8 {11b111 r, )
r@ r" rA r" r_ ri rj r r% r& r; r= s @r* rh rh s=
r, rh c $ e Zd Z d d fd
Z xZS )
AddColumnNr@ r" column Column[Any]r# r$ r% r& c \ t || || _ d S r8 r9 r+ rn r) r@ rn r# r: s r* r+ zAddColumn.__init__ s- f--- r, r( )r@ r" rn ro r# r$ r% r& r; r= s @r* rm rm sG
59 r, rm c $ e Zd Z d d fd
Z xZS )
DropColumnNr@ r" rn ro r# rB r% r& c \ t || || _ d S r8 rq rr s r* r+ zDropColumn.__init__ s- f--- r, r( )r@ r" rn ro r# rB r% r& r; r= s @r* rt rt sE FJ r, rt c e Zd Zd fd Z xZS )
ColumnCommentr@ r" rA commentrB r% r& c L t j ||fi | || _ d S r( )r9 r+ rx )r) r@ rA rx rR r: s r* r+ zColumnComment.__init__ r[ r, )r@ r" rA r" rx rB r% r& r; r= s @r* rw rw r\ r, rw elementcompilerr r% r" c t t || j | j dt || j | j S )Nz RENAME TO ) alter_tabler! r# format_table_namer5 rz r{ rR s r* visit_rename_tabler s?
Hg 0'.AAAA(G$:GNKKK r, c d t || j | j dt || j fi |S N )r} r! r#
add_columnrn r s r* visit_add_columnr sB Hg 0'.AAAA8W^22r222 r, c n t || j | j dt || j j fi |S r )r} r! r# drop_columnrn r@ r s r* visit_drop_columnr sE Hg 0'.AAAAHgn 188R888 r, c t || j | j dt || j d| j rdndS )Nr z
DROP NOT NULLz SET NOT NULL)r} r! r# alter_columnrA rO r s r* visit_column_nullabler sP
Hg 0'.AAAAXw 23333"+? ? r, c t || j | j dt || j ddt || j z S )Nr zTYPE %s)r} r! r# r rA format_typerU r s r* visit_column_typer sU Hg 0'.AAAAXw 23333K'-8888 r, c t || j | j dt || j dt || j S )Nz RENAME z TO )r} r! r# format_column_namerA rY r s r* visit_column_namer sP Hg 0'.AAAA8W%899998W_555 r, c t || j | j dt || j d| j dt
|| j z ndS )Nr zSET DEFAULT %sz DROP DEFAULT)r} r! r# r rA r_ format_server_defaultr s r* visit_column_defaultr sh
Hg 0'.AAAAXw 23333 ? & 07?KKKK
r, c * t j d )NztAdding or removing a "computed" construct, e.g. GENERATED ALWAYS AS, to or from an existing column is not supported.r CompileErrorr s r* visit_computed_columnr s
E r, c * t j d )NzAdding, removing or modifying an "identity" construct, e.g. GENERATED AS IDENTITY, to or from an existing column is not supported in this dialect.r r s r* visit_identity_columnr s
3 r, r@ r6 quotefunctools.partialc t | t r | S d fd| d D }|S )z#quote the elements of a dotted name.c & g | ]
} | S r1 r1 ).0xr s r*
z quote_dotted.. s! 999AuuQxx999r, )
isinstancer
joinsplit)r@ r results ` r* quote_dottedr sZ
$ $$ uT{{
XX9999C 999
:
:F Mr, r r# r$ c t j | j j }|r t || dz || z S || S )Nr ) functoolspartialpreparerr r )r{ r@ r# r s r* r~ r~ sR
h / 5 6 6E
FE**S055;;>>uT{{r, c 6 | j | S r( )r r r{ r@ s r* r r s " "4 ( ((r, r_ rH c V | t dt | S )Nr )server_default)get_column_default_stringr r )r{ r_ s r* r r & s. - -sGG444 r, rU r c @ | j j | S r( )dialect
type_compilerprocess)r{ rU s r* r r / s ) 1 1% 8 88r, rB c * dt | || z S )NzALTER TABLE %s)r~ )r{ r@ r# s r* r} r} 3 s
/$ G G GGr, c ( dt | | z S )NzDROP COLUMN %sr )r{ r@ rR s r* r r ; s 04 @ @ @@r, c ( dt | | z S )NzALTER COLUMN %sr r s r* r r ? s 1(D A A AAr, rn ro c d j |fi |z }d fd|j D }|r|d|z z
}|S )Nz
ADD COLUMN %sr c 3 B K | ]} | V d S r( )r )r
constraintr{ s r* z add_column..F sB )3$$ r, )get_column_specificationr constraints)r{ rn rR textconsts ` r* r r C s| >X >v L L L L LD HH 7=7I
E
e Kr, )rz r3 r{ r r% r" )rz rm r{ r r% r" )rz rt r{ r r% r" )rz rN r{ r r% r" )rz rT r{ r r% r" )rz rX r{ r r% r" )rz r^ r{ r r% r" )rz rd r{ r )rz rh r{ r )r@ r6 r r r% r6 )r{ r r@ r6 r# r$ r% r6 )r{ r r@ r$ r% r6 )r{ r r_ rH r% r" )r{ r rU r r% r" )r{ r r@ r" r# rB r% r" )r{ r r@ r" r% r" )r{ r rn ro r% r" )H
__future__r r typingr r r
sqlalchemyr r r rK sqlalchemy.ext.compilerr
sqlalchemy.schemar r sqlalchemy.sql.elementsr
util.sqla_compatr r r r r r sqlalchemy.sql.compilerr r r sqlalchemy.sql.functionsr sqlalchemy.sql.schemar sqlalchemy.sql.type_apir rj r r r r" _ServerDefaultr r3 r? rN rT rX r^ rd rh rm rt rw r r r r r r r r r r r~ r r r r} r r r r1 r, r* r sG " " " " " " ( ( ( ( ( ( , , , , , , $ $ $ $ $ $ ( ( ( ( ( ( / / / / / / 6 6 6 6 6 6 , , , , , , ' ' ' ' ' ' - - - - - - 4 4 4 4 4 4 ,000000333333222222111111222222222222!!!!!!++++++++++++|^_cIJ $- - - - -* - - -1 1 1 1 1* 1 1 1.! ! ! ! ![ ! ! !1 1 1 1 1 1 1 1 K K K
K
+
)
*
.
*
*
-
!
! ) ) ) ) 9 9 9 9H H H HA A A AB B B B r,