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