在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}
})