var mysql = require('mysql');

module.exports =
{
  init: init,
  query: query
};

var inited = false;

function init()
{
  if(inited) return;
  inited = true;

  db = mysql.createConnection(
  {
    host: '127.0.0.1',
    user: '-',
    password: '-',
    database: 'freehourboost',
  });

  // Keepalive.
  setInterval(function () { db.query('SELECT 1', function() { }); }, 20000);

  console.log("[MYSQL] Connected");
}

function query(qry, params, cb)
{
  if(!inited) { init(); }
  db.query(qry, params, cb);
}