1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
import * as sql from "../sql-builder.ts";import { assertEquals } from "./prelude.ts";
Deno.test(  "Make a select using a schema",  () => {    const statement = sql.makeSelect("tables", "information_schema");    assertEquals(statement.toSql(), "SELECT  FROM information_schema.tables");  },);
Deno.test(  "Select columns",  () => {    const statement = sql.selection(      sql.makeSelect("tables", "information_schema"),      ["table_name"],    );    assertEquals(statement.toSql(), "SELECT table_name  FROM information_schema.tables");  },);
Deno.test(  "INSERT",  () => {    const statement = sql.makeInsert("some_table", { id: undefined, data: 'test' });    assertEquals(statement.toSql(), "INSERT INTO some_table  (id, data) VALUES (( DEFAULT ), ('test'))");  },);
Deno.test(  "DELETE",  () => {    const statement = sql.makeDelete("some_table", { id: 1 });    assertEquals(statement.toSql(), "DELETE FROM some_table   WHERE ((id) = (('1')))");  },);