From 264b5dea5b74c4b5ba54a90caba7e709858a037e Mon Sep 17 00:00:00 2001
From: admin <weikou2014>
Date: 星期四, 25 八月 2022 17:58:27 +0800
Subject: [PATCH] 增加rabbitmq

---
 src/test/java/com/hxh/spring/test/PPTVTest.java |   91 +++++++++++++++++++++++++++++++++++++++------
 1 files changed, 79 insertions(+), 12 deletions(-)

diff --git a/src/test/java/com/hxh/spring/test/PPTVTest.java b/src/test/java/com/hxh/spring/test/PPTVTest.java
index aa22cfd..77a1bf1 100644
--- a/src/test/java/com/hxh/spring/test/PPTVTest.java
+++ b/src/test/java/com/hxh/spring/test/PPTVTest.java
@@ -1,14 +1,18 @@
 package com.hxh.spring.test;
 
+import com.google.gson.Gson;
+import com.yeshi.buwan.dao.juhe.pptv.PPTVProgramDao;
 import com.yeshi.buwan.dao.juhe.pptv.PPTVSeriesDao;
+import com.yeshi.buwan.dao.juhe.pptv.PPTVSeriesProgramMapDao;
+import com.yeshi.buwan.dao.juhe.pptv.VideoPPTVMapDao;
 import com.yeshi.buwan.job.video.PPTVVideoUpdate;
-import com.yeshi.buwan.pptv.PPTVApiUtil;
-import com.yeshi.buwan.pptv.PPTVUtil;
-import com.yeshi.buwan.pptv.entity.PPTVSeries;
+import com.yeshi.buwan.videos.pptv.PPTVApiUtil;
+import com.yeshi.buwan.videos.pptv.entity.PPTVSeries;
+import com.yeshi.buwan.videos.pptv.entity.PPTVSeriesProgramMap;
+import com.yeshi.buwan.videos.pptv.entity.VideoPPTVMap;
 import com.yeshi.buwan.service.inter.LoginUserService;
 import com.yeshi.buwan.service.inter.juhe.PPTVService;
 import com.yeshi.buwan.util.StringUtil;
-import com.yeshi.buwan.util.log.LoggerUtil;
 import jxl.Sheet;
 import jxl.Workbook;
 import jxl.write.Label;
@@ -43,6 +47,17 @@
     @Resource
     private PPTVSeriesDao pptvSeriesDao;
 
+
+    @Resource
+    private PPTVProgramDao pptvProgramDao;
+
+    @Resource
+    private PPTVSeriesProgramMapDao pptvSeriesProgramMapDao;
+
+    @Resource
+    private VideoPPTVMapDao videoPPTVMapDao;
+
+
     @Resource
     private PPTVVideoUpdate pptvVideoUpdate;
 
@@ -57,15 +72,41 @@
 
     @Test
     public void addToVideoInfo() {
-        List<PPTVSeries> list = pptvSeriesDao.list(2000, 1000);
-        for (PPTVSeries s : list) {
-            if (s.getProgramType().contains("灏戝効") || s.getProgramType2().contains("灏戝効")) {
-                continue;
+//        List<PPTVSeries> list = pptvSeriesDao.list(2000, 1000);
+//        for (PPTVSeries s : list) {
+//            if (s.getProgramType().contains("灏戝効") || s.getProgramType2().contains("灏戝効")) {
+//                continue;
+//            }
+//            System.out.println(s.getName() + ":" + s.getInfoID());
+
+        Query query = new Query();
+        query.addCriteria(new Criteria().orOperator(Criteria.where("programType").regex("鐢靛奖"), Criteria.where("programType2").regex("鐢靛奖")));
+
+        List<String> list = new ArrayList<>();
+
+        List<PPTVSeries> seriesList = pptvSeriesDao.findList(query);
+        for (PPTVSeries series : seriesList) {
+            VideoPPTVMap map = pptvService.selectVideoPPTVMapByPPInfo(series.getInfoID(), null);
+
+            if (map != null && map.getProgramCode() == null) {
+                series = pptvService.getSeriesDetail(series.getInfoID());
+                map.setSeriesCode(series.getSeriesCode());
+                map.setProgramCode(series.getSeries().get(0).getProgramCode());
+                videoPPTVMapDao.save(map);
+            } else {
+                if (map == null) {
+                    list.add(series.getInfoID());
+//                    series = PPTVApiUtil.getDetail(series.getSeriesCode());
+                    series = pptvService.getSeriesDetail(series.getInfoID());
+                    pptvService.addToVideoInfo(series);
+                }
             }
-            System.out.println(s.getName() + ":" + s.getInfoID());
-            PPTVSeries series = pptvService.getSeriesDetail(s.getInfoID());
-            pptvService.addToVideoInfo(series);
         }
+
+        System.out.println(new Gson().toJson(list));
+
+
+//        }
     }
 
 
@@ -89,7 +130,7 @@
     @Test
     public void syncVideo() {
         try {
-            pptvVideoUpdate.syncVideo("");
+            pptvVideoUpdate.syncVideo("32427297");
         } catch (Exception e) {
             e.printStackTrace();
         }
@@ -303,4 +344,30 @@
     }
 
 
+    @Test
+    public void repaire() {
+
+        Query query = new Query();
+        query.addCriteria(Criteria.where("seriesCode").is(null));
+        query.limit(200);
+        List<PPTVSeries> list = pptvSeriesDao.findList(query);
+        for (PPTVSeries pptvSeries : list) {
+            PPTVSeriesProgramMap map = pptvSeriesProgramMapDao.getLatestByInfoId(pptvSeries.getInfoID());
+            pptvService.syncSeries(map.getSeriesCode());
+        }
+
+
+    }
+
+    @Test
+    public void sync() {
+//        PPTVSeries series = pptvService.getSeriesDetailByVideoId("8268375");
+//        System.out.println(series);
+
+
+        getDetail("32501376");
+
+    }
+
+
 }

--
Gitblit v1.8.0