Function getChatSidebarState

desktop/chat-state-db.ts:134–190

(selectedGroupId: string | null = null)

}

export function getChatSidebarState(selectedGroupId: string | null = null): ChatSidebarState {
  ensureChatStateSchema()
  const db = getThreadStateDatabase()
  const groups: ChatSidebarState['groups'] = (
    db
      .prepare(
        `
        SELECT id, name, order_index AS orderIndex, collapsed
        FROM chat_groups
        ORDER BY order_index ASC, name COLLATE NOCASE ASC
      `,
      )
      .all() as ChatGroupRow[]
  ).map((group) => ({
    id: group.id,
    name: group.name,
    orderIndex: group.orderIndex,
    collapsed: Boolean(group.collapsed),
    threads: [],
  }))

  const rows = db
    .prepare(
      `
        SELECT
          threads.id AS id,
          threads.cwd AS projectId,
          threads.title AS title,
          threads.session_path AS sessionPath,
          COALESCE(inbox_items.last_assistant_preview, threads.last_assistant_preview) AS summary,
          threads.running AS running,
          COALESCE(inbox_items.unread, 0) AS unread,
          threads.pinned AS pinned,
          threads.last_modified_ms AS lastModifiedMs,
          chat_threads.group_id AS groupId
        FROM threads
        LEFT JOIN chat_threads ON chat_threads.session_path = threads.session_path
        LEFT JOIN inbox_items ON inbox_items.session_path = threads.session_path
        WHERE threads.archived = 0
        ORDER BY threads.pinned DESC, COALESCE(chat_threads.order_index, threads.last_modified_ms) DESC, threads.title COLLATE NOCASE ASC
      `,
    )
    .all() as ChatThreadGroupRow[]

  const chatRows = rows.filter((row) => isChatSessionPath(row.sessionPath))

  const groupsById = new Map(groups.map((group) => [group.id, group]))
  const ungroupedThreads: ChatThread[] = []
  for (const row of chatRows) {
    const thread = mapChatThreadRow(row)
    const group = thread.groupId ? groupsById.get(thread.groupId) : null
    if (group) group.threads.push(thread)
    else ungroupedThreads.push(thread)
  }

  return { groups, ungroupedThreads, selectedGroupId }
}