| | |
| | | @Update("UPDATE parent_platform " + |
| | | "SET enable=#{enable}, " + |
| | | "name=#{name}," + |
| | | "serverGBId=#{serverGBId}," + |
| | | "deviceGBId=#{deviceGBId}," + |
| | | "serverGBDomain=#{serverGBDomain}, " + |
| | | "serverIP=#{serverIP}," + |
| | | "serverPort=#{serverPort}, " + |
| | |
| | | "PTZEnable=#{PTZEnable}, " + |
| | | "rtcp=#{rtcp}, " + |
| | | "status=#{status} " + |
| | | "WHERE deviceGBId=#{deviceGBId}") |
| | | "WHERE serverGBId=#{serverGBId}") |
| | | int updateParentPlatform(ParentPlatform parentPlatform); |
| | | |
| | | @Delete("DELETE FROM parent_platform WHERE deviceGBId=#{deviceGBId}") |
| | | @Delete("DELETE FROM parent_platform WHERE serverGBId=#{serverGBId}") |
| | | int delParentPlatform(ParentPlatform parentPlatform); |
| | | |
| | | @Select("SELECT * FROM parent_platform") |
| | | @Select("SELECT *,( SELECT count(0) FROM platform_gb_channel pc WHERE pc.platformId = pp.serverGBId) as channelCount FROM parent_platform pp ") |
| | | List<ParentPlatform> getParentPlatformList(); |
| | | |
| | | @Select("SELECT * FROM parent_platform WHERE enable=#{enable}") |
| | | List<ParentPlatform> getEnableParentPlatformList(boolean enable); |
| | | |
| | | @Select("SELECT * FROM parent_platform WHERE deviceGBId=#{platformGbId}") |
| | | @Select("SELECT * FROM parent_platform WHERE serverGBId=#{platformGbId}") |
| | | ParentPlatform getParentPlatById(String platformGbId); |
| | | |
| | | @Update("UPDATE parent_platform SET status=false" ) |