From e9f7312050bfefbd1afa6921a7ddd854fb4aff8f Mon Sep 17 00:00:00 2001
From: whycxzp <perryhsu@163.com>
Date: 星期三, 12 一月 2022 11:10:33 +0800
Subject: [PATCH] 更新
---
src/main/java/com/whyc/service/ClearTableService.java | 29 +++++++++++++++++++++++++++++
1 files changed, 29 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/whyc/service/ClearTableService.java b/src/main/java/com/whyc/service/ClearTableService.java
index 2e4efef..e956679 100644
--- a/src/main/java/com/whyc/service/ClearTableService.java
+++ b/src/main/java/com/whyc/service/ClearTableService.java
@@ -129,6 +129,29 @@
tableList.add(new TableDTO("web_site","tb_devstate_usr"));
tableList.add(new TableDTO("web_site","tb_devtmp_record"));
tableList.add(new TableDTO("web_site","tb_stationtraffic"));
+ tableList.add(new TableDTO("web_site","tb_database_backup"));
+ tableList.add(new TableDTO("db_analysis","tb_mon_cap"));
+ tableList.add(new TableDTO("db_analysis","tb_mon_res"));
+ tableList.add(new TableDTO("db_analysis","tb_mon_tmp"));
+ tableList.add(new TableDTO("db_analysis","tb_mon_vol"));
+
+ //杩涜涓�娆¤繃婊�,鏌ヨ鍑烘潵鎵�鏈夌殑搴撲腑琛�
+ List<TableDTO> tableList2 = mapper.findAllTables();
+ for (int i = 0; i < tableList.size(); i++) {
+ boolean compareFlag = false;
+ for (int j = 0; j < tableList2.size(); j++) {
+ if((tableList.get(i).getDbName()+tableList.get(i).getTableName())
+ .equals(tableList2.get(j).getDbName()+tableList2.get(j).getTableName())){
+ compareFlag = true;
+ break;
+ }
+ }
+ //鍖归厤ok
+ if(!compareFlag){
+ tableList.remove(i);
+ i--;
+ }
+ }
mapper.clearTable(tableList);
}
@@ -138,6 +161,9 @@
tableList.add(new TableDTO("db_batt_history","tb_batt_realdata_"));
tableList.add(new TableDTO("db_pwrdev_alarm","tb_pwrdev_alarm_param_"));
tableList.add(new TableDTO("db_pwrdev_data_history","tb_pwrdev_historydata_"));
+ tableList.add(new TableDTO("db_pwrdev_data_history","tb_pwrdev_historydata_"));
+ tableList.add(new TableDTO("db_batt_testdata","tb_battresdata_"));
+ tableList.add(new TableDTO("db_batt_testdata","tb_batttestdatastop_"));
//鏌ヨ搴撲腑闇�瑕佸垹闄ょ殑琛ㄥ悕
List<TableDTO> resTableList = findTableListLike(tableList);
//浼犲叆闇�瑕佸垹闄ょ殑琛ㄥ搴旂殑搴撳悕,琛ㄥ悕
@@ -150,4 +176,7 @@
return mapper.findTableListLike(tableList);
}
+ public void clearColumn() {
+ mapper.clearColumn();
+ }
}
--
Gitblit v1.9.1