sailfork / t3code-github / .repos/ alchemy-effect/ examples/ aws-aurora-drizzle/ src/ bootstrap.ts

import * as AWS from "@alchemy.run/aws";
import * as Alchemy from "alchemy";
import * as Effect from "effect/Effect";
import * as Schedule from "effect/Schedule";
import { database } from "./database.ts";

// One atomic, replay-safe initial migration. Application roles never own DDL.
const initialMigration = `DO $
BEGIN
  IF NOT EXISTS (SELECT FROM pg_roles WHERE rolname = 'app_iam') THEN
    CREATE ROLE app_iam LOGIN;
  END IF;
  GRANT rds_iam TO app_iam;
  REVOKE CREATE ON SCHEMA public FROM PUBLIC;
  CREATE TABLE IF NOT EXISTS public.todos (
    id uuid PRIMARY KEY,
    title text NOT NULL,
    done boolean NOT NULL DEFAULT false
  );
  GRANT CONNECT ON DATABASE app TO app_iam;
  GRANT USAGE ON SCHEMA public TO app_iam;
  GRANT SELECT, INSERT, UPDATE, DELETE ON public.todos TO app_iam;
END $`;

export const bootstrap = Effect.gen(function* () {
  const db = yield* database;
  const Bootstrap = Alchemy.Action(
    "BootstrapDatabase",
    Effect.gen(function* () {
      const execute = yield* AWS.RDSData.ExecuteStatement(db.cluster, {
        secret: db.secret,
        database: "app",
      });
      return Effect.fn(function* (input: { writer: string; sql: string }) {
        yield* execute({ sql: input.sql }).pipe(
          Effect.retry({
            while: (error) =>
              error._tag === "DatabaseUnavailableException" ||
              error._tag === "DatabaseResumingException",
            schedule: Schedule.spaced("5 seconds"),
            times: 8,
          }),
        );
        return "1";
      });
    }).pipe(Effect.provide(AWS.RDSData.ExecuteStatementHttp)),
  );
  return yield* Bootstrap({
    writer: db.writer.dbInstanceArn,
    sql: initialMigration,
  });
});