app/db/dictionary.ts

Functions

Imports

It imports app/db/client.ts, app/db/schema.ts, app/lib/dictionary-entries.mjs, app/lib/search/visibility.mjs. Imported by app/lib/carrel/dictionary-handler.server.ts, app/lib/dictionary/save.server.ts, app/lib/operator/api.server.ts, app/lib/pages/save.server.ts, app/routes/content-page.tsx.

Source

1// The dictionary_entries table: read by the content-page route for the lead and the DefinedTerm, by the page
2// compile for the twin and the search record, and by the operator API. Written only by writeRow in
3// app/lib/dictionary/save.server.ts and by sync:content, from a compile (app/lib/dictionary/compile.mjs).
4import { and, asc, eq } from "drizzle-orm";
5
6import type { DictionaryEntry } from "~/lib/dictionary-entries.mjs";
7import { PUBLISHED_STATUS } from "~/lib/search/visibility.mjs";
8
9import { getDb } from "./client";
10import { dictionaryEntries } from "./schema";
11
12/** The published entry that opens a page, or null: a page with none shows no lead, and a draft shows none either. */
13export async function getPublishedEntryByPath(env: Env, path: string): Promise<DictionaryEntry | null> {
14  const row = (
15    await getDb(env)
16      .select({ record: dictionaryEntries.record })
17      .from(dictionaryEntries)
18      .where(and(eq(dictionaryEntries.path, path), eq(dictionaryEntries.status, PUBLISHED_STATUS)))
19      .limit(1)
20  )[0];
21  return row ? (JSON.parse(row.record) as DictionaryEntry) : null;
22}
23
24/** For list_dictionary and Carrel's list: every row, drafts included, with when D1 last wrote it. */
25export async function listDictionaryRows(env: Env) {
26  const rows = await getDb(env)
27    .select({
28      key: dictionaryEntries.key,
29      path: dictionaryEntries.path,
30      term: dictionaryEntries.term,
31      status: dictionaryEntries.status,
32      syncedAt: dictionaryEntries.syncedAt,
33    })
34    .from(dictionaryEntries)
35    .orderBy(asc(dictionaryEntries.path));
36  return rows.map(({ status, ...row }) => ({ ...row, draft: status === "draft" }));
37}