SQLAlchemy 有没有办法在删除执行后返回结果 [英] SQLAlchemy is there a way to Returning result after Delete execution

问题描述

我找不到有关 Returning 子句的等效解决方案

I can't find equivalent solution about Returning clause

DELETE FROM items
WHERE sub_item_id IN %(sub_item_ids)s
RETURNING item_id, sub_item_id, 

我在 SQLAlchemy 中做到了这一点:

I did this in SQLAlchemy :

purge_family = session.query(ItemItem).filter(ItemItem.sub_item_id.in_(sub_item_ids))

.delete(synchronize_session=False)

我需要在执行 DELETE 语句时返回 item_id、sub_item_id 设置.

I need to return item_id, sub_item_id set upon execution of DELETE statement.

推荐答案

要按原样执行查询，请使用核心结构:

To execute your query as is use Core constructs:

stmt = ItemItem.__table__.delete().\
    where(ItemItem.sub_item_id.in_(sub_item_ids)).\
    returning(ItemItem.item_id, ItemItem.sub_item_ids)

results = session.execute(stmt).fetchall()

这篇关于SQLAlchemy 有没有办法在删除执行后返回结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！