sailfork / t3code-github / .repos/ alchemy-effect/ packages/ neon/ src/ Migrations.ts

import {
  runMigrations,
  withPgClient as withClient,
  withPgExecutor,
  type NormalizedMigrationsInput,
  type StampedMigrationsState,
} from "@alchemy.run/sql/Migrations";
import { stripSslQueryParams } from "@alchemy.run/sql/PostgresDriver";
import { applySqlImports } from "@alchemy.run/sql/SqlFile";
import * as Effect from "effect/Effect";
import * as Redacted from "effect/Redacted";
import type { Client, ClientConfig } from "pg";

/**
 * Neon's URIs carry `sslmode=require`; TLS is set on the client instead,
 * without verifying Neon's certificate chain.
 */
const clientConfig = (connectionUri: Redacted.Redacted<string>): ClientConfig => ({
  connectionString: connectionUri.pipe(Redacted.value, stripSslQueryParams),
  ssl: { rejectUnauthorized: false },
});

/** A `pg` client on a Neon connection URI for the scope of `use`. */
export const withPgClient = <A, E, R>(
  connectionUri: Redacted.Redacted<string>,
  use: (client: Client) => Effect.Effect<A, E, R>,
) => withClient(clientConfig(connectionUri), use);

/** Run one SQL script (several statements are fine). */
export const runSql = (connectionUri: Redacted.Redacted<string>, sql: string) =>
  withPgExecutor(clientConfig(connectionUri), (executor) => executor.query(sql)).pipe(
    Effect.asVoid,
  );

export const runPgMigrations = (options: {
  connectionUri: Redacted.Redacted<string>;
  input: NormalizedMigrationsInput;
  stamped: StampedMigrationsState;
}) =>
  runMigrations({
    input: options.input,
    stamped: options.stamped,
    withExecutor: (apply) => withPgExecutor(clientConfig(options.connectionUri), apply),
  });

/** Apply `importFiles`, each once and again only when it changes. */
export const runImports = (
  connectionUri: Redacted.Redacted<string>,
  importFiles: ReadonlyArray<string>,
  rootDir: string,
  previous: Record<string, string>,
) =>
  applySqlImports({
    importFiles,
    rootDir,
    previous,
    apply: (file) => runSql(connectionUri, file.sql),
  });