ZJɲ") V 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 d
dlmZ ddlmZ ddlm Z ddlm Z ddl m Z ddl m Z er$d dlm!Z! d dl"m#Z# d d l$m%Z% d d l&m'Z' d d l(m)Z) d
d lm*Z* G d d!e Z+ G d" d#e+ Z, G d$ d%e Z- G d& d'e Z. G d( d)e. Z/ e
ed*d+ e
ed*d+ e
ed*d+ e
ed*d+ d, Z0 e
e-d*d+ dAd2 Z1 e
e/d*d+ dBd3 Z2 e
e.d*d+ dCd4 Z3dDd>Z4 e
e j% d*d+ dEd@ Z5dS )F ) annotationsN)Any)Optional)
TYPE_CHECKING)Unionschema)types)compiles ) alter_table) AlterColumn)
ColumnDefault)
ColumnName)ColumnNullable)
ColumnType)format_column_name)format_server_default) DefaultImpl )util)compare) sqla_compat) _is_mariadb)_is_type_bound)Literal)MySQLDDLCompiler)DropConstraint)
Constraint)
TypeEngine)_ServerDefaultc e Zd ZdZdZej ddhddhfz ZddgZ d,d- fd#
Zd. fd& Z d/d(Z
d) Z d* Z d+ Z
xZS )0 MySQLImplmysqlFBOOLTINYINTJSONLONGTEXTzcharacter set ([\w\-_]+)zcollate ([\w\-_]+)N
table_namestr column_namenullableOptional[bool]server_default%Union[_ServerDefault, Literal[False]]name
Optional[str]type_Optional[TypeEngine]r
existing_typeexisting_server_defaultOptional[_ServerDefault]existing_nullable
autoincrementexisting_autoincrementcomment$Optional[Union[str, Literal[False]]]existing_commentkwr returnNonec z t j || st j || r# t j ||f|||||
|| d| || ||n|| rM| t |||||n|||n|
|
nd||n||dur|n| | | n| |
dur|
n| d S ||| |
durM| t |||||n|||n|
|
nd||n||dur|n| | | n| |
dur|
n| d S |dur(| t |||| d S d S )N)r, r2 r r4 r7 r. r5 TF)r newnamer, r2 defaultr8 r: r )
r _server_default_is_identity_server_default_is_computedsuper alter_column$_is_mysql_allowed_functional_default_execMySQLChangeColumnMySQLModifyColumnMySQLAlterDefault)selfr) r+ r, r. r0 r2 r r4 r5 r7 r8 r9 r: r< r= __class__s c/builddir/build/BUILD/cloudlinux-venv-1.0.10/venv/lib/python3.11/site-packages/alembic/ddl/mysql.pyrF zMySQLImpl.alter_column1 s $ 2 3
4 3
!EGG
" +"3 -(?
t H H&EEM>
JJ! !$($4DD+ + &X )4 +* #(#4%%-%U22 +N0$0 #0-/ e++ $G)'
0
(e## JJ! !$($4DD+ + &X )4 +* #(#4%%-%U22 +N0$0 #0-/ e++ $G)'
. 5
(
( JJ! ^F
)
( constr c t |t j rt | rd S t | d S N)
isinstancer CheckConstraintr rE drop_constraint)rL rP rM s rN rU zMySQLImpl.drop_constraint sL eV 3 4 4 9N9N F
&&&&&rO boolc 8 |d uo|j t j u o|d uS rR )_type_affinitysqltypesDateTime)rL r2 r. s rN rG z.MySQLImpl._is_mysql_allowed_functional_default s6
+$ !
+ d*
rO c \ |j j t j u r|j r|j s
|s|dk rdS |r8|j j t j u r |t
j dd| nd }||k S |r8|j j t j u r t
j dd| }|d| dk S |r |rt
j d|
}t
j d|
}|r\|sdS | d | d k rdS | d }| d }t
j d
d |
t
j d
d |
k S ||k S ) Nz'0'Fz^'|'$ 'z (.*) (on update.*?)(?:\(\))?$Tr r z(.*?)(?:\(\))?$z\1) typerX rY Integer primary_keyr8 resubStringmatchlowergroup)rL inspector_columnmetadata_columnrendered_metadata_defaultrendered_inspector_defaultmetadata_default onupdate_ins onupdate_mets rN compare_server_defaultz MySQLImpl.compare_server_default s
/83C C C ,
D$2
D .
D +e335 &. K %48HHH .9 x%?@@@
'
.1JJ J %$ K $3xFF !vh4M N N -1H5E1H1H1HH H
' K,E K 80*0022 L 80)//11 L
B# 4!''**l.@.@.C.CCC 4-9-?-?-B-B*,8,>,>q,A,A)6"E+E+K+K+M+M "E+D+J+J+L+L
.1JJ JrO c t }t | D ]}|j r
|j D ]}|j |j k r1| | | |j nW|j D ]C}|j |j k r1| | | |j nD|j |v r nt | D ] }|j |v r| | !d S rR )setlistuniquecolumnsr0 removeadd foreign_keys) rL conn_unique_constraints conn_indexesmetadata_unique_constraintsmetadata_indexesremovedidxcolfks rN correct_for_autogen_constraintsz)MySQLImpl.correct_for_autogen_constraints s3 %% %% Cz
{
8sx'' '',,,KK)))E * Bw#(**$++C000 CH--- + 8w&&E ' ()) - -Cx7"" '',,, - -rO c h d |D }d |D }t | | D ]v}|| }|| }|j +|j dk r|j d|_ |j +|j dk r|j d|_ wd S )Nc B i | ] }t j | j | S r _fk_constraint_sigsig.0r~ s rN
z=MySQLImpl.correct_for_autogen_foreignkeys.. s5
79G &r * * .
rO c B i | ] }t j | j | S r r r s rN r z=MySQLImpl.correct_for_autogen_foreignkeys.. s5
79G &r * * .
rO restrictRESTRICT)rp intersectionondeletere onupdate)rL conn_fks metadata_fksconn_fk_by_sigmetadata_fk_by_sigr mdfkcnfks rN correct_for_autogen_foreignkeysz)MySQLImpl.correct_for_autogen_foreignkeys s
=E
=I
~&&334FGG + +C%c*D!#&D
)M''))Z77M) *
)M''))Z77M) *
# + +rO ) NFNNNNNNNNFN) r) r* r+ r* r, r- r. r/ r0 r1 r2 r3 r r1 r4 r3 r5 r6 r7 r- r8 r- r9 r- r: r; r< r1 r= r r> r? )rP r r> r? )r2 r3 r. r/ r> rV )__name__
__module__ __qualname__ __dialect__transactional_ddlr
type_synonymstype_arg_extractrF rU rG rn r r
__classcell__rM s @rN r# r# ' s K - 1 M 45JK $(@E "&* $.2<@,0(,158=*. a a a a a a aF' ' ' ' ' '
AK AK AKF$- $- $-L+ + + + + + +rO r# c e Zd ZdZdS ) MariaDBImplmariadbN)r r r r r rO rN r r . s KKKrO r c $ e Zd Z d d
fd
Z xZS )rK Nr0 r* r+ rB r! r r1 r> r? c x t t | || || _ || _ d S )Nr )rE r __init__r+ rB )rL r0 r+ rB r rM s rN r zMySQLAlterDefault.__init__3 s; k4 ))$v)>>>& rO rR )
r0 r* r+ r* rB r! r r1 r> r? r r r r r r s @rN rK rK 2 sG !% rO rK c 0 e Zd Z dd fd
Z xZS )rI NFr0 r* r+ r r1 rA r2 r3 r, r- rB /Optional[Union[_ServerDefault, Literal[False]]]r8 r: r; r> r? c
t t | || || _ || _ || _ || _ || _ | | _ |t j
d t j | | _
d S )Nr zDAll MySQL CHANGE/MODIFY COLUMN operations require the existing type.)rE r r r+ r, rA rB r8 r: r CommandErrorrY to_instancer2 ) rL r0 r+ r rA r2 r, rB r8 r: rM s rN r zMySQLChangeColumn.__init__@ s k4 ))$v)>>>&
* =#-
)%00
rO )NNNNFNF)r0 r* r+ r* r r1 rA r1 r2 r3 r, r- rB r r8 r- r: r; r> r? r r s @rN rI rI ? sY
!%!%&*#'CH(,8=1 1 1 1 1 1 1 1 1 1 1rO rI c e Zd ZdS )rJ N)r r r r rO rN rJ rJ \ s DrO rJ r$ r c t d )Nz9Individual alter column constructs not supported by MySQL)NotImplementedErrorelementcompilerr= s rN _mysql_doesnt_support_individualr ` s
C rO r r r r> r* c t || j | j dt || j d| j dt
|| j z ndS )Nz ALTER COLUMN zSET DEFAULT %sz DROP DEFAULT)r
r) r r r+ rB r r s rN _mysql_alter_defaultr j sh
Hg 0'.AAAA8W%89999 ? & 07?KKKK
rO c t || j | j dt || j dt || j | j | j | j | j
S )Nz MODIFY r r, r. r2 r8 r: ) r
r) r r r+ _mysql_colspecr, rB r2 r8 r: r s rN _mysql_modify_columnr w ss
Hg 0'.AAAA8W%89999 %"?-!/O
rO c t || j | j dt || j dt || j dt
|| j | j | j | j
| j S )Nz CHANGE r r ) r
r) r r r+ rA r r, rB r2 r8 r: r s rN _mysql_change_columnr s
Hg 0'.AAAA8W%899998W_5555 %"?-!/O
rO r, r- r. r r2 r r8 r: r; c | j j | d|rdnd}|r|dz
}|dur||dt | | z z
}|r2|d| j |t
j z z
}|S )Nr NULLzNOT NULLz AUTO_INCREMENTFz DEFAULT %sz COMMENT %s)dialect
type_compilerprocessr sql_compilerrender_literal_valuerY rc )r r, r. r2 r8 r: specs rN r r s &..u5555*
* D " !!U""~'A
5h O OOO
5 J J X_&&!
!
KrO r c | j }t |t j t j t j f r|rJ | | S t |t j rt |j r=d|j
|j d|j
| S d|j
|j d|j
| S t d )zVRedefine SQLAlchemy's drop constraint to
raise errors for invalid constraint type.z ALTER TABLE z DROP CONSTRAINT z DROP CHECK zFNo generic 'DROP CONSTRAINT' in MySQL - please specify constraint type)r rS r ForeignKeyConstraintPrimaryKeyConstraintUniqueConstraintvisit_drop_constraintrT r r preparer format_tabletableformat_constraintr )r r r=
constraints rN _mysql_drop_constraintr s! J ' ' #
v--g666 J 6 7 7
x' ( ( !..z/?@@@@!33J???
!..z/?@@@@!33J???
"
-
rO )r rK r r r> r* )r rJ r r r> r* )r rI r r r> r* )r r r, r- r. r r2 r r8 r- r: r; r> r* )r r r r r> r* )6
__future__r ra typingr r r r
sqlalchemyr r
rY sqlalchemy.ext.compilerr baser
r r r r r r r implr r\ r autogenerater r util.sqla_compatr r r sqlalchemy.dialects.mysql.baser sqlalchemy.sql.ddlr sqlalchemy.sql.schemar sqlalchemy.sql.type_apir r! r# r rK rI rJ r r r r r r r rO rN r s? " " " " " " ( ( ( ( ( ( , , , , , , $ $ $ $ $ $ ' ' ' ' ' ' " " " " " " * * * * * * - - - - - - % ??????111111000000222222$$$$$$D+ D+ D+ D+ D+ D+ D+ D+N )
1 1 1 1 1 1 1 1: )
.'9-- *gy)) -),, *gy)) *) -, *) .-
Wi00 10
Wi00 10"
Wi00 10$ 0
&
)44#
#
#
54#
#
#
rO