sailfork / t3code-github / .repos/ effect/ packages/ sql/ pglite/ test/ SqlRunnerStorage.test.ts

import { PgliteClient } from "@effect/sql-pglite"
import { assert, describe, it } from "@effect/vitest"
import { Effect, Layer } from "effect"
import { Runner, RunnerAddress, RunnerStorage, ShardId, ShardingConfig, SqlRunnerStorage } from "effect/cluster"
import { SqlClient } from "effect/sql"

describe("SqlRunnerStorage", () => {
  for (const shardLockDisableAdvisory of [false, true]) {
    it.live(
      `does not starve the shared PGlite connection (shardLockDisableAdvisory: ${shardLockDisableAdvisory})`,
      () =>
        Effect.gen(function*() {
          const sql = yield* SqlClient.SqlClient
          const storage = yield* RunnerStorage.RunnerStorage
          const address = RunnerAddress.make("localhost", 1234)
          const runner = Runner.make({ address, groups: ["default"], weight: 1 })
          const shards = [ShardId.make("default", 1)]

          assert.deepStrictEqual(yield* storage.getRunners, [])
          yield* storage.register(runner, true)
          assert.deepStrictEqual(yield* storage.getRunners, [[runner, true]])
          assert.deepStrictEqual(yield* storage.acquire(address, shards), shards)
          assert.deepStrictEqual(yield* storage.refresh(address, shards), shards)
          assert.deepStrictEqual(yield* sql`SELECT 2 AS n`, [{ n: 2 }])
        }).pipe(
          Effect.timeout("5 seconds"),
          Effect.provide(SqlRunnerStorage.layer.pipe(
            Layer.provideMerge(PgliteClient.layer()),
            Layer.provide(ShardingConfig.layer({ shardLockDisableAdvisory }))
          ))
        ),
      { timeout: 30_000 }
    )
  }
})