sql - 如何将此 SQL 查询转换为 sequelize？

Question

SELECT
  "flatNo",
  "buildingId",
  count(*)
FROM "FlatDetails"
WHERE "buildingId"= 'E7EA2771'
GROUP BY
  "flatNo",
  "buildingId"
HAVING count(*) > 1;

我试过这个工具 https://pontaku-tools.com/english/ 但它没有给我正确的答案。

Answer 1

你可以试试这个代码。关键字是 fn & literal

FlatDetails.findAll({
    attributes: ['flatNo', 'buildingId', [sequelize.fn('count', sequelize.col('*')), 'count']],
    where: {
        buildingId: 'E7EA2771'
    },
    group: ['flatNo', 'buildingId'],
    having: sequelize.literal('count(*) > 1'),
    raw: true,
    logging: true
})
.then(flats => {
    console.log(flats);
})
.catch(err => {
    console.log(err);
})