express-hbs | Express handlebars template engine with inheritance, partials, i18n and async helpers

app.get('/usersrooms', function (req, res, next) {
    var personList = [];
    connection.query('SELECT * FROM users ORDER BY id', function (err, rows, fields) {
        if (err) {
            res.status(500).json({ "status_code": 500, "status_message": "internal server error" });
            console.error(JSON.stringify(err));
            //return here to prevent second res call
            return;
        } else {
            // Loop check on each row
            for (var i = 0; i < rows.length; i++) {

                // Create an object to save current row's data
                var person = {
                    'email': rows[i].email,
                    'firstname': rows[i].firstname,
                    'GameId': rows[i].GameId,
                    'id': rows[i].id
                }
                // Add object into array
                personList.push(person);
            }

            res.render('index', { "personList": personList });
        }
    });
  });