IndexedDB/idbobjectstore_add.any.js

// META: global=window,worker
// META: title=IDBObjectStore.add()
// META: script=resources/support.js
// @author Microsoft <https://www.microsoft.com>
// @author Intel <http://www.intel.com>
'use strict';


async_test(t => {
    let db;
    const record = { key: 1, property: "data" };

    const open_rq = createdb(t);
    open_rq.onupgradeneeded = function(e) {
      db = e.target.result;
      const objStore = db.createObjectStore("store", { keyPath: "key" });

      objStore.add(record);
    };

    open_rq.onsuccess = function(e) {
      const rq = db.transaction("store", "readonly")
        .objectStore("store")
        .get(record.key);

      rq.onsuccess = t.step_func(function(e) {
        assert_equals(e.target.result.property, record.property);
        assert_equals(e.target.result.key, record.key);
        t.done();
      });
    };
}, 'add() with an inline key');

async_test(t => {
    let db;
    const key = 1;
    const record = { property: "data" };

    const open_rq = createdb(t);
    open_rq.onupgradeneeded = function(e) {
      db = e.target.result;
      const objStore = db.createObjectStore("store");

      objStore.add(record, key);
    };

    open_rq.onsuccess = function(e) {
      const rq = db.transaction("store", "readonly")
        .objectStore("store")
        .get(key);

      rq.onsuccess = t.step_func(function(e) {
        assert_equals(e.target.result.property, record.property);

        t.done();
      });
    };
}, 'add() with an out-of-line key');

async_test(t => {
    const record = { key: 1, property: "data" };

    const open_rq = createdb(t);
    open_rq.onupgradeneeded = function(e) {
      let db = e.target.result;
      const objStore = db.createObjectStore("store", { keyPath: "key" });
      objStore.add(record);

      const rq = objStore.add(record);
      rq.onsuccess = fail(t, "success on adding duplicate record");

      rq.onerror = t.step_func(function(e) {
        assert_equals(e.target.error.name, "ConstraintError");
        assert_equals(rq.error.name, "ConstraintError");
        assert_equals(e.type, "error");

        e.preventDefault();
        e.stopPropagation();
      });
    };

    // Defer done, giving rq.onsuccess a chance to run
    open_rq.onsuccess = function(e) {
      t.done();
    };
}, 'add() record with same key already exists');

async_test(t => {
    const record = { key: 1, property: "data" };

    const open_rq = createdb(t);
    open_rq.onupgradeneeded = function(e) {
      let db = e.target.result;
      const objStore = db.createObjectStore("store", { autoIncrement: true });
      objStore.createIndex("i1", "property", { unique: true });
      objStore.add(record);

      const rq = objStore.add(record);
      rq.onsuccess = fail(t, "success on adding duplicate indexed record");

      rq.onerror = t.step_func(function(e) {
        assert_equals(rq.error.name, "ConstraintError");
        assert_equals(e.target.error.name, "ConstraintError");
        assert_equals(e.type, "error");

        e.preventDefault();
        e.stopPropagation();
      });
    };

    // Defer done, giving a spurious rq.onsuccess a chance to run
    open_rq.onsuccess = function(e) {
      t.done();
    };
}, 'add() where an index has unique:true specified');

async_test(t => {
    let db;
    const record = { test: { obj: { key: 1 } }, property: "data" };

    const open_rq = createdb(t);
    open_rq.onupgradeneeded = function(e) {
      db = e.target.result;
      const objStore = db.createObjectStore("store",
        { keyPath: "test.obj.key" });
      objStore.add(record);
    };

    open_rq.onsuccess = function(e) {
      const rq = db.transaction("store", "readonly")
        .objectStore("store")
        .get(record.test.obj.key);

      rq.onsuccess = t.step_func(function(e) {
        assert_equals(e.target.result.property, record.property);

        t.done();
      });
    };
}, 'add() object store\'s key path is an object attribute');

async_test(t => {
    let db;
    const record = { property: "data" };
    const expected_keys = [1, 2, 3, 4];

    const open_rq = createdb(t);
    open_rq.onupgradeneeded = function(e) {
      db = e.target.result;
      const objStore = db.createObjectStore("store", { keyPath: "key",
       autoIncrement: true });

      objStore.add(record);
      objStore.add(record);
      objStore.add(record);
      objStore.add(record);
    };

    open_rq.onsuccess = function(e) {
      const actual_keys = [];
      const rq = db.transaction("store", "readonly")
        .objectStore("store")
        .openCursor();

      rq.onsuccess = t.step_func(function(e) {
        const cursor = e.target.result;

        if (cursor) {
          actual_keys.push(cursor.value.key);
          cursor.continue();
        } else {
          assert_array_equals(actual_keys, expected_keys);
          t.done();
        }
      });
    };
}, 'add() autoIncrement and inline keys');

async_test(t => {
    let db;
    const record = { property: "data" };
    const expected_keys = [1, 2, 3, 4];

    const open_rq = createdb(t);
    open_rq.onupgradeneeded = function(e) {
      db = e.target.result;
      const objStore = db.createObjectStore("store", { autoIncrement: true });

      objStore.add(record);
      objStore.add(record);
      objStore.add(record);
      objStore.add(record);
    };

    open_rq.onsuccess = function(e) {
      const actual_keys = [];
      const rq = db.transaction("store", "readonly")
        .objectStore("store")
        .openCursor();

      rq.onsuccess = t.step_func(function(e) {
        const cursor = e.target.result;

        if (cursor) {
          actual_keys.push(cursor.key);
          cursor.continue();
        } else {
          assert_array_equals(actual_keys, expected_keys);
          t.done();
        }
      });
    };
}, 'add() autoIncrement and out-of-line keys');

