ZeIi(|ddlmZddlZddlmZddlmZddlmZddlmZddlm Z ddlm Z dd l m Z dd lmZdd lmZdd lmZd dlmZd dlmZd dlmZd dlmZd dlmZerZ6e e3dbd?Z7e e4dcd@Z8e e-dddAZ9e e.dedBZ:e e/dfdCZ;e e0dgdDZ<e e1dhdEZ=e e2didFZ>djdKZ?dkdOZ@dldPZAdmdSZBdndVZCdodXZD dpdqd[ZEdrd\ZF dpdsd`ZGdS)t) 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]ceZdZdZ 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"||_||_dSN)r!r#)selfr!r#s U/var/www/html/MCyber-Diagnostic/venv/lib/python3.11/site-packages/alembic/ddl/base.py__init__zAlterTable.__init__2s % r()r!r"r#r$r%r&)__name__ __module__ __qualname____doc__r+r,r*r r *s<59r,r c$eZdZ d d fd ZxZS) RenameTableNold_table_namer"new_table_nameUnion[quoted_name, str]r#r$r%r&c\t||||_dSN)r#)superr+r5)r)r4r5r# __class__s r*r+zRenameTable.__init__<s0 777,r,r()r4r"r5r6r#r$r%r&r-r.r/r+ __classcell__r:s@r*r3r3;sG 59 -----------r,r3c,eZdZ ddfd ZxZS) AlterColumnNnamer" column_namer# Optional[str] existing_typeOptional[TypeEngine]existing_nullableOptional[bool]existing_server_defaultOptional[_ServerDefault]existing_commentr%r&ct||||_|tj|nd|_||_||_||_dSr8) r9r+rAsqltypes to_instancerCrErGrI) r)r@rAr#rCrErGrIr:s r*r+zAlterColumn.__init__Gsp f---&(   / / /  "3'>$ 0r,)NNNNN)r@r"rAr"r#rBrCrDrErFrGrHrIrBr%r&r;r=s@r*r?r?FsS !%.2,0<@*.11111111111r,r?c eZdZd fd ZxZS) ColumnNullabler@r"rAnullableboolr%r&c Ltj||fi|||_dSr()r9r+rO)r)r@rArOkwr:s r*r+zColumnNullable.__init__^s1 {11b111  r,)r@r"rAr"rOrPr%r&r;r=s@r*rNrN]s=!!!!!!!!!!r,rNc eZdZd fd ZxZS) ColumnTyper@r"rAtype_rr%r&c ptj||fi|tj||_dSr()r9r+rKrLrU)r)r@rArUrRr:s r*r+zColumnType.__init__fs< {11b111)%00 r,)r@r"rAr"rUrr%r&r;r=s@r*rTrTes=1111111111r,rTc eZdZdfd ZxZS) ColumnNamer@r"rAnewnamer%r&c Ltj||fi|||_dSr()r9r+rY)r)r@rArYrRr:s r*r+zColumnName.__init__n1 {11b111 r,)r@r"rAr"rYr"r%r&r;r=s@r*rXrXm=r,rXc eZdZd fd ZxZS) ColumnDefaultr@r"rAdefaultrHr%r&c Ltj||fi|||_dSr(r9r+r_r)r@rAr_rRr:s r*r+zColumnDefault.__init__vs1 {11b111 r,)r@r"rAr"r_rHr%r&r;r=s@r*r^r^us=r,r^c eZdZd fd ZxZS) ComputedColumnDefaultr@r"rAr_Optional[Computed]r%r&c Ltj||fi|||_dSr(rarbs r*r+zComputedColumnDefault.__init__r[r,)r@r"rAr"r_rer%r&r;r=s@r*rdrdr\r,rdc eZdZd fd ZxZS) IdentityColumnDefaultr@r"rAr_Optional[Identity]implrr%r&c Ztj||fi|||_||_dSr()r9r+r_rj)r)r@rAr_rjrRr:s r*r+zIdentityColumnDefault.__init__s8 {11b111  r,) r@r"rAr"r_rirjrr%r&r;r=s@r*rhrhs=          r,rhc&eZdZ d dfd ZxZS) AddColumnNr@r"column Column[Any]r#r$ if_not_existsrFr%r&cjt||||_||_dSr8)r9r+rnrp)r)r@rnr#rpr:s r*r+zAddColumn.__init__s7 f--- *r,NN) r@r"rnror#r$rprFr%r&r;r=s@r*rmrmsJ 59(, + + + + + + + + + + +r,rmc&eZdZ d dfd ZxZS) DropColumnNr@r"rnror#rB if_existsrFr%r&cjt||||_||_dSr8)r9r+rnru)r)r@rnr#rur:s r*r+zDropColumn.__init__s4 f--- "r,rr) r@r"rnror#rBrurFr%r&r;r=s@r*rtrtsJ !%$( # # # # # # # # # # #r,rtc eZdZd fd ZxZS) ColumnCommentr@r"rAcommentrBr%r&c Ltj||fi|||_dSr()r9r+ry)r)r@rAryrRr:s r*r+zColumnComment.__init__r[r,)r@r"rAr"ryrBr%r&r;r=s@r*rxrxr\r,rxelementcompilerrr%r"c tt||j|jdt||j|jS)Nz RENAME TO ) alter_tabler!r#format_table_namer5r{r|rRs r*visit_rename_tablers? Hg0'.AAAA(G$:GNKKK r,c rt||j|jdt||jfd|ji|S)N rp)r~r!r# add_columnrnrprs r*visit_add_columnrsY Hg0'.AAAA gn  4;4I MO    r,c |t||j|jdt||jjfd|ji|S)Nrru)r~r!r# drop_columnrnr@rurs r*visit_drop_columnrs\ Hg0'.AAAA gn)  5<5F JL    r,c t||j|jdt||jd|jrdndS)Nrz DROP NOT NULLz SET NOT NULL)r~r!r# alter_columnrArOrs r*visit_column_nullablersP Hg0'.AAAAXw23333"+?? r,c t||j|jdt||jddt ||jzS)NrzTYPE %s)r~r!r#rrA format_typerUrs r*visit_column_typersU Hg0'.AAAAXw23333K'-8888 r,c t||j|jdt||jdt||jS)Nz RENAME z TO )r~r!r#format_column_namerArYrs r*visit_column_namersP Hg0'.AAAA8W%899998W_555 r,c t||j|jdt||jd|jdt ||jzndS)NrzSET DEFAULT %sz DROP DEFAULT)r~r!r#rrAr_format_server_defaultrs r*visit_column_defaultrsj Hg0'.AAAAXw23333* 4XwOO O 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 CompileErrorrs 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.rrs r*visit_identity_columnr s   3  r,r@r6quotefunctools.partialct|tr |Sdfd|dD}|S)z#quote the elements of a dotted name.c&g|] }|Sr1r1).0xrs r* z quote_dotted..s!999AuuQxx999r,) isinstancer joinsplit)r@rresults ` r* quote_dottedrsZ $ $$uT{{ XX9999C999 : :F Mr,rr#r$ctj|jj}|rt ||dz||zS||S)Nr) functoolspartialpreparerrr)r|r@r#rs r*rr#sR  h/5 6 6E FE**S055;;>>uT{{r,c6|j|Sr()rrr|r@s r*rr/s   " "4 ( ((r,r_rHcb|tdt|}|J|S)Nr)server_default)get_column_default_stringr r)r|r_ default_strs r*rr5s? 44sGG444K  " " " r,rUrc@|jj|Sr()dialect type_compilerprocess)r|rUs r*rrBs   ) 1 1% 8 88r,rBc*dt|||zS)NzALTER TABLE %s)r)r|r@r#s r*r~r~Fs /$GG GGr,rurFc 4d|rdndt||S)Nz DROP COLUMN z IF EXISTS r)r|r@rurRs r*rrNs/") r)8T*** r,c(dt||zS)NzALTER COLUMN %srrs r*rrWs 1(DAA AAr,rnrorpc d|rdndj|fi|}dfd|jD}|r|d|zz }|S)Nz ADD COLUMN zIF NOT EXISTS rrc3BK|]}|VdSr()r)r constraintr|s r* zadd_column..fsB)3$$r,)get_column_specificationr constraints)r|rnrprRtextconsts` r*rr[s*1r1))&77B777 D HH7=7I  E  e  Kr,)r{r3r|rr%r")r{rmr|rr%r")r{rtr|rr%r")r{rNr|rr%r")r{rTr|rr%r")r{rXr|rr%r")r{r^r|rr%r")r{rdr|r)r{rhr|r)r@r6rrr%r6)r|rr@r6r#r$r%r6)r|rr@r$r%r6)r|rr_rHr%r")r|rrUrr%r")r|rr@r"r#rBr%r"r()r|rr@r"rurFr%r")r|rr@r"r%r")r|rrnrorprFr%r")H __future__rrtypingrrr sqlalchemyrrr rKsqlalchemy.ext.compilerr sqlalchemy.schemar r sqlalchemy.sql.elementsr util.sqla_compatrrrrrrrrsqlalchemy.sql.compilerrrrsqlalchemy.sql.functionsrsqlalchemy.sql.schemarsqlalchemy.sql.type_apirrjrr"_ServerDefaultr r3r?rNrTrXr^rdrhrmrtrxrrrrrrrrrrrrrrr~rrrr1r,r*rs[#""""" ((((((,,,,,,$$$$$$((((((//////666666,,,,,,''''''------444444 "############000000333333222222111111222222222222!!!!!!|^_cIJ"-----*---11111*111.!!!!![!!!11111111     K   K     K    + + + + + + + + # # # # # # # #K + ) * . * * -        !     !     ))))    9999HHHHCGBBBB%)r,