sailfork / t3code-github / .repos/ alchemy-effect/ packages/ integration-tests/ test/ Cloudflare/ D1/ fixtures/ drizzle-database.ts

import * as Cloudflare from "@alchemy.run/cloudflare";
import * as Drizzle from "@alchemy.run/drizzle";
import * as Effect from "effect/Effect";

/**
 * The full deploy-time Drizzle flywheel on D1:
 *
 *   1. `Drizzle.Schema` diffs `drizzle-schema.ts` against the checked-in
 *      snapshot under `drizzle-migrations/` and regenerates SQL on drift
 *      (no drift in CI — the initial migration is checked in).
 *   2. `Cloudflare.D1.Database` detects the drizzle-kit layout and applies
 *      pending migrations through drizzle-orm's own migrator, tracked in
 *      the `drizzle_migrations` table (a custom-table override of drizzle's
 *      default `__drizzle_migrations`).
 *
 * Paths are relative to the test cwd (`packages/alchemy`).
 */
export const DrizzleDb = Effect.gen(function* () {
  const schema = yield* Drizzle.Schema("d1-drizzle-schema", {
    schema: "./test/Cloudflare/D1/fixtures/drizzle-schema.ts",
    out: "./test/Cloudflare/D1/fixtures/drizzle-migrations",
    dialect: "sqlite",
  });

  return yield* Cloudflare.D1.Database("D1DrizzleDatabase", {
    migrations: { dir: schema.out, table: "drizzle_migrations" },
  });
});