Re: [sqlalchemy] explain analyze on statement

2019-06-17 Thread Zsolt Ero
Just a conclusion to this thread, I've been using the given snippet with a minor modification with great success. The modification was that single quotation marks had to be added around datetime. class PGDateTime(TypeDecorator): impl = DateTime def literal_processor(self, dialect):

Re: [sqlalchemy] Issue with bulk updates on ORM and PostgreSQL

2019-06-17 Thread Mike Bayer
On Mon, Jun 17, 2019, at 12:02 PM, João Miguel Neves wrote: > Hi, > > Ok, versioning adds a different requirement level, as it fails if the version > being updated has changed. I was looking for a situation where updating 2 > keys inside a JSONB field wouldn't lose one of them. Using versionin

Re: [sqlalchemy] Issue with bulk updates on ORM and PostgreSQL

2019-06-17 Thread Mike Bayer
On Mon, Jun 17, 2019, at 12:02 PM, João Miguel Neves wrote: > Hi, > > Ok, versioning adds a different requirement level, as it fails if the version > being updated has changed. I was looking for a situation where updating 2 > keys inside a JSONB field wouldn't lose one of them. Using versioning

Re: [sqlalchemy] Issue with bulk updates on ORM and PostgreSQL

2019-06-17 Thread João Miguel Neves
Hi, Ok, versioning adds a different requirement level, as it fails if the version being updated has changed. I was looking for a situation where updating 2 keys inside a JSONB field wouldn't lose one of them. Using versioning it raises an exception when writing one of them (which is better than th