From 4ef1277c1620af475d1dd656bae7db31710197bb Mon Sep 17 00:00:00 2001
From: 648540858 <648540858@qq.com>
Date: 星期五, 27 十月 2023 18:12:25 +0800
Subject: [PATCH] 优化sql
---
src/main/java/com/genersoft/iot/vmp/storager/dao/CloudRecordServiceMapper.java | 16 +++-------------
1 files changed, 3 insertions(+), 13 deletions(-)
diff --git a/src/main/java/com/genersoft/iot/vmp/storager/dao/CloudRecordServiceMapper.java b/src/main/java/com/genersoft/iot/vmp/storager/dao/CloudRecordServiceMapper.java
index f8ceaf4..5fdf2f5 100644
--- a/src/main/java/com/genersoft/iot/vmp/storager/dao/CloudRecordServiceMapper.java
+++ b/src/main/java/com/genersoft/iot/vmp/storager/dao/CloudRecordServiceMapper.java
@@ -79,7 +79,7 @@
"update wvp_cloud_record set collect = #{collect} where file_path in " +
" <foreach collection='cloudRecordItemList' item='item' open='(' separator=',' close=')' > #{item.filePath}</foreach>" +
" </script>")
- void updateCollectList(@Param("collect") boolean collect, List<CloudRecordItem> cloudRecordItemList);
+ int updateCollectList(@Param("collect") boolean collect, List<CloudRecordItem> cloudRecordItemList);
@Delete(" <script>" +
"delete from wvp_cloud_record where media_server_id=#{mediaServerId} file_path in " +
@@ -91,7 +91,7 @@
@Select(" <script>" +
"select file_path" +
" from wvp_cloud_record " +
- " where collect = false and reserve = false " +
+ " where collect = false " +
" <if test= 'endTimeStamp != null '> and start_time <= #{endTimeStamp}</if>" +
" <if test= 'callId != null '> and call_id = #{callId}</if>" +
" <if test= 'mediaServerId != null ' > and media_server_id = #{mediaServerId} </if>" +
@@ -99,18 +99,8 @@
List<String> queryRecordFilePathListForDelete(@Param("endTimeStamp")Long endTimeStamp, String mediaServerId);
@Update(" <script>" +
- "update wvp_cloud_record set reserve = #{reserve} where file_path in " +
- " <foreach collection='cloudRecordItems' item='item' open='(' separator=',' close=')' > #{item.filePath}</foreach>" +
- " </script>")
- void updateReserveList(@Param("reserve") boolean reserve,List<CloudRecordItem> cloudRecordItems);
-
- @Update(" <script>" +
"update wvp_cloud_record set collect = #{collect} where id = #{recordId} " +
" </script>")
- void changeCollectById(@Param("collect") boolean collect, @Param("recordId") Integer recordId);
+ int changeCollectById(@Param("collect") boolean collect, @Param("recordId") Integer recordId);
- @Update(" <script>" +
- "update wvp_cloud_record set reserve = #{reserve} where id = #{recordId} " +
- " </script>")
- void changeReserveById(@Param("reserve") boolean reserve, Integer recordId);
}
--
Gitblit v1.8.0