diff options
| -rw-r--r-- | test/js/bun/sqlite/sql-raw.test.js | 18 |
1 files changed, 9 insertions, 9 deletions
diff --git a/test/js/bun/sqlite/sql-raw.test.js b/test/js/bun/sqlite/sql-raw.test.js index 9b6312dda..c571cbcc7 100644 --- a/test/js/bun/sqlite/sql-raw.test.js +++ b/test/js/bun/sqlite/sql-raw.test.js @@ -6,34 +6,34 @@ const dbPath = import.meta.dir + "/northwind.testdb"; it("works", () => { const handle = SQL.open(dbPath); - const stmt = SQL.prepare(handle, 'SELECT * FROM "Orders" WHERE OrderDate > date($date)'); - expect(stmt.toString()).toBe(`SELECT * FROM "Orders" WHERE OrderDate > date(NULL)`); + const stmt = SQL.prepare(handle, 'SELECT * FROM "Orders" WHERE OrderDate > datetime($date, "gmt")'); + expect(stmt.toString()).toBe(`SELECT * FROM "Orders" WHERE OrderDate > datetime(NULL, "gmt")`); 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(), + $date: "1996-09-01T07:00:00.000Z", }), ), ).toBe(true); - expect(stmt.toString()).toBe(`SELECT * FROM "Orders" WHERE OrderDate > date('1996-09-01T07:00:00.000Z')`); + expect(stmt.toString()).toBe(`SELECT * FROM "Orders" WHERE OrderDate > datetime('1996-09-01T07:00:00.000Z', "gmt")`); var ran = stmt.run({ - $date: new Date(new Date(1997, 8, 1, 0, 0, 0, 0).toUTCString()).toISOString(), + $date: "1997-09-01T07:00:00.000Z", }); expect(Array.isArray(ran)).toBe(false); expect(ran === undefined).toBe(true); - expect(stmt.toString()).toBe(`SELECT * FROM "Orders" WHERE OrderDate > date('1997-09-01T07:00:00.000Z')`); + expect(stmt.toString()).toBe(`SELECT * FROM "Orders" WHERE OrderDate > datetime('1997-09-01T07:00:00.000Z', "gmt")`); expect( Array.isArray( stmt.get({ - $date: new Date(new Date(1998, 8, 1, 0, 0, 0, 0).toUTCString()).toISOString(), + $date: "1998-09-01T07:00:00.000Z", }), ), ).toBe(false); - expect(stmt.toString()).toBe(`SELECT * FROM "Orders" WHERE OrderDate > date('1998-09-01T07:00:00.000Z')`); + expect(stmt.toString()).toBe(`SELECT * FROM "Orders" WHERE OrderDate > datetime('1998-09-01T07:00:00.000Z', "gmt")`); expect(stmt.paramsCount).toBe(1); expect(stmt.columnsCount).toBe(14); expect(stmt.columns.length).toBe(14); @@ -46,7 +46,7 @@ it("SQL.run works", () => { expect(typeof handle).toBe("number"); expect( - SQL.run(handle, 'SELECT * FROM "Orders" WHERE OrderDate > date($date)', { + SQL.run(handle, 'SELECT * FROM "Orders" WHERE OrderDate > datetime($date, "gmt")', { $date: new Date(1996, 8, 1).toISOString(), }), ).toBe(undefined); |