sqlaclhemy ORM don't update jsonb[postgres-psycopg2]

[Yaser Abbasi]

Hi,

Sqlalchemy orm don't find out jsonb changes for update when call 

for example Model.add(obj) !!!

now I use Model.update({"jsonb_filed_name":jsonb_filed_name})

What is problem?

thanks,

best

[Jonathan Vanasco]

This sounds like you may be having issues with mutation tracking on edits.

 

http://docs.sqlalchemy.org/en/rel_1_0/dialects/postgresql.html?highlight=jsonb#sqlalchemy.dialects.postgresql.JSONB

The JSON type, when used with the SQLAlchemy ORM, does not detect in-place mutations to the structure. In order to detect these, the sqlalchemy.ext.mutable extension must be used. This extension will allow “in-place” changes to the datastructure to produce events which will be detected by the unit of work. See the example at HSTORE for a simple example involving a dictionary.

Mutation Tracking

* http://docs.sqlalchemy.org/en/rel_1_0/orm/extensions/mutable.html#module-sqlalchemy.ext.mutable

HSTORE example

* http://docs.sqlalchemy.org/en/rel_1_0/dialects/postgresql.html?highlight=jsonb#sqlalchemy.dialects.postgresql.HSTORE