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); } }); }); }
test.before.cb((t) => { fs.unlink(DB_PATH, (err) => { if (err && err.code !== `ENOENT`) { t.end(err); return; } db = new sqlite3.cached.Database(DB_PATH); controllerMock = { spawn: sinon.stub().returnsThis(), startRTM: sinon.stub().returnsThis(), hears: sinon.stub().returnsThis(), on: sinon.stub().returnsThis() }; botkitMock = { slackbot: sinon.stub().returns(controllerMock) }; botMock = { reply: sinon.stub() }; program = proxyquire(`../demo_bot`, { botkit: botkitMock }); db.run(program.TABLE_SQL, t.end); }); });
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); } }); }); }
// 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); } }); }); }