/*jslint node: true */ "use strict"; var _ = require('lodash'); var conf = require("./conf.js"); var sqlite_migrations = require('./sqlite_migrations'); var EventEmitter = require('events').EventEmitter; var bCordova = (typeof window === 'object' && window.cordova); var sqlite3; var path; var cordovaSqlite; if (bCordova){ // will error before deviceready //cordovaSqlite = window.cordova.require('cordova-sqlite-plugin.SQLite'); } else{ sqlite3 = require('sqlite3');//.verbose(); path = require('./desktop_app.js').getAppDataDir() + '/'; console.log("path="+path); } var bLoading = true; module.exports = function(db_name, MAX_CONNECTIONS, bReadOnly){ function openDb(cb){ if (bCordova){ var db = new cordovaSqlite(db_name); db.open(cb); return db; } else return new sqlite3.Database(path + db_name, bReadOnly ? sqlite3.OPEN_READONLY : sqlite3.OPEN_READWRITE, cb); } var eventEmitter = new EventEmitter(); var bReady = false; var arrConnections = []; var arrQueue = []; function connect(handleConnection){ console.log("opening new db connection"); var db = openDb(function(err){ if (err) throw Error(err); console.log("opened db"); setTimeout(function(){ bLoading = false; }, 15000); // if (!bCordova) // db.serialize(); connection.query("PRAGMA foreign_keys = 1", function(){ connection.query("PRAGMA busy_timeout=30000", function(){ connection.query("PRAGMA journal_mode=WAL", function(){ connection.query("PRAGMA synchronous=FULL", function(){ connection.query("PRAGMA temp_store=MEMORY", function(){ if (!conf.bLight) connection.query("PRAGMA cache_size=-200000", function () { }); sqlite_migrations.migrateDb(connection, function(){ handleConnection(connection); }); }); }); }); }); }); }); var connection = { db: db, bInUse: true, currentQuery: null, start_ts: 0, release: function(){ //console.log("released connection"); this.bInUse = false; if (arrQueue.length === 0) return; var connectionHandler = arrQueue.shift(); this.bInUse = true; connectionHandler(this); }, query: function(){ if (!this.bInUse) throw Error("this connection was returned to the pool"); var last_arg = arguments[arguments.length - 1]; var bHasCallback = (typeof last_arg === 'function'); if (!bHasCallback) // no callback last_arg = function(){}; var sql = arguments[0]; //console.log("======= query: "+sql); var bSelect = !!sql.match(/^\s*SELECT/i); var count_arguments_without_callback = bHasCallback ? (arguments.length-1) : arguments.length; var new_args = []; var self = this; for (var i=0; i Date.now() - 60 * 1000) return; console.log(`in long query for ${Date.now() - this.start_ts}ms`, this.currentQuery); }, addQuery: addQuery, escape: escape, addTime: addTime, getNow: getNow, getUnixTimestamp: getUnixTimestamp, getFromUnixTime: getFromUnixTime, getRandom: getRandom, getIgnore: getIgnore, forceIndex: forceIndex, dropTemporaryTable: dropTemporaryTable }; setInterval(connection.printLongQuery.bind(connection), 60 * 1000); arrConnections.push(connection); } // accumulate array of functions for async.series() // it applies both to individual connection and to pool function addQuery(arr) { var self = this; var query_args = []; for (var i=1; i takeConnectionFromPool(resolve)); if (!bReady){ console.log("takeConnectionFromPool will wait for ready"); eventEmitter.once('ready', function(){ console.log("db is now ready"); takeConnectionFromPool(handleConnection); }); return; } // first, try to find a free connection for (var i=0; i 0) // array expanded_sql += _.fill(Array(len), "?").join(","); else if (len === 0) expanded_sql += "NULL"; // _.flatten() will remove the empty array else expanded_sql += "?"; } var flattened_params = _.flatten(params); args[0] = expanded_sql; args[1] = flattened_params; } function getParentDirPath(){ switch(window.cordova.platformId){ case 'ios': return window.cordova.file.applicationStorageDirectory + '/Library'; case 'android': default: return window.cordova.file.applicationStorageDirectory; } } function getDatabaseDirName(){ switch(window.cordova.platformId){ case 'ios': return 'LocalDatabase'; case 'android': default: return 'databases'; } } function getDatabaseDirPath(){ return getParentDirPath() + '/' + getDatabaseDirName(); } function createDatabaseIfNecessary(db_name, onDbReady){ console.log('createDatabaseIfNecessary '+db_name); var initial_db_filename = 'initial.' + db_name; // on mobile platforms, copy initial sqlite file from app root to data folder where we can open it for writing if (bCordova){ console.log("will wait for deviceready"); document.addEventListener("deviceready", function onDeviceReady(){ console.log("deviceready handler"); console.log("data dir: "+window.cordova.file.dataDirectory); console.log("app dir: "+window.cordova.file.applicationDirectory); window.requestFileSystem(LocalFileSystem.PERSISTENT, 0, function onFileSystemSuccess(fs){ window.resolveLocalFileSystemURL(getDatabaseDirPath() + '/' + db_name, function(fileEntry){ console.log("database file already exists"); onDbReady(); }, function onSqliteNotInited(err) { // file not found console.log("will copy initial database file"); window.resolveLocalFileSystemURL(window.cordova.file.applicationDirectory + "/www/" + initial_db_filename, function(fileEntry) { console.log("got initial db fileentry"); // get parent dir window.resolveLocalFileSystemURL(getParentDirPath(), function(parentDirEntry) { console.log("resolved parent dir"); parentDirEntry.getDirectory(getDatabaseDirName(), {create: true}, function(dbDirEntry){ console.log("resolved db dir"); fileEntry.copyTo(dbDirEntry, db_name, function(){ console.log("copied initial cordova database"); onDbReady(); }, function(err){ throw Error("failed to copyTo: "+JSON.stringify(err)); }); }, function(err){ throw Error("failed to getDirectory databases: "+JSON.stringify(err)); }); }, function(err){ throw Error("failed to resolveLocalFileSystemURL of parent dir: "+JSON.stringify(err)); }); }, function(err){ throw Error("failed to getFile: "+JSON.stringify(err)); }); }); }, function onFailure(err){ throw Error("failed to requestFileSystem: "+err); }); }, false); } else{ // copy initial db to app folder var fs = require('fs'); fs.stat(path + db_name, function(err, stats){ console.log("stat "+err); if (!err) // already exists return onDbReady(); console.log("will copy initial db"); var mode = parseInt('700', 8); var parent_dir = require('path').dirname(path); fs.mkdir(parent_dir, mode, function(err){ console.log('mkdir '+parent_dir+': '+err); fs.mkdir(path, mode, function(err){ console.log('mkdir '+path+': '+err); // fs.createReadStream(__dirname + '/initial-db/' + initial_db_filename).pipe(fs.createWriteStream(path + db_name)).on('finish', onDbReady); fs.writeFileSync(path + db_name, fs.readFileSync(__dirname + '/initial-db/' + initial_db_filename)); onDbReady(); }); }); }); } }