diff options
Diffstat (limited to 'integration/bunjs-only-snippets/sql-raw.test.js')
-rw-r--r-- | integration/bunjs-only-snippets/sql-raw.test.js | 71 |
1 files changed, 0 insertions, 71 deletions
diff --git a/integration/bunjs-only-snippets/sql-raw.test.js b/integration/bunjs-only-snippets/sql-raw.test.js deleted file mode 100644 index ea7f72bd6..000000000 --- a/integration/bunjs-only-snippets/sql-raw.test.js +++ /dev/null @@ -1,71 +0,0 @@ -import { expect, it } from "bun:test"; - -var SQL = globalThis[Symbol.for("Bun.lazy")]("sqlite"); - -it("works", () => { - const handle = SQL.open("/tmp/northwind.sqlite"); - - const stmt = SQL.prepare( - handle, - 'SELECT * FROM "Order" WHERE OrderDate > date($date)' - ); - expect(stmt.toString()).toBe( - `SELECT * FROM "Order" WHERE OrderDate > date(NULL)` - ); - - expect( - Array.isArray( - stmt.all({ - // do the conversion this way so that this test runs in multiple timezones - $date: new Date( - new Date(1996, 8, 1, 0, 0, 0, 0).toUTCString() - ).toISOString(), - }) - ) - ).toBe(true); - expect(stmt.toString()).toBe( - `SELECT * FROM "Order" WHERE OrderDate > date('1996-09-01T07:00:00.000Z')` - ); - - var ran = stmt.run({ - $date: new Date( - new Date(1997, 8, 1, 0, 0, 0, 0).toUTCString() - ).toISOString(), - }); - expect(Array.isArray(ran)).toBe(false); - expect(ran === undefined).toBe(true); - expect(stmt.toString()).toBe( - `SELECT * FROM "Order" WHERE OrderDate > date('1997-09-01T07:00:00.000Z')` - ); - - expect( - Array.isArray( - stmt.get({ - $date: new Date( - new Date(1998, 8, 1, 0, 0, 0, 0).toUTCString() - ).toISOString(), - }) - ) - ).toBe(false); - expect(stmt.toString()).toBe( - `SELECT * FROM "Order" WHERE OrderDate > date('1998-09-01T07:00:00.000Z')` - ); - expect(stmt.paramsCount).toBe(1); - expect(stmt.columnsCount).toBe(14); - expect(stmt.columns.length).toBe(14); - stmt.finalize(); - SQL.close(handle); -}); - -it("SQL.run works", () => { - const handle = SQL.open("/tmp/northwind.sqlite"); - expect(typeof handle).toBe("number"); - - expect( - SQL.run(handle, 'SELECT * FROM "Order" WHERE OrderDate > date($date)', { - $date: new Date(1996, 8, 1).toISOString(), - }) - ).toBe(undefined); - - SQL.close(handle); -}); |