| | |
| | | package com.hxh.spring.test; |
| | | |
| | | import com.google.gson.Gson; |
| | | import com.yeshi.buwan.dao.juhe.pptv.PPTVProgramDao; |
| | | import com.yeshi.buwan.dao.juhe.pptv.PPTVSeriesDao; |
| | | import com.yeshi.buwan.dao.juhe.pptv.PPTVSeriesProgramMapDao; |
| | | import com.yeshi.buwan.dao.juhe.pptv.VideoPPTVMapDao; |
| | | 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.videos.pptv.PPTVApiUtil; |
| | | import com.yeshi.buwan.videos.pptv.entity.PPTVSeries; |
| | | import com.yeshi.buwan.videos.pptv.entity.PPTVSeriesProgramMap; |
| | | import com.yeshi.buwan.videos.pptv.entity.VideoPPTVMap; |
| | | 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; |
| | |
| | | @Resource |
| | | private PPTVSeriesDao pptvSeriesDao; |
| | | |
| | | |
| | | @Resource |
| | | private PPTVProgramDao pptvProgramDao; |
| | | |
| | | @Resource |
| | | private PPTVSeriesProgramMapDao pptvSeriesProgramMapDao; |
| | | |
| | | @Resource |
| | | private VideoPPTVMapDao videoPPTVMapDao; |
| | | |
| | | |
| | | @Resource |
| | | private PPTVVideoUpdate pptvVideoUpdate; |
| | | |
| | |
| | | |
| | | @Test |
| | | public void addToVideoInfo() { |
| | | List<PPTVSeries> list = pptvSeriesDao.list(2000, 1000); |
| | | for (PPTVSeries s : list) { |
| | | if (s.getProgramType().contains("少儿") || s.getProgramType2().contains("少儿")) { |
| | | continue; |
| | | // 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()); |
| | | |
| | | Query query = new Query(); |
| | | query.addCriteria(new Criteria().orOperator(Criteria.where("programType").regex("电影"), Criteria.where("programType2").regex("电影"))); |
| | | |
| | | List<String> list = new ArrayList<>(); |
| | | |
| | | List<PPTVSeries> seriesList = pptvSeriesDao.findList(query); |
| | | for (PPTVSeries series : seriesList) { |
| | | VideoPPTVMap map = pptvService.selectVideoPPTVMapByPPInfo(series.getInfoID(), null); |
| | | |
| | | if (map != null && map.getProgramCode() == null) { |
| | | series = pptvService.getSeriesDetail(series.getInfoID()); |
| | | map.setSeriesCode(series.getSeriesCode()); |
| | | map.setProgramCode(series.getSeries().get(0).getProgramCode()); |
| | | videoPPTVMapDao.save(map); |
| | | } else { |
| | | if (map == null) { |
| | | list.add(series.getInfoID()); |
| | | // series = PPTVApiUtil.getDetail(series.getSeriesCode()); |
| | | series = pptvService.getSeriesDetail(series.getInfoID()); |
| | | pptvService.addToVideoInfo(series); |
| | | } |
| | | } |
| | | System.out.println(s.getName() + ":" + s.getInfoID()); |
| | | PPTVSeries series = pptvService.getSeriesDetail(s.getInfoID()); |
| | | pptvService.addToVideoInfo(series); |
| | | } |
| | | |
| | | System.out.println(new Gson().toJson(list)); |
| | | |
| | | |
| | | // } |
| | | } |
| | | |
| | | |
| | |
| | | @Test |
| | | public void syncVideo() { |
| | | try { |
| | | pptvVideoUpdate.syncVideo(""); |
| | | pptvVideoUpdate.syncVideo("32427297"); |
| | | } catch (Exception e) { |
| | | e.printStackTrace(); |
| | | } |
| | |
| | | } |
| | | |
| | | |
| | | @Test |
| | | public void repaire() { |
| | | |
| | | Query query = new Query(); |
| | | query.addCriteria(Criteria.where("seriesCode").is(null)); |
| | | query.limit(200); |
| | | List<PPTVSeries> list = pptvSeriesDao.findList(query); |
| | | for (PPTVSeries pptvSeries : list) { |
| | | PPTVSeriesProgramMap map = pptvSeriesProgramMapDao.getLatestByInfoId(pptvSeries.getInfoID()); |
| | | pptvService.syncSeries(map.getSeriesCode()); |
| | | } |
| | | |
| | | |
| | | } |
| | | |
| | | @Test |
| | | public void sync() { |
| | | // PPTVSeries series = pptvService.getSeriesDetailByVideoId("8268375"); |
| | | // System.out.println(series); |
| | | |
| | | |
| | | getDetail("32501376"); |
| | | |
| | | } |
| | | |
| | | |
| | | } |