Function get_chat_session

skills/storage-helper/scripts/db_ops.py:449–486

Return a chat session with ordered messages.

(user_id: str, session_id: str)

def get_chat_session(user_id: str, session_id: str) -> Optional[Dict[str, Any]]:
    """Return a chat session with ordered messages."""
    normalized_user_id = _normalize_identifier(user_id)
    normalized_session_id = _normalize_identifier(session_id)
    if not normalized_user_id or not normalized_session_id:
        raise ValueError("user_id and session_id are required")

    ensure_chat_tables()
    conn = get_connection()
    cursor = conn.cursor()
    cursor.execute(
        """
        SELECT session_id, user_id, title, created_at, updated_at, message_count
        FROM chat_sessions
        WHERE user_id = ? AND session_id = ?
        """,
        (normalized_user_id, normalized_session_id),
    )
    session_row = cursor.fetchone()
    if not session_row:
        conn.close()
        return None
    cursor.execute(
        """
        SELECT id, session_id, user_id, role, content, metadata, created_at
        FROM chat_messages
        WHERE user_id = ? AND session_id = ?
        ORDER BY id ASC
        """,
        (normalized_user_id, normalized_session_id),
    )
    messages = []
    for row in cursor.fetchall():
        message = dict(row)
        message["metadata"] = _load_json_metadata(message.get("metadata"))
        messages.append(message)
    conn.close()
    return {"session": _chat_session_row(session_row), "messages": messages}


def delete_chat_session(user_id: str, session_id: str) -> bool: