File size: 1,066 Bytes
3c8d218
 
 
 
f1c3c6d
3c8d218
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
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)