The best way to control Claude Code, Codex and more from any computer or phone
| 1 | import { assert, it } from "@effect/vitest" |
| 2 | import { Effect, Layer } from "effect" |
| 3 | import * as KeyValueStoreTest from "effect-test/persistence/KeyValueStoreTest" |
| 4 | import { KeyValueStore, Persistence } from "effect/persistence" |
| 5 | import { SqlClient } from "effect/sql" |
| 6 | import { MssqlContainer } from "./utils.ts" |
| 7 | |
| 8 | // Pin a case-insensitive key collation even when the server default is binary. |
| 9 | const layerKvs = (table: string) => |
| 10 | Layer.unwrap(Effect.gen(function*() { |
| 11 | const sql = yield* SqlClient.SqlClient |
| 12 | yield* sql` |
| 13 | CREATE TABLE ${sql(table)} ( |
| 14 | id NVARCHAR(450) COLLATE Latin1_General_100_CI_AS PRIMARY KEY, |
| 15 | value VARBINARY(MAX) NOT NULL, |
| 16 | value_type SMALLINT NOT NULL |
| 17 | ) |
| 18 | ` |
| 19 | return KeyValueStore.layerSql({ table }) |
| 20 | })).pipe(Layer.provide(MssqlContainer.layerClient)) |
| 21 | |
| 22 | KeyValueStoreTest.suite("sql-mssql-ci", layerKvs("effect_key_value_store_ci")) |
| 23 | |
| 24 | it.layer( |
| 25 | Persistence.layerBackingKvs.pipe(Layer.provide(layerKvs("effect_backing_kvs_ci"))), |
| 26 | { timeout: "90 seconds" } |
| 27 | )("BackingPersistence (sql-mssql-ci)", (it) => { |
| 28 | it.effect("clearing a store preserves a differently cased store with a distinct entry key", () => |
| 29 | Effect.gen(function*() { |
| 30 | const backing = yield* Persistence.BackingPersistence |
| 31 | const lower = yield* backing.make("scope") |
| 32 | const upper = yield* backing.make("SCOPE") |
| 33 | yield* lower.set("one", { value: "match" }, undefined) |
| 34 | yield* upper.set("two", { value: "unrelated" }, undefined) |
| 35 | |
| 36 | yield* lower.clear |
| 37 | |
| 38 | assert.strictEqual(yield* lower.get("one"), undefined) |
| 39 | assert.deepStrictEqual(yield* upper.get("two"), { value: "unrelated" }) |
| 40 | })) |
| 41 | }) |