sailfork / t3code-github / .repos/ alchemy-effect/ packages/ cloudflare/ src/ Workers/ SqlMigrationsApply.ts

import { applyPendingAlchemyFormat } from "@alchemy.run/sql/Migrations/AlchemyFormat";
import {
  MigrationError,
  type MigrationHistoryConflictError,
  type SqlExecutor,
} from "@alchemy.run/sql/Migrations/Format";
import { inlineSqlParams } from "@alchemy.run/sql/Migrations/Utils";
import type { RuntimeContext } from "alchemy/RuntimeContext";
import * as Effect from "effect/Effect";
import { DurableObjectState } from "./DurableObjectState.ts";
import type { SqlMigrationSnapshot } from "./SqlMigrationsRuntime.ts";

/** @internal */
export const applySqlMigrations: (
  migrations: SqlMigrationSnapshot,
) => Effect.Effect<
  void,
  MigrationError | MigrationHistoryConflictError,
  DurableObjectState | RuntimeContext
> = Effect.fn("Cloudflare.SqlMigrations.apply")(function* (migrations) {
  const { raw } = yield* DurableObjectState;
  const storage = raw.storage;
  const executor: SqlExecutor = {
    dialect: "sqlite",
    query: (sql, params = []) =>
      Effect.try({
        try: () => storage.sql.exec(inlineSqlParams(sql, params, "sqlite")).toArray(),
        catch: (cause) =>
          new MigrationError({
            message: "Failed to query migration history",
            cause,
          }),
      }),
    batch: (statements) =>
      Effect.try({
        try: () =>
          storage.transactionSync(() => {
            for (const statement of statements) storage.sql.exec(statement);
          }),
        catch: (cause) =>
          new MigrationError({
            message: "Failed to apply SQL migration",
            cause,
          }),
      }),
  };
  yield* applyPendingAlchemyFormat({
    executor,
    table: migrations.table,
    records: migrations.records,
  });
});