async_test(t => {
    let db;
    const record = { property: "data" };
    const expected_keys = [1, 2, 3, 4];

    const open_rq = createdb(t);
    open_rq.onupgradeneeded = function(e) {
      db = e.target.result;
      const objStore = db.createObjectStore("store", { keyPath: "test.obj.key",
        autoIncrement: true });

      objStore.add(record);
      objStore.add(record);
      objStore.add(record);
      objStore.add(record);
    };

    open_rq.onsuccess = function(e) {
      const actual_keys = [];
      const rq = db.transaction("store", "readonly")
        .objectStore("store")
        .openCursor();

      rq.onsuccess = t.step_func(function(e) {
        const cursor = e.target.result;

        if (cursor) {
          actual_keys.push(cursor.value.test.obj.key);
          cursor.continue();
        } else {
          assert_array_equals(actual_keys, expected_keys);
          t.done();
        }
      });
    };
}, 'Object store has autoIncrement:true and the key path is an object \
attribute');

async_test(t => {
    const record = { key: 1, property: "data" };

    const open_rq = createdb(t);
    open_rq.onupgradeneeded = function(e) {
      let rq;
      const db = e.target.result;
      const objStore = db.createObjectStore("store", { keyPath: "key" });

      assert_throws_dom("DataError", function() {
        rq = objStore.add(record, 1);
      });

      assert_equals(rq, undefined);
      t.done();
    };
  }, 'Attempt to \'add()\' a record that does not meet the constraints of an \
  object store\'s inline key requirements');

async_test(t => {
    const record = { property: "data" };

    const open_rq = createdb(t);
    open_rq.onupgradeneeded = function(e) {
      let db = e.target.result;
      let rq;
      const objStore = db.createObjectStore("store");

      assert_throws_dom("DataError", function() {
        rq = objStore.add(record);
      });

      assert_equals(rq, undefined);
      t.done();
    };
}, 'Attempt to call \'add()\' without a key parameter when the object store \
uses out-of-line keys');

async_test(t => {
    const record = { key: { value: 1 }, property: "data" };

    const open_rq = createdb(t);
    open_rq.onupgradeneeded = function(e) {
      let db = e.target.result;

      let rq;
      const objStore = db.createObjectStore("store", { keyPath: "key" });

      assert_throws_dom("DataError", function() {
        rq = objStore.add(record);
      });

      assert_equals(rq, undefined);
      t.done();
    };
}, 'Attempt to \'add()\' a record where the record\'s key does not meet the \
constraints of a valid key');

async_test(t => {
    const record = { property: "data" };

    const open_rq = createdb(t);
    open_rq.onupgradeneeded = function(e) {
      let db = e.target.result;

      let rq;
      const objStore = db.createObjectStore("store", { keyPath: "key" });

      assert_throws_dom("DataError", function() {
        rq = objStore.add(record);
      });

      assert_equals(rq, undefined);
      t.done();
    };
}, 'Attempt to \'add()\' a record where the record\'s in-line key is not \
 defined');

async_test(t => {
    const record = { property: "data" };

    const open_rq = createdb(t);
    open_rq.onupgradeneeded = function(e) {
      let db = e.target.result;

      let rq;
      const objStore = db.createObjectStore("store");

      assert_throws_dom("DataError", function() {
        rq = objStore.add(record, { value: 1 });
      });

      assert_equals(rq, undefined);
      t.done();
    };
}, 'Attempt to \'add()\' a record where the out of line key provided does not \
meet the constraints of a valid key');

async_test(t => {
    const record = { key: 1, indexedProperty: { property: "data" } };

    const open_rq = createdb(t);
    open_rq.onupgradeneeded = function(e) {
      let db = e.target.result;

      let rq;
      const objStore = db.createObjectStore("store", { keyPath: "key" });

      objStore.createIndex("index", "indexedProperty");

      rq = objStore.add(record);

      assert_true(rq instanceof IDBRequest);
      rq.onsuccess = function() {
          t.done();
      }
    };
}, 'add() a record where a value being indexed does not meet the constraints \
of a valid key');

async_test(t => {
    let db;

    const open_rq = createdb(t);
    open_rq.onupgradeneeded = function (event) {
        db = event.target.result;
        db.createObjectStore("store", {keyPath: "pKey"});
    }

    open_rq.onsuccess = function (event) {
        const txn = db.transaction("store", "readonly");
        const ostore = txn.objectStore("store");
        t.step(function() {
            assert_throws_dom("ReadOnlyError", function() {
                ostore.add({pKey: "primaryKey_0"});
            });
        });
        t.done();
    }
}, 'If the transaction this IDBObjectStore belongs to has its mode set to \
readonly, throw ReadOnlyError');

async_test(t => {
    const open_rq = createdb(t);
    open_rq.onupgradeneeded = function (event) {
        let db = event.target.result;
        const ostore = db.createObjectStore("store", {keyPath: "pKey"});
        db.deleteObjectStore("store");
        assert_throws_dom("InvalidStateError", function() {
            ostore.add({pKey: "primaryKey_0"});
        });
        t.done();
    };
}, 'If the object store has been deleted, the implementation must throw a \
DOMException of type InvalidStateError');