From 5528517471aff57961a527522b09305bcd99922d Mon Sep 17 00:00:00 2001 From: 648540858 <648540858@qq.com> Date: 星期二, 15 二月 2022 09:13:03 +0800 Subject: [PATCH] Merge pull request #325 from nikmu/wvp-28181-2.0 --- src/main/java/com/genersoft/iot/vmp/storager/dao/PlatformGbStreamMapper.java | 8 ++++++++ 1 files changed, 8 insertions(+), 0 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 d8ddabe..e4639e7 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 @@ -74,4 +74,12 @@ @Delete("DELETE FROM platform_gb_stream WHERE app=#{app} AND stream=#{stream} AND platformId=#{platformId}") int delByAppAndStreamAndPlatform(String app, String stream, String platformId); + + @Delete("<script> "+ + "DELETE FROM platform_gb_stream where " + + "<foreach collection='gbStreams' item='item' separator='or'>" + + "(app=#{item.app} and stream=#{item.stream}) " + + "</foreach>" + + "</script>") + void delByGbStreams(List<GbStream> gbStreams); } -- Gitblit v1.8.0