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/Iqiyi2.java | 41 +++++++++++++++++++++++++++++++++--------
1 files changed, 33 insertions(+), 8 deletions(-)
diff --git a/src/test/java/com/hxh/spring/test/Iqiyi2.java b/src/test/java/com/hxh/spring/test/Iqiyi2.java
index f05def9..64d5b60 100644
--- a/src/test/java/com/hxh/spring/test/Iqiyi2.java
+++ b/src/test/java/com/hxh/spring/test/Iqiyi2.java
@@ -3,12 +3,15 @@
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.dao.juhe.iqiyi.VideoIqiyiDao;
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.VideoIqiyi;
import com.yeshi.buwan.iqiyi.entity.VideoIqiyi2;
+import com.yeshi.buwan.iqiyi.util.IqiyiUtil;
import com.yeshi.buwan.iqiyi.util.IqiyiUtil2;
import com.yeshi.buwan.iqiyi.vo.IqiyiAlbumListResult;
import com.yeshi.buwan.job.SMSJob;
@@ -232,18 +235,40 @@
}
}
+
+ @Resource
+ private VideoIqiyiDao videoIqiyiDao;
+
+ @Test
+ public void deleteOldIqiyiVideo() {
+ List<String[]> list = HtmlToolUtil.parseSQLYogExportHtmData("C:\\Users\\Administrator\\Desktop\\鐖卞鑹鸿�佺増姝ｇ墖.htm", 3);
+ for (String[] sts : list) {
+ String videoId = sts[0];
+ List<VideoIqiyi> list1 = videoIqiyiDao.listByVideoId(videoId);
+ if (list1 != null)
+ for (VideoIqiyi videoIqiyi : list1)
+ videoIqiyiDao.delete(videoIqiyi);
+ }
+ }
+
@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() + "");
- }
+// 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() + "");
+// }
+// }
+
+ String json = "[\"588808\",\"466573\",\"475946\",\"328312\",\"475934\",\"359261\",\"276279\",\"322163\",\"276768\"]";
+ JSONArray array = JSONArray.fromObject(json);
+ for (int i = 0; i < array.size(); i++) {
+ resourceVideoService.addVideoResource(array.optString(i), IqiyiUtil2.RESOURCE_ID + "");
}
+
//["588808","466573","475946","328312","475934","359261","276279","322163","276768"]
- System.out.println(new Gson().toJson(videoIds));
}
--
Gitblit v1.8.0