How to delete a record by id in Flask-SQLAlchemy

Question

I have users table in my MySql database  This table has id  name and age fields   How can I delete some record by id   Now I use the following code   user   User query get id  db session delete user  db session commit     But I don t want to make any query before delete operation  Is there any way to do this  I know  I can use db engine execute  delete from users where id        but I would like to use delete   method

User · Accepted Answer

You can do this   User query filter by id 123  delete     or  User query filter User id    123  delete     Make sure to commit for delete   to take effect

User · Answer

Just want to share another option     mark two objects to be deleted session delete obj1  session delete obj2     commit  or flush  session commit     http   docs sqlalchemy org en latest orm session basics html deleting  In this example  the following codes shall works fine   obj   User query filter by id 123  one   session delete obj  session commit

User · Answer

Another possible solution specially if you want batch delete  deleted objects   User   table   delete   where User id in   1  2  3    session execute deleted objects  session commit

[python] How to delete a record by id in Flask-SQLAlchemy

Examples related to python

Examples related to flask

Examples related to sqlalchemy

Examples related to flask-sqlalchemy