| | |
| | | package com.genersoft.iot.vmp.storager.dao; |
| | | |
| | | import com.genersoft.iot.vmp.conf.MediaConfig; |
| | | import com.genersoft.iot.vmp.media.zlm.dto.IMediaServerItem; |
| | | import com.genersoft.iot.vmp.media.zlm.dto.MediaServerItem; |
| | | import org.apache.ibatis.annotations.Insert; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | |
| | | "streamNoneReaderDelayMS, " + |
| | | "rtpEnable, " + |
| | | "rtpPortRange, " + |
| | | "sendRtpPortRange, " + |
| | | "recordAssistPort, " + |
| | | "defaultServer, " + |
| | | "createTime, " + |
| | | "updateTime" + |
| | | ") VALUES " + |
| | |
| | | "${streamNoneReaderDelayMS}, " + |
| | | "${rtpEnable}, " + |
| | | "'${rtpPortRange}', " + |
| | | "'${sendRtpPortRange}', " + |
| | | "${recordAssistPort}, " + |
| | | "${defaultServer}, " + |
| | | "'${createTime}', " + |
| | | "'${updateTime}')") |
| | | int add(IMediaServerItem mediaServerItem); |
| | | int add(MediaServerItem mediaServerItem); |
| | | |
| | | @Update(value = {" <script>" + |
| | | "UPDATE media_server " + |
| | |
| | | "<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(IMediaServerItem mediaServerItem); |
| | | int update(MediaServerItem mediaServerItem); |
| | | |
| | | @Select("SELECT * FROM media_server WHERE id='${id}'") |
| | | MediaServerItem queryOne(String id); |
| | |
| | | List<MediaServerItem> queryAll(); |
| | | |
| | | @Select("DELETE FROM media_server WHERE id='${id}'") |
| | | int delOne(String secret); |
| | | 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(); |
| | | |
| | | @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(); |
| | | } |