Function getChatSessionList

packages/core/src/query/session-queries.ts:479–499

(db: DatabaseAdapter)

 * Timeline list of chat sessions with first message id and summary.
 */
export function getChatSessionList(db: DatabaseAdapter): ChatSessionItem[] {
  if (!hasTable(db, 'segment')) return []
  try {
    return db
      .prepare(
        `SELECT
          cs.id,
          cs.start_ts as startTs,
          cs.end_ts as endTs,
          cs.message_count as messageCount,
          cs.summary,
          (SELECT mc.message_id FROM message_context mc
           WHERE mc.segment_id = cs.id ORDER BY mc.message_id LIMIT 1) as firstMessageId
        FROM segment cs
        ORDER BY cs.start_ts ASC`
      )
      .all() as unknown as ChatSessionItem[]
  } catch {
    return []
  }
}

/**
 * Load messages for a chat session (for summary generation).