From eb7f3343af839a7c71f16e8ada2b25d5e2201c08 Mon Sep 17 00:00:00 2001
From: admin <weikou2014>
Date: 星期一, 19 四月 2021 19:27:52 +0800
Subject: [PATCH] bug修复

---
 src/test/java/com/hxh/spring/test/PPTVTest.java |   88 +++++++++++++++++++++++++++++++++-----------
 1 files changed, 66 insertions(+), 22 deletions(-)

diff --git a/src/test/java/com/hxh/spring/test/PPTVTest.java b/src/test/java/com/hxh/spring/test/PPTVTest.java
index 03cc422..aa22cfd 100644
--- a/src/test/java/com/hxh/spring/test/PPTVTest.java
+++ b/src/test/java/com/hxh/spring/test/PPTVTest.java
@@ -19,6 +19,7 @@
 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;
@@ -75,8 +76,20 @@
 
     @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.updateLatestVideo("");
+            pptvVideoUpdate.syncVideo("");
         } catch (Exception e) {
             e.printStackTrace();
         }
@@ -90,7 +103,8 @@
 
     @Test
     public void getApiDetail() {
-        PPTVApiUtil.getDetail("32159127,10215224,15326213");
+        PPTVSeries series = PPTVApiUtil.getDetail("28544897");
+        System.out.println(series);
     }
 
 
@@ -119,8 +133,11 @@
 
     @Test
     public void addVideoInfo() {
-        PPTVSeries series = pptvService.getSeriesDetail("26796");
+//        List<PPTVSeries> seriesList = pptvSeriesDao.list("灏戝効", 0, 100);
+//        for (PPTVSeries series : seriesList) {
+        PPTVSeries series = pptvService.getSeriesDetail("381472");
         pptvService.addToVideoInfo(series);
+//        }
     }
 
     @Test
@@ -175,7 +192,7 @@
             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 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});
@@ -194,31 +211,37 @@
         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());
-        }
+//        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 infoId : infoIds) {
-            map.remove(infoId);
-        }
+        for (String code : sets)
+            getDetail(code);
 
-        try {
-            save(map);
-        } catch (Exception e) {
-            e.printStackTrace();
-        }
+//        try {
+//            save(map);
+//        } catch (Exception e) {
+//            e.printStackTrace();
+//        }
 
-        System.out.println(map);
+//        System.out.println(map);
     }
 
     private void save(Map<String, String[]> data) throws Exception {
@@ -251,11 +274,32 @@
         }
     }
 
-    @Test
-    public void getDetail() {
-        PPTVSeries series = PPTVApiUtil.getDetail("32385373");
+    //    @Test
+    public void getDetail(String sCode) {
+        PPTVSeries series = PPTVApiUtil.getDetail(sCode);
         pptvService.save(series);
-        System.out.println(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