mysql - 我收到以下错误 : not a valid attribute definition in sequelize

Question

我将如何使用 sequelize 按 desc 按电子邮件顺序获得 COUNT 和以下列分组。我收到以下错误:不是有效的属性定义。
const data = await NominationModel.findAll({attributes: ['email', 'nomineename',[sequelize.fn('COUNT', sequelize.col('email'))]] });
我正在尝试使用 sequelize 低于 sql 查询。SELECT COUNT(1),nomineename, email FROM devchoice.nominations GROUP BY (email) order by email desc

Answer 1

你似乎错过了 sequelize 中的 group，试试这个:

NominationModel.findAll({
    group: ['email', 'nomineename'],
    attributes: ['email', 'nomineename', [sequelize.fn('COUNT', sequelize.col('email')), 'count']],
    order: [
        [Sequelize.literal('count'), 'DESC']
    ],
    raw: true
}).then((rst) => {
    console.log('rst' ,rst);
}).catch((err) => {
    console.log('err', err);
})