530
edits
Changes
Jump to navigation
Jump to search
mLine 1:
Line 1: − + + − pddb.addEventListener('error', (event) => {+ − console.log('Request error:', pddb.error);+ − }, false); − + + + + + + + + − + + + + + + + + + + + + + + + + + + − + − // Start a new transaction − + − var store = tx.objectStore("MyObjectStore");+ − 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);+ − var Pete = {id: 11345, name: {first: "Pete", last: "Rock"}, age: 52}; − store.put(Pete); − recordUpdate(store, index, ["Pete", "Rock"], 'phoneNumber', '+674316'); − // Query the data − − // Close the db when the transaction is done − tx.oncomplete = function() { − db.close(); − }; − } − + − var index = db.index("NameIndex");+ − var getRecord = index.get(record);+ + + + + + + + − getRecord.onsuccess = function() { − console.log("updating"); − getRecord.result.field = value; // => "Bob" − db.put(getRecord.result); − checkrecord(db, ref, record, field) − }; − } − function checkRecord(db, ref, record, field) {+ − checkRecord = ref.get(record);+ − checkRecord.onsuccess = function() {+ − console.log(getRecordAgain.result.phone); // => "Bob"+ − };+ −
no edit summary
console.log("~");
console.log("~");
var pddb = window.indexedDB.open("pdio", 1);
var PersonalDataDataBaseName = "pdio";
var Pete = {id: 11345, name: {first: "Pete", last: "Rock"}, age: 52};
addRecord(PersonalDataDataBaseName, Pete);
recordUpdate(PersonalDataDataBaseName, ["Pete", "Rock"], 'phone', '+313555777');
pddb.onupgradeneeded = function() {
function addrecord(pddbname, record){
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 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() {
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.onsuccess = function() {
pddb.onupgradeneeded = function() {
var db = pddb.result;
var db = pddb.result;
var tx = db.transaction("MyObjectStore", "readwrite");
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 getRecod = index.get(record);
getRecord.onsuccess = function() {
console.log("updating");
getRecord.result.field = value; // => "Bob"
store.put(getRecord.result);
function recordUpdate(db, ref, record, field, value){
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() {
db.close();
};
}
}