Difference between revisions of "User:Abel/experimental.js"
Jump to navigation
Jump to search
m |
m |
||
Line 4: | Line 4: | ||
var Pete = {id: 11345, name: {first: "Pete", last: "Rock"}, age: 52}; | var Pete = {id: 11345, name: {first: "Pete", last: "Rock"}, age: 52}; | ||
− | + | addRecord(PersonalDataDataBaseName, Pete); | |
recordUpdate(PersonalDataDataBaseName, Pete, 'phone', '+313851777'); | recordUpdate(PersonalDataDataBaseName, Pete, 'phone', '+313851777'); | ||
recordCheck(PersonalDataDataBaseName, Pete); | recordCheck(PersonalDataDataBaseName, Pete); | ||
− | function | + | function addRecord(pddbname, record){ |
console.log("pn1"); | console.log("pn1"); | ||
var pddb = window.indexedDB.open(pddbname, 3); | var pddb = window.indexedDB.open(pddbname, 3); | ||
Line 23: | Line 23: | ||
pddb.onsuccess = function() { | pddb.onsuccess = function() { | ||
− | |||
var db = pddb.result; | var db = pddb.result; | ||
var tx = db.transaction(PersonalDataDataBaseName, "readwrite"); | var tx = db.transaction(PersonalDataDataBaseName, "readwrite"); | ||
var store = tx.objectStore(PersonalDataDataBaseName); | var store = tx.objectStore(PersonalDataDataBaseName); | ||
var index = store.index("NameIndex"); | var index = store.index("NameIndex"); | ||
− | + | ||
− | + | store.put(record); | |
− | + | ||
+ | console.log("Mark 2: " + record.name.first); | ||
+ | console.log("Mark 2: " + record.name.last + "..."); | ||
− | + | var recordcheck = index.get([record.name.last, record.name.first]); | |
− | + | recordcheck.onsuccess = function() { | |
− | var | + | console.log(recordcheck); |
− | |||
− | console.log( | ||
} | } | ||
Line 66: | Line 65: | ||
var index = store.index("NameIndex"); | var index = store.index("NameIndex"); | ||
− | var getRecord = | + | var getRecord = index.get([record.name.last, record.name.first]); |
− | |||
getRecord.onsuccess = function() { | getRecord.onsuccess = function() { | ||
− | + | console.log("updating"); | |
− | inp_obj = getRecord | + | inp_obj = getRecord.result |
inp_obj[field] = value; // => "Bob" | inp_obj[field] = value; // => "Bob" | ||
store.put(inp_obj); | store.put(inp_obj); | ||
− | getRecordAgain = index.get([ | + | getRecordAgain = index.get([record.name.last, record.name.first]); |
getRecordAgain.onsuccess = function() { | getRecordAgain.onsuccess = function() { | ||
console.log("Mark 1..."); | console.log("Mark 1..."); | ||
Line 85: | Line 83: | ||
}; | }; | ||
}; | }; | ||
+ | |||
// Close the db when the transaction is done | // Close the db when the transaction is done | ||
Line 113: | Line 112: | ||
var index = store.index("NameIndex"); | var index = store.index("NameIndex"); | ||
− | var recordcheck = | + | var recordcheck = index.get([record.name.last, record.name.first]); |
− | console.log(recordcheck); | + | recordcheck.onsuccess = function() { |
− | + | console.log(recordcheck); | |
+ | console.log("...Mark 0"); | ||
} | } | ||
Line 122: | Line 122: | ||
}; | }; | ||
}; | }; | ||
− | + | }; | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− |
Revision as of 01:32, 27 April 2019
console.log("~");
var PersonalDataDataBaseName = "PDIO2";
var Pete = {id: 11345, name: {first: "Pete", last: "Rock"}, age: 52};
addRecord(PersonalDataDataBaseName, Pete);
recordUpdate(PersonalDataDataBaseName, Pete, 'phone', '+313851777');
recordCheck(PersonalDataDataBaseName, Pete);
function addRecord(pddbname, record){
console.log("pn1");
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");
store.put(record);
console.log("Mark 2: " + record.name.first);
console.log("Mark 2: " + record.name.last + "...");
var recordcheck = index.get([record.name.last, record.name.first]);
recordcheck.onsuccess = function() {
console.log(recordcheck);
}
tx.oncomplete = function() {
db.close();
};
};
};
function recordUpdate(pddbname, record, field, value){
console.log("pn2");
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");
var getRecord = index.get([record.name.last, record.name.first]);
getRecord.onsuccess = function() {
console.log("updating");
inp_obj = getRecord.result
inp_obj[field] = value; // => "Bob"
store.put(inp_obj);
getRecordAgain = index.get([record.name.last, record.name.first]);
getRecordAgain.onsuccess = function() {
console.log("Mark 1...");
console.log(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();
};
};
};
function recordCheck(pddbname, record){
console.log("pn1");
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");
var recordcheck = index.get([record.name.last, record.name.first]);
recordcheck.onsuccess = function() {
console.log(recordcheck);
console.log("...Mark 0");
}
tx.oncomplete = function() {
db.close();
};
};
};