530
edits
Changes
Jump to navigation
Jump to search
mLine 55:
Line 55: − var PersonalDataDataBaseName = "pdio";+ − var Pete = {id: 11345, name: {first: "Pete", last: "Rock"}, age: 52}; − addRecord(PersonalDataDataBaseName, Pete);+ − recordUpdate(PersonalDataDataBaseName, ["Pete", "Rock"], 'phone', '+313555777'); − function addRecord(pddbname, record){+ − var pddb = window.indexedDB.open(pddbname, 1); + + − pddb.onupgradeneeded = function() {+ − };+ − pddb.onsuccess = function() {+ + − + − − store.put(record); − − tx.oncomplete = function() { − db.close(); − }; − }; − }; − − function recordUpdate(pddbname, record, field, value){ − var pddb = window.indexedDB.open(pddbname, 1);+ + + + + + − pddb.addEventListener('error', (event) => {+ − console.log('Request error:', pddb.error); + − }, false);+ − pddb.onupgradeneeded = function() {+ − var db = pddb.result;+ − var store = db.createObjectStore("MyObjectStore", {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("MyObjectStore", "readwrite");+ − var store = tx.objectStore("MyObjectStore");+ − var index = store.index("NameIndex");+ + − var getRecord = index.get(record); − getRecord.onsuccess = function() { − console.log("updating"); − getRecord.result.field = value; // => "Bob" − store.put(getRecord.result); − getRecordAgain = index.get(record); − getRecordAgain.onsuccess = function() { − console.log(getRecordAgain.result.field); // => "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() { − }; − };+
no edit summary
*/
*/
console.log("~");
var pddb = window.indexedDB.open("pdio", 1);
pddb.addEventListener('error', (event) => {
console.log('Request error:', pddb.error);
}, false);
pddb.onupgradeneeded = function() {
var db = pddb.result;
var db = pddb.result;
var store = db.createObjectStore("MyObjectStore", {keyPath: "id"});
var store = db.createObjectStore("MyObjectStore", {keyPath: "id"});
var index = store.createIndex("NameIndex", ["name.last", "name.first"]);
var index = store.createIndex("NameIndex", ["name.last", "name.first"]);
};
pddb.onsuccess = function() {
// Start a new transaction
var db = pddb.result;
var db = pddb.result;
var tx = db.transaction("MyObjectStore", "readwrite");
var tx = db.transaction("MyObjectStore", "readwrite");
var store = tx.objectStore("MyObjectStore");
var store = tx.objectStore("MyObjectStore");
var index = store.index("NameIndex");
var index = store.index("NameIndex");
// Add some data
// var John = {id: 12345, name: {first: "John", last: "Doe"}, age: 42, phone: '+33123456789'};
// var Bob = {id: 67890, name: {first: "Bob", last: "Smith"}, age: 35}
// store.put(John);
// store.put(Bob);
// Query the data
var getJohn = store.get(12345);
var getBob = index.get(["Smith", "Bob"]);
getBob.onsuccess = function() {
console.log("updating");
getBob.result.phone = '+312'; // => "Bob"
store.put(getBob.result);
getBobAgain = index.get(["Smith", "Bob"]);
getBobAgain.onsuccess = function() {
console.log(getBobAgain.result.phone); // => "Bob"
};
};
// Close the db when the transaction is done
tx.oncomplete = function() {
db.close();
db.close();
};
};
}