idb: add first web platform tests, fix issues detected by them

4 files changed, 270 insertions, 0 deletions

diff --git a/packages/idb-bridge/src/idb-wpt-ported/README b/packages/idb-bridge/src/idb-wpt-ported/README
new file mode 100644
index 000000000..e0b665aab
--- /dev/null
+++ b/packages/idb-bridge/src/idb-wpt-ported/README
@@ -0,0 +1,3 @@
+This directory contains test cases from the W3C Web Platform Tests suite for IndexedDB.
+
+The original code for these tests can be found here: https://github.com/web-platform-tests/wpt/tree/master/IndexedDB
\ No newline at end of file
diff --git a/packages/idb-bridge/src/idb-wpt-ported/keypath.test.ts b/packages/idb-bridge/src/idb-wpt-ported/keypath.test.ts
new file mode 100644
index 000000000..61e416a53
--- /dev/null
+++ b/packages/idb-bridge/src/idb-wpt-ported/keypath.test.ts
@@ -0,0 +1,191 @@
+import test from "ava";
+import { assert_key_equals, createdb } from "./wptsupport";
+
+test("WPT test keypath.htm", async (t) => {
+  function keypath(
+    keypath: any,
+    objects: any[],
+    expected_keys: any[],
+    desc?: string,
+  ) {
+    return new Promise<void>((resolve, reject) => {
+      console.log("key path", keypath);
+      console.log("checking", desc);
+      let db: any;
+      const store_name = "store-" + Date.now() + Math.random();
+
+      var open_rq = createdb(t);
+      open_rq.onupgradeneeded = function (e) {
+        db = (e.target as any).result;
+        var objStore = db.createObjectStore(store_name, { keyPath: keypath });
+
+        for (var i = 0; i < objects.length; i++) objStore.add(objects[i]);
+      };
+
+      open_rq.onsuccess = function (e) {
+        var actual_keys: any[] = [],
+          rq = db.transaction(store_name).objectStore(store_name).openCursor();
+
+        rq.onsuccess = (e: any) => {
+          var cursor = e.target.result;
+
+          if (cursor) {
+            actual_keys.push(cursor.key.valueOf());
+            cursor.continue();
+          } else {
+            assert_key_equals(actual_keys, expected_keys, "keyorder array");
+            resolve();
+          }
+        };
+      };
+    });
+  }
+
+  await keypath("my.key", [{ my: { key: 10 } }], [10]);
+
+  await keypath("my.køi", [{ my: { køi: 5 } }], [5]);
+
+  await keypath("my.key_ya", [{ my: { key_ya: 10 } }], [10]);
+
+  await keypath("public.key$ya", [{ public: { key$ya: 10 } }], [10]);
+
+  await keypath("true.$", [{ true: { $: 10 } }], [10]);
+
+  await keypath("my._", [{ my: { _: 10 } }], [10]);
+
+  await keypath("delete.a7", [{ delete: { a7: 10 } }], [10]);
+
+  await keypath(
+    "p.p.p.p.p.p.p.p.p.p.p.p.p.p",
+    [
+      {
+        p: {
+          p: {
+            p: {
+              p: {
+                p: {
+                  p: { p: { p: { p: { p: { p: { p: { p: { p: 10 } } } } } } } },
+                },
+              },
+            },
+          },
+        },
+      },
+    ],
+    [10],
+  );
+
+  await keypath(
+    "str.length",
+    [{ str: "pony" }, { str: "my" }, { str: "little" }, { str: "" }],
+    [0, 2, 4, 6],
+  );
+
+  await keypath(
+    "arr.length",
+    [
+      { arr: [0, 0, 0, 0] },
+      { arr: [{}, 0, "hei", "length", Infinity, []] },
+      { arr: [10, 10] },
+      { arr: [] },
+    ],
+    [0, 2, 4, 6],
+  );
+
+  await keypath("length", [[10, 10], "123", { length: 20 }], [2, 3, 20]);
+
+  await keypath(
+    "",
+    [["bags"], "bean", 10],
+    [10, "bean", ["bags"]],
+    "'' uses value as key",
+  );
+
+  await keypath(
+    [""],
+    [["bags"], "bean", 10],
+    [[10], ["bean"], [["bags"]]],
+    "[''] uses value as [key]",
+  );
+
+  await keypath(
+    ["x", "y"],
+    [
+      { x: 10, y: 20 },
+      { y: 1.337, x: 100 },
+    ],
+    [
+      [10, 20],
+      [100, 1.337],
+    ],
+    "['x', 'y']",
+  );
+
+  await keypath(
+    [["x"], ["y"]],
+    [
+      { x: 10, y: 20 },
+      { y: 1.337, x: 100 },
+    ],
+    [
+      [10, 20],
+      [100, 1.337],
+    ],
+    "[['x'], 'y'] (stringifies)",
+  );
+
+  await keypath(
+    [
+      "x",
+      {
+        toString: function () {
+          return "y";
+        },
+      },
+    ],
+    [
+      { x: 10, y: 20 },
+      { y: 1.337, x: 100 },
+    ],
+    [
+      [10, 20],
+      [100, 1.337],
+    ],
+    "['x', {toString->'y'}] (stringifies)",
+  );
+
+  await keypath(
+    ["name", "type"],
+    [
+      { name: "orange", type: "fruit" },
+      { name: "orange", type: ["telecom", "french"] },
+    ],
+    [
+      ["orange", "fruit"],
+      ["orange", ["telecom", "french"]],
+    ],
+  );
+
+  await keypath(
+    ["name", "type.name"],
+    [
+      { name: "orange", type: { name: "fruit" } },
+      { name: "orange", type: { name: "telecom" } },
+    ],
+    [
+      ["orange", "fruit"],
+      ["orange", "telecom"],
+    ],
+  );
+
+  const loop_array: any[] = [];
+  loop_array.push(loop_array);
+  await keypath(
+    loop_array,
+    ["a", 1, ["k"]],
+    [[1], ["a"], [["k"]]],
+    "array loop -> stringify becomes ['']",
+  );
+
+  t.pass();
+});
diff --git a/packages/idb-bridge/src/idb-wpt-ported/value.test.ts b/packages/idb-bridge/src/idb-wpt-ported/value.test.ts
new file mode 100644
index 000000000..c4a8315c6
--- /dev/null
+++ b/packages/idb-bridge/src/idb-wpt-ported/value.test.ts
@@ -0,0 +1,46 @@
+import test from "ava";
+import { IDBVersionChangeEvent } from "../idbtypes";
+import { createdb } from "./wptsupport";
+
+test.cb("WPT test value.htm, array", (t) => {
+  const value = new Array();
+  const _instanceof = Array;
+
+  t.plan(1);
+
+  createdb(t).onupgradeneeded = function (e: IDBVersionChangeEvent) {
+    (e.target as any).result.createObjectStore("store").add(value, 1);
+    (e.target as any).onsuccess = (e: any) => {
+      console.log("in first onsuccess");
+      e.target.result
+        .transaction("store")
+        .objectStore("store")
+        .get(1).onsuccess = (e: any) => {
+        t.assert(e.target.result instanceof _instanceof, "instanceof");
+        t.end();
+      };
+    };
+  };
+});
+
+test.cb("WPT test value.htm, date", (t) => {
+    const value = new Date();
+    const _instanceof = Date;
+  
+    t.plan(1);
+  
+    createdb(t).onupgradeneeded = function (e: IDBVersionChangeEvent) {
+      (e.target as any).result.createObjectStore("store").add(value, 1);
+      (e.target as any).onsuccess = (e: any) => {
+        console.log("in first onsuccess");
+        e.target.result
+          .transaction("store")
+          .objectStore("store")
+          .get(1).onsuccess = (e: any) => {
+          t.assert(e.target.result instanceof _instanceof, "instanceof");
+          t.end();
+        };
+      };
+    };
+  });
+  
\ No newline at end of file
diff --git a/packages/idb-bridge/src/idb-wpt-ported/wptsupport.ts b/packages/idb-bridge/src/idb-wpt-ported/wptsupport.ts
new file mode 100644
index 000000000..10c11b7a6
--- /dev/null
+++ b/packages/idb-bridge/src/idb-wpt-ported/wptsupport.ts
@@ -0,0 +1,30 @@
+import { ExecutionContext } from "ava";
+import { BridgeIDBFactory } from "..";
+import { IDBOpenDBRequest } from "../idbtypes";
+import MemoryBackend from "../MemoryBackend";
+import compareKeys from "../util/cmp";
+
+BridgeIDBFactory.enableTracing = true;
+const idbFactory = new BridgeIDBFactory(new MemoryBackend());
+
+const self = {
+  indexedDB: idbFactory,
+};
+
+export function createdb(
+  t: ExecutionContext<unknown>,
+  dbname?: string,
+  version?: number,
+): IDBOpenDBRequest {
+  var rq_open: IDBOpenDBRequest;
+  dbname = dbname ? dbname : "testdb-" + new Date().getTime() + Math.random();
+  if (version) rq_open = self.indexedDB.open(dbname, version);
+  else rq_open = self.indexedDB.open(dbname);
+  return rq_open;
+}
+
+export function assert_key_equals(actual: any, expected: any, description?: string) {
+  if (0 != compareKeys(actual, expected)) {
+    throw Error("expected keys to be the same");
+  }
+}