Gecko [ www.utparral.edu.mx ]

Name	Size	Permission
designer_db.js	4.22 KB	-rwxrwxr-x
designer_objects.js	384 B	-rwxrwxr-x
designer_page.js	5.23 KB	-rwxrwxr-x
history.js	28.04 KB	-rwxrwxr-x
init.js	1.27 KB	-rwxrwxr-x
move.js	70.04 KB	-rwxrwxr-x

Code Editor : designer_db.js

var designer_tables = [{name: "pdf_pages", key: "pg_nr", auto_inc: true},
                       {name: "table_coords", key: "id", auto_inc: true}];

var DesignerOfflineDB = (function () {
    var designerDB = {};
    var datastore = null;

designerDB.open = function (callback) {
        var version = 1;
        var request = window.indexedDB.open("pma_designer", version);

request.onupgradeneeded = function (e) {
            var db = e.target.result;
            e.target.transaction.onerror = designerDB.onerror;

for (var t in designer_tables) {
                if (db.objectStoreNames.contains(designer_tables[t].name)) {
                    db.deleteObjectStore(designer_tables[t].name);
                }
            }

for (var t in designer_tables) {
                db.createObjectStore(designer_tables[t].name, {
                    keyPath: designer_tables[t].key,
                    autoIncrement: designer_tables[t].auto_inc
                });
            }
        };

request.onsuccess = function (e) {
            datastore = e.target.result;
            if (typeof callback !== 'undefined' && callback !== null) {
                callback(true);
            }
        };

request.onerror = designerDB.onerror;
    };

designerDB.loadObject = function (table, id, callback) {
        var db = datastore;
        var transaction = db.transaction([table], 'readwrite');
        var objStore = transaction.objectStore(table);
        var cursorRequest = objStore.get(parseInt(id));

cursorRequest.onsuccess = function (e) {
            callback(e.target.result);
        };

cursorRequest.onerror = designerDB.onerror;
    };

designerDB.loadAllObjects = function (table, callback) {
        var db = datastore;
        var transaction = db.transaction([table], 'readwrite');
        var objStore = transaction.objectStore(table);
        var keyRange = IDBKeyRange.lowerBound(0);
        var cursorRequest = objStore.openCursor(keyRange);
        var results = [];

transaction.oncomplete = function (e) {
            callback(results);
        };

cursorRequest.onsuccess = function (e) {
            var result = e.target.result;
            if (Boolean(result) === false) {
                return;
            }
            results.push(result.value);
            result.continue();
        };

cursorRequest.onerror = designerDB.onerror;
    };

designerDB.loadFirstObject = function(table, callback) {
        var db = datastore;
        var transaction = db.transaction([table], 'readwrite');
        var objStore = transaction.objectStore(table);
        var keyRange = IDBKeyRange.lowerBound(0);
        var cursorRequest = objStore.openCursor(keyRange);
        var firstResult = null;

transaction.oncomplete = function(e) {
            callback(firstResult);
        };

cursorRequest.onsuccess = function(e) {
            var result = e.target.result;
            if (Boolean(result) === false) {
                return;
            }
            firstResult = result.value;
        };

cursorRequest.onerror = designerDB.onerror;
    };

designerDB.addObject = function(table, obj, callback) {
        var db = datastore;
        var transaction = db.transaction([table], 'readwrite');
        var objStore = transaction.objectStore(table);
        var request = objStore.put(obj);

request.onsuccess = function(e) {
            if (typeof callback !== 'undefined' && callback !== null) {
                callback(e.currentTarget.result);
            }
        };

request.onerror = designerDB.onerror;
    };

designerDB.deleteObject = function(table, id, callback) {
        var db = datastore;
        var transaction = db.transaction([table], 'readwrite');
        var objStore = transaction.objectStore(table);
        var request = objStore.delete(parseInt(id));

request.onsuccess = function(e) {
            if (typeof callback !== 'undefined' && callback !== null) {
                callback(true);
            }
        };

request.onerror = designerDB.onerror;
    };

designerDB.onerror = function(e) {
        console.log(e);
    };

// Export the designerDB object.
    return designerDB;
}());

${this.title}

Code Editor : designer_db.js