Issue returning proper value form a function with callbacks

Question

I'm working on a small app in node.js and I have a module where I fetch a user from the database. I'm having trouble returning the fetched user and I am pretty certain it has something to do with the flow of callbacks but I can't pinpoint exactly what I'm not doing right.

//first module

exports.userById = (id) => {

db.executeSql(`SELECT * FROM Users WHERE UserId = ${id}`, function(
data,
err
) {
if (err) {
  //handle error
} else {
  //return fetched user    
  return data.recordset;
}
});
} 


//the module where I'm trying to fetch the user

const users = require('../controllers/user');
const id = 1;
const user = users.userById(userId); //this is undefined

To clarify I am certain the data.recordset contains the data, but I don't know how to properly return that data to another module. Thanks for any direction

it's asynchronous.. you can't just return it.. you'll have to move the module call into the callback function itself — I wrestled a bear once., Apr 12 '18 at 19:57
replace `return data.recordset;` with the last three lines of your script. i can;t demonstrate since the question was marked as a dupe. you could starrt by reading that page to understand the problem. — I wrestled a bear once., Apr 12 '18 at 20:09
but that would just lead to a circular reference? I did suspect my issue had something to do with async flow... I'll read up on the link thanks — J.Kirk., Apr 12 '18 at 20:14

Issue returning proper value form a function with callbacks

0 Answers0