12345678910111213141516171819202122232425262728293031323334353637383940414243444546
import {  assertEquals,  assertInstanceOf,  assertThrows,} from "https://deno.land/std@0.154.0/testing/asserts.ts";
import { DB, SqliteError, Status } from "../mod.ts";
Deno.test("invalid SQL", function () {  const db = new DB();  const queries = [    "INSERT INTO does_not_exist (balance) VALUES (5)",    "this is not sql",    ";;;",  ];  for (const query of queries) assertThrows(() => db.query(query));});
Deno.test("constraint error is correct", function () {  const db = new DB();  db.query("CREATE TABLE test (name TEXT PRIMARY KEY)");  db.query("INSERT INTO test (name) VALUES (?)", ["A"]);
  assertThrows(    () => db.query("INSERT INTO test (name) VALUES (?)", ["A"]),    (error: Error) => {      assertInstanceOf(error, SqliteError);      assertEquals(error.code, Status.SqliteConstraint);      assertEquals(error.message, "UNIQUE constraint failed: test.name");    },  );});
Deno.test("syntax error code is correct", function () {  const db = new DB();
  assertThrows(    () => db.query("CREATE TABLEX test (name TEXT PRIMARY KEY)"),    (error: Error) => {      assertInstanceOf(error, SqliteError);      assertEquals(error.code, Status.SqliteError);      assertEquals(error.message, 'near "TABLEX": syntax error');    },  );});