| | |
| | | "geo_coord_sys," + |
| | | "on_line," + |
| | | "media_server_id," + |
| | | "broadcast_push_after_ack," + |
| | | "(SELECT count(0) FROM wvp_device_channel WHERE device_id=wvp_device.device_id) as channel_count "+ |
| | | " FROM wvp_device WHERE device_id = #{deviceId}") |
| | | Device getDeviceByDeviceId(String deviceId); |
| | |
| | | "subscribe_cycle_for_alarm,"+ |
| | | "ssrc_check,"+ |
| | | "as_message_channel,"+ |
| | | "broadcast_push_after_ack,"+ |
| | | "geo_coord_sys,"+ |
| | | "on_line"+ |
| | | ") VALUES (" + |
| | |
| | | "#{subscribeCycleForAlarm}," + |
| | | "#{ssrcCheck}," + |
| | | "#{asMessageChannel}," + |
| | | "#{broadcastPushAfterAck}," + |
| | | "#{geoCoordSys}," + |
| | | "#{onLine}" + |
| | | ")") |
| | |
| | | "subscribe_cycle_for_alarm,"+ |
| | | "ssrc_check,"+ |
| | | "as_message_channel,"+ |
| | | "broadcast_push_after_ack,"+ |
| | | "geo_coord_sys,"+ |
| | | "on_line,"+ |
| | | "media_server_id,"+ |
| | |
| | | "subscribe_cycle_for_alarm,"+ |
| | | "ssrc_check,"+ |
| | | "as_message_channel,"+ |
| | | "broadcast_push_after_ack,"+ |
| | | "geo_coord_sys,"+ |
| | | "on_line"+ |
| | | " FROM wvp_device WHERE on_line = true") |
| | |
| | | "subscribe_cycle_for_alarm,"+ |
| | | "ssrc_check,"+ |
| | | "as_message_channel,"+ |
| | | "broadcast_push_after_ack,"+ |
| | | "geo_coord_sys,"+ |
| | | "on_line"+ |
| | | " FROM wvp_device WHERE ip = #{host} AND port=#{port}") |
| | |
| | | "<if test=\"subscribeCycleForAlarm != null\">, subscribe_cycle_for_alarm=#{subscribeCycleForAlarm}</if>" + |
| | | "<if test=\"ssrcCheck != null\">, ssrc_check=#{ssrcCheck}</if>" + |
| | | "<if test=\"asMessageChannel != null\">, as_message_channel=#{asMessageChannel}</if>" + |
| | | "<if test=\"broadcastPushAfterAck != null\">, broadcast_push_after_ack=#{broadcastPushAfterAck}</if>" + |
| | | "<if test=\"geoCoordSys != null\">, geo_coord_sys=#{geoCoordSys}</if>" + |
| | | "<if test=\"mediaServerId != null\">, media_server_id=#{mediaServerId}</if>" + |
| | | "WHERE device_id=#{deviceId}"+ |
| | |
| | | "charset,"+ |
| | | "ssrc_check,"+ |
| | | "as_message_channel,"+ |
| | | "broadcast_push_after_ack,"+ |
| | | "geo_coord_sys,"+ |
| | | "on_line,"+ |
| | | "media_server_id"+ |
| | |
| | | "#{charset}," + |
| | | "#{ssrcCheck}," + |
| | | "#{asMessageChannel}," + |
| | | "#{broadcastPushAfterAck}," + |
| | | "#{geoCoordSys}," + |
| | | "#{onLine}," + |
| | | "#{mediaServerId}" + |