@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 41 lines 1.48 KB
Raw
1 import { PgliteClient } from "@effect/sql-pglite"
2 import { assert, describe, layer } from "@effect/vitest"
3 import { Effect } from "effect"
4 import { PersistedQueue } from "effect/persistence"
5 import { SqlClient } from "effect/sql"
6
7 const ClientLayer = PgliteClient.layer({})
8
9 describe("PersistedQueue SQL migrations", () => {
10 layer(ClientLayer, { timeout: "30 seconds" })((it) => {
11 it.effect("runs fresh-install migrations once", () =>
12 Effect.gen(function*() {
13 const sql = (yield* SqlClient.SqlClient).withoutTransforms()
14 const tableName = "persisted_queue_migration_test"
15
16 yield* PersistedQueue.makeStoreSql({ tableName })
17 yield* PersistedQueue.makeStoreSql({ tableName })
18
19 const migrations = yield* sql<{
20 readonly migration_id: number
21 readonly name: string
22 }>`SELECT migration_id, name FROM ${sql(`${tableName}_migrations`)} ORDER BY migration_id`
23 assert.deepStrictEqual(migrations, [
24 { migration_id: 1, name: "create_table" },
25 { migration_id: 2, name: "upgrade_schema" }
26 ])
27
28 const indexes = yield* sql<{ readonly indexname: string }>`
29 SELECT indexname FROM pg_indexes
30 WHERE tablename = ${tableName}
31 ORDER BY indexname
32 `
33 assert.deepStrictEqual(indexes.map((row) => row.indexname), [
34 `idx_${tableName}_id`,
35 `idx_${tableName}_take`,
36 `idx_${tableName}_update`,
37 `${tableName}_pkey`
38 ])
39 }))
40 })
41 })