转换SQL查询以序列化

Question

这是我的 SQL 查询，我想将此查询转换为后续查询：

SELECT 
    `users`.`uId`, `users`.*, 
    COUNT(`tasks`.`userUId`) AS 'tasksCount' 
FROM 
    `users` AS `users` 
LEFT OUTER JOIN 
    `tasks` AS `tasks` ON `users`.`uId` = `tasks`.`userUId` 
GROUP BY 
    `users`.`uId`;

Answer 1

您可以在 attributes 选项中使用 Sequelize.fn 并在 group 选项中指示 users.id：

const users = await Users.findAll({
  attributes: {
    include:[[Sequelize.fn('SUM', Sequelize.col('tasks.userId')), 'tasksCount']]
  },
  include: [{
    model: Tasks,
    attributes: ['userId']
  }],
  group: [Sequelize.col('tasks.userId')]
})