sailfork / t3code-github / .repos/ effect/ packages/ sql/ pglite/ test/ Migrator.test.ts

import { PgliteClient, PgliteMigrator } from "@effect/sql-pglite"
import { assert, describe, layer } from "@effect/vitest"
import { Effect, Layer } from "effect"
import * as Migrator from "effect/sql/Migrator"
import { SqlClient } from "effect/sql/SqlClient"
import * as Statement from "effect/sql/Statement"

const ClientLayer = PgliteClient.layer({})

const loader = Effect.succeed([
  [
    1,
    "init",
    Effect.succeed(Effect.gen(function*() {
      const sql = yield* SqlClient
      yield* sql`CREATE TABLE migrator_test (id SERIAL PRIMARY KEY, value TEXT)`
    }))
  ] as const,
  [
    2,
    "insert",
    Effect.succeed(Effect.gen(function*() {
      const sql = yield* SqlClient
      yield* sql`INSERT INTO migrator_test (value) VALUES ('hello')`
    }))
  ] as const
])

const MigratorLayer = PgliteMigrator.layer({ loader }).pipe(Layer.provide(ClientLayer))

describe("PgliteMigrator", () => {
  layer(Layer.merge(ClientLayer, MigratorLayer), { timeout: "30 seconds" })((it) => {
    it.effect("runs migrations and records them", () =>
      Effect.gen(function*() {
        const sql = yield* PgliteClient.PgliteClient
        const rows = yield* sql<{ value: string }>`SELECT value FROM migrator_test`
        assert.deepStrictEqual(rows, [{ value: "hello" }])
        const migrations = yield* sql<
          { migration_id: number; name: string }
        >`SELECT migration_id, name FROM effect_sql_migrations ORDER BY migration_id`
        assert.deepStrictEqual(
          migrations.map((m) => [m.migration_id, m.name]),
          [[1, "init"], [2, "insert"]]
        )
      }))
  })
})

describe("Migrator.make", () => {
  layer(ClientLayer, { timeout: "30 seconds" })((it) => {
    it.effect("reuses a migrations table whose name needs quoting", () =>
      Effect.gen(function*() {
        const table = "MixedCase_make_migrations"
        const loader = Migrator.fromRecord({ "1_first": Effect.void })
        yield* PgliteMigrator.run({ loader, table })

        const completed = yield* PgliteMigrator.run({ loader, table })

        assert.deepStrictEqual(completed, [])
      }))

    it.effect("transforms only the migrations table writes", () =>
      Effect.gen(function*() {
        const transformed: Array<string> = []
        const run = Migrator.make({
          transformWrites: (effect) =>
            Effect.provideService(effect, Statement.CurrentTransformer, (statement) =>
              Effect.sync(() => {
                transformed.push(statement.compile()[0])
                return statement
              }))
        })

        yield* run({ loader: Migrator.fromRecord({ "1_first": Effect.void }), table: "transformed_make_migrations" })

        assert.deepStrictEqual(transformed.map((sql) => sql.split(" ")[0]), ["CREATE", "INSERT"])
      }))
  })
})