var mysql = require("mysql");
var db_config = {
  	host: 'localhost',
    user: 'root',
    password: 'password',
    database: 'db_name'
};
function handleDisconnect() {
  conn = mysql.createConnection(db_config);
  conn.connect(function(err) {
    if(err) {
      console.log('error when connecting to db:', err);
      setTimeout(handleDisconnect, 2000);
    }
  });
  conn.on('error', function(err) {
    console.log('db error', err);
    if(err.code === 'PROTOCOL_CONNECTION_LOST') {
      handleDisconnect();
    } else {
      throw err;
    }
  });
}
handleDisconnect();

module.exports = conn;