爱奇艺/风行资源优化

admin

2020-10-27 69cb3ca5c0fd5f78b0c33bf92601066a37b0209e

 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());
        }
    }

}