sequelize.js - 当关系不使用主键时，将belongsToMany 序列化

Question

我正在建立一个社交网络，所以我的模型是帖子、用户和用户-关注-用户关系

var User = sequelize.define('user', {
  username: Sequelize.DataTypes.STRING
})

var Post = sequelize.define('post', {
  text: Sequelize.DataTypes.STRING,
  userId: Sequelize.DataTypes.INTEGER 
})

var Follow = sequelize.define('follow', {
    followerUserId: Sequelize.DataTypes.INTEGER,
    followingUserId: Sequelize.DataTypes.INTEGER,
  })

为了获取某个用户的提要 - 他们关注的用户的所有帖子 - 我需要能够执行如下所示的查询:

User.findById(13).then(user => user.getFollowingPosts())

但我被困在协会上:

User.belongsToMany(Post, {
      as: 'followingPosts',
      through: { model: Follow, },
      foreignKey: 'followerUserId',
      otherKey: 'userId',
    });

生成错误的 SQL JOIN 条件，我无法修复:

SELECT ...
FROM `posts` AS `post` INNER JOIN `follows` AS `follow`
  ON `post`.`id` = `follow`.`userId` AND `follow`.`followerUserId` = 13

我无法让用户 post.userId 而不是 post.id Sequelize

Answer 1

找到了一个足够好的解决方法:

Post.belongsTo(Follow, {
  as: 'following',
  foreignKey: 'userId',
  targetKey: 'followingUserId',
  allowNull: false
})

这样我完全跳过 User.blongsToMany 并查询以下信息:

Post.findAll({
  include: [{
    association: Post.associations.following,
    where: { followerUserId: 13}
  }]
})

产生:

SELECT ...
FROM `posts` AS `post` INNER JOIN `follows` AS `following`
  ON `post`.`userId` = `following`.`followingUserId` AND
     `following`.`followerUserId` = 13