}d|d4Z?e>@ d5 d}d8 ZAd~d>ZB e jC ejD ejE ejF ejG ejF ejG d? ZHd@eIdA< ddGZJddIZKddKZLejM ddS ZN G dT dU ZO G dV dWeO ZP G dX dYeO ZQ G dZ d[eO ZRe>@ d\ dd_ ZSd` ZTe>@ da ddh ZUe>@ da ddj ZVe>@ da ddk ZWddnZXddqZYddrZZddsZ[dt Z\e>@ da ddv Z]e>@ da ddx Z^e>@ d\ ddy Z_e>@ d\ ddz Z`dS ) ) annotationsN)Any)cast)Dict)Iterator)List)Mapping)Optional)Set)Tuple)
TYPE_CHECKING)Union)event)inspectschema)text)types)
expression)
OrderedSet)_fk_spec )util)ops) sqla_compat)Literal) Inspector) quoted_name)
TextClause)Column)ForeignKeyConstraint)Index)Table)UniqueConstraint)AutogenContext) DefaultImpl)
AlterColumnOp)MigrationScript)ModifyTableOps)
UpgradeOpsautogen_contextr% migration_scriptr( returnNonec |j d }|j d }t | | | | d S )N)upgrade_ops_listdowngrade_ops_list_produce_net_changes reverse_into)r+ r, upgrade_ops
downgrade_opss n/builddir/build/BUILD/cloudlinux-venv-1.0.12/venv/lib/python3.11/site-packages/alembic/autogenerate/compare.py_populate_migration_scriptr8 5 sH #3B7K$7;M +666 ]+++++ T)uselistr5 r* c j }|J j dd }t | }|j j }|rat
| }| d | | | d nd h} fd|D } j J t d j j || d S )Ninclude_schemasFinformation_schemac B h | ]} |d i | S r run_name_filters).0sr+ s r7 z'_produce_net_changes..X s@ o > >q(B O O r9 r )
connectionoptsgetr dialectdefault_schema_namesetget_schema_namesdiscardadd comparatorsdispatchname)r+ r5 rD r< inspectordefault_schemaschemass ` r7 r3 r3 B s !+J ! ! !%*../@%HHO":..I ';N i002233,---''' D& G " . . .?#:#?@@g r9 r rR $Union[Set[None], Set[Optional[str]]]c j }t } j j } j j }|D ]m t | } |k r | j j g }| fd|D nt d j D ||fg }t |||| d S )Nr c 3 R K | ]!} |d di |fV "dS )table schema_nameNr? )rA tnamer+ rW s r7 z&_autogen_for_tables..x s^
//w <
%
r9 c * g | ]}|j |j fS )r rO )rA rV s r7
z'_autogen_for_tables.. s! OOO%,
#OOOr9 ) rP rI migration_contextversion_table_schema
version_tableget_table_names
differenceupdater
sorted_tables_compare_tables)
r+ r5 rR rP conn_table_namesr^ r_ tablesmetadata_table_namesrW s
` @r7 _autogen_for_tablesrh b sD )I7:uu )> $5CM
Y..k.BBCC . . .&& 2@A F
&OO 1NOOO j' 7899 r9 re rI rg rP r c
|j j j t fd|D }fdt || D }|}| | D ]\ }}|r|d|n|} |||f }
|
|ddd r|j t j
|
t d| t j
|g | } t d | ||d |
| s|j | t# j } | | D ]\\ }}t# j || } | | j v }
t# j || | }|
sHt- j |dj j | t7 j || ||dd d rt j
|g | } t d | |||d | s|j | |j t j
| t d
| ^| | }t# j }i }|D ]\ }}t# j || } | |j v }
t# j ||| }|
sHt- j |dj j | t7 j || ||||f< t? |d D ]\ }}|pd }|r|d|n|} |||f }
|j | } |
|dd| rt j
|g | } tA ||||
| | 5 t d | ||||
d d d n # 1 swxY w Y | s|j | d S )
Nc . g | ]\ }}|k r|nd |fS Nr[ )rA r rX rQ s r7 r\ z#_compare_tables.. s@
//VVT5 A
r9 c ^ i | ])\ }\ }}|j t j || *S r[ )table_key_to_table sa_schema_get_table_key)rA no_dflt_schemar rX r+ s r7
z#_compare_tables.. sM
,NOVU : $UF 3 3
r9 .rV FzDetected added table %rr column_reflectTzDetected removed table %rc & | d pd| d fS )Nr r[ )xs r7 z!_compare_tables.. s 1Q4:2qt:L r9 )key)!bindrG rH r zipra run_object_filtersr append
CreateTableOp
from_tableloginfor) rM rN is_emptyrn MetaDataro rf r# r listenr] impl _compat_autogen_column_reflectr _reflect_table DropTableOp intersectionsorted_compare_columns)re rg rP r5 r+ #metadata_table_names_no_dflt_schematname_to_tablerB rX rO metadata_tablemodify_table_opsremoval_metadataexiststexisting_tablesexisting_metadataconn_column_info
conn_tablerQ s ` @r7 rd rd s ^+?N +5
!5
+ +' 03 /1E0
0
N ?(334DEE 9 95'(3!!!UU##e'E
3 - - E7E4
9
O " "!,,^<<
HH. 5 5 5 " 1%A F F F ) )
$,,..
9&&'7888 )++$//0DEE 8 85'q11)00 OE#3A > > >
5 L 16..
&y! 4 4 4 - -at L L 8 " 1%A F F F ) ) !11eQ
$,,..
9&&'7888 O " "3?#=#=a#@#@ A A A HH0$ 7 7 7&334HIIO!*,,# ) )5'q11*11 OE#4Q ? ? ? 5 L 16..y99
&y! 4 4 4'(!U$$?0L0LMMM 9 95
I'(3!!!UU##e'E
3&-d3
- - E7E:
9 # 1%A F F F !
$$W--#$ "
& $,,..
9&&'7888? 9 9s (QQ Q )ascdesc nulls_first
nulls_last
nullsfirst nullslastzMapping[str, Any]_IndexColumnSortingOpsparamsDict[str, Any]r r# Optional[Index]c g }| d }t | d D ]~\ }}|$d| v sJ | d | }t | }n|}|j | }|r-||v r)|| D ] }|t v rt | | }!| | t
j | d g|R | d |d} d| v r| d | j d< | S )Ncolumn_sorting column_names expressionsrO unique)r _tableduplicates_constraint) rF enumerater cr r} rn r" r )
r r exprssortingnumcol_namerO itemoperatorixs
r7 _make_indexr ' s5 24Ejj)**G"6.#9::
X F****-(-D::DDD <)D Btw #DM
B
B 5551(;DAAD
T v
'-h'7
B &((+12I+J'(
Ir9 r$ c t j fd| d D d| d i}d| v r| d |j d< |S )Nc * g | ]}j | S r[ r rA cnamer s r7 r\ z+_make_unique_constraint..E s B B B%*,u
B B Br9 r rO duplicates_index)rn r$ r )r r uqs ` r7 _make_unique_constraintr A sd
# B B B B6.+A B B B
F^
B V##&,-?&@"#
Ir9 r! c
| d | d r
| d d| di }t j fd| d D fd| d D | d | d
| d | d | d
} | |S )Nreferred_tablereferred_schemarr optionsc * g | ]}j | S r[ r r s r7 r\ z%_make_foreign_key..X s HHH e HHHr9 constrained_columnsc g | ] }d |
S )rr r[ )rA nrX s r7 r\ z%_make_foreign_key..Y s$ BBB!EEE11 BBBr9 referred_columnsonupdateondelete
deferrable initiallyrO )r r r r rO )rF rn r! append_constraint)r r r constrX s ` @r7 _make_foreign_keyr N s
# $E
=!"3444ee<jjB''G *HHHH&1F*GHHHBBBBv.@'ABBBZ((Z((;;|,,++k**
F^
E ''' Lr9
Optional[str]rX Union[quoted_name, str]r r r) Iterator[None]c
# K r dn}t d |j D }d |j D } fd|j D }
| |
D ]|} | | | ddd r[|j t j | | t d|| }|
|
D ]} | | }
|j | } |
| dd| s1t j | }t
d | | ||
| r|j | d V t |
| D ]} |j | | dd d r`|j t j |j | t d
|| d S ) Nrr c 3 2 K | ]}|j |j V d S rk systemrO rA r s r7 rY z#_compare_columns..p s? $ $$ $ $ $ $ $ $r9 c , i | ]}|j |j |S r[ r r s r7 rq z$_compare_columns..s s3 18 r9 c ^ i | ])} |j d d !|j |*S )column
table_namerW )r@ rO )rA r r+ r rX s r7 rq z$_compare_columns..w sT
+ +
FHU6 J J
r9 r Fz Detected added column '%s.%s'r Tz Detected removed column '%s.%s')r r ra r| r r} AddColumnOpfrom_column_and_tablenamer r r r' rM rN has_changesrI DropColumnOp)r rX r r r r+ rP rO metadata_col_namesmetadata_cols_by_nameconn_col_namesr colname metadata_colconn_colalter_column_ops `` ` r7 r r e s )/ 9fffee $ $ED# $ $&($ $ $ )+ N $..~>> C C - - !% (%5$
C
' '99E#8#?
HH4dE B B B%22>BB 9 9,W5 <( 11 '8UH
+E76JJJ X&&
& & ( ( 9 ' ' 8 8 8 EEE^$$//0BCC E E - - L $
E
' ' ::E:<#6
HH6e D D D E Er9 c 6 e Zd ZU ded< d
dZd Zd Zdd Zd S )_constraint_sigz4Union[UniqueConstraint, ForeignKeyConstraint, Index]r contextr% r- r c @ t j | j |j S rk r _get_constraint_final_namer rG selfr s r7 md_name_to_sql_namez#_constraint_sig.md_name_to_sql_name 5 J
r9 c " | j |j k S rk r r others r7 __eq__z_constraint_sig.__eq__ zU[((r9 c " | j |j k S rk r r s r7 __ne__z_constraint_sig.__ne__ r r9 intc * t | j S rk )hashr r s r7 __hash__z_constraint_sig.__hash__ s DJ r9 Nr r% r- r )r- r )__name__
__module__ __qualname____annotations__r r r r r[ r9 r7 r r sh ????
) ) )) ) ) r9 r c 6 e Zd ZdZdZd dZed d Zd
S )
_uq_constraint_sigFTr r$ r- r. c || _ |j | _ dt t d |j D z | _ d S )N)UNIQUE_CONSTRAINTc g | ] }|j
S r[ rO rA cols r7 r\ z/_uq_constraint_sig.__init__.. s 666CH666r9 )r rO tupler columnssig)r r s r7 __init__z_uq_constraint_sig.__init__ sJ
J )E 66
666 7 7-
-
r9 List[str]c . d | j j D S )Nc g | ] }|j
S r[ r r s r7 r\ z3_uq_constraint_sig.column_names.. s 777S777r9 )r r r s r7 r z _uq_constraint_sig.column_names s 77DJ$67777r9 N)r r$ r- r. )r- r
)r r r is_index is_uniquer propertyr r[ r9 r7 r r sR HI
8 8 8 X8 8 8r9 r c : e Zd ZdZddZdd Zedd ZdS )_ix_constraint_sigTr r" r r& r- r. c || _ |j | _ d| | z | _ t |j | _ d S )N)INDEX)r rO create_index_sigr boolr r )r r r s r7 r z_ix_constraint_sig.__init__ sA
J 5 5e < << el++r9 r r% r c @ t j | j |j S rk r r s r7 r z&_ix_constraint_sig.md_name_to_sql_name r r9 $Union[List[quoted_name], List[None]]c 4 t j | j S rk )r _get_index_column_namesr r s r7 r z _ix_constraint_sig.column_names s 24:>>>r9 N)r r" r r& r- r. r )r- r )r r r r
r r r r r[ r9 r7 r r sa H, , , ,
? ? ? X? ? ?r9 r c e Zd Z d
d dZd S ) _fk_constraint_sigFr r! include_optionsr r- r. c T || _ |j | _ t | \
| _ | _ | _ | _ | _ | _ }}}}| j | j t | j | j | j t | j f| _
|r| xj
|r.| dk rd n| nd |r.| dk rd n| nd |r| dk rdn|rdndfz
c_
d S d S )Nz no actiondeferredinitially_deferrabler znot deferrable) r rO r
source_schema source_tablesource_columns
target_schema target_tabletarget_columnsr r lower)r r r r r r r s r7 r z_fk_constraint_sig.__init__ s\
J
UOO
$% & & $% & &
%
HH ))[88hnn>N>N>N ))[88hnn>N>N>N &!* !2!2j!@!@ '& &\\%
HHHH r9 N)F)r r! r r r- r. )r r r r r[ r9 r7 r r s0 CH) ) ) ) ) ) )r9 r rV
modify_opsOptional[Table]c * %&'()* j }d u (|d u )|&d |j D }t |j }n t }t }t x} }
d*d} t |d rb | } d* fd| D } | D ]} | d rd} n# t $ r Y nt $ r Y nw xY w |
}
fd|
D }
n# t $ r Y nw xY w)rt } nfd | D } d
fd |
D D }
| rt | |
|| j j
j | |
|| d |D }
j
j ''fd
|D }d | D }'fd|
D } fd|
| D }d |D &d |D %d | | D }%&fdt & % D }d |D }d |
D }d |D } fd|
D } ()*fd} ()*fd} fd}t% t | | D ]^}|| } | j s
| j |v r||v r4|| \ } } | j |vr | j |vr || || S || _t% t | | D ]} || } | |v r|| \ } } | j r| } n | } n|| } | j | j k r || || Ug }!| j | j k r%|! d | j d | j | j | j k r%|! d | j d | j |!r
|| | |! t% t | | D ]}"||" }# ||# |D ]}$|$|vr |||$ d S ) Nc F h | ] }t |t j | S r[ )
isinstancern r$ rA r s r7 rC z/_compare_indexes_and_uniques.. s; '
'
'
"i 899'
'
'
'
r9 Fget_unique_constraintsr Tc T g | ]$} |d dd "|%S )rO unique_constraintr r? )rA r r+ r rX s r7 r\ z0_compare_indexes_and_uniques..@ sT &776
+',VDD r9 r c T g | ]$} |d dd "|%S )rO indexr r? )rA r r+ r rX s r7 r\ z0_compare_indexes_and_uniques..S sT "33vJ#(@@ r9 c 0 h | ]}t | S r[ )r )rA uq_defr s r7 rC z/_compare_indexes_and_uniques..c s3 (
;; r9 c h | ]}||S rk r[ )rA r1 s r7 rC z/_compare_indexes_and_uniques..h s(
r9 c 3 8 K | ]}t | V d S rk )r )rA r r s r7 rY z/_compare_indexes_and_uniques..j s- MM"+b*55MMMMMMr9 c , h | ]}t | S r[ r r, s r7 rC z/_compare_indexes_and_uniques.. s. ' ' '#%2 ' ' 'r9 c 0 h | ]}t | S r[ r rA r r s r7 rC z/_compare_indexes_and_uniques.. s1 )+2t$$ r9 c , h | ]}t | S r[ r7 r, s r7 rC z/_compare_indexes_and_uniques.. s! M M M" 1" 5 5 M M Mr9 c 0 h | ]}t | S r[ r9 r: s r7 rC z/_compare_indexes_and_uniques.. s$ LLL*2t44LLLr9 c i | ]_}t |t s t j |j j 6t
t | |`S r[ ) r+ r r _constraint_is_namedr rG r strr )rA r r+ s r7 rq z0_compare_indexes_and_uniques.. sr
a+ , , +AG_5L M M
S!''88991 r9 c i | ]
}|j | S r[ r r s r7 rq z0_compare_indexes_and_uniques.. s GGG!AFAGGGr9 c i | ]
}|j | S r[ r r s r7 rq z0_compare_indexes_and_uniques.. s @@@!AFA@@@r9 c P i | ]#}t j |j |j |$S r[ )r constraint_name_stringrO r s r7 rq z0_compare_indexes_and_uniques.. s?
-af 5 5 r9 c 2 i | ]}|| | fS r[ r[ )rA rO conn_indexes_by_nameconn_uniques_by_names r7 rq z0_compare_indexes_and_uniques.. s<
#D)+?+EF r9 c i | ]
}|j | S r[ r r, s r7 rq z0_compare_indexes_and_uniques.. s HHH"262HHHr9 c i | ]
}|j | S r[ rH r, s r7 rq z0_compare_indexes_and_uniques.. s) r9 c i | ]
}|j | S r[ rH )rA r s r7 rq z0_compare_indexes_and_uniques.. s I I Ibrvr I I Ir9 c ^ i | ])}t j |j j !|j |*S r[ )r r> r rG r )rA r r+ s r7 rq z0_compare_indexes_and_uniques.. sJ / Ho-
r9 c | j r | j | j ddd r{j t j | j t d| j d
d| j z g d S d S sd S srd S | j | j ddd r{j t j
| j t d| j d
d| j z g d S d S )Nr1 Fz Detected added index '%s' on %s, z'%s'r/ z+Detected added unique constraint '%s' on %s)r
r| r rO r r}
CreateIndexOp
from_indexr r joinr AddConstraintOpfrom_constraint)objr+ is_create_table
is_drop_tabler' supports_unique_constraintss r7 obj_addedz/_compare_indexes_and_uniques..obj_added sx < 11 38WeT
%%c&7&B&B39&M&MNNN5HIIv(8 8 9::
/
-
11 38%8%
%%'77 BB AHIIv(8 8 9::
r9 c D | j r| j rsd S | j | j ddd r_j t
j | j t
d| j d S d S srd S | j | j ddd r_j t
j | j t
d| j d S d S )Nr1 Tz#Detected removed index '%s' on '%s'r/ z/Detected removed unique constraint '%s' on '%s')
r
r r| r rO r r} DropIndexOprO r r DropConstraintOprR )rS r+ rT rU r' rV rX s r7 obj_removedz1_compare_indexes_and_uniques..obj_removed sS < }
%@
11 38WdD
%%co&@&@&K&KLLL938U
-
11 38%8$
%%(88CC EH
r9 c v | j rى |j |j dd| j rt d| j d | j t j
| j j t j
|j d S d S |j |j dd| j rt d| j d | j t j
| j j t j
|j d S d S )Nr1 Fz&Detected changed index '%s' on '%s':%srM r/ z2Detected changed unique constraint '%s' on '%s':%s)r
r| r rO r r rP r r} rY rO rN rZ rR rQ )oldnewmsgr+ r' rX s r7 obj_changedz1_compare_indexes_and_uniques..obj_changed s < 11 38WeSY
O <HIIcNN %%co&@&@&K&KLLL%%c&7&B&B39&M&MNNNNN
O
O 11 38%8%
HHIIcNN %%(88CC %%'77 BB
r9 z unique=z to unique=z expression z to )rP constraintsrI indexes frozensethasattrr- rF NotImplementedError TypeError get_indexes _correct_for_uq_duplicates_uixrG r] r correct_for_autogen_constraintsunionr r ra r
r r r} )+r+ r' r rX r r rP metadata_unique_constraintsmetadata_indexes conn_uniques conn_indexes+unique_constraints_duplicate_unique_indexesr metadata_unique_constraints_sigmetadata_indexes_sigconn_unique_constraintsconn_indexes_sigmetadata_names
conn_namesdoubled_constraintsconn_uniques_by_sigmetadata_uniques_by_sigmetadata_indexes_by_sigunnamed_metadata_uniquesrW r[ r` removed_nameconn_objconn_uqconn_idx
existing_name metadata_objr_
added_namerS uq_sigrE rF r rT rU rV s+ ````` @@@@@@r7 _compare_indexes_and_uniquesr s )I D(O"d*M !'
'
$0'
'
'
#
~ 566&)ee# 55"+++-L<"' 27/ 9 6 7 7 K
K ( ? ?& @ /3+ * ' K KBvv 011 KFJCK# '
$ $00f 1 L & LL # D 55LL * L
MMMM MMM
3
& ' #
%*JJ# ' ')D' ' '# , 1D /? N M M M MLLLL|LLL 066
N HG/FGGG@@/?@@@ (../?@@ J ,--::
IH0GHHH < J I4H I I I 1 > @ < s: 9 9. I IJJ " " BL C
"X\5M%M%M
0
0
0 3L A GX $;;;K'>>> G$$$ H%%% K ! ! ! ! N 3 3 @ @ L LMM 9 9
%m4 / / / 3M B GX$
##"!-0H 5 5 5 K ! ! ! Il # # # #C!\%;;;
)))<+A+AC || ///
.6lllL| |vr| | | ^d S )Nc > g | ]}t j | |fS r[ )r r rA consrG s r7 r\ z2_correct_for_uq_duplicates_uix..o s;
/g > >E r9 c h | ] \ }}||
S rk r[ rA rO r s r7 rC z1_correct_for_uq_duplicates_uix..t s( td6F6F6F6Fr9 c @ h | ]\ }}|t | j S rk )r r r s r7 rC z1_correct_for_uq_duplicates_uix..x s4 D$ < 4 $ <.~ s> ;.tW== r9 c , i | ]}|j |j |S r[ )r rO rA r s r7 rq z2_correct_for_uq_duplicates_uix.. s# MMMMTYMMMr9 c 8 i | ]}|j d |j |S )r )r rO r s r7 rq z2_correct_for_uq_duplicates_uix.. s: 9' ( 4 r9 )r r rK ) rr rn rk rl rG metadata_cons_namesmetadata_uq_namesunnamed_metadata_uqsmetadata_ix_names
conn_ix_namesuqs_dupe_indexesoverlaps ` r7 rh rh ] sS $ /
2 - $ NM MMMM + $ 9 9 + + +"#3G#<==A+, , (//0@0IJJJ
-
-
- w!7 8 8 8 9 9r9 r r r' r r Column[Any]r c l |j }|j }||_ ||urt j |j |j rt j | s t j |j |j r t d|| d S ||_ t d|rdnd|| d S d S )Nz3Ignoring nullable change on identity column '%s.%s'z Detected %s on column '%s.%s'NULLzNOT NULL)
nullableexisting_nullabler _server_default_is_computedserver_default_nullability_might_be_unset_server_default_is_identityr r modify_nullable) r+ r r rX r r r metadata_col_nullableconn_col_nullables r7 _compare_nullabler s ) 1 )(9O% 555 3 +X-D
7 EE 7 /1H
HHE
/DO + HH//?Z
' 65r9 r c |j j |u r d|j d< d S |j du r d|j d< d S |j du r d|j d< d S d S )NT
autoincrementF)rV _autoincrement_columnkwr )r+ r r rX r r r s r7 _setup_autoincrementr sr /<??.2?+++ #t + +.2?+++ #u , ,.3?+++
- ,r9 c | |j }||_ |j }|j t j u r t
d|| d S |j t j u r t
d|| d S | j || } | r'||_ t
d|||| d S d S )Nz3Couldn't determine database type for column '%s.%s'z:Column '%s.%s' has no type within the model; can't comparez-Detected type change from %r to %r on '%s.%s')
type
existing_type_type_affinitysqltypesNullTyper r r]
_compare_type modify_type)
r+ r r rX r r r conn_type
metadata_typeisdiffs
r7 r r s
I$-O! %M 8#444 D
#x'888 K
.
<
<, F
&3# ;
r9 metadata_default
Optional[Any]c t | t j rRt | j t r| j } n0t | j |j ddi } t | t r| S d S )N
literal_bindsTrG compile_kwargs)r+ rn
DefaultClauseargr? compilerG )r r+ s r7 "_render_server_default_for_comparer s "I$;<< &*C 0 0 / 3 " $,, + 3$3T#: - "C(( tr9 sqltextr? c R t j dd| S )zwe want to warn if a computed sql expression has changed. however
we don't want false positives and the warning is not that critical.
so filter out most forms of variability from the SQL text.
z[ \(\)'\"`\[\]]ru )resubr& )r s r7 _normalize_computed_defaultr s% 6$b' 2 2 8 8 : ::r9 c t t t j |j j | j ddi }t | }t |j t j rJt |j j | j ddi }|d}nt | }nd}||k rt || d S d S )Nr Tr ru ) r? r rn Computedr r r rG r r+ _warn_computed_not_supported) r+ r r rX r r r rendered_metadata_defaultrendered_conn_defaults r7 _compare_computed_defaultr ! s !$ Y
!<==EMM#+ +T2 N
! ! !<!! ! ()9+=>> # # # + 3 3'/ / 6
4
!
!
! ($& ! !$?%% % ! ! !# $999$UE22222 :9r9 c < t j d| d|d d S )NzComputed default on rr z cannot be modified)r warn)rX r s r7 r r M s' IIuuuMNNNNNr9 c j | j j }| |j |j \ }} }
||
fS rk )r] r _compare_identity_defaultr ) r+ r r rX r r r r diff ignored_attris_alters r7 r r Q sB , 1D#'#A#A#X%<$ $ D, >r9 Optional[bool]c |j }|j }||dS t j | r#t j sdS t | |||||| S t j | rt || dS t j || rU||_ t | |||||| \ } }
|
r3||_ | r*t d||t | n|t || } |r t t | j j nd } ||_ | j ||| | }
|
r#||_ t d|| d S )NFzIDetected server default on column '%s.%s': identity options attributes %sz)Detected server default on column '%s.%s')r r r has_computed_reflectionr r r existing_server_defaultr modify_server_defaultr r r r r r r r r] _compare_server_default)r+ r r rX r r r r conn_col_defaultr r r r is_diffs r7 r r b s $2 . $4$<u./?@@ 2 5 *##
./?@@ $UE222u.* *P 3C/2
h 4DO 1
54LL %G o%
%
!
5E ND& ' ' + 0 0$ 3C/!3KK % !
P4DO 1 HH@% O O O 4r9 Optional[Literal[False]]c | j J | j j sd S |j }|j }||dS ||_ ||k r#||_ t
d|| d S )NFz Detected column comment '%s.%s')rG supports_commentscommentexisting_commentmodify_commentr r ) r+ r r rX r r r metadata_commentconn_col_comments r7 _compare_column_commentr s " . . . " 4 t#+ ' $4$<u'7O$+++)9& 2E5AAA 4r9 c B |d S j }d |j D } fd| D }t |o d|d v fd|D } j j | | fd|D }
fd| D } d | D } d
|
D }
d |
D }d | D } fd
} fd}t | |
D ]7}| | ||
vr)j |v r|j j
nd } || 8t |
| D ]7}|
| || vr)j |v r|j j
nd } || 8d S )Nc F h | ] }t |t j | S r[ )r+ rn r! )rA fks r7 rC z(_compare_foreign_keys.. s; b)8 9 9
r9 c T g | ]$} |d dd "|%S )rO foreign_key_constraintr r? )rA r r+ r rX s r7 r\ z)_compare_foreign_keys.. sT + + vJ $ 8 8
r9 r r r c 0 h | ]}t | S r[ )r )rA r r s r7 rC z(_compare_foreign_keys.. s3 %,, r9 c 2 h | ]}t | S )r r rA r backend_reflects_fk_optionss r7 rC z(_compare_foreign_keys.. s7 2/JKKK r9 c 2 h | ]}t | S r r r s r7 rC z(_compare_foreign_keys.. s7 2/JKKK r9 c i | ]
}|j | S r[ rH r s r7 rq z)_compare_foreign_keys.. s 666Aqua666r9 c i | ]
}|j | S r[ rH r s r7 rq z)_compare_foreign_keys.. s >>>15!>>>r9 c , i | ]}|j |j |S rk r r s r7 rq z)_compare_foreign_keys.. s* qv/A/A/A/Ar9 c , i | ]}|j |j |S rk r r s r7 rq z)_compare_foreign_keys.. s# NNNa16;M;M;M;Mr9 c | j | j dd| rj t j j t dd | j
d | j | j r
d| j z nd| j
d S d S )Nr Fz1Detected added foreign key (%s)(%s) on table %s%srM %s.ru )r| r rO r r} CreateForeignKeyOprR r r rP r" r% r r! )rS
compare_tor+ r r s r7 _add_fkz&_compare_foreign_keys.._add_fk s - - Isx!95*
' '&66u{CC
HHC #,-- #,---0->F)))B
r9 c | j | j dd| rj t j | j t dd | j
d | j | j r
d| j z nd| j
d S d S )Nr Tz3Detected removed foreign key (%s)(%s) on table %s%srM r ru )r| r rO r r} rZ rR r r rP r" r% r r! )rS r r+ r s r7
_remove_fkz)_compare_foreign_keys.._remove_fk) s - - Isx!94
' '$44SY??
HHE #,-- #,---0->F)))B
r9 ) rP ra get_foreign_keysr r] r correct_for_autogen_foreignkeysrI ra rO r )r+ r r rX r r rP metadata_fks
conn_fks_listconn_fksmetadata_fks_sig conn_fks_sigconn_fks_by_sigmetadata_fks_by_sigmetadata_fks_by_nameconn_fks_by_namer r removed_sigr added_sigr r s ````` @@r7 _compare_foreign_keysr s ^ 3 )I , L ,,U6,BB M #'7)}Q'77# # " H %*JJ,
L
76 666O>>-=>>> + ON<NNN
$ ?++667JKK * * , 1 1 1 :!555 %UZ066
Juj ) ) ),--88 II ' ' #I. O + + :!111 !,22
GE: & & &' 'r9 c | j J | j j sd S ||d S |j |j d S |j =|j 6|j t j ||j | d S |j |j k r<|j t j ||j |j | d S d S )N)r r )rG r r r r} DropTableCommentOpCreateTableCommentOp)r+ r r rX r r s r7 _compare_table_commentr P s
" . . . " 4 ^ 3!n&<&D %**<*H ## "
(:6
:#5 5 5 ## $ &!+!3
6 5r9 )r+ r% r, r( r- r. )r+ r% r5 r* r- r. )r+ r% r5 r* rR rS r- r. ) re rI rg rI rP r r5 r* r+ r% r- r. )r r r r# r- r )r r r r# r- r$ )r r r r# r- r! )r r rX r r r# r r# r r) r+ r% rP r r- r )r+ r% r' r) r r rX r r r( r r( r- r. )r+ r% r r' r r rX r r r r r r r r- r. )r+ r% r r' r r rX r r r r r r r r- r. )r r r+ r% r- r )r r? r- r? )r+ r% r r' r r rX r? r r? r r r r r- r. )rX r? r r? r- r. )r+ r% r r' r r rX r r r r r r r r- r )r+ r% r r' r r rX r r r r r r r r- r )r+ r% r r) r r rX r r r( r r( r- r. )a
__future__r
contextlibloggingr typingr r r r r r r
r r r
r
sqlalchemyr r r rn r r r sqlalchemy.sqlr sqlalchemy.utilr alembic.ddl.baser ru r
operationsr r r sqlalchemy.engine.reflectionr sqlalchemy.sql.elementsr r sqlalchemy.sql.schemar r! r" r# r$ alembic.autogenerate.apir% alembic.ddl.implr& alembic.operations.opsr' r( r) r* getLoggerr r r8
DispatcherrM r3 dispatch_forrh rd
immutabledictr r r r r r r r r contextmanagerr r r r r r rh r r r r r r r r r r r r r[ r9 r7 r s " " " " " " " * * * * * * ( ( ( ( ( ( % % % % % % & & & & & & % % % % % % 2 666666333333222222,,,,,,::::::++++++++++++666666777777,,,,,,444444666666555555111111g!!, , , , dod+++ @
(##' ' ' $#'TK9 K9 K9 K9\ -?D,>~!, * + )
- - 4
. EE EE EE EEP $
8
8
8
8
8
8
8
8 ? ? ? ? ? ? ? ?&* * * * * * * *Z
'""I8 I8 I8 #"I8X
:9 :9 :9z
(##& & & $#&R
(##4 4 4 $#4$
(##(
(
(
$#(
V (; ; ; ;)3 )3 )3 )3XO O O O "
(##U U U $#Up
(## $#8
'""t' t' t' #"t'n
'""#
#
#
#"#
#
#
r9