you can use straight text or a text() construct to issue a mysql REPLACE statement, since only MySQL supports that operation.
Theres also a recipe floating around somewhere which uses text() but automates the generation of the statement based on columns present, you might search on the mailing list for that, though its quite easy to write this. On May 19, 2008, at 1:58 AM, David Novakovic wrote: > > Hey, > > I'm using the SQL generation libs, and i'm wondering where the > update_or_insert functionality is. I know at least mysql and sqlite > have this functionality. > > I basically would like to be able to insert a new row without having > to check if it exists first. Thanks > > David > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---
