Peewee 简明教程
Peewee - Delete Records
对模型实例运行 delete_instance() 方法,从映射的表中删除相应行。
Running delete_instance() method on a model instance delete corresponding row from the mapped table.
obj=User.get(User.name=="Amar")
obj.delete_instance()
另一方面,delete() 是模型类中定义的类方法,它生成 DELETE 查询。有效执行它从表中删除行。
On the other hand, delete() is a class method defined in model class, which generates DELETE query. Executing it effectively deletes rows from the table.
db.create_tables([User])
qry=User.delete().where (User.age==25)
qry.execute()
数据库中受影响的表显示了 DELETE 查询的效果,如下所示 −
Concerned table in database shows effect of DELETE query as follows −
('DELETE FROM "User" WHERE ("User"."age" = ?)', [25])