var mysql = require('mysql');

var config = require('./config');
var connection = mysql.createPool(config.mysql);

function query(){
  return new Promise(function(resolve, reject){
    connection.getConnection(function(err, connection) {
      if(err) reject(err);

      connection.query(query, function(err, row){
        connection.release();

        if(err){
          reject(err);
        }

        resolve(row);
      })
    });
  });
}

module.exports = {
  pool: connection,
  query: query
};

mysql: {
    host: 'localhost',
    user: 'root',
    password: '',
    database: 'site',
    connectionLimit : 10,
    multipleStatements : true
  }