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.
Thanks!
You can do this,
User.query.filter_by(id=123).delete()
or
User.query.filter(User.id == 123).delete()
Edit:
Make sure to commit for delete()
to take effect.
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()