From f388835aae263f93ae6ba4dd29ef406788d875e3 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期四, 08 六月 2023 19:00:06 +0800
Subject: [PATCH] 1
---
src/main/resources/mapping/VocValsMapper.xml | 3 +--
src/main/resources/application-scheduled.yml | 2 +-
src/main/java/com/yssh/scheduled/ReadCsvTask.java | 2 +-
3 files changed, 3 insertions(+), 4 deletions(-)
diff --git a/src/main/java/com/yssh/scheduled/ReadCsvTask.java b/src/main/java/com/yssh/scheduled/ReadCsvTask.java
index 1bacaf9..f419bca 100644
--- a/src/main/java/com/yssh/scheduled/ReadCsvTask.java
+++ b/src/main/java/com/yssh/scheduled/ReadCsvTask.java
@@ -121,7 +121,7 @@
try {
// 璁＄畻棰勮/鎶ヨ,骞朵笖杩涜鍏ュ簱鎿嶄綔
- Thread.sleep(60000);
+ Thread.sleep(10000); // 60000
} catch (InterruptedException e) {
logger.error("鐫＄湢涓�鍒嗛挓鍚庢墽琛岄璀�/鎶ヨ璁＄畻,骞朵笖杩涜鍏ュ簱鎿嶄綔鍑虹幇寮傚父锛屽紓甯稿師鍥犳槸锛�", e);
e.printStackTrace();
diff --git a/src/main/resources/application-scheduled.yml b/src/main/resources/application-scheduled.yml
index 162ffa0..ce65cd1 100644
--- a/src/main/resources/application-scheduled.yml
+++ b/src/main/resources/application-scheduled.yml
@@ -1,3 +1,3 @@
csv:
cron: '0 1 * * * ? '
- voc: '0 21 10 * * ? '
+ voc: '0 31 12 * * ? '
diff --git a/src/main/resources/mapping/VocValsMapper.xml b/src/main/resources/mapping/VocValsMapper.xml
index 8155c12..925e21f 100644
--- a/src/main/resources/mapping/VocValsMapper.xml
+++ b/src/main/resources/mapping/VocValsMapper.xml
@@ -14,8 +14,7 @@
select a.x, a.y, format(a.val, 2) "val", b.addr
from voc_vals a inner join voc_addr b
on a.x = b.x and a.y = b.y
- where date_format(a.create_time, '%Y%m%d%H') = ${time}
- and a.val > (select jcyj from alert_config);
+ where date_format(a.create_time, '%Y%m%d%H') = ${time} and a.val > 0.5;
</select>
<select id="countByTime" resultType="java.lang.Integer">
--
Gitblit v1.9.3