Re: [sqlalchemy] What is the idiomatic Way to implement ON DUPLICATE KEY UPDATE in SQLAlchemy using session with bind

2014-05-01 Thread Michael Bayer
this is MySQL specific and is not represented by a SQLAlchemy structure right now (which would be a MERGE construct that somehow doubles as a MySQL placeholder) so just use a string: session.execute("INSERT ... ON DUPLICATE KEY UPDATE...") On May 1, 2014, at 2:01 PM, Jinu p.r wrote: > > Hi

[sqlalchemy] What is the idiomatic Way to implement ON DUPLICATE KEY UPDATE in SQLAlchemy using session with bind

2014-05-01 Thread Jinu p.r
Hi All, I essentially need to do an INSERT ... ON DUPLICATE KEY UPDATE on an existing table with composite primary key using session with bind. What is the idiomatic way to implemen