From 458abb3a7085edb35d808efc2351552508e82d4b Mon Sep 17 00:00:00 2001 From: kaiyu <404897439@qq.com> Date: Mon, 28 Dec 2020 15:02:09 +0800 Subject: [PATCH] 五分钟建表语句添加索引 --- src/main/java/com/moral/task/AQIDataInsertTask.java | 8 +++++++- 1 files changed, 7 insertions(+), 1 deletions(-) diff --git a/src/main/java/com/moral/task/AQIDataInsertTask.java b/src/main/java/com/moral/task/AQIDataInsertTask.java index f9c3d4f..76ccc6f 100644 --- a/src/main/java/com/moral/task/AQIDataInsertTask.java +++ b/src/main/java/com/moral/task/AQIDataInsertTask.java @@ -56,11 +56,17 @@ if (!ObjectUtils.isEmpty(data)) { values = data.values(); pubtime = format.parse(data.get("pubtime").toString()); + int hours = pubtime.getHours(); + Calendar calendar = Calendar.getInstance(); + int hour = calendar.get(Calendar.HOUR_OF_DAY); + if (hour != hours){ + pubtime = null; + } } } catch (Exception e) { e.printStackTrace(); } - if (ObjectUtils.isEmpty(entity) || ObjectUtils.isEmpty(values) || values.contains("None")) { + if (ObjectUtils.isEmpty(entity) || ObjectUtils.isEmpty(values) || values.contains("None") || pubtime == null) { Map<String, Object> mjMap = restTemplate.getForObject("http://sapi.7drlb.com/api/mj?cityID={1}&apiKey=aqi", Map.class, cityAqiConfig.get("city_id")); if (ObjectUtils.isEmpty(mjMap)) { continue; -- Gitblit v1.8.0