vue框架前后端分离项目之课程详情、课程章节接口及课程详情前台、云对象储存托管等相关内容-129

1 课程详情接口,课程章节接口

1 查询所有课程接口
2 查询单个课程接口
-继续再查询所有接口上写
   -再写一个视图类,单独写查询课程详情接口

4 写课程章节接口,每个章节下有很多课程
Linux从入门到精通
  第一章节:入门
      1 安装环境
           2 配置环境
           3 放弃
        第二章节:入土
      1 哇肯恶搞
           2 挖坑
   
   
   
   
  Python从入门到精通
  第一章节:入门
      1 安装环境
           2 配置环境
           3 放弃
        第二章节:入土
      1 哇肯恶搞
           2 挖坑

课程详情接口

class CourseView(GenericViewSet, ListModelMixin,RetrieveModelMixin):
   queryset = Course.objects.filter(is_delete=False, is_show=True).order_by('-orders')
   serializer_class =CourseSerializer
   filter_backends = [OrderingFilter,DjangoFilterBackend]
   ordering_fields = ['id', 'price', 'students']
   filter_fields = ['course_category']
   pagination_class =BasicPagination

 

课程章节接口(views.py)

class ChapterViewSet(GenericViewSet,ListModelMixin):
   queryset = CourseChapter.objects.filter(is_show=True,is_delete=False).order_by('orders')
   serializer_class = CourseChapterSerializer

   # 加上过滤功能,按课程的id号来过滤
   filter_backends = [DjangoFilterBackend]
   filter_fields = ['course']

序列化类

## 课时序列化类
class CourseSectionSerializer(serializers.ModelSerializer):
   class Meta:
       model = CourseSection
       fields='__all__'


# 课程章节序列化类
class CourseChapterSerializer(serializers.ModelSerializer):
   # 子序列化,课时是多条,一定要写many=True
   coursesections=CourseSectionSerializer(many=True)
   class Meta:
       model = CourseChapter
       fields=['course','chapter','name','summary','pub_date','coursesections']

路由

router.register('chapters',ChapterViewSet,'ChapterViewSet')

 

2 课程详情前台

# 取路径中的值
    mounted() {
               //http://localhost:8080/course/detail/79?name=lqz&age=18
               console.log(this.$route.params) //打印出{pk:79}
               console.log(this.$route.query)//打印出{name:lqz,age:18}
      },

 

3 七牛云对象存储托管视频

1 视频文件,图片文件之前保存在自己服务器
2 搭建自己的存储服务器(fastdfs,go-fastdfs)
-https://sjqzhang.github.io/go-fastdfs/usage.html#python
-docekr 拉起一个来 http://10.1.5.9:8080/group1/upload
   import requests
   url = 'http://10.1.5.9:8080/group1/upload'
   files = {'file': open('report.xls', 'rb')}
   options={'output':'json','path':'','scene':''} #参阅浏览器上传的选项
   r = requests.post(url,data=options, files=files)
   print(r.text)
   
3 第三方云存储(阿里云oss,七牛云存储。。。。)
七牛云托管视频(go语言的践行者)
# from qiniu import Auth, put_file, etag
# import qiniu.config
# #需要填写你的 Access Key 和 Secret Key
# access_key = '-BoMxfk8dxgDq87mA-qLkgmI_AHYfF27tOFan_NJ'
# secret_key = 'Wijh6Fg6gedtBqoqKElkxrrlySoiVWbFSfQ6I-qM'
# #构建鉴权对象
# q = Auth(access_key, secret_key)
# #要上传的空间
# bucket_name = 'lqz'
# #上传后保存的文件名
# key = 'lqz.mp4'
# #生成上传 Token,可以指定过期时间等
# token = q.upload_token(bucket_name, key, 3600)
# #要上传文件的本地路径
# localfile = './6-测试功能.mp4'
# ret, info = put_file(token, key, localfile)
# print(info)
# assert ret['key'] == key
# assert ret['hash'] == etag(localfile)



