Re: [sqlalchemy] Using `INSERT...ON CONFLICT` with ORM

2017-02-17 Thread Calvin Young
s separate SELECT and INSERT/UPDATE. an ORM > integration of merge() and INSERT on conflict would need some very > motivated contributors to come on board and help implement and test. It > can be done as a third party extension to start with. > > On Feb 15, 2017 2:13 PM, &qu

[sqlalchemy] Using `INSERT...ON CONFLICT` with ORM

2017-02-15 Thread Calvin Young
I use the SQLAlchemy ORM in my application, and I know I can use something the following to perform an `INSERT...ON CONFLICT` statement: from sqlalchemy.dialects.postgresql import insert class Foo(Base): ... bar = Column(Integer) foo = Foo(bar=1) insert_stmt = insert(Foo).values(bar=fo