Difference between revisions of "User:Abel/common.js"
Jump to navigation
Jump to search
m |
m |
||
Line 53: | Line 53: | ||
} | } | ||
*/ | */ | ||
− | |||
//|||||||||||||||||||||[ db objects ]||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| | //|||||||||||||||||||||[ db objects ]||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| | ||
− | var | + | var personal = {}; |
var indexedDB = window.indexedDB ; | var indexedDB = window.indexedDB ; | ||
var indexedDBVersion = "2"; | var indexedDBVersion = "2"; | ||
var Pete = {id: '11345', name: {first: "Pete", last: "Rock"}, age: '52'}; | var Pete = {id: '11345', name: {first: "Pete", last: "Rock"}, age: '52'}; | ||
− | + | personal.indexedDB = {}; | |
− | + | personal.indexedDB.db = null; | |
Line 70: | Line 69: | ||
− | + | personal.indexedDB.onerror = function(arr){ | |
console.log(arr); | console.log(arr); | ||
} | } | ||
Line 78: | Line 77: | ||
− | + | personal.indexedDB.open = function(){ | |
// open database of | // open database of | ||
var request = indexedDB.open("personalDataIO"); | var request = indexedDB.open("personalDataIO"); | ||
Line 84: | Line 83: | ||
request.onsuccess = function(e){ | request.onsuccess = function(e){ | ||
// | // | ||
− | + | personal.indexedDB.db = e.target.result; | |
− | var db = | + | var db = personal.indexedDB.db; |
//object stores are created in setVersion transactions | //object stores are created in setVersion transactions | ||
Line 92: | Line 91: | ||
//object store is created onsuccess | //object store is created onsuccess | ||
− | setDBVersion.onerror = | + | setDBVersion.onerror = personal.indexedDB.onerror; |
setDBVersion.onsuccess = function(e){ | setDBVersion.onsuccess = function(e){ | ||
Line 101: | Line 100: | ||
} | } | ||
store.createIndex("NameIndex", ["name.last", "name.first"]); | store.createIndex("NameIndex", ["name.last", "name.first"]); | ||
− | + | personal.indexedDB.recordAll(); | |
}; | }; | ||
}else{ | }else{ | ||
− | + | personal.indexedDB.recordAll(); | |
} | } | ||
}; | }; | ||
− | request.onerror = | + | request.onerror = personal.indexedDB.onerror; |
};//end open | };//end open | ||
Line 115: | Line 114: | ||
//add Items | //add Items | ||
− | + | personal.indexedDB.recordAdd = function(recordObject){ | |
− | + | var db = personal.indexedDB.db; | |
− | var db = | ||
var trans = db.transaction(["personalDataIO"],IDBTransaction.READ_WRITE); | var trans = db.transaction(["personalDataIO"],IDBTransaction.READ_WRITE); | ||
var store = trans.objectStore("personalDataIO"); | var store = trans.objectStore("personalDataIO"); | ||
Line 123: | Line 121: | ||
request.onsuccess = function(e){ | request.onsuccess = function(e){ | ||
− | + | personal.indexedDB.recordAll(); | |
}; | }; | ||
request.onerror = function(e){ | request.onerror = function(e){ | ||
Line 134: | Line 132: | ||
//get Items | //get Items | ||
− | + | personal.indexedDB.recordAppend = function(Uname, field, value){ | |
− | var db = | + | var db = personal.indexedDB.db; |
var trans = db.transaction("personalDataIO"); | var trans = db.transaction("personalDataIO"); | ||
var store = trans.objectStore("personalDataIO"); | var store = trans.objectStore("personalDataIO"); | ||
Line 151: | Line 149: | ||
function init() { | function init() { | ||
− | + | personal.indexedDB.open(); | |
} | } | ||
//||||||||||||||||||||||||||||||[ Get Record by name]|||||||||||||||||||||||||||||||||||||||||||||||||||||||||| | //||||||||||||||||||||||||||||||[ Get Record by name]|||||||||||||||||||||||||||||||||||||||||||||||||||||||||| | ||
− | + | personal.indexedDB.recordGet = function(uname) { | |
− | var db = | + | var db = personal.indexedDB.db; |
var trans = db.transaction("personalDataIO"); | var trans = db.transaction("personalDataIO"); | ||
var store = trans.objectStore("personalDataIO"); | var store = trans.objectStore("personalDataIO"); | ||
Line 179: | Line 177: | ||
init(); | init(); | ||
− | + | personal.indexedDB.recordAdd(Pete); | |
− | + | personal.indexedDB.recordAppend(["Pete", "Rock"], 'telephone', '+123-XXX'); | |
− | + | personal.indexedDB.recordGet(["Pete", "Rock"]); |
Revision as of 23:03, 26 April 2019
console.log('+');
/*
var personal_data_id = 421;
var wbEStruct = {
subclassOfRelations: 'claims.P4', // location of P3 relations in wbEntity
IDPropLoc: 'mainsnak.datavalue.value', // location of ID properties in related entity
IDName: 'numeric-id', // ID property name which checked
qIDPropName: 'id'
};
// check if we are on a page of a loaded Entity
if ( typeof mw.config.values.wbEntity != "undefined" ) {
console.log( "entity is defined" )
// get wbEntity as json
var obj = JSON.parse ( mw.config.values.wbEntity );
console.log( "parsed object" )
// check if we have P3 relations and iterate through
if ( typeof check( obj, wbEStruct["subclassOfRelations"] ) != "undefined" ) {
console.log( "object has 'subclass of' relations" );
for( var i = 0; i < dive( obj, wbEStruct["subclassOfRelations"] ).length; i++ ) {
console.log("dived in");
// check if we have controller id constructed from wbEntity
if( dive( dive( obj, wbEStruct["subclassOfRelations"])[i] , wbEStruct["IDPropLoc"])[wbEStruct["IDName"]] === personal_data_id ) {
console.log( "it's a storable personal data" )
var qId = obj[wbEStruct["qIDPropName"]];
console.log(qId);
}
}
}
// Else let's do nothing;
}
function indexinterpolate(obj,i) { return (obj[i] != undefined) ? obj[i] : obj};
// helper function for checking a part of an array exists
function indexcheck(obj,i) { return (obj[i] != undefined) ? obj[i] : undefined };
// dive selects matrix.a.b.c.d from the array called matrix and 'a.b.c.d' as string
// if a.b.c.d does not exists, it returns the substructure until the substructure exists, if d does not exist, it returns matrix.a.b.c e.g.
function dive(array, read){
return read.split('.').reduce(indexinterpolate, array);
}
function check(array, read){
return read.split('.').reduce(indexcheck, array);
}
*/
//|||||||||||||||||||||[ db objects ]|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
var personal = {};
var indexedDB = window.indexedDB ;
var indexedDBVersion = "2";
var Pete = {id: '11345', name: {first: "Pete", last: "Rock"}, age: '52'};
personal.indexedDB = {};
personal.indexedDB.db = null;
//|||||||||||||||||||||||||||[ Error ]|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
personal.indexedDB.onerror = function(arr){
console.log(arr);
}
//|||||||||||||||||||||||||||[ Open database ]|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
personal.indexedDB.open = function(){
// open database of
var request = indexedDB.open("personalDataIO");
request.onsuccess = function(e){
//
personal.indexedDB.db = e.target.result;
var db = personal.indexedDB.db;
//object stores are created in setVersion transactions
if(indexedDBVersion!=db.version){
var setDBVersion = db.setVersion(indexedDBVersion);
//object store is created onsuccess
setDBVersion.onerror = personal.indexedDB.onerror;
setDBVersion.onsuccess = function(e){
if(db.objectStoreNames.contains("personalDataIO")){
// db.openObjectStore("personalDataIO");
} else {
var store = db.createObjectStore("personalDataIO",{autoIncrement:true});
}
store.createIndex("NameIndex", ["name.last", "name.first"]);
personal.indexedDB.recordAll();
};
}else{
personal.indexedDB.recordAll();
}
};
request.onerror = personal.indexedDB.onerror;
};//end open
//|||||||||||||||||||||||||||||[ Add new record ]|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
//add Items
personal.indexedDB.recordAdd = function(recordObject){
var db = personal.indexedDB.db;
var trans = db.transaction(["personalDataIO"],IDBTransaction.READ_WRITE);
var store = trans.objectStore("personalDataIO");
var request = store.put(recordObject);
request.onsuccess = function(e){
personal.indexedDB.recordAll();
};
request.onerror = function(e){
console.log('Error adding: '+e);
};
};
//|||||||||||||||||||||||||||||[ Add new property to existing record ]|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
//get Items
personal.indexedDB.recordAppend = function(Uname, field, value){
var db = personal.indexedDB.db;
var trans = db.transaction("personalDataIO");
var store = trans.objectStore("personalDataIO");
var index = store.index(uname);
index.get(uname).onsuccess = function(e){
var nit = e.target.result;
nit.field = value;
recordAdd(nit);
};
};
//|||||||||||||||||||||||||||||[ Init wrapper ]|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
function init() {
personal.indexedDB.open();
}
//||||||||||||||||||||||||||||||[ Get Record by name]||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
personal.indexedDB.recordGet = function(uname) {
var db = personal.indexedDB.db;
var trans = db.transaction("personalDataIO");
var store = trans.objectStore("personalDataIO");
var index = store.index(uname);
console.log(index);
index.get(uname).onsuccess = function(e){
console.log(e.target);
/*/ $('#results').append('<li>'+e.target.result+'</li>'); /*///
};
}
//||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
//||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
init();
personal.indexedDB.recordAdd(Pete);
personal.indexedDB.recordAppend(["Pete", "Rock"], 'telephone', '+123-XXX');
personal.indexedDB.recordGet(["Pete", "Rock"]);