app/db/roster.ts

Functions

Imports

It imports app/db/client.ts, app/db/schema.ts, app/lib/roster/compile.mjs. Imported by app/lib/carrel/roster-handler.server.ts, app/lib/operator/api.server.ts, app/routes/content-page.tsx, app/routes/home.tsx.

Source

1// The roster table: read by the home page's counts, the roster on /teaching/phage-discovery and the operator
2// API. Written only by writeRosterRow in app/lib/roster/save.server.ts and by sync:content, from a compile
3// (app/lib/roster/compile.mjs).
4import { desc } from "drizzle-orm";
5
6import { sortCohorts, type Cohort } from "~/lib/roster/compile.mjs";
7
8import { getDb } from "./client";
9import { roster } from "./schema";
10
11/**
12 * Every cohort, newest first: the order the page lists them. An empty table is a fault, never an empty
13 * roster: the page and the home page's counts are drawn from these rows, and a table the sync has not
14 * written yet must not quietly render a page with no roster on it.
15 */
16export async function listRoster(env: Env): Promise<Cohort[]> {
17  const rows = await getDb(env).select({ record: roster.record }).from(roster).orderBy(desc(roster.year));
18  if (rows.length === 0) {
19    throw new Error("the roster table is empty, so there is no roster to draw. Run the content sync (npm run sync:content -- --remote), or sync_roster.");
20  }
21  return sortCohorts(rows.map((row) => JSON.parse(row.record) as Cohort));
22}
23
24/** For list_roster and Carrel's list: every row, with when D1 last wrote it. */
25export async function listRosterRows(env: Env) {
26  const rows = await getDb(env)
27    .select({ slug: roster.slug, year: roster.year, record: roster.record, syncedAt: roster.syncedAt })
28    .from(roster)
29    .orderBy(desc(roster.year));
30  return rows.map(({ record, ...row }) => ({ ...row, cohort: JSON.parse(record) as Cohort }));
31}