Hi all,
browsing the SQLAlchemy docs I coudn't find any references to a
particular SQLite feature, ON CONFLICT clause (http://www.sqlite.org/
lang_conflict.html), is there any support for this in SA? What I want
to do is this, create my database as such:
CREATE TABLE songs(
id INTEGER PRIMARY KEY ON CONFLICT REPLACE,
name TEXT
);
Now, when I do a bunch of INSERTs without specifying 'id' field,
everything works as you would expect. But, when I issue a INSERT with
a 'id' that allready exists, SQLite automatically and automagicaly
does an UPDATE instead.
Now, this is very handy because I don't have to do a SELECT prior to
modifying a table. Is there a way to use this SQLite feature from SA?
Or somehow simulate it without too much gory details?
Thanks guys,
klm.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
