530
edits
Changes
Jump to navigation
Jump to search
mLine 2:
Line 2: − + − + − + − + − console.log("pn1"); − − Line 21:
Line 18: − Line 27:
Line 23: − + − + − console.log("Mark 2: " + inp_obj.name.first); − console.log("Mark 2: " + inp_obj.name.last + "..."); Line 44:
Line 38: − + Line 52:
Line 46: − console.log("pn2"); − − Line 64:
Line 55: − Line 71:
Line 61: + − + Line 86:
Line 77: − console.log("Mark 1..."); − + − + − + − − // Close the db when the transaction is done Line 105:
Line 93: − console.log("pn1"); − − Line 117:
Line 102: − Line 123:
Line 107: − + − + − + + + + + −
no edit summary
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){
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;
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;
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;
} else {
} else {
inp_obj = record;
inp_obj = record;
}
}
}
}
//|||||||||||||||||||||||||||||||||||||||||||||
tx.oncomplete = function() {
tx.oncomplete = function() {
db.close();
db.close();
function recordUpdate(pddbname, record, field, value){
function recordUpdate(pddbname, record, field, value){
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;
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
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;
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(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");
}
}
};
};
};
};
//||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
tx.oncomplete = function() {
tx.oncomplete = function() {
db.close();
db.close();
function recordCheck(pddbname, record){
function recordCheck(pddbname, record){
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;
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;
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();