同步执行Sequelize查询

本文介绍了同步执行Sequelize查询的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我正在使用Node.js和Sequelize(带有Postgres后端)构建一个网站.我有一个查询，该查询返回带有外键的许多对象，并且我想将外键引用的对象的列表传递给视图.

I am building a website using Node.js and Sequelize (with a Postgres backend). I have a query that returns many objects with a foreign key, and I want to pass to the view a list of the objects that the foreign key references.

在该示例中，出勤"包含Hackathon密钥，我想返回一个hackathon列表.由于代码是异步的，因此以下内容在Node中当然不起作用:

In the example, Attendances contains Hackathon keys, and I want to return a list of hackathons. Since the code is async, the following thing of course does not work in Node:

models.Attendance.findAll({ where: { UserId: req.user.id } }).then(function (data) { var hacks = []; for (var d in data) { models.Hackathon.findOne({ where: { id: data[d].id } }).then(function (data1) { hacks.append(data1); }); } res.render('dashboard/index.ejs', {title: 'My Hackathons', user: req.user, hacks: hacks}); });

有没有办法以同步方式执行该查询，这意味着直到我拥有所有对象的"hacks"列表时，我才返回视图?

Is there any way to do that query in a synchronous way, meaning that I don't return the view untill I have the "hacks" list filled with all the objects?

谢谢！

推荐答案

使用 Promise.all 执行所有查询，然后调用下一个函数.

Use Promise.all to execute all of your queries then call the next function.

models.Attendance.findAll({ where: { UserId: req.user.id } }).then(function (data) { // get an array of the data keys, (not sure if you need to do this) // it is unclear whether data is an object of users or an array. I assume // it's an object as you used a `for in` loop const keys = Object.keys(data) // map the data keys to [Promise(query), Promise(query), {...}] const hacks = keys.map((d) => { return models.Hackathon.findOne({ where: { id: data[d].id } }) }) // user Promise.all to resolve all of the promises asynchronously Promise.all(hacks) // this will be called once all promises have resolved so // you can modify your data. it will be an array of the returned values .then((users) => { const [user1, user2, {...}] = users res.render('dashboard/index.ejs', { title: 'My Hackathons', user: req.user, hacks: users }); }) });