import * as Drizzle from "@alchemy.run/drizzle/Postgres";
import { ConnectPostgres } from "@alchemy.run/railway/ConnectPostgres";
import { ConnectPostgresHttp } from "@alchemy.run/railway/ConnectPostgresHttp";
import { Function } from "@alchemy.run/railway/Function";
import * as Effect from "effect/Effect";
import * as HttpServerResponse from "effect/http/HttpServerResponse";
import { Db } from "./postgres-shared.ts";
import { Partition, Site } from "./suite-env.ts";
export { Db, Site };
/**
* Effect-native canvas Function that binds {@link Db} via
* {@link ConnectPostgres} and answers SELECT 1. Overflows Railway's 96KB
* encoded start command (`FunctionTooLarge`) — live HTTP coverage uses
* the async fixture in `async-postgres-fn.ts` instead.
*/
export default class PostgresFn extends Function<PostgresFn>()(
"PostgresFn",
{
project: Site,
environment: Partition,
main: import.meta.url,
build: { install: ["drizzle-orm"] },
},
Effect.gen(function* () {
const conn = yield* ConnectPostgres(Db);
const db = yield* Drizzle.Postgres(conn.connectionString);
return {
fetch: db.execute("select 1 as ok", "objects").pipe(
Effect.flatMap((rows) => HttpServerResponse.json({ rows })),
Effect.catch((error) =>
HttpServerResponse.json({ ok: false, error: String(error) }, { status: 500 }),
),
),
};
}).pipe(Effect.provide(ConnectPostgresHttp)),
) {}