sqlalchemy - 批量删除数据，返回被删除数据的id

# 删除数据

# type 1 - 批量删除
# delete_ids = list()
# colors = db.session.query(
#     Color
# ).filter(
#     Color.id.in_(color_ids)
# ).all()
# for data in colors:
#     db.session.delete(data)
#     delete_ids.append(data.id)
# db.session.commit()
# return delete_ids

# type 2 - 批量逻辑删除
# delete_ids = list()
# db.session.query(
#     Color
# ).filter(
#     Color.id.in_(color_ids)
# ).update({Color.status:0}, synchronize_session=False)
# db.session.commit()

# type 3 - 批量逻辑删除，返回删除的id
# delete_ids = list()
# colors = db.session.query(
#     Color
# ).filter(
#     Color.id.in_(color_ids)
# ).all()
# for data in colors:
#     data.status = 0
#     delete_ids.append(data.id)
# db.session.commit()
# return delete_ids