function createDatabase(file){ var db = new sqlite3.Database(file); if(!fs.existsSync(file)){ console.log("creating database file"); fs.openSync(file, "w"); db.run("CREATE TABLE users (username TEXT, password TEXT, email TEXT)", function(createResult){ if(createResult) throw createResult; }); console.log("database initialized"); } return db; }
/** * Create the cache database. */ var createDb = function() { console.log(" Create cache db."); db = new sqlite3.Database(':memory:'); }
const connect = () => new Promise((resolve, reject) => { db = new sqlite3.Database(process.env.DB_NAME, (err) => { if (err) { reject(err.message); } debug(`Connected to "${process.env.DB_NAME}" SQlite database.`); resolve(); }); })
constructor(options) { super(); try{ this.connectionOptions=options; var connection = new sqlite3.Database(options.database); this.connection=connection; }catch(ex){ console.error(ex.toString()); } }
init_session_sqlite() { // get sqlite database path let path = require("path"); let sqlite3 = require("sqlite3").verbose(); let database_path = path.join(process.cwd(), process.env.DB_STORAGE); // init sessions table let database = new sqlite3.Database(database_path); database.run( "CREATE TABLE IF NOT EXISTS 'sessions' (id varchar(255) primary key, session varchar(255))" ); // create sqlite session middleware let TelegrafSession = require("telegraf-session-sqlite"); return TelegrafSession({ db: database, table_name: "sessions" }); }
function init() { const dirName = require('path').dirname(location); if (!fs.existsSync(dirName)) { fs.mkdirSync(dirName, { recursive: true }); } return new Promise((acc, rej) => { db = new sqlite3.Database(location, err => { if (err) return rej(err); if (process.env.NODE_ENV !== 'test') console.log(`Using sqlite database at ${location}`); db.run( 'CREATE TABLE IF NOT EXISTS todo_items (id varchar(36), name varchar(255), completed boolean)', (err, result) => { if (err) return rej(err); acc(); }, ); }); }); }
/** * Bind the database resource by create the table if not exist */ function _bind() { return new Promise(function (resolve, reject) { var dbfile = path.join(settings.workDir, 'users.fuxap.db'); var dbfileExist = fs.existsSync(dbfile); db_usr = new sqlite3.Database(dbfile, function (err) { if (err) { logger.error('usrstorage.failed-to-bind: ' + err); reject(); } logger.info('usrstorage.connected-to ' + dbfile + ' database.'); }); // prepare query var sql = "CREATE TABLE if not exists users (username TEXT PRIMARY KEY, password TEXT, groups INTEGER);"; db_usr.exec(sql, function (err) { if (err) { logger.error('usrstorage.failed-to-bind: ' + err); reject(); } else { resolve(dbfileExist); } }); }); }
const initialise = async (reset) => { db = new sqlite3.Database('couchwarehouse.sqlite') return new Promise((resolve, reject) => { db.serialize(() => { // create table to hold replication "checkpoints" const checkpointSQL = 'CREATE TABLE IF NOT EXISTS couchwarehouse_checkpoints (id INTEGER PRIMARY KEY AUTOINCREMENT, tablename TEXT, seq TEXT)' db.run(checkpointSQL, err => { if (err) { reject(err) } resolve() }) }) }) }
function dbConnect () { return new Promise((resolve, reject) => { const db = new sqlite3.Database(dbName, dbOptions, (error) => { if (error) { reject(error); } else { resolve(db); } }); }); }
const openSqliteDb = (config, pathForTest) => { let path; if (!pathForTest) { path = config.chrome_profile_path + "/Local Storage/chrome-extension_" + config.onetab_ext_id + "_0.localstorage"; } else { path = pathForTest; } return new Promise((resolve, reject) => { try { fs.accessSync(path); } catch (e) { reject (e); return; } let db = new sqlite3.Database(path); db.serialize(() => { db.get("SELECT key,value FROM ItemTable WHERE key = ?", "state", (err, row) => { if (err) { reject(err) } else { resolve(createSqliteDBInterface(db, row.key)); } }) }) }); }
// open connection to the database connect () { return new Promise((resolve, reject) => { const db = new sqlite3.Database( this.path, sqlite3.OPEN_READONLY, (err, res) => { if (err) reject(err) resolve(db) }) }) }
function dbConnect () { return new Promise((resolve, reject) => { const db = new sqlite3.Database(dbName, dbOptions, (error) => { if (error) { reject(error); } else { resolve(db); } }); }); }
function dbConnect () { return new Promise((resolve, reject) => { const db = new sqlite3.Database(dbName, dbOptions, (error) => { if (error) { reject(error); } else { resolve(db); } }); }); }
function dbConnect () { return new Promise((resolve, reject) => { const db = new sqlite3.Database(dbName, dbOptions, (error) => { if (error) { reject(error); } else { resolve(db); } }); }); }
/** * Bind the database resource by create the table if not exist */ function _bind() { return new Promise(function (resolve, reject) { var dbfile = path.join(settings.workDir, 'alarms.fuxap.db'); var dbfileExist = fs.existsSync(dbfile); db_alarms = new sqlite3.Database(dbfile, function (err) { if (err) { logger.error('alarmsstorage.failed-to-bind: ' + err); reject(); } logger.info('alarmsstorage.connected-to ' + dbfile + ' database.'); }); // prepare query var sql = "CREATE TABLE if not exists alarms (nametype TEXT PRIMARY KEY, type TEXT, status TEXT, ontime INTEGER, offtime INTEGER, acktime INTEGER);"; // sql += "CREATE TABLE if not exists history (dt INTEGER, name TEXT, type TEXT, text TEXT, groups TEXT, status INTEGER);"; db_alarms.exec(sql, function (err) { if (err) { logger.error('alarmsstorage.failed-to-bind: ' + err); reject(); } else { resolve(dbfileExist); } }); }); }