python - Flask-SQLAlchemy how to delete all rows in a single table

Question

How do I delete all rows in a single table using Flask-SQLAlchemy?

Looking for something like this:

>>> users = models.User.query.all()
>>> models.db.session.delete(users)

# but it errs out: UnmappedInstanceError: Class '__builtin__.list' is not mapped

Answer 1

Try delete:

models.User.query.delete()

From the docs: Returns the number of rows deleted, excluding any cascades.