app/db/cv.ts

Functions

Imports

It imports app/db/client.ts, app/db/publications.ts, app/db/schema.ts, app/lib/cv/compile.mjs, app/lib/cv/types.ts. Imported by app/lib/carrel/cv-handler.server.ts, app/lib/cv/pdf.server.ts, app/lib/cv/save.server.ts, app/lib/health/checks.server.ts, app/lib/operator/api.server.ts, app/lib/operator/sync-tools.server.ts, app/lib/publications/save.server.ts, app/routes/cv.charts[.json].ts, app/routes/cv.tsx, app/routes/cv[.md].ts.

Source

1// The cv table: read by the CV page, its charts, its markdown twin and the operator API. Written only by
2// writeCvRow in app/lib/cv/save.server.ts and by sync:content, from a compile (app/lib/cv/compile.mjs).
3import { asc, eq } from "drizzle-orm";
4
5import { compileCv } from "~/lib/cv/compile.mjs";
6import type { CvFileRecord } from "~/lib/cv/types";
7
8import { listPublishedPublications } from "./publications";
9import { getDb } from "./client";
10import { cv } from "./schema";
11
12/** Every file's row, in slug order, with its record parsed. */
13export async function listCvRows(env: Env) {
14  const rows = await getDb(env)
15    .select({
16      slug: cv.slug,
17      type: cv.type,
18      record: cv.record,
19      sourceBlobSha: cv.sourceBlobSha,
20      syncedAt: cv.syncedAt,
21    })
22    .from(cv)
23    .orderBy(asc(cv.slug));
24  return rows.map(({ record, ...row }) => ({ ...row, record: JSON.parse(record) as CvFileRecord }));
25}
26
27/**
28 * The CV as the page, the charts and the twin draw it: the rows joined to the published publication records
29 * and compiled by the one door (compileCv). A set of rows that does not make a CV (a row missing before the
30 * first sync, a cited paper unpublished since) throws, naming the repair, rather than answering a partial CV.
31 */
32export async function readCv(env: Env) {
33  const [rows, publications] = await Promise.all([listCvRows(env), listPublishedPublications(env)]);
34  const compiled = compileCv({ records: rows.map((row) => row.record), publications });
35  if (!compiled.ok) {
36    throw new Error(
37      `The CV rows in D1 do not make a CV: ${compiled.errors.join("; ")}. The repair is the content sync ` +
38        "(npm run sync:content, or the sync_cv operator tool).",
39    );
40  }
41  return compiled.cv;
42}
43
44/**
45 * The DOIs (lower-cased) the CV's publications file cites, as D1 holds them now. The publication save reads it to
46 * refuse a change that would leave the CV citing a paper that is gone, and to know when a paper's save changes the CV.
47 */
48export async function listCvCitedDois(env: Env): Promise<Set<string>> {
49  const row = (await getDb(env).select({ record: cv.record }).from(cv).where(eq(cv.slug, "publications")).limit(1))[0];
50  if (!row) return new Set();
51  const record = JSON.parse(row.record) as CvFileRecord;
52  if (record.type === "profile") return new Set();
53  return new Set(record.entries.flatMap((entry) => ("doi" in entry ? [entry.doi.toLowerCase()] : [])));
54}