From b37275dba6b782bf3bb3817c4504f6cdef1bef7c Mon Sep 17 00:00:00 2001
From: admin <weikou2014>
Date: 星期四, 18 三月 2021 18:38:51 +0800
Subject: [PATCH] APP首页顶部标签兼容
---
src/test/java/com/hxh/spring/test/PPTVTest.java | 246 ++++++++++++++++++++++++++++++++++++++++++++++---
1 files changed, 231 insertions(+), 15 deletions(-)
diff --git a/src/test/java/com/hxh/spring/test/PPTVTest.java b/src/test/java/com/hxh/spring/test/PPTVTest.java
index 86b148b..03cc422 100644
--- a/src/test/java/com/hxh/spring/test/PPTVTest.java
+++ b/src/test/java/com/hxh/spring/test/PPTVTest.java
@@ -1,46 +1,262 @@
package com.hxh.spring.test;
+import com.yeshi.buwan.dao.juhe.pptv.PPTVSeriesDao;
+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.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;
+import jxl.write.WritableCell;
+import jxl.write.WritableSheet;
+import jxl.write.WritableWorkbook;
import org.junit.Test;
+import org.junit.runner.RunWith;
+import org.springframework.data.mongodb.core.query.Criteria;
+import org.springframework.data.mongodb.core.query.Query;
+import org.springframework.test.context.ContextConfiguration;
+import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
+import org.springframework.test.context.web.WebAppConfiguration;
+import org.yeshi.utils.HtmlToolUtil;
import javax.annotation.Resource;
-import java.util.List;
+import java.io.File;
+import java.io.FileInputStream;
+import java.util.*;
-//@RunWith(SpringJUnit4ClassRunner.class) //浣跨敤junit4杩涜娴嬭瘯
-//@ContextConfiguration(locations = {"classpath:spring.xml"})
-//@WebAppConfiguration
+@RunWith(SpringJUnit4ClassRunner.class) //浣跨敤junit4杩涜娴嬭瘯
+@ContextConfiguration(locations = {"classpath:spring.xml"})
+@WebAppConfiguration
public class PPTVTest {
@Resource
private PPTVService pptvService;
+
+ @Resource
+ private PPTVSeriesDao pptvSeriesDao;
+
+ @Resource
+ private PPTVVideoUpdate pptvVideoUpdate;
+
+ @Resource
+ private LoginUserService loginUserService;
+
@Test
- public void save() {
- List<PPTVSeries> list = PPTVApiUtil.getUpdateList();
+ public void saveAll() {
+ List<PPTVSeries> list = PPTVApiUtil.getTotalList();
// pptvService.save(list);
}
@Test
- public void getDetail() {
- PPTVSeries pptvSeries = pptvService.getSeriesDetail("201161");
- System.out.println(pptvSeries);
- }
-
- @Test
- public void test(){
- PPTVApiUtil.getOpenId("123");
+ public void addToVideoInfo() {
+ 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());
+ PPTVSeries series = pptvService.getSeriesDetail(s.getInfoID());
+ pptvService.addToVideoInfo(series);
+ }
}
@Test
- public void getApiDetail(){
+ public void test() {
+ PPTVApiUtil.getOpenId("123");
+ }
+
+ @Test
+ public void update() {
+ try {
+ pptvVideoUpdate.updateLatestVideo("");
+ } catch (Exception e) {
+ e.printStackTrace();
+ }
+ }
+
+ @Test
+ public void login() {
+ PPTVApiUtil.login("zcoAY6ev7RpYSLzXKtWybniCK+sgBiCARUii_uyNdFw-");
+ }
+
+
+ @Test
+ public void getApiDetail() {
PPTVApiUtil.getDetail("32159127,10215224,15326213");
}
+ @Test
+ public void getOpenId() {
+ //CODE:XefbSM0H8BC9kaEGEjHF2U7wd6Sd9ec1oSUmG1gZDTg=
+// PPTVApiUtil.login("XefbSM0H8BC9kaEGEjHF2U7wd6Sd9ec1oSUmG1gZDTg=");
+ String pptvUid = "buwan_844600";//PPTVUtil.decryptPPTVCode("XefbSM0H8BC9kaEGEjHF2U7wd6Sd9ec1oSUmG1gZDTg=").pptvUid;
+ String openId = PPTVApiUtil.getOpenId(pptvUid);
+ System.out.println(openId);
+
+// try {
+// loginUserService.updatePPTVOpenId("766693");
+// } catch (PPTVException e) {
+// e.printStackTrace();
+// }
+
+ }
+
+
+ @Test
+ public void getVIPPriceList() {
+ PPTVApiUtil.getVIPPriceList();
+ }
+
+
+ @Test
+ public void addVideoInfo() {
+ PPTVSeries series = pptvService.getSeriesDetail("26796");
+ pptvService.addToVideoInfo(series);
+ }
+
+ @Test
+ public void offline() {
+ List<String[]> list = HtmlToolUtil.parseSQLYogExportHtmData("C:\\Users\\Administrator\\Desktop\\鑽夌\\PPTV閲嶅鐨勭數瑙嗗墽.htm", 1);
+ for (int i = 1000; i < list.size(); i++) {
+ String[] sts = list.get(i);
+ String name = sts[0];
+ Query query = new Query();
+ query.addCriteria(Criteria.where("name").is(name));
+ PPTVSeries series = pptvSeriesDao.findOne(query);
+ if (series != null) {
+ pptvService.offLineSeries(series.getInfoID());
+ //娣诲姞鍒拌鎯�
+ try {
+ Thread.sleep(1000 * 3L);
+ } catch (InterruptedException e) {
+ e.printStackTrace();
+ }
+ series = pptvService.getSeriesDetail(series.getInfoID());
+ pptvService.addToVideoInfo(series);
+ }
+ }
+ }
+
+ @Test
+ public void reAddVideo() {
+ reAdd("姝︽灄澶栦紶");
+ }
+
+ private void reAdd(String name) {
+ Query query = new Query();
+ query.addCriteria(Criteria.where("name").is(name));
+ PPTVSeries series = pptvSeriesDao.findOne(query);
+ if (series != null) {
+ pptvService.offLineSeries(series.getInfoID());
+ //娣诲姞鍒拌鎯�
+ try {
+ Thread.sleep(1000 * 3L);
+ } catch (InterruptedException e) {
+ e.printStackTrace();
+ }
+ series = pptvService.getSeriesDetail(series.getInfoID());
+ pptvService.addToVideoInfo(series);
+ }
+ }
+
+ private List<String[]> getPPTVVideos(File f, int sheetNum) {
+ List<String[]> videoList = new ArrayList<>();
+ try {
+ jxl.Workbook rwb = Workbook.getWorkbook(new FileInputStream(f));
+ Sheet sheet = rwb.getSheet(sheetNum);
+ for (int c = 1; c < sheet.getRows(); c++) {
+ String infoId = sheet.getCell(0, c).getContents().trim();
+ String name = sheet.getCell(2, c).getContents().trim();
+ String del = sheet.getCell(21, c).getContents().trim();
+ if (!StringUtil.isNullOrEmpty(infoId) && StringUtil.isNullOrEmpty(del)) {
+ videoList.add(new String[]{infoId, name, del});
+ }
+ }
+ } catch (Exception e) {
+ e.printStackTrace();
+ }
+
+ return videoList;
+ }
+
+
+ @Test
+ public void checkPPTVVideos() {
+ List<String[]> list1 = getPPTVVideos(new File("C:\\Users\\Administrator\\Desktop\\鍏ㄩ噺.xls"), 0);
+ List<String[]> list2 = getPPTVVideos(new File("C:\\Users\\Administrator\\Desktop\\鍏ㄩ噺.xls"), 1);
+ Map<String, String[]> map = new TreeMap<>();
+ for (String[] sts : list1) {
+ map.put(sts[0], sts);
+ }
+
+ for (String[] sts : list2) {
+ map.put(sts[0], sts);
+ }
+
+ List<PPTVSeries> list = pptvSeriesDao.list(0, 10000);
+ Set<String> infoIds = new HashSet<>();
+ for (PPTVSeries s : list) {
+ infoIds.add(s.getInfoID());
+ }
+
+ for (String infoId : infoIds) {
+ map.remove(infoId);
+ }
+
+ try {
+ save(map);
+ } catch (Exception e) {
+ e.printStackTrace();
+ }
+
+ System.out.println(map);
+ }
+
+ private void save(Map<String, String[]> data) throws Exception {
+ WritableWorkbook wwb = Workbook.createWorkbook(new File("C:\\Users\\Administrator\\Desktop\\甯冧父杈撳嚭鐗囧崟_缂哄け.xls"));
+ WritableSheet sheet = wwb.createSheet("缂哄け", 0);
+ sheet.addCell((WritableCell) new Label(0, 0, "鐧剧ID"));
+ sheet.addCell((WritableCell) new Label(1, 0, "鍚嶇О"));
+ int row = 1;
+ for (Iterator<String> its = data.keySet().iterator(); its.hasNext(); ) {
+ String key = its.next();
+ sheet.addCell((WritableCell) new Label(0, row, key));
+ sheet.addCell((WritableCell) new Label(1, row, data.get(key)[1]));
+ row++;
+ }
+ wwb.write();
+ wwb.close();
+ }
+
+
+ @Test
+ public void logs() {
+// LoggerUtil.getVIPLogger().info("123123");
+
+ Map<String, String[]> data = new TreeMap<>();
+ data.put("4234234", new String[]{"4234234", "娴嬭瘯"});
+ try {
+ save(data);
+ } catch (Exception e) {
+ e.printStackTrace();
+ }
+ }
+
+ @Test
+ public void getDetail() {
+ PPTVSeries series = PPTVApiUtil.getDetail("32385373");
+ pptvService.save(series);
+ System.out.println(series);
+ }
}
--
Gitblit v1.8.0