t3-code-android-nightly/.repos/alchemy-effect/packages/alchemy/test/Planetscale/Postgres/fixtures/Stack.ts

import * as Cloudflare from "@/Cloudflare/index.ts";
import * as Planetscale from "@/Planetscale/index.ts";
import * as Effect from "effect/Effect";
import path from "node:path";
import { fileURLToPath } from "node:url";

/**
 * Shared Planetscale + Cloudflare wiring used by the Hyperdrive
 * fixture worker. A long-lived staging Postgres database (named
 * deterministically so reruns adopt the same resource) owns a feature
 * branch + role. The live Hyperdrive config points at the direct
 * `role.origin`; local dev bypasses Hyperdrive, so it uses
 * `role.pooledOrigin` to avoid one direct connection per worker request.
 */
// This module is bundled into the worker (hyperdrive-worker.ts imports it),
// so this also evaluates at worker startup, where the bundler leaves
// `import.meta.url` undefined. The fallback is never read there — resource
// props are only consumed at deploy time.
const migrationsDir = import.meta.url
  ? path.join(fileURLToPath(import.meta.url), "..", "migrations")
  : ".";

export const PlanetscaleDb = Effect.gen(function* () {
  const database = yield* Planetscale.PostgresDatabase("HyperdriveTestDb", {
    name: "alchemy-postgres-hyperdrive",
    region: { slug: "us-east" },
    clusterSize: "PS_10",
  });

  const branch = yield* Planetscale.PostgresBranch("HyperdriveTestBranch", {
    database,
    migrations: migrationsDir,
  });

  const role = yield* Planetscale.PostgresRole("HyperdriveTestRole", {
    database,
    branch,
    inheritedRoles: ["postgres"],
  });

  return { database, branch, role };
});

export const Hyperdrive = Effect.gen(function* () {
  const { role } = yield* PlanetscaleDb;
  return yield* Cloudflare.Hyperdrive.Connection("HyperdriveTestEdge", {
    origin: role.origin,
    dev: role.pooledOrigin,
    // The test asserts read-your-writes across separate HTTP requests;
    // Hyperdrive's query cache (60s default) would serve stale SELECTs.
    caching: { disabled: true },
  });
});