hubot-js/gear-jenkins

'use strict';

exports.getDb = getDb;

const path = require('path');
const sqlite = require('sqlite');

let database;

function getDb() {
  if (database) {
    return Promise.resolve(database);
  }

  return startDb();
}

function startDb() {
  return open()
        .then(migrate)
        .catch(() => { }); // do nothing
}

function open() {
  const dbPath = path.join(process.env.HOME, 'hubot.js', 'data');
  const dbFile = `${dbPath}/gear-jenkins.db`;

  return sqlite.open(dbFile);
}

function migrate(sqliteDb) {
  const migrations = `${gearPath()}/migrations`;

  return sqliteDb.migrate({ migrationsPath: migrations })
           .then((result) => {
             database = result;
             return database;
           });
}

function gearPath() {
  return path.resolve(__dirname, '../');
}