node.js - Sequelize 包括创建一个嵌套对象

Question

我想进行从模型用户到模型团队的内部联接。这是代码:

User.findAll({
  arrtibute: ['name'],
  include: [{
    model: Team,
    arrtibutes: ['teamName']
  }]
})

然后，我得到:

[ 
  { 
    name: 'wrq',
    team: {
      teamName: 'teamA'
    }
  },
  { 
    name: 'wyx',
    team: {
      teamName: 'teamB'
    }
  },
]

但我期望的是:

[ 
  { 
    name: 'wrq',
    teamName: 'teamA'
  },
  { 
    name: 'wyx',
    teamName: 'teamB'
  },
]

如何通过 Sequelize 来做到这一点？

Answer 1

您可以简单地映射这些值。

User.findAll({
    attributes: ['name'],
    include: [{
        model: Team,
        attributes: ['teamName']
    }]
}).then(function(users) {
    return users.map(function(user) {
        return {
            name: user.name,
            teamName: user.team.teamName
        }
    });
}).then(function(users) {
    // The rest of your logics here...
});