datas := make([]*models.HorizontalMultiple, 0)
errone := session.Table("horizontal").Select("horizontal.auto_code_id,horizontal.id,horizontal.monitor_point_name,horizontal.collect_time,horizontal.tangential_cumulative,horizontal.radial_cumulative,water_level.water_level_value,air_temperature.air_temperature_value").
Where("horizontal.monitor_point_name = ?", monitorPointName).
Join("LEFT OUTER", "water_level", "water_level.collect_time = horizontal.collect_time").
Join("LEFT OUTER", "air_temperature", "air_temperature.collect_time = horizontal.collect_time").
OrderBy("collect_time ASC,auto_code_id ASC").
Find(&datas)
[GO] xorm
最新推荐文章于 2023-02-19 14:21:37 发布