+h&0ddlmZddlZddlmZddlmZddlmZddlmZddlm Z ddlm Z dd l m Z dd lmZdd lmZdd lmZd dlmZd dlmZd dlmZd dlmZd dlmZerZ;e e0 dQd?Z<e e1 dRd@Z=e e2 dSdAZ> dTdBZ? dUdCZ@ dVdDZA dWdEZBdXdFZC dYdGZDdZdHZEdZdIZFd[dJZGy)\) 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)Computed)Identity)Compiled) DDLCompiler) TextClause)Function) FetchedValue) TypeEngine) DefaultImplrrz Function[Any]c&eZdZdZ d ddZy) AlterTablezRepresent an ALTER TABLE statement. Only the string name and optional schema name of the table is required, not a full Table object. Nc ||_||_yN) table_nameschema)selfr#r$s C/var/www/html/venv/lib/python3.12/site-packages/alembic/ddl/base.py__init__zAlterTable.__init__2s % r")r#strr$!Optional[Union[quoted_name, str]]returnNone)__name__ __module__ __qualname____doc__r'r(r&r r *s-592  r(r c2eZdZ d dfd ZxZS) RenameTablec6t|||||_yN)r$)superr'new_table_name)r%old_table_namer7r$ __class__s r&r'zRenameTable.__init__<s 7,r(r")r8r)r7Union[quoted_name, str]r$r*r+r,r-r.r/r' __classcell__r9s@r&r3r3;s8 59 --0-2 -  --r(r3cJeZdZ d dfd ZxZS) AlterColumnct|||||_|tj|nd|_||_||_||_yr5) r6r' column_namesqltypes to_instance existing_typeexisting_nullableexisting_server_defaultexisting_comment) r%namerAr$rDrErFrGr9s r&r'zAlterColumn.__init__Gs\ f-&(   /  "3'>$ 0r()NNNNN)rHr)rAr)r$ Optional[str]rDzOptional[TypeEngine]rEzOptional[bool]rFOptional[_ServerDefault]rGrIr+r,r;r=s@r&r?r?Fsl !%.2,0<@*.111 1 , 1 * 1":1(1 11r(r?c0eZdZ dfd ZxZS)ColumnNullablec 6t|||fi|||_yr")r6r'nullable)r%rHrArNkwr9s r&r'zColumnNullable.__init__^s  {1b1  r()rHr)rAr)rNboolr+r,r;r=s@r&rLrL]s-!!&)!59! !!r(rLc0eZdZ dfd ZxZS) ColumnTypec \t|||fi|tj||_yr")r6r'rBrCtype_)r%rHrArTrOr9s r&r'zColumnType.__init__fs+ {1b1))%0 r()rHr)rAr)rTrr+r,r;r=s@r&rRrRes-11&)12<1 11r(rRc0eZdZ dfd ZxZS) ColumnNamec 6t|||fi|||_yr")r6r'newname)r%rHrArXrOr9s r&r'zColumnName.__init__n  {1b1 r()rHr)rAr)rXr)r+r,r;r=s@r&rVrVms-&)47 r(rVc0eZdZ dfd ZxZS) ColumnDefaultc 6t|||fi|||_yr"r6r'defaultr%rHrAr^rOr9s r&r'zColumnDefault.__init__vs  {1b1 r()rHr)rAr)r^rJr+r,r;r=s@r&r[r[us3*   r(r[c0eZdZ dfd ZxZS)ComputedColumnDefaultc 6t|||fi|||_yr"r]r_s r&r'zComputedColumnDefault.__init__rYr()rHr)rAr)r^zOptional[Computed]r+r,r;r=s@r&raras-&)4F r(rac4eZdZ dfd ZxZS)IdentityColumnDefaultc Dt|||fi|||_||_yr")r6r'r^impl)r%rHrAr^rfrOr9s r&r'zIdentityColumnDefault.__init__s' {1b1  r() rHr)rAr)r^zOptional[Identity]rfrr+r,r;r=s@r&rdrds=   $      r(rdc2eZdZ d dfd ZxZS) AddColumnc6t|||||_yr5r6r'columnr%rHrkr$r9s r&r'zAddColumn.__init__s f- r(r")rHr)rk Column[Any]r$r*r+r,r;r=s@r&rhrhs8 59 2   r(rhc2eZdZ d dfd ZxZS) DropColumnc6t|||||_yr5rjrls r&r'zDropColumn.__init__s f- r(r")rHr)rkrmr$rIr+r,r;r=s@r&roros0FJ!,6C r(roc0eZdZ dfd ZxZS) ColumnCommentc 6t|||fi|||_yr")r6r'comment)r%rHrArtrOr9s r&r'zColumnComment.__init__rYr()rHr)rAr)rtrIr+r,r;r=s@r&rrrrs-&)4A r(rrc t||j|jdt||j|jS)Nz RENAME TO ) alter_tabler#r$format_table_namer7elementcompilerrOs r&visit_rename_tabler{s: Hg00'..A(G$:$:GNNK r(c xt||j|jdt||jfi|SN )rvr#r$ add_columnrkrxs r&visit_add_columnrs7 Hg00'..A8W^^2r2 r(c t||j|jdt||jj fi|Sr})rvr#r$ drop_columnrkrHrxs r&visit_drop_columnrs= Hg00'..AHgnn118R8 r(c t||j|jdt||jd|j rdSdS)Nr~z DROP NOT NULLz SET NOT NULL)rvr#r$ alter_columnrArNrxs r&visit_column_nullablersU Hg00'..AXw223"++? 2@? r(c t||j|jdt||jddt ||j zS)Nr~zTYPE %s)rvr#r$rrA format_typerTrxs r&visit_column_typersG Hg00'..AXw223K'--88 r(c t||j|jdt||jdt||j S)Nz RENAME z TO )rvr#r$format_column_namerArXrxs r&visit_column_namersB Hg00'..A8W%8%898W__5 r(c t||j|jdt||jd|j dt ||j zSdS)Nr~zSET DEFAULT %sz DROP DEFAULT)rvr#r$rrAr^format_server_defaultrxs r&visit_column_defaultrso Hg00'..AXw223* 4XwO O      r(c ,tjd)NztAdding or removing a "computed" construct, e.g. GENERATED ALWAYS AS, to or from an existing column is not supported.r CompileErrorrxs r&visit_computed_columnrs    E r(c ,tjd)NzAdding, removing or modifying an "identity" construct, e.g. GENERATED AS IDENTITY, to or from an existing column is not supported in this dialect.rrxs r&visit_identity_columnrs    3 r(ct|tr||Sdj|jdDcgc] }|| c}}|Scc}w)z#quote the elements of a dotted name.) isinstancer joinsplit)rHquotexresults r& quote_dottedr sG $ $T{ XXC9AuQx9 :F M:sActj|jj}|rt ||dz||zS||S)Nr) functoolspartialpreparerrr)rzrHr$rs r&rwrwsH   h//55 6E FE*S05;>>T{r(c8|jj|Sr")rrrzrHs r&rr$s    " "4 ((r(cP|jtdt|}|J|S)Nr)server_default)get_column_default_stringr r)rzr^ default_strs r&rr*s4 44sGG4K  "" " r(cL|jjj|Sr")dialect type_compilerprocess)rzrTs r&rr7s    ) ) 1 1% 88r(c"dt|||zS)NzALTER TABLE %s)rw)rzrHr$s r&rvrv;s /$G GGr(c  dt||zS)NzDROP COLUMN %sr)rzrHrOs r&rrCs 04@ @@r(c dt||zS)NzALTER COLUMN %srrs r&rrGs 1(DA AAr(c dj|fi|z}djfd|jD}|r|d|zz }|S)Nz ADD COLUMN %sr~c3@K|]}j|ywr")r).0 constraintrzs r& zadd_column..Ns!)3$s)get_column_specificationr constraints)rzrkrOtextconsts` r&rrKsY >X>>vLL LD HH7=7I7I E  e  Kr()ryr3rzrr+r))ryrhrzrr+r))ryrorzrr+r))ryrLrzrr+r))ryrRrzrr+r))ryrVrzrr+r))ryr[rzrr+r))ryrarzr)ryrdrzr)rHr:rzfunctools.partialr+r:)rzrrHr:r$r*r+r:)rzrrHr*r+r:)rzrr^rJr+r))rzrrTrr+r))rzrrHr)r$rIr+r))rzrrHr)r+r))rzrrkrmr+r))H __future__rrtypingrrr sqlalchemyrrr rBsqlalchemy.ext.compilerr sqlalchemy.schemar r sqlalchemy.sql.elementsr util.sqla_compatrrrrrrrrsqlalchemy.sql.compilerrrrsqlalchemy.sql.functionsrsqlalchemy.sql.schemarsqlalchemy.sql.type_apirrfrr)_ServerDefaultr r3r?rLrRrVr[rardrhrorrr{rrrrrrrrrrwrrrrvrrrr1r(r&rs# (,$(/6,'-4##032122!|^_cIJ"-*-1*1.![!11 K K K  K + $/ ) * . '2 * * -   &1      ".9!   ".9! !*;   !  .  ))!B))   %   9HH H H HAB r(