manager

const mysql = require('mysql');
const config = require('../../config/database.config');

let DatabaseManager = {};

const pool = mysql.createPool({
  connectionLimit: 10,
  host: '127.0.0.1',
  user: 'root',
  password: 'root',
  database: 'reactietijden'
});


DatabaseManager.query = (query, params) => {
  return new Promise((resolve, reject) => {
    pool.getConnection((err, connection) => {
      if (err) reject({"code": 100, "status": "Error in connection database"});
      connection.query(query, params, function(error, rows) {
        connection.release();
        (!error) ? resolve(rows) : reject(error);
      });
    });
  });
};

module.exports = DatabaseManager;