Asynchronous function return

Question

I am trying to return the value of a query using Sequelize but it always comes as Undefined. I imagine it is due to being an asynchronous function.

const { Sequelize, sequelize } = require('../../config/database');

// Classe para realizar manipulação dos usuarios no banco
class UserDAO{
    // Consultar registros no banco pelas credenciais passadas pelo controller
    userQuery(userCredentials){   
        sequelize.query(`SELECT * FROM usuarios WHERE login='${userCredentials.user}' AND senha='${userCredentials.pass}'`).then((result) => {
            return result;
        }).catch((err) => {
            console.log(err);            
        });
    }

}

module.exports = UserDAO;

The Userdao class is instantiated in another file and the userQuery() function is called by passing an object as argument. I need the userQuery() function to return the then() value of the sequelize.query().

Answer 1

I’ll try to help you try to do it this way:

const { Sequelize, sequelize } = require('../../config/database');

// Classe para realizar manipulação dos usuarios no banco
function pesquisa() {
class UserDAO{
    // Consultar registros no banco pelas credenciais passadas pelo controller
    userQuery(userCredentials){   
        sequelize.query(`SELECT * FROM usuarios WHERE login='${userCredentials.user}' AND senha='${userCredentials.pass}'`).then((result) => {
            console.log(result)
            return result;
        }).catch((err) => {
            console.log(err);            
        });
    }

  }
}

pesquisa()

probably solve this, keep an eye to see the result of the log, if everything goes well export this function as an object JSON in that way:

    const { Sequelize, sequelize } = require('../../config/database');

    // Classe para realizar manipulação dos usuarios no banco
module.exports = {
pesquisa: function(){
class UserDAO{
        // Consultar registros no banco pelas credenciais passadas pelo controller
        userQuery(userCredentials){   
            sequelize.query(`SELECT * FROM usuarios WHERE login='${userCredentials.user}' AND senha='${userCredentials.pass}'`).then((result) => {
                console.log(result)
                return result;
            }).catch((err) => {
                console.log(err);            
            });
        }

      }
    }
}