javascript - 如何将混合表更改为 Sequelize？

Question

我尝试使用 Sequelize 来混淆表格，但我不知道如何操作。

SELECT count(*) as counts
FROM
  (SELECT * FROM board order by id desc limit 10) as board
WHERE board.login_id = 1234

我如何在 Sequelize 中表示这一点

Answer 1

你可以在 sequelize 中这样做。

//board means your model name

let result = await board.count({
    order: [sequelize.literal('id DESC')],
    limit: 10,
    where: { login_id: 1234 },
    as: 'board'
})