From ea66c01f85340a5ed65d5dd74607e5cfcdbec03d Mon Sep 17 00:00:00 2001
From: jinpengyong <jpy123456>
Date: Wed, 14 Dec 2022 10:01:33 +0800
Subject: [PATCH] 修改sql语句问题3
---
screen-job/src/main/java/com/moral/api/service/impl/HistoryAqiServiceImpl.java | 31 +++++++++++--------------------
screen-job/src/main/resources/mapper/HistoryAqiMapper.xml | 4 ++--
2 files changed, 13 insertions(+), 22 deletions(-)
diff --git a/screen-job/src/main/java/com/moral/api/service/impl/HistoryAqiServiceImpl.java b/screen-job/src/main/java/com/moral/api/service/impl/HistoryAqiServiceImpl.java
index 0b4daab..5287e1c 100644
--- a/screen-job/src/main/java/com/moral/api/service/impl/HistoryAqiServiceImpl.java
+++ b/screen-job/src/main/java/com/moral/api/service/impl/HistoryAqiServiceImpl.java
@@ -2,10 +2,8 @@
import com.alibaba.fastjson.JSONObject;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
-import com.moral.api.entity.CityAqi;
import com.moral.api.entity.GovMonitorPoint;
import com.moral.api.entity.HistoryAqi;
-import com.moral.api.mapper.CityAqiMapper;
import com.moral.api.mapper.HistoryAqiMapper;
import com.moral.api.service.GovMonitorPointService;
import com.moral.api.service.HistoryAqiService;
@@ -13,6 +11,7 @@
import com.moral.constant.Constants;
import com.moral.constant.RedisConstants;
import com.moral.util.DateUtils;
+import com.xxl.job.core.context.XxlJobHelper;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
@@ -47,8 +46,6 @@
@Autowired
private HistoryAqiMapper historyAqiMapper;
- @Autowired
- private CityAqiMapper cityAqiMapper;
@Autowired
private RestTemplate restTemplate;
@@ -78,7 +75,7 @@
// String timeStr = DateUtils.dateToDateString(time, DateUtils.yyyy_MM_dd_HH_mm_ss_EN);
String timeStr = DateUtils.dateToDateString(DateUtils.addHours(time, -1), DateUtils.yyyy_MM_dd_HH_mm_ss_EN);
-// List<HistoryAqi> historyAqis = new ArrayList<>();
+ List<HistoryAqi> historyAqis = new ArrayList<>();
for (GovMonitorPoint govMonitorPoint : govMonitorPoints) {
HistoryAqi historyAqi = new HistoryAqi();
@@ -103,7 +100,7 @@
//���������������
historyAqi.setValue(JSONObject.toJSONString(map));
-// historyAqis.add(historyAqi);
+ historyAqis.add(historyAqi);
Map<String, Object> value = new HashMap<>();
Object pm2_5 = map.get("pm2_5");
@@ -140,12 +137,8 @@
//aqi������������redis
redisTemplate.opsForHash().put(RedisConstants.AQI_DATA, guid, value);
- historyAqiMapper.insert(historyAqi);
- CityAqi cityAqi = new CityAqi();
- cityAqi.setCityCode(11111);
- cityAqi.setTime(DateUtils.addHours(time, -1));
- cityAqi.setValue(JSONObject.toJSONString(map));
- cityAqiMapper.insert(cityAqi);
+// historyAqiMapper.insert(historyAqi);
+
}else {
ResponseEntity<String> response;
@@ -166,7 +159,7 @@
//���������������
historyAqi.setValue(JSONObject.toJSONString(map));
-// historyAqis.add(historyAqi);
+ historyAqis.add(historyAqi);
Map<String, Object> value = new HashMap<>();
Object pm2_5 = map.get("pm2_5");
@@ -201,18 +194,16 @@
//aqi������������redis
redisTemplate.opsForHash().put(RedisConstants.AQI_DATA, guid, value);
- historyAqiMapper.insert(historyAqi);
+// historyAqiMapper.insert(historyAqi);
- CityAqi cityAqi = new CityAqi();
- cityAqi.setCityCode(11111);
- cityAqi.setTime(DateUtils.addHours(time, -1));
- cityAqi.setValue(JSONObject.toJSONString(map));
- cityAqiMapper.insert(cityAqi);
}
}
//���������������
-// historyAqiMapper.insertHistoryAqi(historyAqis);
+ if (ObjectUtils.isEmpty(historyAqis)){
+ XxlJobHelper.log("���������������");
+ }
+ historyAqiMapper.insertHistoryAqi(historyAqis);
}
@Override
diff --git a/screen-job/src/main/resources/mapper/HistoryAqiMapper.xml b/screen-job/src/main/resources/mapper/HistoryAqiMapper.xml
index 70830ce..78b9ab9 100644
--- a/screen-job/src/main/resources/mapper/HistoryAqiMapper.xml
+++ b/screen-job/src/main/resources/mapper/HistoryAqiMapper.xml
@@ -6,7 +6,7 @@
<resultMap id="BaseResultMap" type="com.moral.api.entity.HistoryAqi">
<result column="guid" property="guid"/>
<result column="time" property="time"/>
- <result column="json" property="json"/>
+ <result column="value" property="value"/>
</resultMap>
<insert id="insertHistoryAqi">
@@ -14,7 +14,7 @@
history_aqi
VALUES
<foreach collection="list" item="item" separator=",">
- (#{item.guid},#{item.time},#{item.json})
+ (#{item.guid},#{item.time},#{item.value})
</foreach>
</insert>
</mapper>
\ No newline at end of file
--
Gitblit v1.8.0