Function loadSegmentMessages

packages/core/src/query/session-queries.ts:504–526

(
  db: DatabaseAdapter,
  segmentId: number,
  limit: number = 500
)

 * Load messages for a chat session (for summary generation).
 */
export function loadSegmentMessages(
  db: DatabaseAdapter,
  segmentId: number,
  limit: number = 500
): Array<{ senderName: string; content: string | null }> | null {
  try {
    return db
      .prepare(
        `SELECT
          COALESCE(mb.group_nickname, mb.account_name, mb.platform_id) as senderName,
          m.content
        FROM message_context mc
        JOIN message m ON m.id = mc.message_id
        JOIN member mb ON mb.id = m.sender_id
        WHERE mc.segment_id = ?
        ORDER BY m.ts ASC
        LIMIT ?`
      )
      .all(segmentId, limit) as unknown as Array<{ senderName: string; content: string | null }>
  } catch {
    return null
  }
}

/**
 * Get summary text for a single chat session.