const mysql = require('mysql2');
const Promise = require('bluebird');
const http = require('http');

const pool = mysql.createPool({
    host: 'localhost',
    user: 'root',
    password: 'pwd',
    database: 'test',
    connectionLimit: 100
});
pool.query = Promise.promisify(pool.query);

function generatePage(res) {
    const time = process.hrtime();
    pool.query('SELECT * FROM `users`')
        .then(results => {
            let response = JSON.stringify(results);
            const diff = process.hrtime(time);
            const generationTime = diff[1] / 1000000;
            response += `<div><b>Страница сгенерирована за: ${generationTime}ms</b></div>`;
            res.end(response)
        })
        .catch(err => console.log(err))
}