let mysql = require('mysql');

let connection = mysql.createConnection({
    host: "localhost",
    user: "root",
    password: "",

});

connection.query('USE test_database');

let run_mysql = (mysql_query) => {
    return new Promise(function (resolve, reject) {
        connection.query(mysql_query, function (err, rows) {
            if (err) {
                return reject(err);
            }
            resolve(rows);
        });
    });
}

const sF_classbooking = 'SELECT * FROM `users_logs` ORDER BY `ts_create` DESC LIMIT 10';
const sF_userName = 'SELECT `name`,`surname` FROM `users_info` WHERE id='; //2865

run_mysql(sF_classbooking).then(function (rows) {

    let promises = [];

    for (var j = 0; j < rows.length; j++) {

        promises.push(run_mysql(sF_userName + rows[j].id_user));

    }

    Promise.all(promises)
        .then(function (data) {

            let logs = [];

            for (var i = 0; i < data.length; i ++) {
                var obj = {};

                obj.user = data[i][0].name + ', ' + data[i][0].surname;
                obj.userId = rows[i].id_user;
                obj.log = rows[i].id_logs;

                logs.push(obj);
            }
            console.log(logs);
        })
        .catch((err) => setImmediate(() => {
            throw err;
        }));
}).catch((err) => setImmediate(() => {
    throw err;
}));