From 358ae8bb194bde152b62b492adfaf743b0ef45c8 Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期五, 09 六月 2023 15:34:42 +0800
Subject: [PATCH] 2.db_pwrdev_alarm.tb_pwrdev_alarm_param_forsx 新增字段 `alarm_limitH_upper` float NOT NULL DEFAULT '200' COMMENT '告警上上限阈值', `alarm_limitL_lower` float NOT NULL DEFAULT '0' COMMENT '告警下下限阈值',
---
BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Alarm.java | 43 +++++++++++++++++++++++++++++++++++++++++++
1 files changed, 43 insertions(+), 0 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Alarm.java b/BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Alarm.java
index a030ad7..7d359fb 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Alarm.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Alarm.java
@@ -181,6 +181,7 @@
" `alm_cleared_type` int(11) NOT NULL DEFAULT '0'," +
" `usr_Id` int(11) NOT NULL DEFAULT '0'," +
" `alm_trigger` int(11) NOT NULL DEFAULT '0' COMMENT '告警来源[0-来源于点表；1-来源于电源告警参数]'," +
+ " `alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT '告警重要等级[0:重要；1:紧急]'," +
" PRIMARY KEY (`num`)," +
" KEY `index_record_id` (`record_id`)," +
" KEY `index_pwrdev_id` (`PowerDeviceId`)," +
@@ -225,6 +226,16 @@
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_Table
+ " ADD COLUMN `alm_trigger` int(11) NOT NULL DEFAULT '0' COMMENT '告警触发来源[0-来源于点表；1-来源于电源告警参数]'");
}
+ res = null;
+ //添加 alm_severity 告警重要等级[0:重要；1:紧急]
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_pwrdev_alarm'"
+ + " AND table_name='tb_pwrdev_alarm'"
+ + " AND column_name='alm_severity'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_Table
+ + " ADD COLUMN `alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT '告警重要等级[0:重要；1:紧急]'");
+ }
} catch (SQLException e) {
e.printStackTrace();
} finally {
@@ -255,6 +266,7 @@
" `alm_cleared_type` int(11) NOT NULL DEFAULT '0'," +
" `usr_Id` int(11) NOT NULL DEFAULT '0'," +
" `alm_trigger` int(11) NOT NULL DEFAULT '0' COMMENT '告警触发来源[0-来源于点表；1-来源于电源告警参数]'," +
+ " `alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT '告警重要等级[0:重要；1:紧急]'," +
" PRIMARY KEY (`num`)," +
" KEY `index_record_id` (`record_id`)," +
" KEY `index_pwrdev_id` (`PowerDeviceId`)," +
@@ -299,6 +311,15 @@
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_History_Table
+ " ADD COLUMN `alm_trigger` int(11) NOT NULL DEFAULT '0' COMMENT '告警触发来源[0-来源于点表；1-来源于电源告警参数]'");
}
+ //添加 alm_severity -- 告警重要等级[0:重要；1:紧急]
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_pwrdev_alarm'"
+ + " AND table_name='tb_pwrdev_alarm_history'"
+ + " AND column_name='alm_severity'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_History_Table
+ + " ADD COLUMN `alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT '告警重要等级[0:重要；1:紧急]'");
+ }
} catch (SQLException e) {
e.printStackTrace();
} finally {
@@ -321,6 +342,8 @@
" `alarm_name` varchar(255) NOT NULL DEFAULT '' COMMENT '当前告警描述'," +
" `alarm_type` int(11) NOT NULL DEFAULT '0' COMMENT '0-上下限有效 1-上限有效 2-下限有效'," +
" `alarm_en_node` int(4) NOT NULL DEFAULT '1' COMMENT '告警来源是点位时告警使能[0:不启用；1：启用]'," +
+ " `alarm_limitH_upper` float NOT NULL DEFAULT '200' COMMENT '告警上上限阈值'," +
+ " `alarm_limitL_lower` float NOT NULL DEFAULT '0' COMMENT '告警下下限阈值'," +
" PRIMARY KEY (`num`)" +
") ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='山西电源告警参数表';";
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
@@ -340,6 +363,26 @@
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table
+ " ADD COLUMN `alarm_en_node` int(4) NOT NULL DEFAULT '1' COMMENT '告警来源是点位时告警使能[0:不启用；1：启用]';");
}
+ res = null;
+ //添加 alarm_limitH_upper -- 告警上上限阈值
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_pwrdev_alarm'"
+ + " AND table_name='tb_pwrdev_alarm_param_forsx'"
+ + " AND column_name='alarm_limitH_upper'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table
+ + " ADD COLUMN `alarm_limitH_upper` float NOT NULL DEFAULT '200' COMMENT '告警上上限阈值';");
+ }
+ res = null;
+ //添加 alarm_limitL_lower -- 告警下下限阈值
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_pwrdev_alarm'"
+ + " AND table_name='tb_pwrdev_alarm_param_forsx'"
+ + " AND column_name='alarm_limitL_lower'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table
+ + " ADD COLUMN `alarm_limitL_lower` float NOT NULL DEFAULT '0' COMMENT '告警下下限阈值';");
+ }
res = sql.sqlMysqlQuery("SELECT PowerDeviceId FROM " + Sql_Mysql.Pwrdev_Inf_Table);
--
Gitblit v1.9.1