Node router can't get data from Sequelize using async await

Question

Using Sequelizefor the first time I'm trying this code in my Node router:

router.get('/get-users', async (req, res, next) => {
  const data = await users.getAll()
  console.log('users in router:', data);
  res.send(data)
});

And this is the sequlize code:

const users = {
  getAll () {
    sequelize
      .query('SELECT * FROM users', { model: User })
      .then(users => {
        console.log('users in database:', users);
        return users;
      })
  }
};

The log statement in Sequelize code is getting me the right data but the log statement in router gets undefined.

It's probably async await problem but can you help?

RetBack · Accepted Answer · 2018-11-09 14:17:17Z

1

Try to return the promise in the getAll(). Await is just a wrapper for a then() call of a promise but since you are not returning a promise the await is not waiting for the promise.

  getAll () {
    return sequelize
      .query('SELECT * FROM users', { model: User })
      .then(users => {
        console.log('users in database:', users);
        return users;
    })
  }

answered Nov 9, 2018 at 14:17

RetBack

812 bronze badges

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

1 Comment

Lee Maan Over a year ago

It works! Thank you! Yes I forgot to the part of returning a promise.

Collectives™ on Stack Overflow

Node router can't get data from Sequelize using async await

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related