修改sql语句问题3

jinpengyong

2022-12-14 ea66c01f85340a5ed65d5dd74607e5cfcdbec03d

修改sql语句问题3

 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

 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>