From 9d87378fe981389b4b86819e69c5359675968f98 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期四, 02 三月 2023 18:00:20 +0800
Subject: [PATCH] 1
---
src/main/java/com/lf/server/service/data/MetaService.java | 19 +++++++++++++++++--
1 files changed, 17 insertions(+), 2 deletions(-)
diff --git a/src/main/java/com/lf/server/service/data/MetaService.java b/src/main/java/com/lf/server/service/data/MetaService.java
index 03ae908..25b734b 100644
--- a/src/main/java/com/lf/server/service/data/MetaService.java
+++ b/src/main/java/com/lf/server/service/data/MetaService.java
@@ -148,10 +148,25 @@
/**
* 鑾峰彇鍒犻櫎琛ㄨ褰昐QL
*/
- private String getDelTabsSql(List<MetaEntity> metas) {
+ public String getDelTabsSql(List<MetaEntity> metas) {
List<String> list = new ArrayList<>();
+ String tab = metas.get(0).getTab();
+
+ List<String> pids = new ArrayList<>();
for (MetaEntity me : metas) {
- list.add(String.format("delete from %s where parentid='%s'", me.getTab(), me.getEventid()));
+ if (tab.equals(me.getTab())) {
+ pids.add("'" + me.getEventid() + "'");
+ } else {
+ list.add(String.format("delete from %s where parentid in (%s)", tab, StringHelper.join(pids, ",")));
+
+ pids.clear();
+ tab = me.getTab();
+ pids.add("'" + me.getEventid() + "'");
+ }
+ }
+
+ if (pids.size() > 0) {
+ list.add(String.format("delete from %s where parentid in (%s)", tab, StringHelper.join(pids, ",")));
}
return StringHelper.join(list, ";");
--
Gitblit v1.9.3