Node MYSQL request, Async issue

Question

Okay, so i could use some help. I know my code is incorrect, whats the easiest way to go about handling this. As you can see my return is going to return an empty variable before the query has been executed.

const fetchall = function fetch(sessionid) {
      let data;
      connection.query(
        'SELECT * FROM LOCATIONS WHERE SESSIONID = ?', [sessionid],
        function(err, rows, fields) {
          data = rows;
      });
      return data;
    };

I am using express here and the code for the request looks like this.

  app.post('/api/locations/fetchall', function (req, res) {
    let sesionid = sessions.active();
    let results = locations.fetchall(sesionid);
    res.send(results);
  });

codeshinobi · Accepted Answer · 2016-01-22 15:54:29Z

1

You have to return data inside the query. I am not sure what module you are using to make your database query. I assume that function(err, rows, fields){} is a callback. That means you have to return data in your query() function and not outside.

Or else, check if your framework is not promise-based, ie. you can call something like

connection.query("your query").then(function(data){
   //return data somewhere in here
})

answered Jan 22, 2016 at 15:54

codeshinobi

11412 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Node MYSQL request, Async issue

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related