Line 2: |
Line 2: |
| | | |
| var PersonalDataDataBaseName = "PDIO2"; | | var PersonalDataDataBaseName = "PDIO2"; |
− | var Pete = {id: 11345, name: {first: "Pete", last: "Rock"}, age: 52}; | + | var Jonathan = {id: 11345, name: {first: "Jonatha", last: "Lemmings"}, age: 32}; |
| | | |
− | recordAdd(PersonalDataDataBaseName, Pete); | + | recordAdd(PersonalDataDataBaseName, Jonathan); |
− | recordUpdate(PersonalDataDataBaseName, Pete, 'phone', '+313851777'); | + | recordUpdate(PersonalDataDataBaseName, Jonathan, 'phone', '+313851777'); |
− | recordCheck(PersonalDataDataBaseName, Pete); | + | recordCheck(PersonalDataDataBaseName, Jonathan); |
| | | |
| function recordAdd(pddbname, record){ | | function recordAdd(pddbname, record){ |
− | console.log("pn1");
| |
| var pddb = window.indexedDB.open(pddbname, 3); | | var pddb = window.indexedDB.open(pddbname, 3); |
− |
| |
| pddb.addEventListener('error', (event) => { | | pddb.addEventListener('error', (event) => { |
| console.log('Request error:', pddb.error); | | console.log('Request error:', pddb.error); |
| }, false); | | }, false); |
− |
| |
| pddb.onupgradeneeded = function() { | | pddb.onupgradeneeded = function() { |
| var db = pddb.result; | | var db = pddb.result; |
Line 21: |
Line 18: |
| var index = store.createIndex("NameIndex", ["name.last", "name.first"]); | | var index = store.createIndex("NameIndex", ["name.last", "name.first"]); |
| }; | | }; |
− |
| |
| pddb.onsuccess = function() { | | pddb.onsuccess = function() { |
| var db = pddb.result; | | var db = pddb.result; |
Line 27: |
Line 23: |
| var store = tx.objectStore(PersonalDataDataBaseName); | | var store = tx.objectStore(PersonalDataDataBaseName); |
| var index = store.index("NameIndex"); | | var index = store.index("NameIndex"); |
− | | + | //||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||[ Essential recordAdd ]|||||||||||||||||||||||||||||| |
| var getRecord = index.get([record.name.last, record.name.first]); | | var getRecord = index.get([record.name.last, record.name.first]); |
| getRecord.onsuccess = function() { | | getRecord.onsuccess = function() { |
− | if (getRecord != undefined) { | + | if (getRecord.result != undefined) { |
| console.log("updating"); | | console.log("updating"); |
| inp_obj = getRecord.result; | | inp_obj = getRecord.result; |
− | console.log("Mark 2: " + inp_obj.name.first);
| |
− | console.log("Mark 2: " + inp_obj.name.last + "...");
| |
| } else { | | } else { |
| inp_obj = record; | | inp_obj = record; |
Line 44: |
Line 38: |
| } | | } |
| } | | } |
− | | + | //||||||||||||||||||||||||||||||||||||||||||||| |
| tx.oncomplete = function() { | | tx.oncomplete = function() { |
| db.close(); | | db.close(); |
Line 52: |
Line 46: |
| | | |
| function recordUpdate(pddbname, record, field, value){ | | function recordUpdate(pddbname, record, field, value){ |
− | console.log("pn2");
| |
| var pddb = window.indexedDB.open(pddbname, 3); | | var pddb = window.indexedDB.open(pddbname, 3); |
− |
| |
| pddb.addEventListener('error', (event) => { | | pddb.addEventListener('error', (event) => { |
| console.log('Request error:', pddb.error); | | console.log('Request error:', pddb.error); |
| }, false); | | }, false); |
− |
| |
| pddb.onupgradeneeded = function() { | | pddb.onupgradeneeded = function() { |
| var db = pddb.result; | | var db = pddb.result; |
Line 64: |
Line 55: |
| var index = store.createIndex("NameIndex", ["name.last", "name.first"]); | | var index = store.createIndex("NameIndex", ["name.last", "name.first"]); |
| }; | | }; |
− |
| |
| pddb.onsuccess = function() { | | pddb.onsuccess = function() { |
| // Start a new transaction | | // Start a new transaction |
Line 71: |
Line 61: |
| var store = tx.objectStore(PersonalDataDataBaseName); | | var store = tx.objectStore(PersonalDataDataBaseName); |
| var index = store.index("NameIndex"); | | var index = store.index("NameIndex"); |
| + | //||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||[ Essential recordUpdate ]|||||||||||||||||||||||||||||| |
| var inp_obj; | | var inp_obj; |
| var getRecord = index.get([record.name.last, record.name.first]); | | var getRecord = index.get([record.name.last, record.name.first]); |
| getRecord.onsuccess = function() { | | getRecord.onsuccess = function() { |
− | if( getRecord != undefined ) { | + | if( getRecord.result != undefined ) { |
| console.log("updating"); | | console.log("updating"); |
| inp_obj = getRecord.result; | | inp_obj = getRecord.result; |
Line 86: |
Line 77: |
| getRecordAgain = index.get([record.name.last, record.name.first]); | | getRecordAgain = index.get([record.name.last, record.name.first]); |
| getRecordAgain.onsuccess = function() { | | getRecordAgain.onsuccess = function() { |
− | console.log("Mark 1...");
| |
| console.log(getRecordAgain); // => "Bob" | | console.log(getRecordAgain); // => "Bob" |
| if ( getRecordAgain.result[field] == value ) { | | if ( getRecordAgain.result[field] == value ) { |
− | console.log("update succeeded"); | + | console.log("Update succeeded"); |
| } else { | | } else { |
− | console.log("update unsuccessful"); | + | console.log("Update unsuccessful"); |
| } | | } |
| }; | | }; |
| }; | | }; |
− | | + | //|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| |
− | | |
− | // Close the db when the transaction is done
| |
| tx.oncomplete = function() { | | tx.oncomplete = function() { |
| db.close(); | | db.close(); |
Line 105: |
Line 93: |
| | | |
| function recordCheck(pddbname, record){ | | function recordCheck(pddbname, record){ |
− | console.log("pn1");
| |
| var pddb = window.indexedDB.open(pddbname, 3); | | var pddb = window.indexedDB.open(pddbname, 3); |
− |
| |
| pddb.addEventListener('error', (event) => { | | pddb.addEventListener('error', (event) => { |
| console.log('Request error:', pddb.error); | | console.log('Request error:', pddb.error); |
| }, false); | | }, false); |
− |
| |
| pddb.onupgradeneeded = function() { | | pddb.onupgradeneeded = function() { |
| var db = pddb.result; | | var db = pddb.result; |
Line 117: |
Line 102: |
| var index = store.createIndex("NameIndex", ["name.last", "name.first"]); | | var index = store.createIndex("NameIndex", ["name.last", "name.first"]); |
| }; | | }; |
− |
| |
| pddb.onsuccess = function() { | | pddb.onsuccess = function() { |
| var db = pddb.result; | | var db = pddb.result; |
Line 123: |
Line 107: |
| var store = tx.objectStore(PersonalDataDataBaseName); | | var store = tx.objectStore(PersonalDataDataBaseName); |
| var index = store.index("NameIndex"); | | var index = store.index("NameIndex"); |
− |
| + | //||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||[ Essential recordCheck ]|||||||||||||| |
| var recordcheck = index.get([record.name.last, record.name.first]); | | var recordcheck = index.get([record.name.last, record.name.first]); |
| recordcheck.onsuccess = function() { | | recordcheck.onsuccess = function() { |
− | console.log(recordcheck); | + | if ( recordcheck.result != undefined ) { |
− | console.log("...Mark 0"); | + | console.log(recordcheck); |
| + | } else { |
| + | console.log("...else undefined"); |
| + | } |
| + | //|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| |
| } | | } |
− |
| |
| tx.oncomplete = function() { | | tx.oncomplete = function() { |
| db.close(); | | db.close(); |