Function makeFakeSql

apps/cloud/src/db/code-migration-runner.test.ts:10–32

(options: { readonly ledgerExists?: boolean; readonly stamped?: string[] })

} from "../../scripts/code-migrations/runner";

const makeFakeSql = (options: { readonly ledgerExists?: boolean; readonly stamped?: string[] }) => {
  const log: { readonly query: string; readonly params?: readonly unknown[] }[] = [];
  const stamped = [...(options.stamped ?? [])];
  const sql: CodeMigrationSql = {
    unsafe: (query, params) => {
      log.push({ query, params });
      if (query.includes("to_regclass")) {
        const rows = [
          { ledger_table: options.ledgerExists === false ? null : "cloud_code_migration" },
        ];
        return Promise.resolve(rows as never);
      }
      if (query.includes('SELECT "name" FROM "cloud_code_migration"')) {
        return Promise.resolve(stamped.map((name) => ({ name })) as never);
      }
      if (query.includes('INSERT INTO "cloud_code_migration"')) {
        stamped.push(String(params?.[0]));
      }
      return Promise.resolve([] as never);
    },
  };
  return { sql, log, stamped };
};

const migrationSpy = (name: string): { migration: CodeMigration; calls: boolean[] } => {
  const calls: boolean[] = [];