SQLAlchemy is there a way to Returning result after Delete execution

Question

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,

I did this in SQLAlchemy :

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

.delete(synchronize_session=False)

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

because i need to know (PosgreSql) , how many items are deleted. for example i have list of 10 items, after it ll only delete 4 items. then i continue to run other treatment — Anouar Mokhtari
– Anouar Mokhtari, Commented Jun 26, 2017 at 13:24
But Query.delete() already returns the count of matched rows. — Ilja Everilä
– Ilja Everilä, Commented Jun 26, 2017 at 13:26
I still have my doubts that this is an XY problem. Supposedly the "other treatment" depends on the ids of the removed rows somehow? — Ilja Everilä
– Ilja Everilä, Commented Jun 26, 2017 at 13:35

Ilja Everilä · Accepted Answer · 2017-06-26 13:21:20Z

10

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()

answered Jun 26, 2017 at 13:21

Ilja Everilä

53.4k9 gold badges138 silver badges142 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQLAlchemy is there a way to Returning result after Delete execution

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related