需求
删除课程的同时删除云端视频

一、vod服务

1、业务

业务接口：VideoService.java

  1. void removeVideoList(List<String> videoIdList);

业务实现：VideoServiceImpl.java

  1. @Override
  2. public void removeVideoList(List<String> videoIdList) {
  3.       try {
  4.           //初始化
  5.           DefaultAcsClient client = AliyunVodSDKUtils.initVodClient(
  6.               ConstantPropertiesUtil.ACCESS_KEY_ID,
  7.               ConstantPropertiesUtil.ACCESS_KEY_SECRET);
  10.           //创建请求对象
  11.           //一次只能批量删20个
  12.           String str = org.apache.commons.lang.StringUtils.join(videoIdList.toArray(), ",");
  13.           DeleteVideoRequest request = new DeleteVideoRequest();
  14.           request.setVideoIds(str);
  17.           //获取响应
  18.           DeleteVideoResponse response = client.getAcsResponse(request);
  21.           System.out.print("RequestId = " + response.getRequestId() + "\n");
  24.       } catch (ClientException e) {
  25.           throw new GuliException(20001, "视频删除失败");
  26.       }
  28. }

2、web层接口

controller：VideoAdminController.java

  1. /**
  2.      * 批量删除视频
  3.      * @param videoIdList
  4.      * @return
  5.      */
  6. @DeleteMapping("delete-batch")
  7. public R removeVideoList(
  8.    @ApiParam(name = "videoIdList", value = "云端视频id", required = true)
  9.    @RequestParam("videoIdList") List videoIdList){
  12.    videoService.removeVideoList(videoIdList);
  13.    return R.ok().message("视频删除成功");
  15. }

3、Swagger测试

输入多个id，每个一行
image.png

二、edu服务

1、client

VodClient.java

  1. @DeleteMapping(value = "/admin/vod/video/delete-batch")
  2. public R removeVideoList(@RequestParam("videoIdList") List<String> videoIdList);

2、业务

VideoServiceImpl.java

  1. @Override
  2. public boolean removeByCourseId(String courseId) {
  5.       //根据课程id查询所有视频列表
  6.       QueryWrapper<Video> queryWrapper = new QueryWrapper<>();
  7.       queryWrapper.eq("course_id", courseId);
  8.       queryWrapper.select("video_source_id");
  9.       List<Video> videoList = baseMapper.selectList(queryWrapper);
  12.       //得到所有视频列表的云端原始视频id
  13.       List<String> videoSourceIdList = new ArrayList<>();
  14.       for (int i = 0; i < videoList.size(); i++) {
  15.           Video video = videoList.get(i);
  16.           String videoSourceId = video.getVideoSourceId();
  17.           if(!StringUtils.isEmpty(videoSourceId)){
  18.               videoSourceIdList.add(videoSourceId);
  19.           }
  20.       }
  23.       //调用vod服务删除远程视频
  24.       if(videoSourceIdList.size() > 0){
  25.           vodClient.removeVideoList(videoSourceIdList);
  26.       }
  29.       //删除video表示的记录
  30.       QueryWrapper<Video> queryWrapper2 = new QueryWrapper<>();
  31.       queryWrapper2.eq("course_id", courseId);
  32.       Integer count = baseMapper.delete(queryWrapper2);
  33.       return null != count && count > 0;
  35. }

CourseServiceImpl.java

  1. @Override
  2. public boolean removeCourseById(String id) {
  5.       //根据id删除所有视频
  6.       videoService.removeByCourseId(id);
  9.       //根据id删除所有章节
  10.       chapterService.removeByCourseId(id);
  13.       //根据id删除所有课程详情
  14.       courseDescriptionService.removeById(id);
  17.       //删除封面 TODO 独立完成
  20.       Integer result = baseMapper.deleteById(id);
  21.       return null != result && result > 0;
  23. }