| | |
| | | package com.genersoft.iot.vmp.storager.dao; |
| | | |
| | | import com.genersoft.iot.vmp.media.zlm.dto.MediaServerItem; |
| | | import org.apache.ibatis.annotations.Insert; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | import org.apache.ibatis.annotations.Select; |
| | | import org.apache.ibatis.annotations.Update; |
| | | import org.apache.ibatis.annotations.*; |
| | | import org.springframework.stereotype.Repository; |
| | | |
| | | import java.util.List; |
| | |
| | | "rtspSSLPort, " + |
| | | "autoConfig, " + |
| | | "secret, " + |
| | | "streamNoneReaderDelayMS, " + |
| | | "rtpEnable, " + |
| | | "rtpPortRange, " + |
| | | "sendRtpPortRange, " + |
| | |
| | | "${rtspSSLPort}, " + |
| | | "${autoConfig}, " + |
| | | "'${secret}', " + |
| | | "${streamNoneReaderDelayMS}, " + |
| | | "${rtpEnable}, " + |
| | | "'${rtpPortRange}', " + |
| | | "'${sendRtpPortRange}', " + |
| | |
| | | "<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=\"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>" + |
| | |
| | | @Select("SELECT * FROM media_server") |
| | | List<MediaServerItem> queryAll(); |
| | | |
| | | @Select("DELETE FROM media_server WHERE id='${id}'") |
| | | @Delete("DELETE FROM media_server WHERE id='${id}'") |
| | | void delOne(String id); |
| | | |
| | | @Select("DELETE FROM media_server WHERE ip='${host}' and httpPort=${port}") |
| | | void delOneByIPAndPort(String host, int port); |
| | | |
| | | @Select("DELETE FROM media_server WHERE defaultServer=1;") |
| | | void delDefault(); |
| | | @Delete("DELETE FROM media_server WHERE defaultServer=1") |
| | | int delDefault(); |
| | | |
| | | @Select("SELECT * FROM media_server WHERE ip='${host}' and httpPort=${port}") |
| | | MediaServerItem queryOneByHostAndPort(String host, int port); |