From 5300c070d95f9f3d6222b149e8431e77e9337637 Mon Sep 17 00:00:00 2001
From: admin <weikou2014>
Date: 星期二, 13 四月 2021 18:33:58 +0800
Subject: [PATCH] 单片购买
---
src/test/java/com/hxh/spring/test/PPTVTest.java | 292 +++++++++++++++++++++++++++++++++++++++++++++++++++++++---
1 files changed, 276 insertions(+), 16 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..aa22cfd 100644
--- a/src/test/java/com/hxh/spring/test/PPTVTest.java
+++ b/src/test/java/com/hxh/spring/test/PPTVTest.java
@@ -1,46 +1,306 @@
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.data.mongodb.core.query.Update;
+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(){
- PPTVApiUtil.getDetail("32159127,10215224,15326213");
+ public void test() {
+ PPTVApiUtil.getOpenId("123");
+ }
+
+ @Test
+ public void update() {
+// try {
+// pptvVideoUpdate.updateLatestVideo("");
+// } catch (Exception e) {
+// e.printStackTrace();
+// }
+
+ List<PPTVSeries> list = PPTVApiUtil.getUpdateList();
+ System.out.println(list);
+ }
+
+ @Test
+ public void syncVideo() {
+ try {
+ pptvVideoUpdate.syncVideo("");
+ } catch (Exception e) {
+ e.printStackTrace();
+ }
+ }
+
+ @Test
+ public void login() {
+ PPTVApiUtil.login("zcoAY6ev7RpYSLzXKtWybniCK+sgBiCARUii_uyNdFw-");
}
+ @Test
+ public void getApiDetail() {
+ PPTVSeries series = PPTVApiUtil.getDetail("28544897");
+ System.out.println(series);
+ }
+
+
+ @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() {
+// List<PPTVSeries> seriesList = pptvSeriesDao.list("灏戝効", 0, 100);
+// for (PPTVSeries series : seriesList) {
+ PPTVSeries series = pptvService.getSeriesDetail("381472");
+ 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(1, 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<>();
+ Set<String> sets = new HashSet<>();
+ for (String[] sts : list1) {
+ map.put(sts[0], sts);
+ sets.add(sts[1]);
+ }
+
+ for (String[] sts : list2) {
+ map.put(sts[0], sts);
+ sets.add(sts[1]);
+ }
+
+// 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);
+// }
+
+ for (String code : sets)
+ getDetail(code);
+
+// 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(String sCode) {
+ PPTVSeries series = PPTVApiUtil.getDetail(sCode);
+ pptvService.save(series);
+ }
+
+
+ @Test
+ public void buy() {
+ PPTVApiUtil.buyGoods("257dfd950c20ad25dee9f99ef926c0f8", "danpian-1", "AB5574873120458", new Date());
+ }
+
+ @Test
+ public void updateGoodsInfo() {
+ Query query = new Query();
+ query.addCriteria(new Criteria("goodsInfo").is(null).andOperator(Criteria.where("free").is("1")));
+ query.limit(400);
+ List<PPTVSeries> list = pptvSeriesDao.findList(query);
+ for (PPTVSeries series : list) {
+ PPTVSeries detail = PPTVApiUtil.getDetail(series.getSeriesCode());
+ query = new Query();
+ query.addCriteria(Criteria.where("_id").is(detail.getInfoID()));
+ Update update = new Update();
+ update.set("goodsInfo", detail.getGoodsInfo());
+ pptvSeriesDao.update(query, update);
+ }
+ }
}
--
Gitblit v1.8.0