sequelize /sequelize-findAll with HasMany 返回一个对象而不是数组

Question

我正在尝试使用续集打字稿建立一对多关系。 但是当我尝试获取数据时，许多人的关系会返回一个对象而不是数组

我有两张桌子。团队和球员。

球队可以有很多球员，一个球员属于一个球队。

我的模型：

@Table
export class Team extends Model<Team> {
@Column
name: string
@HasMany(() => Player)
players: Player[]
}
@Table
export class Player extends Model<Player> {
@Column
name: string
@Column
num: number
@ForeignKey(() => Team)
@Column
teamId: number
@BelongsTo(() => Team)
team: Team
}

当我运行时：

Team.findAll({ include: [Player] })

我明白这个：

[
{
"id": 1,
"name": "My Team",
"createdAt": "2020-06-17T14:23:03.000Z",
"updatedAt": "2020-06-17T14:23:03.000Z",
"players": {
"id": 1,
"name": "Player One",
"num": 10,
"teamId": 1,
"createdAt": "2020-06-17T14:23:03.000Z",
"updatedAt": "2020-06-17T14:23:03.000Z"
}
},
{
"id": 1,
"name": "My Team",
"createdAt": "2020-06-17T14:23:03.000Z",
"updatedAt": "2020-06-17T14:23:03.000Z",
"players": {
"id": 2,
"name": "Player Two",
"num": 99,
"teamId": 1,
"createdAt": "2020-06-17T14:23:03.000Z",
"updatedAt": "2020-06-17T14:23:03.000Z"
}
}
]

但我需要得到这个：

[
{
"id": 1,
"name": "My Team",
"createdAt": "2020-06-17T14:23:03.000Z",
"updatedAt": "2020-06-17T14:23:03.000Z",
"players": [
{
"id": 1,
"name": "Player One",
"num": 10,
"teamId": 1,
"createdAt": "2020-06-17T14:23:03.000Z",
"updatedAt": "2020-06-17T14:23:03.000Z"
},
{
"id": 2,
"name": "Player Two",
"num": 99,
"teamId": 1,
"createdAt": "2020-06-17T14:23:03.000Z",
"updatedAt": "2020-06-17T14:23:03.000Z"
}
]
}
]

我不知道是我做错了什么，还是续集打字稿的问题，或者是否是续集的问题。

有人可以帮助我吗？

Answer 1

如果您指定：raw: true在查询选项中

。

Team.findAll({
include: [
Player
],
raw: true // <-- problem
}
)

结果：

[
{
"id": 1,
"name": "Team 1",
"players.id": 1,
"players.name": "Player 1",
"players.num": 1,
"players.teamId": 1
},
{
"id": 1,
"name": "Team 1",
"players.id": 2,
"players.name": "Player 2",
"players.num": 2,
"players.teamId": 1
}
]

删除它：

Team.findAll({
include: [
Player
]
}
)

结果：

[
{
"id":1,
"name":"Team 1",
"players":[
{
"id":1,
"name":"Player 1",
"num":1,
"teamId":1
},
{
"id":2,
"name":"Player 2",
"num":2,
"teamId":1
}
]
}
]