sailfork / t3code-github / .repos/ alchemy-effect/ packages/ integration-tests/ test/ Neon/ fixtures/ connect-handler.ts

import { Connect, ConnectHttp, connectEnvKeys } from "@alchemy.run/neon/Connect";
import { Postgres } from "@alchemy.run/sql/Postgres";
import { CurrentRuntimeContext } from "alchemy/RuntimeContext";
import * as Cause from "effect/Cause";
import * as Effect from "effect/Effect";
import * as HttpServerResponse from "effect/http/HttpServerResponse";
import { ConnectBranch, ConnectProject } from "./connect-database.ts";

export const connectHandler = Effect.gen(function* () {
  const context = yield* CurrentRuntimeContext;
  if (!context) return yield* Effect.die(new Error("Connect fixture requires a host"));
  const branchResource = yield* ConnectBranch;
  const keys = connectEnvKeys(branchResource);
  const branch = yield* Connect(branchResource);
  const projectResource = yield* ConnectProject;
  const projectKeys = connectEnvKeys(projectResource);
  const project = yield* Connect(projectResource);
  const pooled = yield* Postgres({ url: branch.connectionString });
  const direct = yield* Postgres({ url: branch.directConnectionString });
  const parent = yield* Postgres({ url: project.pooledConnectionString });
  return {
    fetch: Effect.gen(function* () {
      const rows =
        yield* pooled`SELECT current_database() AS database, value FROM alchemy_connect_marker`;
      const directRows =
        yield* direct`SELECT current_database() AS database, value FROM alchemy_connect_marker`;
      const parentRows =
        yield* parent`SELECT current_database() AS database, value FROM alchemy_connect_marker`;
      const accountKey = yield* context.get<string>("NEON_API_KEY");
      return yield* HttpServerResponse.json({
        database: rows[0]?.database,
        directDatabase: directRows[0]?.database,
        parentDatabase: parentRows[0]?.database,
        branchMarker: rows[0]?.value,
        directMarker: directRows[0]?.value,
        parentMarker: parentRows[0]?.value,
        hasAccountKey: accountKey !== undefined,
        injected: yield* context.get<boolean>(keys.injected),
        parentInjected: yield* context.get<boolean>(projectKeys.injected),
      });
    }).pipe(
      Effect.catchCause((cause) =>
        HttpServerResponse.json({
          error: Cause.pretty(cause).replace(
            /postgres(?:ql)?:\/\/[^\s"']+/g,
            "<redacted-database-url>",
          ),
        }),
      ),
      Effect.orDie,
    ),
  };
}).pipe(Effect.provide(ConnectHttp));