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     gt  gt  gt  users   models User query all    gt  gt  gt  models db session delete users     but it errs out  UnmappedInstanceError  Class    builtin   list  is not mapped

User · Accepted Answer

Try delete   models User query delete     From the docs  Returns the number of rows deleted  excluding any cascades

User · Answer

DazWorrall s answer is spot on  Here s a variation that might be useful if your code is structured differently than the OP s   num rows deleted   db session query Model  delete     Also  don t forget that the deletion won t take effect until you commit  as in this snippet   try      num rows deleted   db session query Model  delete       db session commit   except      db session rollback

User · Answer

Flask-Sqlalchemy  Delete All Records   for all records db session query Model  delete   db session commit     Deleted Single Row  here DB is the object Flask-SQLAlchemy class  It will delete all records from it and if you want to delete specific records then try filter clause in the query  ex    for specific value db session query Model  filter Model id  123  delete   db session commit     Delete Single Record by Object  record obj   db session query Model  filter Model id  123  first   db session delete record obj  db session commit     https   flask-sqlalchemy palletsprojects com en 2 x queries  deleting-records

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

Examples related to python

Examples related to sqlalchemy

Examples related to flask-sqlalchemy