HI
I have tried to figure out how to do a multi-table delete using
SQLAlchemy, but I have not suceeded.I was kinda hoping this
construction would work:
delete(production_phrase_sentiments, and_(production_phrases.c.al_id
== al_id, production_phrase_sentiments.c.phrase_id ==
production_phrases.c.phrase_id))
For this to work, it needs to get translated to something like:
DELETE review.ps FROM review.alasemantic_phrase_sentiments as ps,
review.alasemantic_phrases as ph
WHERE ps.phrase_id = ph.phrase_id
AND ph.al_id = :al_id""")
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
