@devries-cameron20 / t3code Mirror · read-only
Fork 0

The best way to control Claude Code, Codex and more from any computer or phone

Mirrored from https://github.com/Camo67/t3code.git

Synced Nov 21, 04:45 UTC

main
ts 69 lines 2.43 KB
Raw
1 import { NodeFileSystem } from "@effect/platform-node"
2 import { SqliteClient, SqliteMigrator } from "@effect/sql-sqlite-node"
3 import { assert, describe, it } from "@effect/vitest"
4 import { Effect, FileSystem } from "effect"
5 import { Reactivity } from "effect/reactivity"
6 import * as SqlClient from "effect/sql/SqlClient"
7 import * as SqlError from "effect/sql/SqlError"
8
9 const makeClients = Effect.gen(function*() {
10 const fs = yield* FileSystem.FileSystem
11 const dir = yield* fs.makeTempDirectoryScoped()
12 const filename = dir + "/test.db"
13
14 return {
15 lockClient: yield* SqliteClient.make({ filename }),
16 migratorClient: yield* SqliteClient.make({ filename })
17 }
18 }).pipe(Effect.provide([NodeFileSystem.layer, Reactivity.layer]))
19
20 describe("SqliteMigrator", () => {
21 it.effect("fails with a typed MigrationError and rolls back failed migrations", () =>
22 Effect.gen(function*() {
23 const { migratorClient } = yield* makeClients
24
25 const error = yield* Effect.flip(
26 SqliteMigrator.run({
27 loader: SqliteMigrator.fromRecord({
28 "1_bad": Effect.gen(function*() {
29 const sql = yield* SqlClient.SqlClient
30 yield* sql`INSERT INTO missing_table (id) VALUES (1)`
31 })
32 })
33 }).pipe(Effect.provideService(SqlClient.SqlClient, migratorClient))
34 )
35
36 assert(error._tag === "MigrationError")
37 assert.strictEqual(error.kind, "Failed")
38 assert(SqlError.isSqlError(error.cause))
39 assert.deepStrictEqual(yield* migratorClient`SELECT migration_id FROM effect_sql_migrations`, [])
40 }))
41
42 it.effect("fails on lock errors", () =>
43 Effect.gen(function*() {
44 const { lockClient, migratorClient } = yield* makeClients
45
46 yield* migratorClient`PRAGMA busy_timeout = 1`
47
48 yield* SqliteMigrator.run({
49 loader: SqliteMigrator.fromRecord({})
50 }).pipe(Effect.provideService(SqlClient.SqlClient, migratorClient))
51
52 yield* Effect.acquireRelease(
53 lockClient`BEGIN IMMEDIATE`,
54 () => lockClient`ROLLBACK`.pipe(Effect.ignore)
55 )
56
57 const error = yield* Effect.flip(
58 SqliteMigrator.run({
59 loader: SqliteMigrator.fromRecord({
60 "1_test": Effect.void
61 })
62 }).pipe(Effect.provideService(SqlClient.SqlClient, migratorClient))
63 )
64
65 assert.strictEqual(error._tag, "SqlError")
66 assert(SqlError.isSqlError(error))
67 assert.strictEqual(error.reason._tag, "LockTimeoutError")
68 }))
69 })