sailfork / t3code-github / .repos/ alchemy-effect/ packages/ integration-tests/ test/ AWS/ RedshiftServerless/ fixtures/ query-handler.ts

import * as Lambda from "@alchemy.run/aws/Lambda";
import * as RedshiftData from "@alchemy.run/aws/RedshiftData";
import * as RedshiftServerless from "@alchemy.run/aws/RedshiftServerless";
import * as Duration from "effect/Duration";
import * as Effect from "effect/Effect";
import { HttpServerRequest } from "effect/http/HttpServerRequest";
import * as HttpServerResponse from "effect/http/HttpServerResponse";
import path from "pathe";

const main = path.resolve(import.meta.dirname, "query-handler.ts");

export class RedshiftQueryFunction extends Lambda.Function<Lambda.Function>()(
  "RedshiftQueryFunction",
) {}

export default RedshiftQueryFunction.make(
  {
    main,
    functionUrl: true,
    // Redshift Data statements are submitted then polled — allow generous
    // time for the composite query to finish.
    timeout: Duration.seconds(120),
  },
  Effect.gen(function* () {
    const namespace = yield* RedshiftServerless.Namespace("QueryNamespace", {
      namespaceName: "alchemy-test-rs-ns",
      dbName: "dev",
      adminUsername: "alchemyadmin",
      manageAdminPassword: true,
    });
    const workgroup = yield* RedshiftServerless.Workgroup("QueryWorkgroup", {
      workgroupName: "alchemy-test-rs-wg",
      namespaceName: namespace.namespaceName,
      baseCapacity: 8,
      publiclyAccessible: false,
    });

    const sql = yield* RedshiftData.Statements(workgroup, { database: "dev" });

    return {
      fetch: Effect.gen(function* () {
        const request = yield* HttpServerRequest;
        const url = new URL(request.originalUrl);
        const pathname = url.pathname;

        if (request.method === "GET" && pathname === "/query") {
          const result = yield* sql.query("SELECT 1 AS n");
          return yield* HttpServerResponse.json({
            columns: (result.ColumnMetadata ?? []).map((c) => c.name),
            records: result.Records,
            totalNumRows: result.TotalNumRows,
          });
        }

        return yield* HttpServerResponse.json(
          { error: "Not found", method: request.method, pathname },
          { status: 404 },
        );
      }).pipe(Effect.orDie),
    };
  }).pipe(Effect.provide(RedshiftData.StatementsHttp)),
);