postgresql - 我如何将此 sql 转换为 sequelize 函数

Question

我想将sql转换为sequelize函数

我试过代码

const result = await models.chapter.findOne({
    logging: log.trace,
    where: {
      seq: db.fn('max', db.col('seq'))
    }
  });

sql 中的成功代码select * from page_chapter where seq = (select max(seq) from page_chapter)

我期待这样的结果

  const result = await model.chapter.findOne({
    where: {
      seq: sequelize.fn('max', sequelize.col('seq'))
    }
  })

Answer 1

您可以使用 sequelize.literal 获取您的查询:

const result = await model.chapter.findOne({
    where: sequelize.literal('"seq" = (SELECT MAX("page_chapter"."seq") FROM "page_chapter")')
})