From a3649ca243f827f78b85dbb41af2c3d7d978aa89 Mon Sep 17 00:00:00 2001
From: panlinlin <648540858@qq.com>
Date: 星期二, 27 四月 2021 15:38:00 +0800
Subject: [PATCH] 优化mysql建库脚本
---
src/main/java/com/genersoft/iot/vmp/media/zlm/ZLMMediaListManager.java | 170 +++++++++++++++++++++++++++++++++++++++-----------------
1 files changed, 118 insertions(+), 52 deletions(-)
diff --git a/src/main/java/com/genersoft/iot/vmp/media/zlm/ZLMMediaListManager.java b/src/main/java/com/genersoft/iot/vmp/media/zlm/ZLMMediaListManager.java
index 5ffa467..a50b170 100644
--- a/src/main/java/com/genersoft/iot/vmp/media/zlm/ZLMMediaListManager.java
+++ b/src/main/java/com/genersoft/iot/vmp/media/zlm/ZLMMediaListManager.java
@@ -3,17 +3,18 @@
import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
-import com.alibaba.fastjson.TypeReference;
-import com.genersoft.iot.vmp.common.RealVideo;
-import com.genersoft.iot.vmp.gb28181.bean.SendRtpItem;
-import com.genersoft.iot.vmp.gb28181.session.SsrcUtil;
-import com.genersoft.iot.vmp.media.zlm.dto.MediaItem;
+import com.genersoft.iot.vmp.conf.MediaServerConfig;
+import com.genersoft.iot.vmp.media.zlm.dto.StreamProxyItem;
+import com.genersoft.iot.vmp.media.zlm.dto.StreamPushItem;
+import com.genersoft.iot.vmp.gb28181.bean.GbStream;
+import com.genersoft.iot.vmp.service.IStreamPushService;
import com.genersoft.iot.vmp.storager.IRedisCatchStorage;
-import com.genersoft.iot.vmp.storager.impl.RedisCatchStorageImpl;
+import com.genersoft.iot.vmp.storager.IVideoManagerStorager;
+import com.genersoft.iot.vmp.storager.dao.GbStreamMapper;
+import com.genersoft.iot.vmp.storager.dao.PlatformGbStreamMapper;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
-import org.springframework.beans.factory.annotation.Value;
import org.springframework.stereotype.Component;
import java.util.*;
@@ -29,60 +30,125 @@
@Autowired
private IRedisCatchStorage redisCatchStorage;
+ @Autowired
+ private IVideoManagerStorager storager;
+
+ @Autowired
+ private GbStreamMapper gbStreamMapper;
+
+ @Autowired
+ private PlatformGbStreamMapper platformGbStreamMapper;
+
+ @Autowired
+ private IStreamPushService streamPushService;
+
+ @Autowired
+ private ZLMHttpHookSubscribe subscribe;
+
public void updateMediaList() {
- JSONObject mediaList = zlmresTfulUtils.getMediaList();
- if (mediaList == null) return;
- String dataStr = mediaList.getString("data");
+ storager.clearMediaList();
- Integer code = mediaList.getInteger("code");
- Map<String, RealVideo> result = new HashMap<>();
- if (code == 0 ) {
- if (dataStr != null) {
- List<MediaItem> mediaItems = JSON.parseObject(dataStr, new TypeReference<List<MediaItem>>() {});
- for (MediaItem item : mediaItems) {
- if ("rtp".equals(item.getApp())) {
- continue;
- }
- String key = item.getApp() + "_" + item.getStream();
- RealVideo realVideo = result.get(key);
- if (realVideo == null) {
- realVideo = new RealVideo();
- realVideo.setApp(item.getApp());
- realVideo.setStream(item.getStream());
- realVideo.setAliveSecond(item.getAliveSecond());
- realVideo.setCreateStamp(item.getCreateStamp());
- realVideo.setOriginSock(item.getOriginSock());
- realVideo.setTotalReaderCount(item.getTotalReaderCount());
- realVideo.setOriginType(item.getOriginType());
- realVideo.setOriginTypeStr(item.getOriginTypeStr());
- realVideo.setOriginUrl(item.getOriginUrl());
- realVideo.setCreateStamp(item.getCreateStamp());
- realVideo.setAliveSecond(item.getAliveSecond());
+ // 浣跨敤寮傛鐨勫綋鏃舵洿鏂板獟浣撴祦鍒楄〃
+ zlmresTfulUtils.getMediaList((mediaList ->{
+ if (mediaList == null) return;
+ String dataStr = mediaList.getString("data");
- ArrayList<RealVideo.MediaSchema> mediaSchemas = new ArrayList<>();
- realVideo.setSchemas(mediaSchemas);
- realVideo.setTracks(item.getTracks());
- realVideo.setVhost(item.getVhost());
- result.put(key, realVideo);
- }
-
- RealVideo.MediaSchema mediaSchema = new RealVideo.MediaSchema();
- mediaSchema.setSchema(item.getSchema());
- mediaSchema.setBytesSpeed(item.getBytesSpeed());
- realVideo.getSchemas().add(mediaSchema);
+ Integer code = mediaList.getInteger("code");
+ Map<String, StreamPushItem> result = new HashMap<>();
+ List<StreamPushItem> streamPushItems = null;
+ // 鑾峰彇鎵�鏈夌殑鍥芥爣鍏宠仈
+ List<GbStream> gbStreams = gbStreamMapper.selectAll();
+ if (code == 0 ) {
+ if (dataStr != null) {
+ streamPushItems = streamPushService.handleJSON(dataStr);
}
-
+ }else {
+ logger.warn("鏇存柊瑙嗛娴佸け璐ワ紝閿欒code锛� " + code);
}
- }else {
- logger.warn("鏇存柊瑙嗛娴佸け璐ワ紝閿欒code锛� " + code);
- }
- List<RealVideo> realVideos = new ArrayList<>(result.values());
- Collections.sort(realVideos);
- redisCatchStorage.updateMediaList(realVideos);
+ if (streamPushItems != null) {
+ storager.updateMediaList(streamPushItems);
+ for (StreamPushItem streamPushItem : streamPushItems) {
+ JSONObject jsonObject = new JSONObject();
+ jsonObject.put("app", streamPushItem.getApp());
+ jsonObject.put("stream", streamPushItem.getStream());
+ subscribe.addSubscribe(ZLMHttpHookSubscribe.HookType.on_play,jsonObject,(response)->{
+ updateMedia(response.getString("app"), response.getString("stream"));
+ });
+ }
+ }
+ }));
+
+ }
+
+ public void addMedia(String app, String streamId) {
+ //浣跨敤寮傛鏇存柊鎺ㄦ祦
+ updateMedia(app, streamId);
}
+ public void updateMedia(String app, String streamId) {
+ //浣跨敤寮傛鏇存柊鎺ㄦ祦
+ zlmresTfulUtils.getMediaList(app, streamId, "rtmp", json->{
+ if (json == null) return;
+ String dataStr = json.getString("data");
+
+ Integer code = json.getInteger("code");
+ Map<String, StreamPushItem> result = new HashMap<>();
+ List<StreamPushItem> streamPushItems = null;
+ if (code == 0 ) {
+ if (dataStr != null) {
+ streamPushItems = streamPushService.handleJSON(dataStr);
+ }
+ }else {
+ logger.warn("鏇存柊瑙嗛娴佸け璐ワ紝閿欒code锛� " + code);
+ }
+
+ if (streamPushItems != null && streamPushItems.size() == 1) {
+ storager.updateMedia(streamPushItems.get(0));
+ }
+ });
+ }
+
+
+ public void removeMedia(String app, String streamId) {
+ // 鏌ユ壘鏄惁鍏宠仈浜嗗浗鏍囷紝 鍏宠仈浜嗕笉鍒犻櫎锛� 缃负绂荤嚎
+ StreamProxyItem streamProxyItem = gbStreamMapper.selectOne(app, streamId);
+ if (streamProxyItem == null) {
+ storager.removeMedia(app, streamId);
+ }else {
+ storager.mediaOutline(app, streamId);
+ }
+ }
+
+ public void clearAllSessions() {
+ logger.info("娓呯┖鎵�鏈夊浗鏍囩浉鍏崇殑session");
+ JSONObject allSessionJSON = zlmresTfulUtils.getAllSession();
+ MediaServerConfig mediaInfo = redisCatchStorage.getMediaInfo();
+ HashSet<String> allLocalPorts = new HashSet();
+ if (allSessionJSON.getInteger("code") == 0) {
+ JSONArray data = allSessionJSON.getJSONArray("data");
+ if (data.size() > 0) {
+ for (int i = 0; i < data.size(); i++) {
+ JSONObject sessionJOSN = data.getJSONObject(i);
+ Integer local_port = sessionJOSN.getInteger("local_port");
+ if (!local_port.equals(Integer.valueOf(mediaInfo.getHttpPort())) &&
+ !local_port.equals(Integer.valueOf(mediaInfo.getHttpSSLport())) &&
+ !local_port.equals(Integer.valueOf(mediaInfo.getRtmpPort())) &&
+ !local_port.equals(Integer.valueOf(mediaInfo.getRtspPort())) &&
+ !local_port.equals(Integer.valueOf(mediaInfo.getRtspSSlport())) &&
+ !local_port.equals(Integer.valueOf(mediaInfo.getHookOnFlowReport()))){
+ allLocalPorts.add(sessionJOSN.getInteger("local_port") + "");
+ }
+ }
+ }
+ }
+ if (allLocalPorts.size() > 0) {
+ List<String> result = new ArrayList<>(allLocalPorts);
+ String localPortSStr = String.join(",", result);
+ zlmresTfulUtils.kickSessions(localPortSStr);
+ }
+ }
}
--
Gitblit v1.8.0