User:Abel/experimental.js

console.log("~");

var PersonalDataDataBaseName = "PDIO2";
var Jonathan = {id: 11345, name: {first: "Jonatha", last: "Lemmings"}, age: 32};

recordAdd(PersonalDataDataBaseName, Jonathan);
recordUpdate(PersonalDataDataBaseName, Jonathan, 'phone', '+313851777');
recordCheck(PersonalDataDataBaseName, Jonathan);

function recordAdd(pddbname, record){
  var pddb = window.indexedDB.open(pddbname, 3);
  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");  
//||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||[  Essential recordAdd  ]||||||||||||||||||||||||||||||
    var getRecord = index.get([record.name.last, record.name.first]);
    getRecord.onsuccess = function() {
        if (getRecord.result != undefined) {
            console.log("updating");
            inp_obj = getRecord.result;
        } else {
          inp_obj = record;
          store.put(inp_obj);
        }
        var sanitycheck = index.get([inp_obj.name.last, inp_obj.name.first]);
        sanitycheck.onsuccess = function() {
            console.log(sanitycheck);
        }
    }
    //|||||||||||||||||||||||||||||||||||||||||||||
    tx.oncomplete = function() {
      db.close();
    };  
  };
};

function recordUpdate(pddbname, record, field, value){
  var pddb = window.indexedDB.open(pddbname, 3);
  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");
//||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||[  Essential recordUpdate  ]||||||||||||||||||||||||||||||
        var inp_obj;
        var getRecord = index.get([record.name.last, record.name.first]);
        getRecord.onsuccess = function() {
            if( getRecord.result != undefined ) {
               console.log("updating");
               inp_obj = getRecord.result; 
            } else {
               inp_obj = record;
            }

            inp_obj[field] = value;   // => "Bob"
            store.put(inp_obj);

            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");
                }
              };   
            };
//||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
      tx.oncomplete = function() {
        db.close();
      };
    };
  };

function recordCheck(pddbname, record){
  var pddb = window.indexedDB.open(pddbname, 3);
  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");  
//||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||[ Essential recordCheck ]||||||||||||||
    var recordcheck = index.get([record.name.last, record.name.first]);
    recordcheck.onsuccess = function() {
      if ( recordcheck.result != undefined ) {
         console.log(recordcheck);
      } else {
         console.log("...else undefined");
      }
//||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
    }
    tx.oncomplete = function() {
      db.close();
    };  
  };
};