Changes

Jump to navigation Jump to search
m
no edit summary
Line 1: Line 1:  
console.log("~");
 
console.log("~");
 +
 +
var PersonalDataDataBaseName = "PDIO2";
 +
var Pete = {id: 11345, name: {first: "Pete", last: "Rock"}, age: 52};
 +
 +
addRecord(PersonalDataDataBaseName, Pete, function() {
 +
  recordUpdate(PersonalDataDataBaseName, Pete, 'phone', '+313555777');
 +
});
 +
 +
 +
function addRecord(pddbname, record){
 +
  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("PDIO2", {keyPath: "id"});
 +
    var index = store.createIndex("NameIndex", ["name.last", "name.first"]);
 +
  };
 +
 +
  pddb.onsuccess = function() {
 +
    var db = pddb.result;
 +
    var tx = db.transaction("PDIO2", "readwrite");
 +
    var store = tx.objectStore("PDIO2");
 +
    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.first, record.name.last]);
 +
    recordcheck.onsuccess = function() {
 +
      console.log(recordcheck);
 +
    }
 +
 +
    tx.oncomplete = function() {
 +
      db.close();
 +
    }; 
 +
  };
 +
};
 +
 +
function recordUpdate(pddbname, record, field, value){
 +
 +
  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("PDIO2", {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("PDIO2", "readwrite");
 +
        var store = tx.objectStore("PDIO2");
 +
        var index = store.index("NameIndex");
 +
 +
        var getRecord = index.get([record.name.first, record.name.last]);
 +
        getRecord.onsuccess = function() {
 +
          console.log("updating");
 +
            getRecord.result.field = value;  // => "Bob"
 +
            store.put(getRecord.result);
 +
 +
            getRecordAgain = index.get([record.name.first, record.name.last]);
 +
            getRecordAgain.onsuccess = function() {
 +
                console.log("hey there" + 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();
 +
      };
 +
    };
 +
  };
530

edits

Navigation menu