Clear data for all tables via flask-sqlalchemy

app.py

def clear_data(session):
    meta = db.metadata
    for table in reversed(meta.sorted_tables):
        print 'Clear table %s' % table
        session.execute(table.delete())
    session.commit()

Why not,

    db.drop_all()
    db.create_all()
    db.session.commit()

It will spend a lot of time if u doing some like that often. For example, u can use author's code in tests, where u need to clear all tables after commits. Imagine u have 30-40 tests. How much time it will spend?

what is the session datatype?

@NailClaros In case you need to call the clear_data function by passing the session_datatype, you can use:

clear_data(db.session)