'初始化导入'

admin

2020-08-22 813d2cae75cbae3f216de5f493af643c5a560c82

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
package com.hxh.spring.test;
 
import java.util.List;
 
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.junit.Test;
import org.springframework.orm.hibernate4.HibernateCallback;
 
import com.yeshi.buwan.dao.VideoInfoDao;
import com.yeshi.buwan.iqiyi.entity.IqiyiUpdateQueue;
import com.yeshi.buwan.iqiyi.util.IqiyiUtil;
import com.yeshi.buwan.service.imp.ClearService;
import com.yeshi.buwan.service.imp.juhe.IqiyiQueueService;
import com.yeshi.buwan.util.BeanUtil;
import com.yeshi.buwan.util.StringUtil;
 
public class Iqiyi {
    // 203879301
 
    public static void main(String[] args) {
//        IqiyiQueueService iqiyiQueueService = BeanUtil.getBean(IqiyiQueueService.class);
//        IqiyiUtil iqiyiUtil = BeanUtil.getBean(IqiyiUtil.class);
//
//        List<IqiyiUpdateQueue> queueList = iqiyiQueueService.listUpdateQueue();
//        for (IqiyiUpdateQueue queue : queueList) {
//            String aid = null;
//            int count = 0;
//            while (StringUtil.isNullOrEmpty(aid) && count < 3) {
//                if (StringUtil.isNullOrEmpty(queue.getAid())) {
//                    aid = IqiyiUtil.getAlbumIdFromPlayUrl(queue.getUrl());
//                    count++;
//                    try {
//                        Thread.sleep(1000 * 2);
//                    } catch (InterruptedException e) {
//                        e.printStackTrace();
//                    }
//                } else
//                    aid = queue.getAid();
//            }
//            if (!StringUtil.isNullOrEmpty(aid)) {
//                queue.setAid(aid);
//                iqiyiQueueService.updateUpdateQueue(queue);
//                iqiyiUtil.updateAlbum(aid);
//            }
//        }
        test3();
    }
 
    @Test
    public static void test() {
        VideoInfoDao infoDao = BeanUtil.getBean(VideoInfoDao.class);
        infoDao.excute(new HibernateCallback<List<String>>() {
            public List<String> doInHibernate(Session session) throws HibernateException {
                List list = session
                        .createSQLQuery(
                                "SELECT hv.`videoid`,v.`picture` FROM wk_video_homevideo hv LEFT JOIN wk_video_video v ON v.`id`=hv.`videoid`  WHERE  hv.`picture` IS NULL OR hv.`picture` =''")
                        .list();
                for (int i = 0; i < list.size(); i++) {
                    session.getTransaction().begin();
                    Object[] objs = (Object[]) list.get(i);
                    session.createSQLQuery("update wk_video_homevideo hv set hv.picture=? where hv.videoid=?")
                            .setParameter(0, objs[1] + "").setParameter(1, objs[0] + "").executeUpdate();
                    session.flush();
                    session.getTransaction().commit();
                }
                return null;
            }
        });
    }
 
    @Test
    public static void test2() {
        IqiyiUtil iqiyiUtil = BeanUtil.getBean(IqiyiUtil.class);
        iqiyiUtil.addShortVideo("208536001");
    }
 
    @Test
    public static void test3() {
        // Map<String, Object> map = IqiYiAPI.getAlbumList("6", "220327201", 1,
        // 50, -1);
        IqiyiUtil iqiyiUtil = BeanUtil.getBean(IqiyiUtil.class);
        // iqiyiUtil.updateSourceAlbum("233071001");
        // iqiyiUtil.updateAlbum("101160300");
        iqiyiUtil.updateAlbum("252458001");
    }
 
    public static void test4() {
        IqiyiUtil iqiyiUtil = BeanUtil.getBean(IqiyiUtil.class);
        iqiyiUtil.updateIqiyiVIP();
    }
 
    public static void test5() {
        ClearService clearService = BeanUtil.getBean(ClearService.class);
        clearService.clearInvalidIqiyiVideo();
    }
 
    public static void test6() {
        IqiyiQueueService iqiyiQueueService = BeanUtil.getBean(IqiyiQueueService.class);
        IqiyiUtil iqiyiUtil = BeanUtil.getBean(IqiyiUtil.class);
        List<IqiyiUpdateQueue> queueList = iqiyiQueueService.listUpdateQueue();
        for (IqiyiUpdateQueue queue : queueList) {
            String aid = null;
            int count = 0;
            while (StringUtil.isNullOrEmpty(aid) && count < 3) {
                if (StringUtil.isNullOrEmpty(queue.getAid())) {
                    aid = IqiyiUtil.getAlbumIdFromPlayUrl(queue.getUrl());
                    count++;
                    try {
                        Thread.sleep(1000 * 2);
                    } catch (InterruptedException e) {
                        e.printStackTrace();
                    }
                } else
                    aid = queue.getAid();
            }
            if (!StringUtil.isNullOrEmpty(aid)) {
                queue.setAid(aid);
                iqiyiQueueService.updateUpdateQueue(queue);
                iqiyiUtil.updateAlbum(aid);
            }
        }
 
    }
 
    public static void test7() {
        String aid = IqiyiUtil.getAlbumIdFromPlayUrl("http://www.iqiyi.com/v_19rr1i5o2k.html");
        IqiyiUtil iqiyiUtil = BeanUtil.getBean(IqiyiUtil.class);
        iqiyiUtil.updateAlbum(aid);
        System.out.println(aid);
    }
 
}