From d866a0c52c419156941801ea0008643d1c7f0e04 Mon Sep 17 00:00:00 2001
From: lizijie <lzjiiie@163.com>
Date: Wed, 05 Jan 2022 16:18:59 +0800
Subject: [PATCH] 新建污染警报小时表定时任务
---
screen-job/src/main/java/com/moral/api/service/AlarmInfoService.java | 9 +++++++++
screen-job/src/main/java/com/moral/api/service/impl/AlarmInfoServiceImpl.java | 8 ++++++++
screen-job/src/main/resources/mapper/AlarmInfoMapper.xml | 13 +++++++++++++
screen-job/src/main/java/com/moral/api/mapper/AlarmInfoMapper.java | 2 ++
screen-job/src/main/java/com/moral/api/task/CreateTableTask.java | 17 +++++++++++++++++
5 files changed, 49 insertions(+), 0 deletions(-)
diff --git a/screen-job/src/main/java/com/moral/api/mapper/AlarmInfoMapper.java b/screen-job/src/main/java/com/moral/api/mapper/AlarmInfoMapper.java
index 3918cc5..b555155 100644
--- a/screen-job/src/main/java/com/moral/api/mapper/AlarmInfoMapper.java
+++ b/screen-job/src/main/java/com/moral/api/mapper/AlarmInfoMapper.java
@@ -13,4 +13,6 @@
*/
public interface AlarmInfoMapper extends BaseMapper<AlarmInfo> {
+ void createTable(String timeUnits);
+
}
diff --git a/screen-job/src/main/java/com/moral/api/service/AlarmInfoService.java b/screen-job/src/main/java/com/moral/api/service/AlarmInfoService.java
index 1422563..d9ddea0 100644
--- a/screen-job/src/main/java/com/moral/api/service/AlarmInfoService.java
+++ b/screen-job/src/main/java/com/moral/api/service/AlarmInfoService.java
@@ -12,5 +12,14 @@
* @since 2021-11-12
*/
public interface AlarmInfoService extends IService<AlarmInfo> {
+
+ /**
+ *@Description: ���������������������
+ *@Param: [timeUnits]
+ *@return: void
+ *@Author: lizijie
+ *@Date: 2022/1/5 15:55
+ **/
+ void createTable(String timeUnits);
}
diff --git a/screen-job/src/main/java/com/moral/api/service/impl/AlarmInfoServiceImpl.java b/screen-job/src/main/java/com/moral/api/service/impl/AlarmInfoServiceImpl.java
index d42f834..03b3456 100644
--- a/screen-job/src/main/java/com/moral/api/service/impl/AlarmInfoServiceImpl.java
+++ b/screen-job/src/main/java/com/moral/api/service/impl/AlarmInfoServiceImpl.java
@@ -4,6 +4,7 @@
import com.moral.api.mapper.AlarmInfoMapper;
import com.moral.api.service.AlarmInfoService;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
/**
@@ -17,4 +18,11 @@
@Service
public class AlarmInfoServiceImpl extends ServiceImpl<AlarmInfoMapper, AlarmInfo> implements AlarmInfoService {
+ @Autowired
+ private AlarmInfoMapper alarmInfoMapper;
+
+ @Override
+ public void createTable(String timeUnits) {
+ alarmInfoMapper.createTable(timeUnits);
+ }
}
diff --git a/screen-job/src/main/java/com/moral/api/task/CreateTableTask.java b/screen-job/src/main/java/com/moral/api/task/CreateTableTask.java
index 514aa54..b6e0621 100644
--- a/screen-job/src/main/java/com/moral/api/task/CreateTableTask.java
+++ b/screen-job/src/main/java/com/moral/api/task/CreateTableTask.java
@@ -1,5 +1,6 @@
package com.moral.api.task;
+import com.moral.api.service.AlarmInfoService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;
@@ -23,6 +24,9 @@
@Autowired
private HistoryHourlyService historyHourlyService;
+
+ @Autowired
+ private AlarmInfoService alarmInfoService;
//���������������������
@@ -82,4 +86,17 @@
}
return ReturnT.SUCCESS;
}
+
+ //���������������������
+ @XxlJob("createAlarmInfoTable")
+ public ReturnT createAlarmInfoTable() {
+ String timeUnits = DateUtils.getDateStringOfMon(1, DateUtils.yyyyMM_EN);
+ try {
+ alarmInfoService.createTable(timeUnits);
+ } catch (Exception e) {
+ XxlJobHelper.log(e.getMessage());
+ return new ReturnT(ReturnT.FAIL_CODE, e.getMessage());
+ }
+ return ReturnT.SUCCESS;
+ }
}
diff --git a/screen-job/src/main/resources/mapper/AlarmInfoMapper.xml b/screen-job/src/main/resources/mapper/AlarmInfoMapper.xml
index 7cf5bc0..ce72da2 100644
--- a/screen-job/src/main/resources/mapper/AlarmInfoMapper.xml
+++ b/screen-job/src/main/resources/mapper/AlarmInfoMapper.xml
@@ -13,4 +13,17 @@
<result column="create_time" property="createTime" />
</resultMap>
+ <update id="createTable" parameterType="String">
+ CREATE TABLE IF NOT EXISTS `alarm_info_${timeUnits}` (
+ `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
+ `alarm_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '������������',
+ `index` varchar(255) NOT NULL COMMENT '������������������',
+ `device_id` int(11) NOT NULL COMMENT '������������������',
+ `alarm_type` varchar(255) NOT NULL COMMENT '������������',
+ `alarm_information` varchar(255) NOT NULL COMMENT '������������',
+ `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '������������',
+ PRIMARY KEY (`id`)
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT '���������������������';
+ </update>
+
</mapper>
\ No newline at end of file
--
Gitblit v1.8.0