Hello,
I have a need to perform an "upsert" query with PostgreSQL. the following
SQL query achieves this goal:
WITH upsert AS (
UPDATE metric k SET k.count = k.count + 5
WHERE event = "foo" AND interval = "D" and date = "whatever"
RETURNING k.*
)
INSERT INTO metric (event, interval, date, count)
SELECT ("foo", "D", "whatever", 5)
WHERE NOT EXISTS (
SELECT 1 FROM upsert
);
How do I do this sort of thing with SQLAlchemy? It only ever needs to work
with PostgreSQL so any PG specific things are fine.
Best,
Mitchell
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected].
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.
