From 65affacc5092e050b233b1b83e7aab1636a728e4 Mon Sep 17 00:00:00 2001
From: Jarred Sumner <709451+Jarred-Sumner@users.noreply.github.com>
Date: Tue, 6 Sep 2022 21:00:56 -0700
Subject: Fix missing file in SQL-raw test

---
 test/bun.js/sql-raw.test.js | 17 +++++++++--------
 1 file changed, 9 insertions(+), 8 deletions(-)

(limited to 'test/bun.js/sql-raw.test.js')

diff --git a/test/bun.js/sql-raw.test.js b/test/bun.js/sql-raw.test.js
index ea7f72bd6..e4dd1db82 100644
--- a/test/bun.js/sql-raw.test.js
+++ b/test/bun.js/sql-raw.test.js
@@ -1,16 +1,17 @@
 import { expect, it } from "bun:test";
 
 var SQL = globalThis[Symbol.for("Bun.lazy")]("sqlite");
+const dbPath = import.meta.dir + "/northwind.testdb";
 
 it("works", () => {
-  const handle = SQL.open("/tmp/northwind.sqlite");
+  const handle = SQL.open(dbPath);
 
   const stmt = SQL.prepare(
     handle,
-    'SELECT * FROM "Order" WHERE OrderDate > date($date)'
+    'SELECT * FROM "Orders" WHERE OrderDate > date($date)'
   );
   expect(stmt.toString()).toBe(
-    `SELECT * FROM "Order" WHERE OrderDate > date(NULL)`
+    `SELECT * FROM "Orders" WHERE OrderDate > date(NULL)`
   );
 
   expect(
@@ -24,7 +25,7 @@ it("works", () => {
     )
   ).toBe(true);
   expect(stmt.toString()).toBe(
-    `SELECT * FROM "Order" WHERE OrderDate > date('1996-09-01T07:00:00.000Z')`
+    `SELECT * FROM "Orders" WHERE OrderDate > date('1996-09-01T07:00:00.000Z')`
   );
 
   var ran = stmt.run({
@@ -35,7 +36,7 @@ it("works", () => {
   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')`
+    `SELECT * FROM "Orders" WHERE OrderDate > date('1997-09-01T07:00:00.000Z')`
   );
 
   expect(
@@ -48,7 +49,7 @@ it("works", () => {
     )
   ).toBe(false);
   expect(stmt.toString()).toBe(
-    `SELECT * FROM "Order" WHERE OrderDate > date('1998-09-01T07:00:00.000Z')`
+    `SELECT * FROM "Orders" WHERE OrderDate > date('1998-09-01T07:00:00.000Z')`
   );
   expect(stmt.paramsCount).toBe(1);
   expect(stmt.columnsCount).toBe(14);
@@ -58,11 +59,11 @@ it("works", () => {
 });
 
 it("SQL.run works", () => {
-  const handle = SQL.open("/tmp/northwind.sqlite");
+  const handle = SQL.open(dbPath);
   expect(typeof handle).toBe("number");
 
   expect(
-    SQL.run(handle, 'SELECT * FROM "Order" WHERE OrderDate > date($date)', {
+    SQL.run(handle, 'SELECT * FROM "Orders" WHERE OrderDate > date($date)', {
       $date: new Date(1996, 8, 1).toISOString(),
     })
   ).toBe(undefined);
-- 
cgit v1.2.3