From 0327d1602156510225e695a94147181d9f5db33b Mon Sep 17 00:00:00 2001
From: 648540858 <648540858@qq.com>
Date: 星期四, 17 二月 2022 15:33:25 +0800
Subject: [PATCH] 优化级联平台删除
---
src/main/java/com/genersoft/iot/vmp/storager/dao/PlatformGbStreamMapper.java | 9 +++++++--
1 files changed, 7 insertions(+), 2 deletions(-)
diff --git a/src/main/java/com/genersoft/iot/vmp/storager/dao/PlatformGbStreamMapper.java b/src/main/java/com/genersoft/iot/vmp/storager/dao/PlatformGbStreamMapper.java
index 1e15360..85310ed 100644
--- a/src/main/java/com/genersoft/iot/vmp/storager/dao/PlatformGbStreamMapper.java
+++ b/src/main/java/com/genersoft/iot/vmp/storager/dao/PlatformGbStreamMapper.java
@@ -95,6 +95,11 @@
"</script>")
void delByGbStreams(List<GbStream> gbStreams);
-
-
+ @Delete("<script> "+
+ "DELETE FROM platform_gb_stream where " +
+ "<foreach collection='gbStreams' item='item' separator='or'>" +
+ "(app=#{item.app} and stream=#{item.stream}) and platformId=#{platformId}" +
+ "</foreach>" +
+ "</script>")
+ void delByAppAndStreamsByPlatformId(List<GbStream> gbStreams, String platformId);
}
--
Gitblit v1.8.0