from sqlalchemy.orm import Session from sqlalchemy.orm.attributes import flag_modified from backend.database import SessionModel def get_context(db: Session, session_id: str) -> dict: session = db.query(SessionModel).filter(SessionModel.id == session_id).first() if not session: return {} return session.context_variables or {} def set_context_variables(db: Session, session_id: str, variables: dict) -> dict: session = db.query(SessionModel).filter(SessionModel.id == session_id).first() if session: current_context = session.context_variables or {} current_context.update(variables) session.context_variables = current_context # Explicitly flag JSON column as modified for SQLAlchemy flag_modified(session, "context_variables") db.commit() db.refresh(session) return session.context_variables return {} def get_context_variable(db: Session, session_id: str, key: str) -> any: context = get_context(db, session_id) return context.get(key)