From 89e370bfdda29ac8a8f7080a18dc09a6ddc75c09 Mon Sep 17 00:00:00 2001
From: admin <weikou2014>
Date: 星期一, 26 十月 2020 18:42:16 +0800
Subject: [PATCH] 风行爱奇艺视频更新

---
 src/test/java/com/hxh/spring/test/Iqiyi2.java |  107 +++++++++++++++++++++++++++++++++++++++++++++++------
 1 files changed, 95 insertions(+), 12 deletions(-)

diff --git a/src/test/java/com/hxh/spring/test/Iqiyi2.java b/src/test/java/com/hxh/spring/test/Iqiyi2.java
index 2690164..f05def9 100644
--- a/src/test/java/com/hxh/spring/test/Iqiyi2.java
+++ b/src/test/java/com/hxh/spring/test/Iqiyi2.java
@@ -2,15 +2,24 @@
 
 import com.google.gson.Gson;
 import com.yeshi.buwan.dao.juhe.iqiyi.IqiyiAlbum2Dao;
+import com.yeshi.buwan.dao.juhe.iqiyi.VideoIqiyi2Dao;
+import com.yeshi.buwan.domain.ResourceVideo;
+import com.yeshi.buwan.funtv.FunTVUtil2;
+import com.yeshi.buwan.funtv.entity.VideoFunTV2;
 import com.yeshi.buwan.iqiyi.IqiYiNewAPI;
 import com.yeshi.buwan.iqiyi.entity.IqiyiAlbum2;
+import com.yeshi.buwan.iqiyi.entity.VideoIqiyi2;
 import com.yeshi.buwan.iqiyi.util.IqiyiUtil2;
 import com.yeshi.buwan.iqiyi.vo.IqiyiAlbumListResult;
+import com.yeshi.buwan.job.SMSJob;
 import com.yeshi.buwan.job.video.Iqiyi2VideoUpdate;
+import com.yeshi.buwan.query.Iqiyi2AlbumQuery;
+import com.yeshi.buwan.service.imp.CategoryVideoService;
+import com.yeshi.buwan.service.imp.ResourceVideoService;
 import com.yeshi.buwan.service.inter.juhe.Iqiyi2Service;
-import com.yeshi.buwan.util.FileUtil;
-import com.yeshi.buwan.util.StringUtil;
-import com.yeshi.buwan.util.TimeUtil;
+import com.yeshi.buwan.util.*;
+import com.yeshi.buwan.util.mq.CMQManager;
+import net.sf.json.JSONArray;
 import org.junit.Test;
 import org.junit.runner.RunWith;
 import org.springframework.test.context.ContextConfiguration;
@@ -18,13 +27,11 @@
 import org.springframework.test.context.web.WebAppConfiguration;
 
 import javax.annotation.Resource;
-import java.io.File;
-import java.io.FileWriter;
-import java.io.IOException;
-import java.io.PrintWriter;
+import java.io.*;
 import java.util.ArrayList;
 import java.util.Date;
 import java.util.List;
+import java.util.Scanner;
 
 //
 @RunWith(SpringJUnit4ClassRunner.class) //浣跨敤junit4杩涜娴嬭瘯
@@ -44,10 +51,19 @@
     @Resource
     private Iqiyi2VideoUpdate iqiyi2VideoUpdate;
 
+    @Resource
+    private CategoryVideoService categoryVideoService;
+
+    @Resource
+    private VideoIqiyi2Dao videoIqiyi2Dao;
+
+    @Resource
+    private ResourceVideoService resourceVideoService;
+
 
     @Test
     public void syncAll() {
-        iqiyiUtil2.syncAllDianShiJu();
+        iqiyiUtil2.updateTodayAlbumAndVideo(IqiYiNewAPI.TYPE_DIANYING);
     }
 
     @Test
@@ -113,9 +129,11 @@
 
     @Test
     public void test6() {
-        for(int i=0;i<10;i++) {
-            List<Long> ids = iqiyiAlbum2Dao.listInvalid(1000*(i), 1000);
-            saveToFile(ids);
+        for (int i = 0; i < 10; i++) {
+            List<Long> ids = iqiyiAlbum2Dao.listInvalid(0, 1000);
+            for (long id : ids)
+                iqiyiAlbum2Dao.delete(id);
+            //saveToFile(ids);
         }
     }
 
@@ -146,7 +164,7 @@
     public void count() {
 //        long count = iqiyiAlbum2Dao.countVideoByAid(253120001L);
 //        System.out.println(count);
-        IqiyiAlbum2 album2 = iqiyiAlbum2Dao.get(6603128446259700L);
+        IqiyiAlbum2 album2 = iqiyiAlbum2Dao.get(730266600L);
         iqiyi2Service.addToVideoInfo(album2);
     }
 
@@ -163,5 +181,70 @@
         System.out.println(result);
     }
 
+    @Test
+    public void deleteAlbum() {
+        try {
+            Scanner scanner = new Scanner(new FileInputStream(new File("E:\\iqiyialbum_invalid.txt")));
+            while (scanner.hasNextLine()) {
+                String text = scanner.nextLine();
+                if (!StringUtil.isNullOrEmpty(text)) {
+                    JSONArray array = JSONArray.fromObject(text);
+                    for (int i = 0; i < array.size(); i++) {
+                        iqiyi2Service.deleteByAid(array.optLong(i));
+                    }
+                }
+            }
+            scanner.close();
+        } catch (FileNotFoundException e) {
+            e.printStackTrace();
+        }
+    }
+
+
+    @Test
+    public void addToMQ() {
+        Iqiyi2AlbumQuery query = new Iqiyi2AlbumQuery();
+        query.setContentType(1);
+        query.setFeatureAlbumId(0L);
+        query.setChannelId(2);
+
+        long count = iqiyiAlbum2Dao.countByAid(query);
+        int page = (int) (count % 100 == 0 ? count / 100 : count / 100 + 1);
+
+        for (int i = 0; i < page; i++) {
+            List<IqiyiAlbum2> album2List = iqiyiAlbum2Dao.listByAid(query, IqiyiAlbum2.SORT_ID, i * 100, 100);
+            for (IqiyiAlbum2 album2 : album2List) {
+                System.out.println(album2.getName());
+                if (IqiyiUtil2.albumIsValid(album2)) {
+                    CMQManager.getInstance().addIqiyiAlbumUpdateMsg(album2.getId());
+                }
+            }
+        }
+    }
+
+    @Test
+    public void addCategory() {
+        List<String[]> list = HtmlToolUtil.parseSQLYogExportHtmData("C:\\Users\\Administrator\\Desktop\\鐖卞鑹哄垎绫荤己澶�.htm", 2);
+        for (String[] sts : list) {
+            String videoId = sts[0];
+            String videoType = sts[1];
+            categoryVideoService.addCategoryVideo(videoId, Long.parseLong(videoType));
+        }
+    }
+
+    @Test
+    public void addResources() {
+        List<String> videoIds = new ArrayList<>();
+        List<VideoIqiyi2> list = videoIqiyi2Dao.listAll(0, 5000);
+        for (VideoIqiyi2 video : list) {
+            long count = resourceVideoService.countByVideoIdAndResourceId(video.getVideoId() + "", IqiyiUtil2.RESOURCE_ID);
+            if (count == 0L) {
+                videoIds.add(video.getVideoId() + "");
+            }
+        }
+        //["588808","466573","475946","328312","475934","359261","276279","322163","276768"]
+        System.out.println(new Gson().toJson(videoIds));
+    }
+
 
 }

--
Gitblit v1.8.0