INSERT OR REPLACE INTO is sqlite-specific about scraperwiki-python HOT 10 CLOSED

The relevant Stack Overflow question is a bit depressing!

http://stackoverflow.com/questions/1109061/insert-on-duplicate-update-in-postgresql

On Tue, Sep 16, 2014 at 06:00:52AM -0700, Peter Waller wrote:

Turns out that postgres bails when we try to do a .save:

ProgrammingError: (ProgrammingError) syntax error at or near "OR"
LINE 1: INSERT OR REPLACE INTO test (a) VALUES ('b')
               ^
 'INSERT OR REPLACE INTO test (a) VALUES (%(a)s)' {'a': 'b'}

---

Reply to this email directly or view it on GitHub:
#63

from scraperwiki-python.

Yes. Yes it is.

from scraperwiki-python.

Looks like there is an sqlalchemy issue tracking the CTE method: https://bitbucket.org/zzzeek/sqlalchemy/issue/2551

from scraperwiki-python.

"What's fascinating is that Postgresql, which in most cases supports way more than all the other DBs, doesn't yet support MERGE, which is a cleaner bit of SQL and is also part of the ANSI standard."

from scraperwiki-python.

"Why upsert is weird"

from scraperwiki-python.

From the slides:

from scraperwiki-python.

SQLAlchemy has session.merge

On September 16, 2014 10:15:50 AM EDT, Peter Waller [email protected] wrote:

From the slides:

---

Reply to this email directly or view it on GitHub:
#63 (comment)

from scraperwiki-python.

Can you use that if you're not using the ORM?

from scraperwiki-python.

Searching the docs, that's only applicable to the ORM - the reason it can do it there is because if you have an object instance, then sqlalchemy knows what you changed. So it doesn't help us here - sqlalchemy just invokes an insert or update as appropriate.

from scraperwiki-python.

Looks like it just grew support.

https://news.ycombinator.com/item?id=9509870

from scraperwiki-python.