Function create_chat_session

skills/storage-helper/scripts/db_ops.py:289–326

Create or return a persistent GUI chat session.

(
    user_id: str,
    title: str = "",
    session_id: Optional[str] = None,
)

def create_chat_session(
    user_id: str,
    title: str = "",
    session_id: Optional[str] = None,
) -> Dict[str, Any]:
    """Create or return a persistent GUI chat session."""
    normalized_user_id = _normalize_identifier(user_id)
    if not normalized_user_id:
        raise ValueError("user_id is required")

    ensure_chat_tables()
    normalized_session_id = _normalize_identifier(session_id) or f"chat_{datetime.now().strftime('%Y%m%d_%H%M%S')}_{uuid.uuid4().hex[:8]}"
    normalized_title = _chat_title_from_content(title)
    now = _chat_now()

    conn = get_connection()
    cursor = conn.cursor()
    cursor.execute(
        """
        INSERT OR IGNORE INTO chat_sessions (session_id, user_id, title, created_at, updated_at, message_count)
        VALUES (?, ?, ?, ?, ?, 0)
        """,
        (normalized_session_id, normalized_user_id, normalized_title, now, now),
    )
    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),
    )
    row = cursor.fetchone()
    conn.commit()
    conn.close()
    if not row:
        raise ValueError("chat session belongs to another user or could not be created")
    return _chat_session_row(row)


def save_chat_message(