node.js - 使用 join、group by、having、order by 进行 Sequelize

Question

如何使用 ORM 编写此查询？

SELECT p.id, 
    p.name, 
    COUNT(c.id) counter 
FROM Posts p 
LEFT JOIN Comments c 
    ON c.post_id = p.id 
WHERE p.rating > 100 
GROUP BY p.id
HAVING counter > 10
ORDER BY counter DESC 
LIMIT 5

Answer 1

试试这个:

Post.findAll({
  where: {rating: {gt: 100}},
  include: [Comments],
  having: ['COUNT(?) >= ?', '`comment`.`id`', 10]
})

阅读my research通过这个问题。

我使用 sequelize@2.0.0-dev9