sqlalchemy_mutable_json_model_with_nested_change_tracking.py

1from sqlalchemy_json import MutableJson
2from sqlalchemy import Column, Integer, String
3from sqlalchemy.ext.declarative import declarative_base
4
5Base = declarative_base()
6
7class MyModel(Base):
8    __tablename__ = 'my_model'
9
10    id = Column(Integer, primary_key=True)
11    name = Column(String)
12    # The MutableJson type tracks changes to the JSON structure 
13    # so that they are persisted to the database on commit.
14    data = Column(MutableJson)
15
16# Example usage:
17# model = MyModel(data={'nested': {'key': 'value'}})
18# session.add(model)
19# session.commit()
20
21# Tracking nested changes:
22# model.data['nested']['key'] = 'new_value'
23# session.commit()  # This will trigger an UPDATE because of MutableJson