新增清除和删除的表

whycxzp

2021-09-08 fed319a1771b6cc6abdababa73055021a240d78b

新增清除和删除的表

 src/main/java/com/whyc/service/ClearTableService.java

@@ -129,6 +129,10 @@
        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("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();
@@ -156,6 +160,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);
        //传入需要删除的表对应的库名,表名