mirror of
https://github.com/Effect-TS/effect.git
synced 2026-11-22 06:21:50 +08:00
Co-authored-by: Viacheslav <bezff@MacBook-Pro-3.local> Co-authored-by: Effect Bot <tech-ops@effectful.co>
62 lines
2.5 KiB
TypeScript
62 lines
2.5 KiB
TypeScript
import { assert, describe, it } from "@effect/vitest"
|
|
import { Effect, Layer, Logger } from "effect"
|
|
import { SqlClient, Statement } from "effect/sql"
|
|
import { MysqlContainer } from "./utils.ts"
|
|
|
|
const SqlLogger = Layer.succeed(Statement.CurrentTransformer)((statement) => {
|
|
const [query, params] = statement.compile()
|
|
return Effect.log("executing sql").pipe(
|
|
Effect.annotateLogs({ query, params }),
|
|
Effect.as(statement)
|
|
)
|
|
})
|
|
|
|
describe("sql", () => {
|
|
it.effect("releases completed nested savepoints", () =>
|
|
Effect.gen(function*() {
|
|
const sql = yield* SqlClient.SqlClient
|
|
yield* sql`CREATE TABLE savepoint_release (value INTEGER)`
|
|
yield* sql.withTransaction(Effect.gen(function*() {
|
|
for (const rollback of [false, true]) {
|
|
yield* sql.withTransaction(
|
|
sql`INSERT INTO savepoint_release VALUES (1)`.pipe(
|
|
Effect.andThen(rollback ? Effect.fail("rollback") : Effect.void)
|
|
)
|
|
).pipe(Effect.ignore)
|
|
const error = yield* sql`RELEASE SAVEPOINT effect_sql_1`.unprepared.pipe(Effect.flip)
|
|
assert.strictEqual(error._tag, "SqlError")
|
|
}
|
|
}))
|
|
assert.deepStrictEqual(yield* sql`SELECT value FROM savepoint_release`, [{ value: 1 }])
|
|
}).pipe(Effect.provide(MysqlContainer.layerClient)), { timeout: 60_000 })
|
|
|
|
it.effect("in helper with an empty list", () =>
|
|
Effect.gen(function*() {
|
|
const sql = yield* SqlClient.SqlClient
|
|
yield* sql`CREATE TABLE empty_in (id INTEGER)`
|
|
yield* sql`INSERT INTO empty_in VALUES (1)`
|
|
assert.deepStrictEqual(yield* sql`SELECT id FROM empty_in WHERE id IN ${sql.in([])}`, [])
|
|
assert.deepStrictEqual(yield* sql`SELECT id FROM empty_in WHERE id NOT IN ${sql.in([])}`, [{ id: 1 }])
|
|
}).pipe(Effect.provide(MysqlContainer.layerClient)), { timeout: 60_000 })
|
|
|
|
it.effect("tranformers", () =>
|
|
Effect.gen(function*() {
|
|
const logs: Array<unknown> = []
|
|
const sql = yield* SqlClient.SqlClient
|
|
const result = yield* sql<{ result: number }>`SELECT 1 + 1 AS result`.pipe(
|
|
Effect.provide(Logger.layer([
|
|
Logger.make((log) => {
|
|
logs.push(log.message)
|
|
})
|
|
]))
|
|
)
|
|
assert.deepStrictEqual(result, [{ result: 2 }])
|
|
assert.deepStrictEqual(logs, [["executing sql"]])
|
|
}).pipe(
|
|
Effect.provide(MysqlContainer.layerClient.pipe(
|
|
Layer.provideMerge(SqlLogger)
|
|
)),
|
|
Effect.catchTag("ContainerError", () => Effect.void)
|
|
), { timeout: 60_000 })
|
|
})
|