Function listProjects

notfair-cmo/src/server/db/projects.ts:22–28

(opts: { includeArchived?: boolean } = {})

  | { ok: false; reason: string };

export function listProjects(opts: { includeArchived?: boolean } = {}): Project[] {
  const db = getDb();
  const sql = opts.includeArchived
    ? "SELECT * FROM projects ORDER BY created_at DESC"
    : "SELECT * FROM projects WHERE archived_at IS NULL ORDER BY created_at DESC";
  return db.prepare(sql).all() as Project[];
}

export function getProject(slug: string): Project | null {
  const db = getDb();