From d07a5680f3f25a9898a1d465d785f6c595a21005 Mon Sep 17 00:00:00 2001 From: 648540858 <648540858@qq.com> Date: 星期一, 07 二月 2022 18:30:43 +0800 Subject: [PATCH] 为推流列表增加批量移除功能 --- src/main/java/com/genersoft/iot/vmp/storager/dao/StreamPushMapper.java | 9 ++++++++- 1 files changed, 8 insertions(+), 1 deletions(-) diff --git a/src/main/java/com/genersoft/iot/vmp/storager/dao/StreamPushMapper.java b/src/main/java/com/genersoft/iot/vmp/storager/dao/StreamPushMapper.java index 3c43a9d..3379c9f 100644 --- a/src/main/java/com/genersoft/iot/vmp/storager/dao/StreamPushMapper.java +++ b/src/main/java/com/genersoft/iot/vmp/storager/dao/StreamPushMapper.java @@ -1,5 +1,6 @@ package com.genersoft.iot.vmp.storager.dao; +import com.genersoft.iot.vmp.gb28181.bean.GbStream; import com.genersoft.iot.vmp.media.zlm.dto.StreamPushItem; import org.apache.ibatis.annotations.*; import org.springframework.stereotype.Repository; @@ -48,7 +49,13 @@ "</script>") int delAll(List<StreamPushItem> streamPushItems); - + @Delete("<script> "+ + "DELETE FROM stream_push where " + + "<foreach collection='gbStreams' item='item' separator='or'>" + + "(app=#{item.app} and stream=#{item.stream}) " + + "</foreach>" + + "</script>") + int delAllForGbStream(List<GbStream> gbStreams); @Select(value = {" <script>" + -- Gitblit v1.8.0