ޠjVXVSSKJr SSKJr SSKJr SSKrSSKrSSKJr SSKJ r SSK J r SS K J r SS K Jr S S K Jr S S KJr S SKJr S SKJr \ (arSSKJr SSKJr SSKJr SSKJr SSKJr SSKJr S SKJr S SKJ r S SKJ!r! S SKJ"r" S SK#J$r$ S SK#J%r% S SK#J&r& S SK#J'r' S SK(J)r) S SK*J+r+ S S K*J,r, S S!K-J.r. S S"KJ/r/ \R`"\15r2S+S#jr3S,S$jr4S-S.S%jjr5S/S&jr6"S'S(5r7"S)S*5r8g)0) annotations)Iterator)SequenceN)Any) TYPE_CHECKING)inspect)compare)render)util)ops)Plugin) sqla_compat) Connection)Dialect) Inspector)MetaData) SchemaItem)Table)Config) DowngradeOps)MigrationScript) UpgradeOps)NameFilterParentNames)NameFilterType)ProcessRevisionDirectiveFn) RenderItemFnMigrationContext)Script)ScriptDirectory) _GetRevArg)PriorityDispatchercj[X5nURceURR5$)a Compare a database schema to that given in a :class:`~sqlalchemy.schema.MetaData` instance. The database connection is presented in the context of a :class:`.MigrationContext` object, which provides database connectivity as well as optional comparison functions to use for datatypes and server defaults - see the "autogenerate" arguments at :meth:`.EnvironmentContext.configure` for details on these. The return format is a list of "diff" directives, each representing individual differences:: from alembic.migration import MigrationContext from alembic.autogenerate import compare_metadata from sqlalchemy import ( create_engine, MetaData, Column, Integer, String, Table, text, ) import pprint engine = create_engine("sqlite://") with engine.begin() as conn: conn.execute( text( ''' create table foo ( id integer not null primary key, old_data varchar, x integer ) ''' ) ) conn.execute(text("create table bar (data varchar)")) metadata = MetaData() Table( "foo", metadata, Column("id", Integer, primary_key=True), Column("data", Integer), Column("x", Integer, nullable=False), ) Table("bat", metadata, Column("info", String)) mc = MigrationContext.configure(engine.connect()) diff = compare_metadata(mc, metadata) pprint.pprint(diff, indent=2, width=20) Output:: [ ( "add_table", Table( "bat", MetaData(), Column("info", String(), table=), schema=None, ), ), ( "remove_table", Table( "bar", MetaData(), Column("data", VARCHAR(), table=), schema=None, ), ), ( "add_column", None, "foo", Column("data", Integer(), table=), ), [ ( "modify_nullable", None, "foo", "x", { "existing_comment": None, "existing_server_default": False, "existing_type": INTEGER(), }, True, False, ) ], ( "remove_column", None, "foo", Column("old_data", VARCHAR(), table=), ), ] :param context: a :class:`.MigrationContext` instance. :param metadata: a :class:`~sqlalchemy.schema.MetaData` instance. .. seealso:: :func:`.produce_migrations` - produces a :class:`.MigrationScript` structure based on metadata comparison. )produce_migrations upgrade_opsas_diffs)contextmetadatamigration_scripts R/var/www/html/gaurav/venv/lib/python3.13/site-packages/alembic/autogenerate/api.pycompare_metadatar--s7r*'<  ' ' 33 3  ' ' 0 0 22c[XS9n[R"S[R"/5[R"/5S9n[ R "X#5 U$)aProduce a :class:`.MigrationScript` structure based on schema comparison. This function does essentially what :func:`.compare_metadata` does, but then runs the resulting list of diffs to produce the full :class:`.MigrationScript` object. For an example of what this looks like, see the example in :ref:`customizing_revision`. .. seealso:: :func:`.compare_metadata` - returns more fundamental "diff" data from comparing a schema. )r*Nrev_idr' downgrade_ops)AutogenContextrrrrr _populate_migration_script)r)r*autogen_contextr+s r,r&r&sR$%W@O**NN2&&&r*  &&I r.cUUUUUS.nUc!SSKJn SSKJn U R"U "5S9n[ XhS9n [ U5U l[R"[R"X 55$)aRender Python code given an :class:`.UpgradeOps` or :class:`.DowngradeOps` object. This is a convenience function that can be used to test the autogenerate output of a user-defined :class:`.MigrationScript` structure. :param up_or_down_op: :class:`.UpgradeOps` or :class:`.DowngradeOps` object :param sqlalchemy_module_prefix: module prefix for SQLAlchemy objects :param alembic_module_prefix: module prefix for Alembic constructs :param render_as_batch: use "batch operations" style for rendering :param imports: sequence of import symbols to add :param render_item: callable to render items :param migration_context: optional :class:`.MigrationContext` :param user_module_prefix: optional string prefix for user-defined types .. versionadded:: 1.11.0 )sqlalchemy_module_prefixalembic_module_prefix render_itemrender_as_batchuser_module_prefixr rr)DefaultDialect)dialect)opts) runtime.migrationr sqlalchemy.engine.defaultr< configurer3setimportsr _indent_render_cmd_body) up_or_down_opr7r8r:rCr9migration_contextr;r>r r<r5s r,render_python_coderHsw:%=!6"*0  D 8<,66"$ %%6BO!'lO >> ? r.c[U5n[R"/5n[R"X#5 [R "SUUR 5S9n[R"X$U5 g)z6legacy, used by test_autogen_composition at the momentNr0) r3rrr _produce_net_changesrreverser _render_python_into_templatevars)r) template_argsr5r'r+s r,_render_migration_diffsrNsb %W-O..$K   >**!))+  ++=r.cr\rSrSr%SrSrS\S'SrS\S'S\S 'SrS \S 'S \S 'S\S'SSSjjr \ RSSj5r \ RSSj5rSSjrSSjr\r\ RSSj5r\ RSSj5rSrg) r3izOMaintains configuration and state that's specific to an autogenerate operation.N$MetaData | Sequence[MetaData] | Noner*zConnection | None connectionrr=zset[str]rCr rGr$ comparatorscU(a*Ub'UR(a[R"S5eU(a][RR 5Ul[ R"URURRSS/5S9 Uc URnUcURSS5OU=Ul nU(a@Uc=Ub:URb-[R"SURR-5eURSS5nURSS5n/n/nU(aURU5 U(aURU5 XplXlXlUR R"UlUR R&Ul[)5UlX0lS Ulg) Nz^autogenerate can't use as_sql=True as it prevents querying the database for schema informationautogenerate_pluginszalembic.autogenerate.*)include_pluginstarget_metadatazCan't proceed with --autogenerate option; environment script %s does not provide a MetaData object or sequence of objects to the context.include_object include_nameF)as_sqlr CommandErrorr rRbranchr'populate_autogenerate_priority_dispatchr>getr*scriptenv_py_locationappend_object_filters _name_filtersrGbindrQr=rBrC _has_batch) selfrGr*r> autogeneraterWrXobject_filters name_filterss r,__init__AutogenContext.__init__Ls !-!((##6  &2299;D   : :  1 6 6 : :*-E,F!  <$))D2:1ADHH& -x    !-!((4##K%++;;= "2D9xx5    ! !. 1     --)!20055--55 u $( %r.c\URc [S5e[UR5$)NzHcan't return inspector as this AutogenContext has no database connection)rQ TypeErrorrres r, inspectorAutogenContext.inspectors/ ?? "< t''r.c#0# SUlSv SUlg7f)NTF)rdrms r, _within_batchAutogenContext._within_batchs scSU;a?US:XaUnOURSS5nU(aUSnU(a U<SU<3US'OXCS'URHnU"XU5(aM g g) aRun the context's name filters and return True if the targets should be part of the autogenerate operation. This method should be run for every kind of name encountered within the reflection side of an autogenerate operation, giving the environment the chance to filter what names should be reflected as database objects. The filters here are produced directly via the :paramref:`.EnvironmentContext.configure.include_name` parameter. schema_nametable table_nameN.schema_qualified_table_nameFT)r]rb)renametype_ parent_namesrvrtfns r,run_name_filtersAutogenContext.run_name_filterss L (! )--lDA *=9 #"CL!>? CM!>?$$Bd<00%r.cLURHnU"XX4U5(aM g g)aRun the context's object filters and return True if the targets should be part of the autogenerate operation. This method should be run for every kind of object encountered within an autogenerate operation, giving the environment the chance to filter what objects should be included in the comparison. The filters here are produced directly via the :paramref:`.EnvironmentContext.configure.include_object` parameter. FT)ra)reobject_ryrz reflected compare_tor|s r,run_object_filters!AutogenContext.run_object_filterss+$&&BgUzBB'r.c/n[R"UR5HnURUR5 M U$)a9Return an aggregate of the :attr:`.MetaData.sorted_tables` collection(s). For a sequence of :class:`.MetaData` objects, this concatenates the :attr:`.MetaData.sorted_tables` collection for each individual :class:`.MetaData` in the order of the sequence. It does **not** collate the sorted tables collections. )r to_listr*extend sorted_tables)reresultms r,rAutogenContext.sorted_tabless5dmm,A MM!// *- r.c P0n[R"UR5Hn[U5R [UR 55nU(a-[ SSRS[U555-5eURUR 5 M U$)aReturn an aggregate of the :attr:`.MetaData.tables` dictionaries. The :attr:`.MetaData.tables` collection is a dictionary of table key to :class:`.Table`; this method aggregates the dictionary across multiple :class:`.MetaData` objects into one dictionary. Duplicate table keys are **not** supported; if two :class:`.MetaData` objects contain the same table key, an exception is raised. z9Duplicate table keys across multiple MetaData objects: %sz, c3*# UH nSU-v M g7f)z"%s"N).0keys r, 4AutogenContext.table_key_to_table..s K9J##9Js) r rr*rB intersectiontables ValueErrorjoinsortedupdate)rerr intersects r,table_key_to_table!AutogenContext.table_key_to_tables$&dmm,AF 00QXX?I +yy K 9J KKM MM!(( #- r.) rdrbrarRrQr=rCr*rGr>)NNT) rGr r*rPr>zdict[str, Any] | NonerfboolreturnNone)rr)rzIterator[None])ry str | Nonerzrr{rrr) rrryzsqla_compat._ConstraintNamerzrrrrzSchemaItem | Nonerr)rz list[Table])rzdict[str, Table])__name__ __module__ __qualname____firstlineno____doc__r*__annotations__rQrCrir memoized_propertyrn contextlibcontextmanagerrqr}r run_filtersrr__static_attributes__rr.r,r3r3sy6:H29"%)J!(GX ('N## :>&*! E&+E&7E&$ E&  E&  E&N ((  ###, #  #J*    &  0%K    r.r3c\rSrSr%SrS\S'S\S'SSSjjrSS jrSS jrSS jr SS jr SS jr SSjr Sr g)RevisionContexti zZMaintains configuration and state that's specific to a revision file generation operation.zlist[MigrationScript]generated_revisionsz!ProcessRevisionDirectiveFn | Noneprocess_revision_directivesNcrXlX lX0lX@lSU0UlUR 5/Ulg)Nconfig)rscript_directory command_argsrrM_default_revisionr)rerrrrs r,riRevisionContext.__init__s@ 0(+F( f %)$:$:$<#= r.c URR5n[USS5(ahURn[ 5UlUR (a%UR R UR 5 [R"X1U5 URceURR"URUR4SURURURUR UR"S.UD6$)N _needs_renderFT)refreshheadsplice branch_labels version_path depends_on)rMcopygetattr_last_autogen_contextrBrCrr rLr1rgenerate_revisionmessagerr branch_labelrr)rer+rMr5s r, _to_scriptRevisionContext._to_script%s(,(:(:(?(?(A #_e < <"88O'*eO #''''../?/G/GH  3 3=  &&222$$66  # #  $ $  !&&#***77)66'22    r.c(URXS5 g)NT_run_environmentrerevrGs r,run_autogenerate RevisionContext.run_autogenerateAs cd;r.c(URXS5 g)NFrrs r,run_no_autogenerate#RevisionContext.run_no_autogenerateFs cerrupgrade_ops_listrdowngrade_ops_listrr _upgrade_opsr`rr_downgrade_opsrr3rr r4r) rerrGrfrrr+r5hooks r,r RevisionContext._run_environmentKs   '''M4((66s;<%%33G<A''(LMM)..? +001BC33B7'%@@BO - -b 1 ?  / / 3 C.2  *  ) ) 0 0r?   + + 2 2  _E )  6E"   . .   + +  , ,!(@(@ !%%&CD  ")A)A B $ 8 8 -1  *!9r.c URn[R"US=(d [R"5US[R "/5[R "/5USUSUSUSUSS9 nU$) Nr1rrrrrr) r1rr'r2rrrrr)rrrr r1rr)rerops r,r!RevisionContext._default_revisions'+'8'8  ):T[[] +r***2.f%)%n5%n5#L1   r.c#X# URHnURU5v M g7fN)rr)regenerated_revisions r,generate_scripts RevisionContext.generate_scriptss&"&":": //"45 5#;s(*)rrrrrrrMr) rrrr"rzdict[str, Any]rz!None | ProcessRevisionDirectiveFnrr)r+rrz Script | None)rr#rGr rr)rr#rGr rfrrr)rr)rzIterator[Script | None])rrrrrrrirrrrrrrrr.r,rr s"/.!BB >>*>% > & > >& 8<<2B< < ==2B= = 62 62,62 62  62p 6r.r)r)r r*rrr)r)r r*rrr)zsa.zop.FrNNN)rFzUpgradeOps | DowngradeOpsr7strr8rr:rrCz Sequence[str]r9zRenderItemFn | NonerGzMigrationContext | Noner;rrr)r)r rMzdict[Any, Any]rr)9 __future__rcollections.abcrrrloggingtypingrr sqlalchemyrr r r operationsrruntime.pluginsrrsqlalchemy.enginerrrsqlalchemy.sql.schemarrrrroperations.opsrrrruntime.environmentrrrrr?r script.baser!r"script.revisionr#r$ getLoggerrlogr-r&rHrNr3rrr.r,rsK"$$ $,)+.0+-0+;4@24$-,)!{3| )1B%*!&!'+15%)0,0!00 0  0 % 0/0#0 0f .< *vvrI6I6r.