// The twelve sections, read from the shelf table the build writes from packs/sections.tsv.
// No screen names a section in code; every list, title, and icon comes from here.

import type { Database } from './db';
import { rows } from './db';

export interface SectionRow {
  id: string;
  order: number;
  title: string;
  scope: string;
  icon: string;
  gloss: string;
  accent: string | null;
}

const cache = new WeakMap<Database, SectionRow[]>();

/** Every section in order, memoised per database instance. */
export function sections(db: Database): SectionRow[] {
  let list = cache.get(db);
  if (!list) {
    const cols = rows<{ name: string }>(db, 'PRAGMA table_info(shelf)').map((c) => c.name);
    const accent = cols.includes('accent') ? 'accent' : 'NULL AS accent';
    list = rows<{ id: string; order: number; title: string; scope_line: string | null; icon: string | null; gloss: string | null; accent: string | null }>(
      db,
      `SELECT id, "order" AS "order", title, scope_line, icon, gloss, ${accent} FROM shelf ORDER BY "order"`,
    ).map((r) => ({ id: r.id, order: r.order, title: r.title, scope: r.scope_line ?? '', icon: r.icon ?? 'book-open', gloss: r.gloss ?? '', accent: r.accent ?? null }));
    cache.set(db, list);
  }
  return list;
}

export function sectionTitle(db: Database, id: string): string {
  return sections(db).find((s) => s.id === id)?.title ?? id;
}