Function getChatOverview

packages/core/src/query/session-queries.ts:232–257

(db: DatabaseAdapter, topN: number = 10)

 * Simpler than Electron version — no cache layer, direct SQL.
 */
export function getChatOverview(db: DatabaseAdapter, topN: number = 10): ChatOverviewData | null {
  const meta = getSessionMeta(db)
  if (!meta) return null

  const overview = getSessionOverview(db)
  const members = getMemberActivity(db)
  const summaryCount = getSummaryCount(db)

  const topMembers = members.slice(0, topN).map((m) => ({
    id: m.memberId,
    name: m.name,
    count: m.messageCount,
  }))

  return {
    name: meta.name,
    platform: meta.platform,
    type: meta.type,
    totalMessages: overview.totalMessages,
    totalMembers: overview.totalMembers,
    firstMessageTs: overview.firstMessageTs,
    lastMessageTs: overview.lastMessageTs,
    topMembers,
    summaryCount,
  }
}

/**
 * Get messages for a specific chat session