Flask-sqlalchemy using drop_all and create_all for specific tables

Question

In sqlalchemy (0.8.2), drop_all()and create_all()both have a parameter tables, which can be a list of table objects to be deleted or added.

In flask-sqlalchemy (1.0), these methods do not have this parameter.

How can I drop / create a subset of database tables using flask alchemy?

Answer 1

Flask-SQLAlchemy create_all() , SQLAlchemy MetaData.create_all(). . "", . , engine Flask-SQLAlchemy.

, ...

db = SQLAlchemy(app)

class MyTable(db.Model):
    ...

class MyOtherTable(db.Model):
    ...

db.metadata.create_all(db.engine, tables=[
    MyTable.__table__,
    ...
])

, . create_all() , get_engine().