U ^g%i<&ã@s¦ddlmZddlZddlmZddlmZddlmZddlmZddlm Z ddlm Zdd lm Z dd lmZddlmZddlmZd dlmZd dlmZd dlmZd dlmZd dlmZerFddlmZddlmZddlmZddlmZddlmZddl m!Z!ddl"m#Z#ddl$m%Z%d dlm&Z&d dlm'Z'eddd e(fZ)Gd!d"„d"eƒZ*Gd#d$„d$e*ƒZ+Gd%d&„d&e*ƒZ,Gd'd(„d(e,ƒZ-Gd)d*„d*e,ƒZ.Gd+d,„d,e,ƒZ/Gd-d.„d.e,ƒZ0Gd/d0„d0e,ƒZ1Gd1d2„d2e,ƒZ2Gd3d4„d4e*ƒZ3Gd5d6„d6e*ƒZ4Gd7d8„d8e,ƒZ5e e+ƒd$d9d:d;œdd?„ƒZ7e e4ƒd6d9d:d;œd@dA„ƒZ8e e-ƒd(d9d:d;œdBdC„ƒZ9e e.ƒd*d9d:d;œdDdE„ƒZ:e e/ƒd,d9d:d;œdFdG„ƒZ;e e0ƒd.d9d:d;œdHdI„ƒZdOdPdOdQœdRdS„Z?dTdOdUdOdVœdWdX„Z@d9dUdOdYœdZd[„ZAd9d\d:d]œd^d_„ZBd9d`d:daœdbdc„ZCd9d:ddd:dVœdedf„ZDd9d:d:dYœdgdh„ZEd9d:d:dYœdidj„ZFd9dkd:dlœdmdn„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)ÚIdentityrrz Function[Any]c@s$eZdZdZd ddddœdd„ZdS) Ú AlterTablez“Represent an ALTER TABLE statement. Only the string name and optional schema name of the table is required, not a full Table object. NÚstrú!Optional[Union[quoted_name, str]]ÚNone)Ú table_nameÚschemaÚreturncCs||_||_dS©N)r"r#)Úselfr"r#©r'úO/var/www/html/api-medvista/venv/lib/python3.8/site-packages/alembic/ddl/base.pyÚ__init__2szAlterTable.__init__)N)Ú__name__Ú __module__Ú__qualname__Ú__doc__r)r'r'r'r(r*s ýrcs*eZdZd dddddœ‡fdd„ Z‡ZS) ÚRenameTableNrúUnion[quoted_name, str]r r!)Úold_table_nameÚnew_table_namer#r$cstƒj||d||_dS©N)r#)Úsuperr)r1)r&r0r1r#©Ú __class__r'r(r)<szRenameTable.__init__)N©r*r+r,r)Ú __classcell__r'r'r4r(r.;sür.c s2eZdZddddddddddœ‡fd d „ Z‡ZS)ÚAlterColumnNrú Optional[str]zOptional[TypeEngine]zOptional[bool]úOptional[_ServerDefault]r!)ÚnameÚcolumn_namer#Ú existing_typeÚexisting_nullableÚexisting_server_defaultÚexisting_commentr$csDtƒj||d||_|dk r(t |¡nd|_||_||_||_dSr2) r3r)r<ÚsqltypesÚto_instancer=r>r?r@)r&r;r<r#r=r>r?r@r4r'r(r)Gs ÿýzAlterColumn.__init__)NNNNNr6r'r'r4r(r8Fsør8cs(eZdZdddddœ‡fdd„Z‡ZS)ÚColumnNullablerÚboolr!)r;r<Únullabler$cstƒj||f|Ž||_dSr%)r3r)rE)r&r;r<rEÚkwr4r'r(r)^szColumnNullable.__init__r6r'r'r4r(rC]srCcs(eZdZdddddœ‡fdd„Z‡ZS)Ú ColumnTyperrr!)r;r<Útype_r$cs"tƒj||f|Žt |¡|_dSr%)r3r)rArBrH)r&r;r<rHrFr4r'r(r)fszColumnType.__init__r6r'r'r4r(rGesrGcs(eZdZdddddœ‡fdd„Z‡ZS)Ú ColumnNamerr!)r;r<Únewnamer$cstƒj||f|Ž||_dSr%)r3r)rJ)r&r;r<rJrFr4r'r(r)nszColumnName.__init__r6r'r'r4r(rImsrIcs(eZdZdddddœ‡fdd„Z‡ZS)Ú ColumnDefaultrr:r!©r;r<Údefaultr$cstƒj||f|Ž||_dSr%©r3r)rM©r&r;r<rMrFr4r'r(r)vszColumnDefault.__init__r6r'r'r4r(rKusrKcs(eZdZdddddœ‡fdd„Z‡ZS)ÚComputedColumnDefaultrzOptional[Computed]r!rLcstƒj||f|Ž||_dSr%rNrOr4r'r(r)‚szComputedColumnDefault.__init__r6r'r'r4r(rPsrPcs*eZdZddddddœ‡fdd„Z‡ZS)ÚIdentityColumnDefaultrzOptional[Identity]rr!)r;r<rMÚimplr$cs"tƒj||f|Ž||_||_dSr%)r3r)rMrR)r&r;r<rMrRrFr4r'r(r)ŠszIdentityColumnDefault.__init__r6r'r'r4r(rQ‰srQcs*eZdZd dddddœ‡fdd„ Z‡ZS) Ú AddColumnNrúColumn[Any]r r!©r;Úcolumnr#r$cstƒj||d||_dSr2©r3r)rV©r&r;rVr#r4r'r(r)˜szAddColumn.__init__)Nr6r'r'r4r(rS—sürScs*eZdZd dddddœ‡fdd„ Z‡ZS) Ú DropColumnNrrTr9r!rUcstƒj||d||_dSr2rWrXr4r'r(r)£szDropColumn.__init__)Nr6r'r'r4r(rY¢sÿrYcs(eZdZdddddœ‡fdd„Z‡ZS)Ú ColumnCommentrr9r!)r;r<Úcommentr$cstƒj||f|Ž||_dSr%)r3r)r[)r&r;r<r[rFr4r'r(r)«szColumnComment.__init__r6r'r'r4r(rZªsrZrr)ÚelementÚcompilerr$cKs$dt||j|jƒt||j|jƒfS)Nz%s RENAME TO %s)Úalter_tabler"r#Úformat_table_namer1©r\r]rFr'r'r(Úvisit_rename_table²sþracKs$dt||j|jƒt||jf|ŽfS©Nz%s %s)r^r"r#Ú add_columnrVr`r'r'r(Úvisit_add_column¼sþrdcKs&dt||j|jƒt||jjf|ŽfSrb)r^r"r#Údrop_columnrVr;r`r'r'r(Úvisit_drop_columnÄsþrfcKs,dt||j|jƒt||jƒ|jr$dndfS)Nú%s %s %sz DROP NOT NULLzSET NOT NULL)r^r"r#Úalter_columnr<rEr`r'r'r(Úvisit_column_nullableÌs ýricKs.dt||j|jƒt||jƒdt||jƒfS)NrgzTYPE %s)r^r"r#rhr<Úformat_typerHr`r'r'r(Úvisit_column_type×s ýrkcKs*dt||j|jƒt||jƒt||jƒfS)Nz%s RENAME %s TO %s)r^r"r#Úformat_column_namer<rJr`r'r'r(Úvisit_column_nameàs ýrmcKs<dt||j|jƒt||jƒ|jdk r4dt||jƒndfS)NrgzSET DEFAULT %szDROP DEFAULT)r^r"r#rhr<rMÚformat_server_defaultr`r'r'r(Úvisit_column_defaultés ÿúro)r\r]cKst d¡‚dS)NztAdding or removing a "computed" construct, e.g. GENERATED ALWAYS AS, to or from an existing column is not supported.©rÚCompileErrorr`r'r'r(Úvisit_computed_columnøsÿrrcKst d¡‚dS)Nz’Adding, removing or modifying an "identity" construct, e.g. GENERATED AS IDENTITY, to or from an existing column is not supported in this dialect.rpr`r'r'r(Úvisit_identity_columnsÿrsr/zfunctools.partial)r;Úquoter$cs4t|tƒrˆ|ƒSd ‡fdd„| d¡Dƒ¡}|S)z#quote the elements of a dotted nameÚ.csg|]}ˆ|ƒ‘qSr'r')Ú.0Úx©rtr'r(Ú sz quote_dotted..)Ú isinstancerÚjoinÚsplit)r;rtÚresultr'rxr(Úquote_dotted s r~rr )r]r;r#r$cCs4t |jj¡}|r(t||ƒd||ƒS||ƒSdS)Nru)Ú functoolsÚpartialÚpreparerrtr~)r]r;r#rtr'r'r(r_sr_)r]r;r$cCs|j |¡Sr%)rrt©r]r;r'r'r(rl$srlr:)r]rMr$cCs| tdt|d¡S)Nrw)Zserver_default)Zget_column_default_stringr r)r]rMr'r'r(rn*sÿrnr)r]rHr$cCs|jj |¡Sr%)ÚdialectZ type_compilerÚprocess)r]rHr'r'r(rj3srjr9cCsdt|||ƒS)NzALTER TABLE %s)r_)r]r;r#r'r'r(r^7sr^cKsdt||ƒS)NzDROP COLUMN %s©rl)r]r;rFr'r'r(re?srecCsdt||ƒS)NzALTER COLUMN %sr…r‚r'r'r(rhCsrhrT)r]rVr$cs@dˆj|f|Ž}d ‡fdd„|jDƒ¡}|r<|d|7}|S)Nz ADD COLUMN %sú c3s|]}ˆ |¡VqdSr%)r„)rvÚ constraint©r]r'r(Ú Jszadd_column..)Zget_column_specificationr{Úconstraints)r]rVrFÚtextÚconstr'rˆr(rcGsÿrc)HÚ __future__rrÚtypingrrrZ sqlalchemyrrrrAZsqlalchemy.ext.compilerr Zsqlalchemy.schemar rZsqlalchemy.sql.elementsrZutil.sqla_compatrrrrrrZsqlalchemy.sql.compilerrrrZsqlalchemy.sql.functionsrZsqlalchemy.sql.schemarZsqlalchemy.sql.type_apirrRrrrrZ_ServerDefaultrr.r8rCrGrIrKrPrQrSrYrZrardrfrirkrmrorrrsr~r_rlrnrjr^rerhrcr'r'r'r(Ús†