Re: [sqlalchemy] When gets flagged as mutated with postgresql JSONB column?

2018-06-26 Thread Victor Reichert
Thanks! I understand what was happening. I had tried MutableDict, but I think my data was too complex (a list-valued dictionary) for the basic implementation. When it didn't work I I got confused and thought reassigning the value would trigger mutation tracking. On Tuesday, June 26, 2018 at

Re: [sqlalchemy] When gets flagged as mutated with postgresql JSONB column?

2018-06-26 Thread Mike Bayer
On Tue, Jun 26, 2018 at 3:56 PM, Victor Reichert wrote: > Hi, > > I have a class like: > > class SQLClass(db): > > json_field = Column(sqlalchemy.dialects.postgresql.JSONB) > > I'm doing something like: > > session.add( > SQLClass(json_field = dict( > key = [value1] > ) > )) >

[sqlalchemy] When gets flagged as mutated with postgresql JSONB column?

2018-06-26 Thread Victor Reichert
Hi, I have a class like: class SQLClass(db): json_field = Column(sqlalchemy.dialects.postgresql.JSONB) I'm doing something like: session.add( SQLClass(json_field = dict( key = [value1] ) )) session.commit() slq_class_obj = session.query(SQLClass).first() new_dict =