# 删除视频
# from qiniu import Auth
# from qiniu import BucketManager
# access_key = '-BoMxfk8dxgDq87mA-qLkgmI_AHYfF27tOFan_NJ'
# secret_key = 'Wijh6Fg6gedtBqoqKElkxrrlySoiVWbFSfQ6I-qM'
# #初始化Auth状态
# q = Auth(access_key, secret_key)
# #初始化BucketManager
# bucket = BucketManager(q)
# #你要测试的空间, 并且这个key在你空间中存在
# bucket_name = 'lqz'
# key = 'lqz.mp4'
# #删除bucket_name 中的文件 key
# ret, info = bucket.delete(bucket_name, key)
# print(info)

# import requests
#
#
# res=requests.get('https://vd3.bdstatic.com/mda-kkena9xzt4hmb7b7/sc/cae_h264_clips/1605430730/mda-kkena9xzt4hmb7b7.mp4?auth_key=1610529585-0-0-14a58ce4cca097b0a5c823cc506d95da&bcevod_channel=searchbox_feed&pd=1&pt=3&abtest=8656_1')
# with open('致命诱惑.mp4','wb') as f:
#     for line in res.iter_content():
#         f.write(line)






'''

通过该程序下载的视频和音频是分成连个文件的,没有合成,
视频为:视频名_video.mp4
音频为:视频名_audio.mp4
修改url的值,换成自己想下载的页面节课
'''

# 导入requests模块,模拟发送请求
import requests
# 导入json
import json
# 导入re
import re

# 定义请求头
headers = {
   'Accept': '*/*',
   'Accept-Language': 'en-US,en;q=0.5',
   'User-Agent': 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.84 Safari/537.36'
}


# 正则表达式,根据条件匹配出值
def my_match(text, pattern):
   match = re.search(pattern, text)
   print(match.group(1))
   print()
   return json.loads(match.group(1))


def download_video(old_video_url, video_url, audio_url, video_name):
   headers.update({"Referer": old_video_url})
   print("开始下载视频:%s" % video_name)
   video_content = requests.get(video_url, headers=headers)
   print('%s视频大小:' % video_name, video_content.headers['content-length'])
   audio_content = requests.get(audio_url, headers=headers)
   print('%s音频大小:' % video_name, audio_content.headers['content-length'])
   # 下载视频开始
   received_video = 0
   with open('%s_video.mp4' % video_name, 'ab') as output:
       while int(video_content.headers['content-length']) > received_video:
           headers['Range'] = 'bytes=' + str(received_video) + '-'
           response = requests.get(video_url, headers=headers)
           output.write(response.content)
           received_video += len(response.content)
   # 下载视频结束
   # 下载音频开始
   audio_content = requests.get(audio_url, headers=headers)
   received_audio = 0
   with open('%s_audio.mp4' % video_name, 'ab') as output:
       while int(audio_content.headers['content-length']) > received_audio:
           # 视频分片下载
           headers['Range'] = 'bytes=' + str(received_audio) + '-'
           response = requests.get(audio_url, headers=headers)
           output.write(response.content)
           received_audio += len(response.content)
   # 下载音频结束
   return video_name


if __name__ == '__main__':
   # 换成你要爬取的视频地址
   url = 'https://www.bilibili.com/video/BV1TA411H7gQ'
   # 发送请求,拿回数据
   res = requests.get(url, headers=headers)
   # 视频详情json
   playinfo = my_match(res.text, '__playinfo__=(.*?)</script><script>')
   # 视频内容json
   initial_state = my_match(res.text, r'__INITIAL_STATE__=(.*?);(function()')
   # 视频分多种格式,直接取分辨率最高的视频 1080p
   video_url = playinfo['data']['dash']['video'][0]['baseUrl']
   # 取出音频地址
   audio_url = playinfo['data']['dash']['audio'][0]['baseUrl']
   video_name = initial_state['videoData']['title']
   print('视频名字为:video_name')
   print('视频地址为:', video_url)
   print('音频地址为:', audio_url)
   download_video(url, video_url, audio_url, video_name)

4 区间过滤

1 查询课程价格大于30小于90的课程
http://127.0.0.1:8000/course/free/?price_ge=30&price_lt=90
2 写一个过滤类,配置在视图类中
filter_backends = [SearchByPrice]




3 通过扩写django-filter来实现该功能
   

 

 

原文地址:https://www.cnblogs.com/usherwang/p/14284284.html