Return MySQL rows from .exec(err,rows) to a function in Sails JS(i dont want to send rows in response)

Question

How can i return the rows of a table (model) if i don't want to send it to response via response.json() of response.ok().

i have user model api/model/User.js

module.exports = {
  attributes: {
    name:{
      type:'string'
    },
    age:{
      type:'text'
    }
  }
};

I am writing a function in api/services/sendList.js

module.exports=function sendList(model){
  model.find({}).exec(function(err,rows){
   //here i dont want to send it as res.json(rows)
  });
   /***i want to return the rows obtained so that it can be used
    *somewhere else(wherever the function **sendList** is being
    *called.)
    */
}

Gary · Accepted Answer · 2015-12-18T13:51:07.500

1

Use a callback, or promises. Here is a callback example :

module.exports=function sendList(model,callback){
  model.find({}).exec(function(err,rows){
    callback(rows);
  });
}

To use it :

sendlList(model, function(rows) {
    console.log(rows);

    // Go ahead and use them now.
});

edited Dec 18 '15 at 13:51

answered Dec 18 '15 at 13:24

Gary

2,866
1
17
20

callback is a good way to perform the task i want.But Is there a way exissting where i can return the array of row objects. – vkstack Dec 18 '15 at 13:47
So due to async feature of node the only way possible is callback!! – vkstack Dec 18 '15 at 13:58

score 0 · Answer 2 · answered Dec 18 '15 at 13:48

0

Gary's response works.

Or just return:

module.exports.sendList = function(model){
  model.find().exec(function(err,rows){
    if(!err) return rows;
  });
}

answered Dec 18 '15 at 13:48

1

That will not work... sendList will return before results are available. – Gary Dec 18 '15 at 13:52
console.log(getList(User)); and this was printing undefined – vkstack Dec 18 '15 at 13:55
If you don't know why this does not work, read http://stackoverflow.com/questions/14220321/how-do-i-return-the-response-from-an-asynchronous-call/14220323#14220323 – Gary Dec 18 '15 at 13:56

Return MySQL rows from .exec(err,rows) to a function in Sails JS(i dont want to send rows in response)

2 Answers2