var sqlite3 = require('sqlite3').verbose();

const db = new sqlite3.Database('data/db.sqlite3', (err) => {
  if (err) {
    console.error(err.message);
    throw err;
  } else {
    console.log('Connected to the SQLite database.');
    db.run(
      `CREATE TABLE IF NOT EXISTS netmonResults (id integer PRIMARY KEY, 
      timestamp text, 
      status integer)`
    );
  }
});

module.exports = db;