Difference between revisions of "User:Abel/experimental.js"
Jump to navigation
Jump to search
m (Replaced content with "console.log("~");") Tag: Replaced |
m |
||
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(); | ||
+ | }; | ||
+ | }; | ||
+ | }; |
Revision as of 23:46, 26 April 2019
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();
};
};
};