src/store-probe.ts

Functions

Imports

It imports no other module of this repo. Imported by src/backup.ts, src/conventions-read.ts, src/health.ts.

Source

1// One MATCH probe, used by /health and by backup preflight. COUNT(*) on an
2// external-content FTS5 table reads through to documents and cannot see a
3// corrupted index; integrity-check passes on an emptied one.
4export const HEALTH_PROBE_NS = "capsid";
5export const HEALTH_PROBE_PATH = "conventions.md";
6const HEALTH_PROBE_TERM = "conventions";
7
8// Returns "ok", or a short reason. Never throws.
9export async function probeFts(db: D1Database): Promise<string> {
10  try {
11    const hit = await db
12      .prepare(
13        `SELECT d.path FROM documents_fts
14         JOIN documents d ON d.id = documents_fts.rowid
15         WHERE documents_fts MATCH ?1 AND d.namespace = ?2 AND d.path = ?3
16         LIMIT 1`
17      )
18      .bind(HEALTH_PROBE_TERM, HEALTH_PROBE_NS, HEALTH_PROBE_PATH)
19      .first<{ path: string }>();
20    return hit?.path === HEALTH_PROBE_PATH ? "ok" : `no match for ${HEALTH_PROBE_NS}/${HEALTH_PROBE_PATH}`;
21  } catch (err) {
22    return `error: ${(err instanceof Error ? err.message : String(err)).slice(0, 120)}`;
23  }
24}