Updates to JSON field don’t persist to DB

by

If you are using Postgres < 9.4 you can’t update JSON field directly. You need flag_modified function to report the change to SQLAlchemy:

from sqlalchemy.orm.attributes import flag_modified
model.data['key'] = 'New value'
flag_modified(model, "data")
session.add(model)
session.commit()

More Related Contents:

  1. sqlalchemy.exc.NoSuchModuleError: Can’t load plugin: sqlalchemy.dialects:postgres
  2. SQLAlchemy – performing a bulk upsert (if exists, update, else insert) in postgresql
  3. SQLAlchemy: filtering on values stored in nested list of the JSONB field
  4. How to serialize SqlAlchemy result to JSON?
  5. How to execute raw SQL in Flask-SQLAlchemy app
  6. jsonify a SQLAlchemy result set in Flask [duplicate]
  7. Flask SQLAlchemy query, specify column names
  8. SQLAlchemy create_all() does not create tables
  9. SQLAlchemy ORM conversion to pandas DataFrame
  10. Django JSONField inside ArrayField
  11. How to create an SQL View with SQLAlchemy?
  12. How to update SQLAlchemy row entry?
  13. Generate sql with subquery as a column in select statement using SQLAlchemy
  14. SQLAlchemy ManyToMany secondary table with additional fields
  15. Can SQLAlchemy be used with Google Cloud SQL?
  16. Complex foreign key constraint in SQLAlchemy
  17. Connection problems with SQLAlchemy and multiple processes
  18. Get inserted key before commit session
  19. Querying with function on Flask-SQLAlchemy model gives BaseQuery object is not callable error
  20. AttributeError: ‘int’ object has no attribute ‘_sa_instance_state’
  21. SQLAlchemy multiple foreign keys in one mapped class to the same primary key
  22. Creating partial unique index with sqlalchemy on Postgres
  23. SQLAlchemy func.count on boolean column
  24. How to set connection timeout in SQLAlchemy
  25. Flask-SQLAlchemy Constructor
  26. Using SQLAlchemy models in and out of Flask
  27. How to prevent UUID primary key for new SQLAlchemy objects being created with the same value
  28. Retrieve query results as dict in SQLAlchemy
  29. SQLAlchemy ordering by count on a many to many relationship
  30. flask sqlalchemy query with keyword as variable

Leave a Comment