const mysql = require('mysql');
const promisify = require('util').promisify;

const pool = mysql.createPool({
    connectionLimit: 10,
    host: process.env.db.host,
    user: process.env.db.user,
    password: process.env.db.pass,
    database: process.env.db.name,
    multipleStatements: true
});

pool.on('connection', function (connection) {
    connection.query('SET NAMES "utf8"');
    connection.query('SET lc_time_names = "ru_RU"');
});

pool.query = promisify(pool.query);

module.exports = pool;