如何在Flask-SQLAlchemy中按ID删除记录 [英] How to delete a record by id in Flask-SQLAlchemy

问题描述

我的MySql数据库中有users表.该表具有id，name和age字段.

I have users table in my MySql database. This table has id, name and age fields.

如何删除id的某些记录?

现在我使用以下代码:

user = User.query.get(id)
db.session.delete(user)
db.session.commit()

但是我不想在删除操作之前进行任何查询.有什么办法吗?我知道，我可以使用db.engine.execute("delete from users where id=...")，但是我想使用delete()方法.

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.query.filter_by(id=123).delete()

或

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

确保commit生效，以使delete()生效.

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

这篇关于如何在Flask-SQLAlchemy中按ID删除记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！