[sqlalchemy] doing replaces

2008-03-06 Thread noelsplace
I am trying to implement a generic REPLACE INTO as shown below. The code works fine if REPLACE INTO is changed to INSERT INTO. There really should not be any difference between REPLACE and INSERT if the table is empty to start with. Also, the REPLACE command works fine when issued manually from

[sqlalchemy] doing replaces

2008-01-04 Thread Mike Bernson
I have code that need to do a mysql replace instead of an insert. The quick hack to just create a string and execute has problems with quoting things, sql injection ... If a table.replace() is not easy to do is there a way to create a statement that works that way. If I could do a conn.execute(s