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}`) }) })