User:Abel/experimental.js

From Wikibase Personal data
< User:Abel
Revision as of 00:07, 27 April 2019 by Abel (talk | contribs)
Jump to navigation Jump to search

Note: After saving, you may have to bypass your browser's cache to see the changes.

  • Firefox / Safari: Hold Shift while clicking Reload, or press either Ctrl-F5 or Ctrl-R (⌘-R on a Mac)
  • Google Chrome: Press Ctrl-Shift-R (⌘-Shift-R on a Mac)
  • Internet Explorer / Edge: Hold Ctrl while clicking Refresh, or press Ctrl-F5
  • Opera: Go to Menu → Settings (Opera → Preferences on a Mac) and then to Privacy & security → Clear browsing data → Cached images and files.
console.log("~");

var PersonalDataDataBaseName = "PDIO2";
var Pete = {id: 11345, name: {first: "Pete", last: "Rock"}, age: 52};

addRecord(PersonalDataDataBaseName, Pete);
recordUpdate(PersonalDataDataBaseName, Pete, 'phone', '+313855777');

function addRecord(pddbname, record){
  console.log("pn1");
  var pddb = window.indexedDB.open(pddbname, 3);

  pddb.addEventListener('error', (event) => {
    console.log('Request error:', pddb.error);
  }, false);

  pddb.onupgradeneeded = function() {
    var db = pddb.result;
    var store = db.createObjectStore(PersonalDataDataBaseName, {keyPath: "id"});
    var index = store.createIndex("NameIndex", ["name.last", "name.first"]);
  };

  pddb.onsuccess = function() {
    var db = pddb.result;
    var tx = db.transaction(PersonalDataDataBaseName, "readwrite");
    var store = tx.objectStore(PersonalDataDataBaseName);
    var index = store.index("NameIndex");  
  
    store.put(record);

    console.log("Mark 1: " + record.name.first);
    console.log("Mark 1: " + record.name.last);

    var recordcheck = index.get([record.name.last, record.name.first]);
    recordcheck.onsuccess = function() {
      console.log(recordcheck);
      console.log("Mark 1.1: " + recordcheck.result.phone);
    }

    tx.oncomplete = function() {
      db.close();
    };  
  };
};

function recordUpdate(pddbname, record, field, value){
  console.log("pn2");
  var pddb = window.indexedDB.open(pddbname, 3);

  pddb.addEventListener('error', (event) => {
    console.log('Request error:', pddb.error);
  }, false);

  pddb.onupgradeneeded = function() {
    var db = pddb.result;
    var store = db.createObjectStore(PersonalDataDataBaseName, {keyPath: "id"});
    var index = store.createIndex("NameIndex", ["name.last", "name.first"]);
  };

  pddb.onsuccess = function() {
        // Start a new transaction
        var db = pddb.result;
        var tx = db.transaction(PersonalDataDataBaseName, "readwrite");
        var store = tx.objectStore(PersonalDataDataBaseName);
        var index = store.index("NameIndex");

        var getRecord = index.get([record.name.last, record.name.first]);
        getRecord.onsuccess = function() {
          console.log("updating");
            dive(getRecord.result, field) = value;   // => "Bob"
            store.put(getRecord.result);

            getRecordAgain = index.get([record.name.last, record.name.first]);
            getRecordAgain.onsuccess = function() {
                console.log(getRecordAgain);   // => "Bob"
                if ( getRecordAgain.result.field == value ) { 
                  console.log("update succeeded");
                } else {
                  console.log("update unsuccessful");
                }
              };   
            };


      // Close the db when the transaction is done
      tx.oncomplete = function() {
        db.close();
      };
    };
  };

function indexinterpolate(obj,i) { return  (obj[i] != undefined) ? obj[i] : obj}; 

// helper function for checking a part of an array exists
function indexcheck(obj,i) {  return  (obj[i] != undefined) ? obj[i] : undefined };

// dive selects matrix.a.b.c.d from the array called matrix and 'a.b.c.d' as string
// if a.b.c.d does not exists, it returns the substructure until the substructure exists, if d does not exist, it returns matrix.a.b.c e.g.

function dive(array, read){
	return read.split('.').reduce(indexinterpolate, array);
}

function check(array, read){
	return read.split('.').reduce(indexcheck, array);
}