存储部分使用sqlite代替redis-3

panlinlin

2021-01-04 dcd78a1cfa0c929403d51a347e43414f6aa5f0d8

 src/main/java/com/genersoft/iot/vmp/gb28181/transmit/request/impl/MessageRequestProcessor.java

@@ -10,6 +10,7 @@
import javax.sip.message.Request;

import javax.sip.message.Response;



import com.genersoft.iot.vmp.storager.IRedisCatchStorage;

import org.dom4j.Document;

import org.dom4j.DocumentException;

import org.dom4j.Element;

@@ -34,7 +35,7 @@
import com.genersoft.iot.vmp.storager.IVideoManagerStorager;

import com.genersoft.iot.vmp.utils.redis.RedisUtil;

import org.springframework.util.StringUtils;



import com.genersoft.iot.vmp.common.StreamInfo;

/**

 * @Description:MESSAGE请求处理器

 * @author: swwheihei

@@ -47,6 +48,8 @@
   private SIPCommander cmder;



   private IVideoManagerStorager storager;



   private IRedisCatchStorage redisCatchStorage;



   private EventPublisher publisher;



@@ -64,6 +67,7 @@
   private static final String MESSAGE_DEVICE_INFO = "DeviceInfo";

   private static final String MESSAGE_ALARM = "Alarm";

   private static final String MESSAGE_RECORD_INFO = "RecordInfo";

   private static final String MESSAGE_MEDIA_STATUS = "MediaStatus";

   // private static final String MESSAGE_BROADCAST = "Broadcast";

   // private static final String MESSAGE_DEVICE_STATUS = "DeviceStatus";

   // private static final String MESSAGE_MOBILE_POSITION = "MobilePosition";

@@ -98,6 +102,11 @@
         } else if (MESSAGE_RECORD_INFO.equals(cmd)) {

            logger.info("接收到RecordInfo消息");

            processMessageRecordInfo(evt);

         }else if (MESSAGE_MEDIA_STATUS.equals(cmd)) {

            logger.info("接收到MediaStatus消息");

            processMessageMediaStatus(evt);

         } else {

            logger.info("接收到消息：" + cmd);

         }

      } catch (DocumentException e) {

         e.printStackTrace();

@@ -178,10 +187,11 @@
               DeviceChannel deviceChannel = new DeviceChannel();

               deviceChannel.setName(channelName);

               deviceChannel.setChannelId(channelDeviceId);

               if (status.equals("ON") || status.equals("On")) {

               // ONLINE OFFLINE  HIKVISION DS-7716N-E4 NVR的兼容性处理

               if (status.equals("ON") || status.equals("On") || status.equals("ONLINE")) {

                  deviceChannel.setStatus(1);

               }

               if (status.equals("OFF") || status.equals("Off")) {

               if (status.equals("OFF") || status.equals("Off") || status.equals("OFFLINE")) {

                  deviceChannel.setStatus(0);

               }



@@ -191,30 +201,57 @@
               deviceChannel.setCivilCode(XmlUtil.getText(itemDevice, "CivilCode"));

               deviceChannel.setBlock(XmlUtil.getText(itemDevice, "Block"));

               deviceChannel.setAddress(XmlUtil.getText(itemDevice, "Address"));

               deviceChannel.setParental(itemDevice.element("Parental") == null ? 0

                     : Integer.parseInt(XmlUtil.getText(itemDevice, "Parental")));

               if (XmlUtil.getText(itemDevice, "Parental") == null || XmlUtil.getText(itemDevice, "Parental") == "") {

                  deviceChannel.setParental(0);

               } else {

                  deviceChannel.setParental(Integer.parseInt(XmlUtil.getText(itemDevice, "Parental")));

               } 
               deviceChannel.setParentId(XmlUtil.getText(itemDevice, "ParentID"));

               deviceChannel.setSafetyWay(itemDevice.element("SafetyWay") == null ? 0

                     : Integer.parseInt(XmlUtil.getText(itemDevice, "SafetyWay")));

               deviceChannel.setRegisterWay(itemDevice.element("RegisterWay") == null ? 1

                     : Integer.parseInt(XmlUtil.getText(itemDevice, "RegisterWay")));

               if (XmlUtil.getText(itemDevice, "SafetyWay") == null || XmlUtil.getText(itemDevice, "SafetyWay")== "") {

                  deviceChannel.setSafetyWay(0);

               } else {

                  deviceChannel.setSafetyWay(Integer.parseInt(XmlUtil.getText(itemDevice, "SafetyWay")));

               }

               if (XmlUtil.getText(itemDevice, "RegisterWay") == null || XmlUtil.getText(itemDevice, "RegisterWay") =="") {

                  deviceChannel.setRegisterWay(1);

               } else {

                  deviceChannel.setRegisterWay(Integer.parseInt(XmlUtil.getText(itemDevice, "RegisterWay")));

               }

               deviceChannel.setCertNum(XmlUtil.getText(itemDevice, "CertNum"));

               deviceChannel.setCertifiable(itemDevice.element("Certifiable") == null ? 0

                     : Integer.parseInt(XmlUtil.getText(itemDevice, "Certifiable")));

               deviceChannel.setErrCode(itemDevice.element("ErrCode") == null ? 0

                     : Integer.parseInt(XmlUtil.getText(itemDevice, "ErrCode")));

               if (XmlUtil.getText(itemDevice, "Certifiable") == null || XmlUtil.getText(itemDevice, "Certifiable") == "") {

                  deviceChannel.setCertifiable(0);

               } else {

                  deviceChannel.setCertifiable(Integer.parseInt(XmlUtil.getText(itemDevice, "Certifiable")));

               }

               if (XmlUtil.getText(itemDevice, "ErrCode") == null || XmlUtil.getText(itemDevice, "ErrCode") == "") {

                  deviceChannel.setErrCode(0);

               } else {

                  deviceChannel.setErrCode(Integer.parseInt(XmlUtil.getText(itemDevice, "ErrCode")));

               }

               deviceChannel.setEndTime(XmlUtil.getText(itemDevice, "EndTime"));

               deviceChannel.setSecrecy(XmlUtil.getText(itemDevice, "Secrecy"));

               deviceChannel.setIpAddress(XmlUtil.getText(itemDevice, "IPAddress"));

               deviceChannel.setPort(itemDevice.element("Port") == null ? 0

                     : Integer.parseInt(XmlUtil.getText(itemDevice, "Port")));

               if (XmlUtil.getText(itemDevice, "Port") == null || XmlUtil.getText(itemDevice, "Port") =="") {

                  deviceChannel.setPort(0);

               } else {

                  deviceChannel.setPort(Integer.parseInt(XmlUtil.getText(itemDevice, "Port")));

               }

               deviceChannel.setPassword(XmlUtil.getText(itemDevice, "Password"));

               deviceChannel.setLongitude(itemDevice.element("Longitude") == null ? 0.00

                     : Double.parseDouble(XmlUtil.getText(itemDevice, "Longitude")));

               deviceChannel.setLatitude(itemDevice.element("Latitude") == null ? 0.00

                     : Double.parseDouble(XmlUtil.getText(itemDevice, "Latitude")));

               deviceChannel.setPTZType(itemDevice.element("PTZType") == null ? 0

                     : Integer.parseInt(XmlUtil.getText(itemDevice, "PTZType")));

               if (XmlUtil.getText(itemDevice, "Longitude") == null || XmlUtil.getText(itemDevice, "Longitude") == "") {

                  deviceChannel.setLongitude(0.00);

               } else {

                  deviceChannel.setLongitude(Double.parseDouble(XmlUtil.getText(itemDevice, "Longitude")));

               }

               if (XmlUtil.getText(itemDevice, "Latitude") == null || XmlUtil.getText(itemDevice, "Latitude") =="") {

                  deviceChannel.setLatitude(0.00);

               } else {

                  deviceChannel.setLatitude(Double.parseDouble(XmlUtil.getText(itemDevice, "Latitude")));

               }

               if (XmlUtil.getText(itemDevice, "PTZType") == null || XmlUtil.getText(itemDevice, "PTZType") == "") {

                  deviceChannel.setPTZType(0);

               } else {

                  deviceChannel.setPTZType(Integer.parseInt(XmlUtil.getText(itemDevice, "PTZType")));

               }

               deviceChannel.setHasAudio(true); // 默认含有音频，播放时再检查是否有音频及是否AAC

               storager.updateChannel(device.getDeviceId(), deviceChannel);

            }

@@ -260,7 +297,7 @@
            device.setStreamMode("UDP");

         }

         storager.updateDevice(device);

         cmder.catalogQuery(device);

         cmder.catalogQuery(device, null);

         // 回复200 OK

         responseAck(evt);

         if (offLineDetector.isOnline(deviceId)) {

@@ -281,12 +318,16 @@
      try {

         Element rootElement = getRootElement(evt);

         String deviceId = XmlUtil.getText(rootElement, "DeviceID");

         // 回复200 OK

         responseAck(evt);

         if (offLineDetector.isOnline(deviceId)) {

            publisher.onlineEventPublish(deviceId, VideoManagerConstants.EVENT_ONLINE_KEEPLIVE);

         } else {

         // 检查设备是否存在， 不存在则不回复

         if (storager.exists(deviceId)) {

            // 回复200 OK

            responseAck(evt);

            if (offLineDetector.isOnline(deviceId)) {

               publisher.onlineEventPublish(deviceId, VideoManagerConstants.EVENT_ONLINE_KEEPLIVE);

            } else {

            }

         }



      } catch (ParseException | SipException | InvalidArgumentException | DocumentException e) {

         e.printStackTrace();

      }

@@ -307,76 +348,83 @@
         String deviceId = deviceIdElement.getText().toString();

         recordInfo.setDeviceId(deviceId);

         recordInfo.setName(XmlUtil.getText(rootElement, "Name"));

         recordInfo.setSumNum(Integer.parseInt(XmlUtil.getText(rootElement, "SumNum")));

         if (XmlUtil.getText(rootElement, "SumNum")== null || XmlUtil.getText(rootElement, "SumNum") =="") {

            recordInfo.setSumNum(0);

         } else {

            recordInfo.setSumNum(Integer.parseInt(XmlUtil.getText(rootElement, "SumNum")));

         }

         String sn = XmlUtil.getText(rootElement, "SN");

         Element recordListElement = rootElement.element("RecordList");

         if (recordListElement == null) {

         if (recordListElement == null || recordInfo.getSumNum() == 0) {

            logger.info("无录像数据");

            // responseAck(evt);

            return;

         }



         Iterator<Element> recordListIterator = recordListElement.elementIterator();

         List<RecordItem> recordList = new ArrayList<RecordItem>();

         if (recordListIterator != null) {

            RecordItem record = new RecordItem();

            logger.info("处理录像列表数据...");

            // 遍历DeviceList

            while (recordListIterator.hasNext()) {

               Element itemRecord = recordListIterator.next();

               Element recordElement = itemRecord.element("DeviceID");

               if (recordElement == null) {

                  logger.info("记录为空，下一个...");

                  continue;

            // return;

         } else {

            Iterator<Element> recordListIterator = recordListElement.elementIterator();

            List<RecordItem> recordList = new ArrayList<RecordItem>();

            if (recordListIterator != null) {

               RecordItem record = new RecordItem();

               logger.info("处理录像列表数据...");

               // 遍历DeviceList

               while (recordListIterator.hasNext()) {

                  Element itemRecord = recordListIterator.next();

                  Element recordElement = itemRecord.element("DeviceID");

                  if (recordElement == null) {

                     logger.info("记录为空，下一个...");

                     continue;

                  }

                  record = new RecordItem();

                  record.setDeviceId(XmlUtil.getText(itemRecord, "DeviceID"));

                  record.setName(XmlUtil.getText(itemRecord, "Name"));

                  record.setFilePath(XmlUtil.getText(itemRecord, "FilePath"));

                  record.setAddress(XmlUtil.getText(itemRecord, "Address"));

                  record.setStartTime(

                        DateUtil.ISO8601Toyyyy_MM_dd_HH_mm_ss(XmlUtil.getText(itemRecord, "StartTime")));

                  record.setEndTime(

                        DateUtil.ISO8601Toyyyy_MM_dd_HH_mm_ss(XmlUtil.getText(itemRecord, "EndTime")));

                  record.setSecrecy(itemRecord.element("Secrecy") == null ? 0

                        : Integer.parseInt(XmlUtil.getText(itemRecord, "Secrecy")));

                  record.setType(XmlUtil.getText(itemRecord, "Type"));

                  record.setRecorderId(XmlUtil.getText(itemRecord, "RecorderID"));

                  recordList.add(record);

               }

               record = new RecordItem();

               record.setDeviceId(XmlUtil.getText(itemRecord, "DeviceID"));

               record.setName(XmlUtil.getText(itemRecord, "Name"));

               record.setFilePath(XmlUtil.getText(itemRecord, "FilePath"));

               record.setAddress(XmlUtil.getText(itemRecord, "Address"));

               record.setStartTime(

                     DateUtil.ISO8601Toyyyy_MM_dd_HH_mm_ss(XmlUtil.getText(itemRecord, "StartTime")));

               record.setEndTime(DateUtil.ISO8601Toyyyy_MM_dd_HH_mm_ss(XmlUtil.getText(itemRecord, "EndTime")));

               record.setSecrecy(itemRecord.element("Secrecy") == null ? 0

                     : Integer.parseInt(XmlUtil.getText(itemRecord, "Secrecy")));

               record.setType(XmlUtil.getText(itemRecord, "Type"));

               record.setRecorderId(XmlUtil.getText(itemRecord, "RecorderID"));

               recordList.add(record);

               // recordList.sort(Comparator.naturalOrder());

               recordInfo.setRecordList(recordList);

            }

            // recordList.sort(Comparator.naturalOrder());

            recordInfo.setRecordList(recordList);

         }



         // 存在录像且如果当前录像明细个数小于总条数，说明拆包返回，需要组装，暂不返回

         if (recordInfo.getSumNum() > 0 && recordList.size() > 0 && recordList.size() < recordInfo.getSumNum()) {

            // 为防止连续请求该设备的录像数据，返回数据错乱，特增加sn进行区分

            String cacheKey = CACHE_RECORDINFO_KEY + deviceId + sn;

            // TODO 暂时直接操作redis存储，后续封装专用缓存接口，改为本地内存缓存

            if (redis.hasKey(cacheKey)) {

               List<RecordItem> previousList = (List<RecordItem>) redis.get(cacheKey);

               if (previousList != null && previousList.size() > 0) {

                  recordList.addAll(previousList);

               }

               // 本分支表示录像列表被拆包，且加上之前的数据还是不够,保存缓存返回，等待下个包再处理

               if (recordList.size() < recordInfo.getSumNum()) {

            // 存在录像且如果当前录像明细个数小于总条数，说明拆包返回，需要组装，暂不返回

            if (recordInfo.getSumNum() > 0 && recordList.size() > 0 && recordList.size() < recordInfo.getSumNum()) {

               // 为防止连续请求该设备的录像数据，返回数据错乱，特增加sn进行区分

               String cacheKey = CACHE_RECORDINFO_KEY + deviceId + sn;

               // TODO 暂时直接操作redis存储，后续封装专用缓存接口，改为本地内存缓存

               if (redis.hasKey(cacheKey)) {

                  List<RecordItem> previousList = (List<RecordItem>) redis.get(cacheKey);

                  if (previousList != null && previousList.size() > 0) {

                     recordList.addAll(previousList);

                  }

                  // 本分支表示录像列表被拆包，且加上之前的数据还是不够,保存缓存返回，等待下个包再处理

                  if (recordList.size() < recordInfo.getSumNum()) {

                     logger.info("已获取" + recordList.size() + "项录像数据，共" + recordInfo.getSumNum() + "项");

                     redis.set(cacheKey, recordList, 90);

                     return;

                  } else {

                     // 本分支表示录像被拆包，但加上之前的数据够足够，返回响应

                     // 因设备心跳有监听redis过期机制，为提高性能，此处手动删除

                     logger.info("录像数据已全部获取");

                     redis.del(cacheKey);

                  }

               } else {

                  // 本分支有两种可能：1、录像列表被拆包，且是第一个包,直接保存缓存返回，等待下个包再处理

                  // 2、之前有包，但超时清空了，那么这次sn批次的响应数据已经不完整，等待过期时间后redis自动清空数据

                  logger.info("已获取" + recordList.size() + "项录像数据，共" + recordInfo.getSumNum() + "项");

                  logger.info("等待后续的包...");



                  redis.set(cacheKey, recordList, 90);

                  return;

               } else {

                  // 本分支表示录像被拆包，但加上之前的数据够足够，返回响应

                  // 因设备心跳有监听redis过期机制，为提高性能，此处手动删除

                  logger.info("录像数据已全部获取");

                  redis.del(cacheKey);

               }

            } else {

               // 本分支有两种可能：1、录像列表被拆包，且是第一个包,直接保存缓存返回，等待下个包再处理

               // 2、之前有包，但超时清空了，那么这次sn批次的响应数据已经不完整，等待过期时间后redis自动清空数据

               logger.info("等待后续的包...");



               redis.set(cacheKey, recordList, 90);

               return;

            }



            // 自然顺序排序, 元素进行升序排列

            recordInfo.getRecordList().sort(Comparator.naturalOrder());

         }

         // 走到这里，有以下可能：1、没有录像信息,第一次收到recordinfo的消息即返回响应数据，无redis操作

         // 2、有录像数据，且第一次即收到完整数据，返回响应数据，无redis操作

@@ -386,8 +434,8 @@
         RequestMessage msg = new RequestMessage();

         msg.setDeviceId(deviceId);

         msg.setType(DeferredResultHolder.CALLBACK_CMD_RECORDINFO);

         // 自然顺序排序, 元素进行升序排列

         recordInfo.getRecordList().sort(Comparator.naturalOrder());

         // // 自然顺序排序, 元素进行升序排列

         // recordInfo.getRecordList().sort(Comparator.naturalOrder());

         msg.setData(recordInfo);

         deferredResultHolder.invokeResult(msg);

         logger.info("处理完成，返回结果");

@@ -396,6 +444,35 @@
      }

   }





   private void processMessageMediaStatus(RequestEvent evt){

      try {

         // 回复200 OK

         responseAck(evt);

         Element rootElement = getRootElement(evt);

         String deviceId = XmlUtil.getText(rootElement, "DeviceID");

         String NotifyType =XmlUtil.getText(rootElement, "NotifyType");

         if (NotifyType.equals("121")){

            logger.info("媒体播放完毕，通知关流");

            StreamInfo streamInfo = redisCatchStorage.queryPlaybackByDevice(deviceId, "*");

            if (streamInfo != null) {

               redisCatchStorage.stopPlayback(streamInfo);

               cmder.streamByeCmd(streamInfo.getStreamId());

            }

         }

      } catch (ParseException | SipException | InvalidArgumentException | DocumentException e) {

         e.printStackTrace();

      }

   }





   /***

    * 回复200 OK

    * @param evt

    * @throws SipException

    * @throws InvalidArgumentException

    * @throws ParseException

    */

   private void responseAck(RequestEvent evt) throws SipException, InvalidArgumentException, ParseException {

      Response response = getMessageFactory().createResponse(Response.OK, evt.getRequest());

      getServerTransaction(evt).sendResponse(response);

@@ -433,4 +510,11 @@
      this.offLineDetector = offLineDetector;

   }



   public IRedisCatchStorage getRedisCatchStorage() {

      return redisCatchStorage;

   }



   public void setRedisCatchStorage(IRedisCatchStorage redisCatchStorage) {

      this.redisCatchStorage = redisCatchStorage;

   }

}