背景:Biquge数据库中对应的字段chapter_name存在很多503 Service Temporarily Unavailable的异常数据,现在需要进行批量删除。
- Book模型
class Book(db.Model):
__tablename__ = 'Biquge'
id = db.Column(db.Integer, primary_key=True)
chapter_name = db.Column(db.String(64), index=True)
content = db.Column(db.String(4048))
def __repr__(self):
return "<chapter name>:%r" % self.chapter_name
已存放数据如图:
- 批量删除
>flask shell
>>> from models import Book
>>> Book
<class 'models.Book'>
>>> db.session.query(Book).filter(Book.chapter_name=='503 Service Temporarily Unavailable').delete()
31
>>> db.session.commit()