wvp-pro.git - Gitblit

old mode 100644 new mode 100755

			@@ -13,9 +13,9 @@
			public interface StreamPushMapper {

			@Insert("INSERT INTO wvp_stream_push (app, stream, total_reader_count, origin_type, origin_type_str, " +
			"push_time, alive_second, media_server_id, server_id, update_time, create_time, push_ing, self) VALUES" +
			"push_time, alive_second, media_server_id, update_time, create_time, push_ing, self) VALUES" +
			"(#{app}, #{stream}, #{totalReaderCount}, #{originType}, #{originTypeStr}, " +
			"#{pushTime}, #{aliveSecond}, #{mediaServerId} , #{serverId} , #{updateTime} , #{createTime}, " +
			"#{pushTime}, #{aliveSecond}, #{mediaServerId} , #{updateTime} , #{createTime}, " +
			"#{pushIng}, #{self} )")
			int add(StreamPushItem streamPushItem);

			@@ -102,7 +102,15 @@
			@Delete("DELETE FROM wvp_stream_push")
			void clear();

			@Delete("DELETE sp FROM wvp_stream_push sp left join wvp_gb_stream gs on gs.app = sp.app and gs.stream= sp.stream WHERE sp.media_server_id=#{mediaServerId} and gs.gb_id is null ")
			@Delete("delete" +
			" from wvp_stream_push " +
			" where id in " +
			" (select temp.id from " +
			" (select wgs.gb_stream_id as id " +
			" from wvp_gb_stream wgs" +
			" left join wvp_stream_push sp on sp.id = wgs.gb_stream_id" +
			" where wgs.gb_id is null and wgs.media_server_id = #{mediaServerId}) temp)"
			)
			void deleteWithoutGBId(String mediaServerId);

			@Select("SELECT * FROM wvp_stream_push WHERE media_server_id=#{mediaServerId}")