Function getChatOverview

apps/desktop/main/worker/query/sessions.ts:153–193

(sessionId: string, topN: number = 10)

 * Cache-first: overview cache + members cache, fallback to live SQL via core.
 */
export function getChatOverview(sessionId: string, topN: number = 10) {
  const db = openDatabase(sessionId)
  if (!db) return null

  const coreDb = asCoreDb(db)
  const meta = getSessionMeta(coreDb)
  if (!meta) return null

  const cacheDir = getCacheDir()
  const overview = resolveOverview(db, sessionId, cacheDir)
  const summaryCount = getSummaryCount(coreDb)

  let membersCache = getCache<MembersCache>(sessionId, CACHE_KEY_MEMBERS, cacheDir)
  if (!membersCache) {
    try {
      membersCache = computeAndSetMembersCache(new BetterSqliteAdapter(db), sessionId, cacheDir)
    } catch {
      // fallback: no member data
    }
  }

  let topMembers: Array<{ id: number; name: string; count: number }> = []
  if (membersCache?.members) {
    topMembers = Object.entries(membersCache.members)
      .map(([id, stat]) => ({ id: Number(id), name: stat.name, count: stat.count }))
      .sort((a, b) => b.count - a.count)
      .slice(0, topN)
  }

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