INNER CODE UNIT · TypeScript

checkSchemaFingerprint

harvard-edge/cs249r_book · interviews/staffml-vault-worker/src/index.ts:31

async function checkSchemaFingerprint(env: Env, expectedFromDb: string | undefined): Promise<boolean> {
  if (schemaOk === false && Date.now() - schemaCheckedAt > SCHEMA_RECHECK_MS) {
    schemaOk = undefined;   // re-check after backoff window
  }
  if (schemaOk !== undefined) return schemaOk;
  schemaCheckedAt = Date.now();

  if (!expectedFromDb) {
    schemaOk = false;
    return schemaOk;
  }
  try {
    // Chip R7-H-2 + Gemini R9-C-1: FTS5 shadow tables
    // (questions_fts_data/idx/docsize/content/config) have auto-generated DDL
    // that differs across SQLite versions (host Python vs Cloudflare D1).
    // Must mirror the compiler.py filter exactly or fingerprint permanently
    // mismatches, pinning the worker to degraded mode forever.
    const result = await env.DB.prepare(

View source record →