sequelize.js - 在 sequelize 上执行 sql 查询

Question

我在 MySQL 中执行了以下 SQL 查询。如何将此查询转换为 Sequelize 格式的查询。

SELECT * 
FROM   weather_datas AS S 
WHERE  created_at = (SELECT Max(created_at) 
                     FROM   weather_datas 
                     WHERE  control_esp_id = S.control_esp_id 
                     GROUP  BY control_esp_id) 

Answer 1

也许这可以得到你想要的数据

await weather_datas.findAll({
  attributes: [[Sequelize.fn('max', Sequelize.col('created_at')), 'max']],
  group: ['control_esp_id'],
  where : {
   control_esp_id : req.body.control_esp_id}
})