Update metadata after creating table.

[AliyevH]

Hi. After creating table, i see that metadata object doesn't updates itself.
What do you say about adding such feature?
Now i manually reflect metadata object to get created tables.

[CaselIT]

Hi,

I'm not sure what you mean by

see that metadata object doesn't updates itself.

How should the metadata be updated?

[AliyevH]

For example.

engine = create_engine(uri, echo=False)
session = Session(self.engine, autocommit=False, autoflush=False)
metadata = MetaData(bind=self.engine)
base = declarative_base()
base.metadata.reflect(self.engine)

First i reflect database. It means, now in metadata object i can view all tables that currently exists.
After creating new table. i can't get new table information from base.metadata

[zzzeek]

you can call reflect() again and it will add the new table(s).

metadata itself is only a set of table structures and is not linked to a specific database, with the exception of the bind=self.engine you have there; that's deprecated after many years of being strongly discouraged and is not available in the next major release of SQLAlchemy.