| | |
| | | "geo_coord_sys," + |
| | | "on_line," + |
| | | "media_server_id," + |
| | | "switch_primary_sub_stream," + |
| | | "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,"+ |
| | | "switch_primary_sub_stream switchPrimarySubStream,"+ |
| | | "(SELECT count(0) FROM wvp_device_channel WHERE device_id=de.device_id) as channel_count " + |
| | | "FROM wvp_device de" + |
| | | "<if test=\"onLine != null\"> where on_line=${onLine}</if>"+ |
| | |
| | | "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=\"switchPrimarySubStream != null\">, switch_primary_sub_stream=#{switchPrimarySubStream}</if>" + |
| | | "<if test=\"mediaServerId != null\">, media_server_id=#{mediaServerId}</if>" + |
| | | "WHERE device_id=#{deviceId}"+ |
| | | " </script>"}) |
| | |
| | | "charset,"+ |
| | | "ssrc_check,"+ |
| | | "as_message_channel,"+ |
| | | "broadcast_push_after_ack,"+ |
| | | "geo_coord_sys,"+ |
| | | "on_line,"+ |
| | | "media_server_id,"+ |
| | | "switch_primary_sub_stream"+ |
| | | "media_server_id"+ |
| | | ") VALUES (" + |
| | | "#{deviceId}," + |
| | | "#{name}," + |
| | |
| | | "#{charset}," + |
| | | "#{ssrcCheck}," + |
| | | "#{asMessageChannel}," + |
| | | "#{broadcastPushAfterAck}," + |
| | | "#{geoCoordSys}," + |
| | | "#{onLine}," + |
| | | "#{mediaServerId}," + |
| | | "#{switchPrimarySubStream}" + |
| | | "#{mediaServerId}" + |
| | | ")") |
| | | void addCustomDevice(Device device); |
| | | |