Hi,
am I wrong, or is it at the moment not possible to write an update statement
for Mysql which includes multiple tables like that:
import sqlalchemy.sql as sql
query = sql.text("""UPDATE shows AS s INNER JOIN show_artendef AS sad
ON sad.id = s.art
SET s.seq = s.seq + 1
WHERE s.seq >= :newseq AND s.seq < :oldseq AND sad.name
= :name""")
At the moment I use the above but maybe I could write that without text?
visit_update in mysql.py looks like at the moment I can't use multiple tables
if I'm
not wrong (but I didn't look too deep in the source code). I use SA 0.4.0
KP
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
