Skip to content
Source
Sign inSign up
pingdotgg/t3code
Open History to see the last commit

Migrator.test.ts

79 lines2.7 KB

1import { PgliteClient, PgliteMigrator } from "@effect/sql-pglite"
2import { assert, describe, layer } from "@effect/vitest"
3import { Effect, Layer } from "effect"
4import * as Migrator from "effect/sql/Migrator"
5import { SqlClient } from "effect/sql/SqlClient"
6import * as Statement from "effect/sql/Statement"
7​
8const ClientLayer = PgliteClient.layer({})
9​
10const loader = Effect.succeed([
11 [
12 1,
13 "init",
14 Effect.succeed(Effect.gen(function*() {
15 const sql = yield* SqlClient
16 yield* sql`CREATE TABLE migrator_test (id SERIAL PRIMARY KEY, value TEXT)`
17 }))
18 ] as const,
19 [
20 2,
21 "insert",
22 Effect.succeed(Effect.gen(function*() {
23 const sql = yield* SqlClient
24 yield* sql`INSERT INTO migrator_test (value) VALUES ('hello')`
25 }))
26 ] as const
27])
28​
29const MigratorLayer = PgliteMigrator.layer({ loader }).pipe(Layer.provide(ClientLayer))
30​
31describe("PgliteMigrator", () => {
32 layer(Layer.merge(ClientLayer, MigratorLayer), { timeout: "30 seconds" })((it) => {
33 it.effect("runs migrations and records them", () =>
34 Effect.gen(function*() {
35 const sql = yield* PgliteClient.PgliteClient
36 const rows = yield* sql<{ value: string }>`SELECT value FROM migrator_test`
37 assert.deepStrictEqual(rows, [{ value: "hello" }])
38 const migrations = yield* sql<
39 { migration_id: number; name: string }
40 >`SELECT migration_id, name FROM effect_sql_migrations ORDER BY migration_id`
41 assert.deepStrictEqual(
42 migrations.map((m) => [m.migration_id, m.name]),
43 [[1, "init"], [2, "insert"]]
44 )
45 }))
46 })
47})
48​
49describe("Migrator.make", () => {
50 layer(ClientLayer, { timeout: "30 seconds" })((it) => {
51 it.effect("reuses a migrations table whose name needs quoting", () =>
52 Effect.gen(function*() {
53 const table = "MixedCase_make_migrations"
54 const loader = Migrator.fromRecord({ "1_first": Effect.void })
55 yield* PgliteMigrator.run({ loader, table })
56​
57 const completed = yield* PgliteMigrator.run({ loader, table })
58​
59 assert.deepStrictEqual(completed, [])
60 }))
61​
62 it.effect("transforms only the migrations table writes", () =>
63 Effect.gen(function*() {
64 const transformed: Array<string> = []
65 const run = Migrator.make({
66 transformWrites: (effect) =>
67 Effect.provideService(effect, Statement.CurrentTransformer, (statement) =>
68 Effect.sync(() => {
69 transformed.push(statement.compile()[0])
70 return statement
71 }))
72 })
73​
74 yield* run({ loader: Migrator.fromRecord({ "1_first": Effect.void }), table: "transformed_make_migrations" })
75​
76 assert.deepStrictEqual(transformed.map((sql) => sql.split(" ")[0]), ["CREATE", "INSERT"])
77 }))
78 })
79})