Example

import { Client } from "knix";
import SQLite from "react-native-sqlite-storage";

async function func() {
  const client = new Client(await SQLite.openDatabase({ name: ":memory:" }));
  await client
    .query(
      "CREATE TABLE IF NOT EXISTS example (id INTEGER PRIMARY KEY AUTOINCREMENT, data TEXT)"
    )
    .exec();
  const id = await client
    .query("INSERT INTO example (data) VALUES (?)", ["test"])
    .insert();
  const data = await client
    .query<{ id: number; data: string }>("SELECT * FROM example WHERE id = ?", [
      id,
    ])
    .one();
  console.log(data); // {id:1, data:"test"}
  const rowsAffected = await client
    .query("UPDATE example SET data = ?", ["test1"])
    .update();
  console.log(rowsAffected); // 1
  await client.transaction(async (tx) => {
    await tx.query("INSERT INTO example (data) VALUES (?)", ["a"]).insert();
    await tx.query("INSERT INTO example (data) VALUES (?)", ["b"]).insert();
    await tx.query("INSERT INTO example (data) VALUES (?)", ["c"]).insert();
  });
  const all = await client.query("SELECT * FROM example").all();
  console.log(all); // [{id:1, data:"test"},{id:2, data:"a"},{id:3, data:"b"},{id:4, data:"c"}]}
}