From 69cb3ca5c0fd5f78b0c33bf92601066a37b0209e Mon Sep 17 00:00:00 2001
From: admin <weikou2014>
Date: 星期二, 27 十月 2020 17:36:41 +0800
Subject: [PATCH] 爱奇艺/风行资源优化
---
src/test/java/com/hxh/spring/test/FunTV2.java | 64 +++++++++++++++++++++++---------
1 files changed, 46 insertions(+), 18 deletions(-)
diff --git a/src/test/java/com/hxh/spring/test/FunTV2.java b/src/test/java/com/hxh/spring/test/FunTV2.java
index 97becb5..475cc1e 100644
--- a/src/test/java/com/hxh/spring/test/FunTV2.java
+++ b/src/test/java/com/hxh/spring/test/FunTV2.java
@@ -1,21 +1,22 @@
package com.hxh.spring.test;
import com.google.gson.Gson;
-import com.yeshi.buwan.dao.juhe.funtv.FunTVAlbum2Dao;
-import com.yeshi.buwan.dao.juhe.funtv.FunTVVideo2Dao;
-import com.yeshi.buwan.dao.juhe.funtv.VideoFunTV2Dao;
+import com.yeshi.buwan.dao.juhe.funtv.*;
import com.yeshi.buwan.domain.ResourceVideo;
+import com.yeshi.buwan.dto.mq.VideoExtraInfoChangeMQMsg;
import com.yeshi.buwan.funtv.FunTVNewApi;
+import com.yeshi.buwan.funtv.FunTVUtil;
import com.yeshi.buwan.funtv.FunTVUtil2;
-import com.yeshi.buwan.funtv.entity.FunTVAlbum2;
-import com.yeshi.buwan.funtv.entity.FunTVShortVideo2;
-import com.yeshi.buwan.funtv.entity.FunTVVideo2;
-import com.yeshi.buwan.funtv.entity.VideoFunTV2;
+import com.yeshi.buwan.funtv.entity.*;
+import com.yeshi.buwan.iqiyi.entity.VideoIqiyi;
import com.yeshi.buwan.job.video.FunTV2VideoUpdate;
import com.yeshi.buwan.service.imp.ResourceVideoService;
import com.yeshi.buwan.service.imp.VideoInfoService;
import com.yeshi.buwan.service.inter.juhe.FunTV2Service;
+import com.yeshi.buwan.util.HtmlToolUtil;
+import com.yeshi.buwan.util.mq.CMQManager;
import com.yeshi.buwan.vo.video.funtv.Funtv2ResultVO;
+import net.sf.json.JSONArray;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.test.context.ContextConfiguration;
@@ -125,7 +126,7 @@
@Test
public void addToVideoInfo() {
- List<FunTVAlbum2> album2List = funTVAlbum2Dao.listByChannelId(3, 2000, 1000);
+ List<FunTVAlbum2> album2List = funTVAlbum2Dao.listByChannelId(2, 0, 1000);
for (FunTVAlbum2 album2 : album2List) {
System.out.println(album2.getName());
List<FunTVVideo2> list = funTVVideo2Dao.listByMediaId(album2.getId(), 0, 2000);
@@ -152,16 +153,25 @@
@Test
public void addResource() {
- List<String> videoIds = new ArrayList<>();
- List<VideoFunTV2> list = videoFunTV2Dao.listAll(0, 5000);
- for (VideoFunTV2 funTV2 : list) {
- long count = resourceVideoService.countByVideoIdAndResourceId(funTV2.getVideoId() + "", FunTVUtil2.RESOURCE_ID);
- if (count==0L) {
- videoIds.add(funTV2.getVideoId() + "");
- }
- }
- //["7993072","7993075","7993076","7993077","7993078","7993079","7993081","7993082","7993083","7993084","7993085","7993086","7993088","7993089","7993090","7993094","7993095","7993096","7595177","8066187","8066194","8066195","8066196","8076894","7582863","7582643","7582653","7582876","7583418","7582690","7595550","7595195","7582913","7582989","982912","5625845","7582991","7334865","7761779","8077307","8077347","8077354","8077355","8077397","8077399","7728744","7674559","7728747","7726042","359250","7053989","7351834"]
- System.out.println(new Gson().toJson(videoIds));
+// List<String> videoIds = new ArrayList<>();
+// List<VideoFunTV2> list = videoFunTV2Dao.listAll(0, 5000);
+// for (VideoFunTV2 funTV2 : list) {
+// long count = resourceVideoService.countByVideoIdAndResourceId(funTV2.getVideoId() + "", FunTVUtil2.RESOURCE_ID);
+// if (count == 0L) {
+// videoIds.add(funTV2.getVideoId() + "");
+// }
+// }
+// System.out.println(new Gson().toJson(videoIds));
+
+// String json = "[\"7993076\",\"7993077\",\"7993078\"]";
+// JSONArray array = JSONArray.fromObject(json);
+// for (int i = 0; i < array.size(); i++) {
+// resourceVideoService.addVideoResource(array.optString(i), FunTVUtil2.RESOURCE_ID + "");
+// }
+//
+// CMQManager.getInstance().addVideoExtraInfoChanged(new VideoExtraInfoChangeMQMsg(VideoExtraInfoChangeMQMsg.TYPE_RESOURCE, "7993076", VideoExtraInfoChangeMQMsg.ACTION_ADD));
+
+// resourceVideoService.addVideoResource("7993076", FunTVUtil2.RESOURCE_ID + "");
}
@@ -170,4 +180,22 @@
funTV2Service.offLineAlbum("565");
}
+
+ @Resource
+ private VideoFunTVNewDao videoFunTVNewDao;
+
+ @Test
+ public void deleteOldFunTVVideo() {
+ List<String[]> list = HtmlToolUtil.parseSQLYogExportHtmData("C:\\Users\\Administrator\\Desktop\\椋庤鑰佺増姝ｇ墖.htm", 3);
+ for (String[] sts : list) {
+ String videoId = sts[0];
+ resourceVideoService.delete(videoId, FunTVUtil.RESOURCE_ID+"");
+// List<VideoFunTV> list1 = videoFunTVNewDao.listByVideoId(Long.parseLong(videoId));
+//
+// if (list1 != null)
+// for (VideoFunTV videoIqiyi : list1)
+// videoFunTVNewDao.delete(videoIqiyi.getId());
+ }
+ }
+
}
--
Gitblit v1.8.0