Class FakeDatabase

src/storage/migrations.test.ts:17–61

});

class FakeDatabase implements SQLiteDatabase {
  readonly sessionColumns: Set<string>;

  constructor(
    private version: number,
    sessionColumns: string[],
  ) {
    this.sessionColumns = new Set(sessionColumns);
  }

  exec(sql: string): void {
    const match = sql.match(/ALTER TABLE sessions ADD COLUMN ([a-z_]+) /);
    if (match?.[1]) {
      this.sessionColumns.add(match[1]);
    }
  }

  prepare(sql: string): SQLiteStatement {
    if (sql === "PRAGMA table_info(sessions)") {
      return new FakeStatement(() => [...this.sessionColumns].map((name) => ({ name })));
    }

    throw new Error(`Unexpected SQL: ${sql}`);
  }

  pragma(query: string, options?: { simple?: boolean }): unknown {
    if (query === "user_version" && options?.simple) {
      return this.version;
    }

    const match = query.match(/^user_version = (\d+)$/);
    if (match?.[1]) {
      this.version = Number(match[1]);
      return undefined;
    }

    throw new Error(`Unexpected pragma: ${query}`);
  }

  transaction<T>(fn: () => T): () => T {
    return fn;
  }

  close(): void {}
}

class FakeStatement implements SQLiteStatement {
  constructor(private readonly allFn: () => unknown[]) {}