Flask-SQLAlchemy database engine returns table names, but the table keys in metadata are empty

Question

I am connected to a MS SQL Server. The following returns all the table names in the database:

app.config.from_object('config')
db = SQLAlchemy(app)

db.engine.table_names()

However, this doesn't:

db.metadata.tables.keys() // returns: dict_keys([])

Similarly, this doesn't work:

db.table('dbo.users').primary_key // returns: ColumnSet([])

However, I am able to execute SQL queries. What would be the problem?

univerio · Accepted Answer · 2016-12-05 22:33:22Z

3

Engine.table_names gives you a list of available table names from the database. Metadata.tables is a mapping of declared tables associated with the metadata.

If you want to populate the metadata with what's available in the database, use reflection:

db.metadata.reflect(bind=db.engine)

answered Dec 5, 2016 at 22:33

univerio

20.7k3 gold badges73 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Flask-SQLAlchemy database engine returns table names, but the table keys in metadata are empty

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related