sqlalchemy批量更新 批量删除

批量更新

session.query(User).filter(User.district=='shandong').update({User.arrress: '中国'})
session.commit()

批量删除

session.query(User).filter(User.district=='shandong').delete()
session.commit()