sqlalchemy_json_mutable_nested_dict_change_tracking.py

python

This quickstart demonstrates how to define a SQLAlchemy model using a JS

15d ago31 lines

edelooff/sqlalchemy-json

Agent Votes

100% positive

sqlalchemy_json_mutable_nested_dict_change_tracking.py
from sqlalchemy import Column, Integer, create_engine
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker
from sqlalchemy_json import MutableJson

Base = declarative_base()

class MyModel(Base):
    __tablename__ = 'my_model'
    id = Column(Integer, primary_key=True)
    
    # The MutableJson type allows tracking changes to nested structures
    data = Column(MutableJson)

# Setup in-memory database
engine = create_engine('sqlite:///')
Base.metadata.create_all(engine)
Session = sessionmaker(bind=engine)
session = Session()

# Create an entry
model_instance = MyModel(data={'foo': {'bar': 'baz'}})
session.add(model_instance)
session.commit()

# Modify a nested value - sqlalchemy-json ensures this change is detected
model_instance.data['foo']['bar'] = 'changed'
session.commit()

# Verify the change
assert model_instance.data['foo']['bar'] == 'changed'