we are very slowly getting around to supporting various edge case syntaxes like these, this one is:
https://bitbucket.org/zzzeek/sqlalchemy/issue/959/support-mysql-delete-from-join <https://bitbucket.org/zzzeek/sqlalchemy/issue/959/support-mysql-delete-from-join> it’s not very often requested so it’s pretty low in the priority at the moment. so for now the only options are to stick with the string SQL or try to build your own construct using the @compiles system: http://docs.sqlalchemy.org/en/rel_0_9/core/compiler.html <http://docs.sqlalchemy.org/en/rel_0_9/core/compiler.html> > On Nov 14, 2014, at 12:48 AM, 'Dmitry Pugachevich' via sqlalchemy > <[email protected]> wrote: > > hey guys, > > can’t figure out how to properly construct sqla core delete() construct for > something that should look like (I’m using MySQL): > > DELETE FROM a USING a > JOIN b ON (a.id1 = b.id1) > JOIN c ON (a.id2 = c.id2) > WHERE . . . > > I can write in it literal SQL and feed to the execute() of course but I was > wondering if it’s possible to write it via table.delete() construct somehow. > > — > Thanks, > Dima. > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] > <mailto:[email protected]>. > To post to this group, send email to [email protected] > <mailto:[email protected]>. > Visit this group at http://groups.google.com/group/sqlalchemy > <http://groups.google.com/group/sqlalchemy>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
