From d68f9c813341afa82726e6182cca8af61248fc5e Mon Sep 17 00:00:00 2001 From: 648540858 <648540858@qq.com> Date: 星期一, 06 十二月 2021 10:44:33 +0800 Subject: [PATCH] 修复选择直播通道缺失了通道类型的问题 --- src/main/java/com/genersoft/iot/vmp/storager/dao/MediaServerMapper.java | 30 ++++++++++++++++++++++++++++++ 1 files changed, 30 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/genersoft/iot/vmp/storager/dao/MediaServerMapper.java b/src/main/java/com/genersoft/iot/vmp/storager/dao/MediaServerMapper.java index 2167c55..aaa1845 100644 --- a/src/main/java/com/genersoft/iot/vmp/storager/dao/MediaServerMapper.java +++ b/src/main/java/com/genersoft/iot/vmp/storager/dao/MediaServerMapper.java @@ -32,6 +32,7 @@ "streamNoneReaderDelayMS, " + "rtpEnable, " + "rtpPortRange, " + + "sendRtpPortRange, " + "recordAssistPort, " + "defaultServer, " + "createTime, " + @@ -55,6 +56,7 @@ "${streamNoneReaderDelayMS}, " + "${rtpEnable}, " + "'${rtpPortRange}', " + + "'${sendRtpPortRange}', " + "${recordAssistPort}, " + "${defaultServer}, " + "'${createTime}', " + @@ -79,11 +81,36 @@ "<if test=\"streamNoneReaderDelayMS != null\">, streamNoneReaderDelayMS=${streamNoneReaderDelayMS}</if>" + "<if test=\"rtpEnable != null\">, rtpEnable=${rtpEnable}</if>" + "<if test=\"rtpPortRange != null\">, rtpPortRange='${rtpPortRange}'</if>" + + "<if test=\"sendRtpPortRange != null\">, sendRtpPortRange='${sendRtpPortRange}'</if>" + "<if test=\"secret != null\">, secret='${secret}'</if>" + "<if test=\"recordAssistPort != null\">, recordAssistPort=${recordAssistPort}</if>" + "WHERE id='${id}'"+ " </script>"}) int update(MediaServerItem mediaServerItem); + + @Update(value = {" <script>" + + "UPDATE media_server " + + "SET updateTime='${updateTime}'" + + "<if test=\"id != null\">, id='${id}'</if>" + + "<if test=\"hookIp != null\">, hookIp='${hookIp}'</if>" + + "<if test=\"sdpIp != null\">, sdpIp='${sdpIp}'</if>" + + "<if test=\"streamIp != null\">, streamIp='${streamIp}'</if>" + + "<if test=\"httpSSlPort != null\">, httpSSlPort=${httpSSlPort}</if>" + + "<if test=\"rtmpPort != null\">, rtmpPort=${rtmpPort}</if>" + + "<if test=\"rtmpSSlPort != null\">, rtmpSSlPort=${rtmpSSlPort}</if>" + + "<if test=\"rtpProxyPort != null\">, rtpProxyPort=${rtpProxyPort}</if>" + + "<if test=\"rtspPort != null\">, rtspPort=${rtspPort}</if>" + + "<if test=\"rtspSSLPort != null\">, rtspSSLPort=${rtspSSLPort}</if>" + + "<if test=\"autoConfig != null\">, autoConfig=${autoConfig}</if>" + + "<if test=\"streamNoneReaderDelayMS != null\">, streamNoneReaderDelayMS=${streamNoneReaderDelayMS}</if>" + + "<if test=\"rtpEnable != null\">, rtpEnable=${rtpEnable}</if>" + + "<if test=\"rtpPortRange != null\">, rtpPortRange='${rtpPortRange}'</if>" + + "<if test=\"sendRtpPortRange != null\">, sendRtpPortRange='${sendRtpPortRange}'</if>" + + "<if test=\"secret != null\">, secret='${secret}'</if>" + + "<if test=\"recordAssistPort != null\">, recordAssistPort=${recordAssistPort}</if>" + + "WHERE ip='${ip}' and httpPort=${httpPort}"+ + " </script>"}) + int updateByHostAndPort(MediaServerItem mediaServerItem); @Select("SELECT * FROM media_server WHERE id='${id}'") MediaServerItem queryOne(String id); @@ -102,4 +129,7 @@ @Select("SELECT * FROM media_server WHERE ip='${host}' and httpPort=${port}") MediaServerItem queryOneByHostAndPort(String host, int port); + + @Select("SELECT * FROM media_server WHERE defaultServer=1") + MediaServerItem queryDefault(); } -- Gitblit v1.8.0