Node.js sequelize embed hasMany IDs [英] Node.js sequelize embed hasMany IDs

问题描述

我正在尝试使用 ember-data 的 Ember 应用程序和使用 Sequelize.js 从 MySQL 提供数据的 node.js 后端.

I am experimenting with a Ember app using ember-data and a node.js backend serving data from MySQL using Sequelize.js.

我的问题:如果我通过 hasMany 将 Comment 模型关联到 Post 模型，则 ember-data 的预期 JSON 看起来像

My problem: If I have a Comment model associated to a Post model through hasMany the expected JSON by ember-data looks like

{
  "post": {
    "comment_ids": [1, 2, 3]
  }
}

使用 sequelize 在没有昂贵循环等的情况下查询/生成此 JSON 的最佳方法是什么?

What would be the best way to query / generate this JSON without expensive loops etc. using sequelize?

Comment 模型有一个带有 post_id 的外键.

The Comment model has a foreign key with the post_id.

推荐答案

我去实现它是这样的:

// include comments
Post.all({
  where: "..",
  include: [Comment]
}).success(function(posts) {
  // collect IDs
  _.each(posts, function(element) {
    element["comments"] = _.pluck(element.comments, 'id');
  });
});

这篇关于Node.js sequelize embed hasMany IDs的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！