How to delete a record by id in Flask-SQLAlchemy

--------------------------------------------------
Rise to the top 3% as a developer or hire one of them at Toptal: https://topt.al/25cXVn
--------------------------------------------------

Music by Eric Matyas
https://www.soundimage.org
Track title: Ominous Technology Looping

--

Chapters
00:00 How To Delete A Record By Id In Flask-Sqlalchemy
00:28 Accepted Answer Score 353
00:44 Answer 2 Score 97
01:04 Answer 3 Score 32
01:34 Answer 4 Score 20
01:42 Thank you

--

Full question
https://stackoverflow.com/questions/2715...

--

Content licensed under CC BY-SA
https://meta.stackexchange.com/help/lice...

--

Tags
#python #flask #sqlalchemy #flasksqlalchemy

#avk47

ACCEPTED ANSWER

Score 356

You can do this,

User.query.filter_by(id=123).delete()

User.query.filter(User.id == 123).delete()

Make sure to commit for delete() to take effect.

ANSWER 2

Score 98

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()

ANSWER 3

Score 33

In sqlalchemy 1.4 (2.0 style) you can do it like this:

from sqlalchemy import select, update, delete, values

sql1 = delete(User).where(User.id.in_([1, 2, 3]))
sql2 = delete(User).where(User.id == 1)

db.session.execute(sql1)
db.session.commit()

u = db.session.get(User, 1)
db.session.delete(u)
db.session.commit()

In my opinion using select, update, delete is more readable. Style comparison 1.0 vs 2.0 can be found here.

ANSWER 4

Score 20

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()