mysql id多节点连续_节点Mysql异步多个查询

因此,在发送响应之前,必须等待所有回调返回.如果为了简单起见忽略错误处理和清空结果,可以这样做：

var callback = function(blogs) {

res.send(blogs);

}

connection.query("SELECT * FROM blogs ORDER BY time DESC", function(err, blogs, fields) {

var pending = blogs.length;

for (blog in blogs) {

connection.query("SELECT * FROM tags WHERE blog_id='blog.id' ", function(err, tags, fields) {

blog.tags = tags;

if (0 === --pending) {

callback(blogs);

}

});

}

});

使用promises,查看Promise.all函数,它返回一个新的promise.当解决传递给它的所有promise时,解决了这个promise.使用Q库它应该是这样的：

var getTags = function(blog) {

var deferred = Q.defer();

connection.query("SELECT * FROM tags WHERE blog_id='blog.id' ", function(err, tags, fields) {

blog.tags = tags;

deferred.resolve();

});

return deferred.promise;

}

var promises = blogs.map(getTags(blog));

Q.all(promises).then(res.send(blogs));