sailfork / t3code-github / .repos/ effect/ packages/ sql/ sqlite-react-native/ test/ Client.test.ts

import { assert, describe, it } from "@effect/vitest"
import { Effect } from "effect"
import { Reactivity } from "effect/reactivity"
import { createRequire } from "node:module"
import * as Semver from "semver"
import { vi } from "vitest"

const state = vi.hoisted(() => ({
  database: {
    close() {},
    execute: async () => ({ rowsAffected: 0, rows: [{ value: 1 }] }),
    executeRaw: async () => ({ rowsAffected: 0, rawRows: [[1]], columnNames: ["value"] }),
    executeRawSync: () => ({ rowsAffected: 0, rawRows: [[1]], columnNames: ["value"] }),
    executeSync: () => ({ rowsAffected: 0, rows: [{ value: 1 }] })
  }
}))

vi.mock("@op-engineering/op-sqlite", () => ({
  open: () => state.database
}))

import { SqliteClient } from "@effect/sql-sqlite-react-native"

const require = createRequire(import.meta.url)

describe("Client", () => {
  it.effect("should work", () => Effect.void)

  it.effect("returns array rows from synchronous values queries", () =>
    Effect.gen(function*() {
      const sql = yield* SqliteClient.make({ filename: "test.db" })
      const rows = yield* sql`SELECT 1 AS value`.values
      const unpreparedRows = yield* sql`SELECT 1 AS value`.valuesUnprepared
      assert.deepStrictEqual(rows, [[1]])
      assert.deepStrictEqual(unpreparedRows, [[1]])
    }).pipe(Effect.provide(Reactivity.layer)))

  it.effect("returns array rows from asynchronous values queries", () =>
    Effect.gen(function*() {
      const sql = yield* SqliteClient.make({ filename: "test.db" })
      const rows = yield* SqliteClient.withAsyncQuery(sql`SELECT 1 AS value`.values)
      const unpreparedRows = yield* SqliteClient.withAsyncQuery(sql`SELECT 1 AS value`.valuesUnprepared)
      assert.deepStrictEqual(rows, [[1]])
      assert.deepStrictEqual(unpreparedRows, [[1]])
    }).pipe(Effect.provide(Reactivity.layer)))

  it("peer range accepts op-sqlite 17 and the tested op-sqlite version", () => {
    const peerRange = require("../package.json").peerDependencies["@op-engineering/op-sqlite"]
    const testedVersion = require("@op-engineering/op-sqlite/package.json").version
    assert.isTrue(Semver.satisfies("17.1.2", peerRange))
    assert.isTrue(Semver.satisfies(testedVersion, peerRange), `${testedVersion} is outside ${peerRange}`)
  })
})