Difference between revisions of "User:Abel/experimental.js"
Jump to navigation
Jump to search
m |
m |
||
Line 2: | Line 2: | ||
var PersonalDataDataBaseName = "PDIO2"; | var PersonalDataDataBaseName = "PDIO2"; | ||
− | var | + | var Jonathan = {id: 11345, name: {first: "Jonatha", last: "Lemmings"}, age: 32}; |
− | recordAdd(PersonalDataDataBaseName, | + | recordAdd(PersonalDataDataBaseName, Jonathan); |
− | recordUpdate(PersonalDataDataBaseName, | + | recordUpdate(PersonalDataDataBaseName, Jonathan, 'phone', '+313851777'); |
− | recordCheck(PersonalDataDataBaseName, | + | 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; | ||
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; | ||
− | |||
− | |||
} 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){ | ||
− | |||
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(getRecordAgain); // => "Bob" | console.log(getRecordAgain); // => "Bob" | ||
if ( getRecordAgain.result[field] == value ) { | if ( getRecordAgain.result[field] == value ) { | ||
− | console.log(" | + | console.log("Update succeeded"); |
} else { | } else { | ||
− | console.log(" | + | console.log("Update unsuccessful"); |
} | } | ||
}; | }; | ||
}; | }; | ||
− | + | //|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| | |
− | |||
− | |||
tx.oncomplete = function() { | tx.oncomplete = function() { | ||
db.close(); | db.close(); | ||
Line 105: | Line 93: | ||
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; | ||
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("... | + | console.log(recordcheck); |
+ | } else { | ||
+ | console.log("...else undefined"); | ||
+ | } | ||
+ | //|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| | ||
} | } | ||
− | |||
tx.oncomplete = function() { | tx.oncomplete = function() { | ||
db.close(); | db.close(); |
Revision as of 02:54, 27 April 2019
console.log("~");
var PersonalDataDataBaseName = "PDIO2";
var Jonathan = {id: 11345, name: {first: "Jonatha", last: "Lemmings"}, age: 32};
recordAdd(PersonalDataDataBaseName, Jonathan);
recordUpdate(PersonalDataDataBaseName, Jonathan, 'phone', '+313851777');
recordCheck(PersonalDataDataBaseName, Jonathan);
function recordAdd(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(PersonalDataDataBaseName, {keyPath: "id"});
var index = store.createIndex("NameIndex", ["name.last", "name.first"]);
};
pddb.onsuccess = function() {
var db = pddb.result;
var tx = db.transaction(PersonalDataDataBaseName, "readwrite");
var store = tx.objectStore(PersonalDataDataBaseName);
var index = store.index("NameIndex");
//||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||[ Essential recordAdd ]||||||||||||||||||||||||||||||
var getRecord = index.get([record.name.last, record.name.first]);
getRecord.onsuccess = function() {
if (getRecord.result != undefined) {
console.log("updating");
inp_obj = getRecord.result;
} else {
inp_obj = record;
store.put(inp_obj);
}
var sanitycheck = index.get([inp_obj.name.last, inp_obj.name.first]);
sanitycheck.onsuccess = function() {
console.log(sanitycheck);
}
}
//|||||||||||||||||||||||||||||||||||||||||||||
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(PersonalDataDataBaseName, {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(PersonalDataDataBaseName, "readwrite");
var store = tx.objectStore(PersonalDataDataBaseName);
var index = store.index("NameIndex");
//||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||[ Essential recordUpdate ]||||||||||||||||||||||||||||||
var inp_obj;
var getRecord = index.get([record.name.last, record.name.first]);
getRecord.onsuccess = function() {
if( getRecord.result != undefined ) {
console.log("updating");
inp_obj = getRecord.result;
} else {
inp_obj = record;
}
inp_obj[field] = value; // => "Bob"
store.put(inp_obj);
getRecordAgain = index.get([record.name.last, record.name.first]);
getRecordAgain.onsuccess = function() {
console.log(getRecordAgain); // => "Bob"
if ( getRecordAgain.result[field] == value ) {
console.log("Update succeeded");
} else {
console.log("Update unsuccessful");
}
};
};
//||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
tx.oncomplete = function() {
db.close();
};
};
};
function recordCheck(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(PersonalDataDataBaseName, {keyPath: "id"});
var index = store.createIndex("NameIndex", ["name.last", "name.first"]);
};
pddb.onsuccess = function() {
var db = pddb.result;
var tx = db.transaction(PersonalDataDataBaseName, "readwrite");
var store = tx.objectStore(PersonalDataDataBaseName);
var index = store.index("NameIndex");
//||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||[ Essential recordCheck ]||||||||||||||
var recordcheck = index.get([record.name.last, record.name.first]);
recordcheck.onsuccess = function() {
if ( recordcheck.result != undefined ) {
console.log(recordcheck);
} else {
console.log("...else undefined");
}
//||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
}
tx.oncomplete = function() {
db.close();
};
};
};