sailfork / t3code-github / .repos/ effect/ packages/ sql/ mssql/ test/ Cancellation.integration.test.ts

import { MssqlClient } from "@effect/sql-mssql"
import { assert, it } from "@effect/vitest"
import { Effect, Fiber, Redacted } from "effect"
import * as Reactivity from "effect/reactivity/Reactivity"
import { MssqlContainer } from "./utils.ts"

it.layer(MssqlContainer.layer, { timeout: "90 seconds" })((it) => {
  it.effect("can query after interrupting a request in a single-connection pool", () =>
    Effect.gen(function*() {
      const container = yield* MssqlContainer
      const client = yield* MssqlClient.make({
        server: container.getHost(),
        port: container.getPort(),
        database: container.getDatabase(),
        username: container.getUsername(),
        password: Redacted.make(container.getPassword()),
        encrypt: !("Deno" in globalThis),
        trustServer: true,
        minConnections: 1,
        maxConnections: 1
      })
      // Start the request before interrupting it; do not wait for the server
      // delay or give the cancellation acknowledgement time to arrive.
      const pending = yield* client`WAITFOR DELAY '00:00:10'`.pipe(Effect.forkScoped({ startImmediately: true }))
      yield* Fiber.interrupt(pending)
      const rows = yield* client<{ value: number }>`SELECT 42 AS value`
      assert.deepStrictEqual(rows, [{ value: 42 }])
    }).pipe(Effect.provide(Reactivity.layer)))
})