[sqlalchemy] Batch-remove (UPDATE) keys in JSONB column

2021-01-25 Thread Anders Steinlein
x27; WHERE custom ? 'firmanavn'; I have not found a way to batch-update JSON columns such as this in SQLAlchemy. The column is defined as: custom = Column(MutableDict.as_mutable(JSONB)) Is there a way? Looping over filtered models and deleting the keys per model obviously doesn't sca

Re: [sqlalchemy] Dynamic table on the same declarative model

2019-02-03 Thread Anders Steinlein
On Sun, Feb 3, 2019 at 6:00 PM Mike Bayer wrote: > > > On Sun, Feb 3, 2019, 6:18 AM Anders Steinlein >> >> Is there a way to dynamically set up the table for a particular >> declarative model, i.e. based on the bind? The point is that we'd like all >> cod

[sqlalchemy] Dynamic table on the same declarative model

2019-02-03 Thread Anders Steinlein
ike all code to still use the same and only model class, and just have conditionals in the code where appropriate for the differences in columns. Best, Anders Steinlein *Gründer og alkymistleder* Eliksir AS – MailMojo og QuizWiz tlf: 21 42 30 30 mob: 926 13 069 web: e5r.no mail

Re: [sqlalchemy] Understanding sporadic ObjectDeletedError (in gevent)

2017-06-30 Thread Anders Steinlein
On Fri, Jun 30, 2017 at 8:04 PM, Mike Bayer wrote: > On Fri, Jun 30, 2017 at 11:52 AM, Anders Steinlein wrote: > > [...] > > > > > I've set _use_threadlocal = True on the connection pool, as my thinking > > initially was that we could be getting a different

[sqlalchemy] Understanding sporadic ObjectDeletedError (in gevent)

2017-06-30 Thread Anders Steinlein
Hi, We're using SQLAlchemy (see below for versions) on Flask running on uWSGI in gevent mode, with psycopg2 to PostgreSQL 9.4. We recently switched from regular prefork+threaded to gevent mode, and with it applied all gevent monkey patches and the psycogreen package for the psycopg2 gevent wait ca