| 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(); |
| | + | }; |
| | + | }; |
| | + | }; |