day 112,在day111的基础上添加了认证
models.py,表有更新
from django.db import models # Create your models here. from django.db import models from django.contrib.contenttypes.fields import GenericForeignKey, GenericRelation from django.contrib.contenttypes.models import ContentType # Create your models here. __all__ = ["Category", "Course", "CourseDetail", "Teacher", "DegreeCourse", "CourseChapter", "CourseSection", "PricePolicy", "OftenAskedQuestion", "Comment", "Account", "CourseOutline"] class Account(models.Model): """ 用户表 """ username = models.CharField(max_length=32, verbose_name="用户姓名") password = models.CharField(max_length=128,verbose_name="密码",null=True) type_choices = [(1,"普通用户"),(2,"VIP"),(3,"SVIP")] user_type = models.IntegerField(choices=type_choices,default=1) # head_img = models.CharField(max_length=256, default='/static/frontend/head_portrait/logo@2x.png', # verbose_name="个人头像") def __str__(self): return self.username class Meta: verbose_name = "11-用户表" db_table = verbose_name verbose_name_plural = verbose_name class UserToken(models.Model): user = models.OneToOneField("Account") token = models.CharField(max_length=32) create_time=models.DateField(auto_now_add=True)#auto_now_add自动添加更新时间 class Category(models.Model): """课程分类表""" title = models.CharField(max_length=32, unique=True, verbose_name="课程的分类") def __str__(self): return self.title class Meta: verbose_name = "01-课程分类表" db_table = verbose_name verbose_name_plural = verbose_name class Course(models.Model): """课程表""" title = models.CharField(max_length=128, unique=True, verbose_name="课程的名称") course_img = models.ImageField(upload_to="course/%Y-%m", verbose_name='课程的图片',null=True,blank=True) category = models.ForeignKey(to="Category", verbose_name="课程的分类") COURSE_TYPE_CHOICES = ((0, "付费"), (1, "vip专享"), (2, "学位课程")) course_type = models.SmallIntegerField(choices=COURSE_TYPE_CHOICES) degree_course = models.ForeignKey(to="DegreeCourse", blank=True, null=True, help_text="如果是学位课程,必须关联学位表") brief = models.CharField(verbose_name="课程简介", max_length=1024) level_choices = ((0, '初级'), (1, '中级'), (2, '高级')) level = models.SmallIntegerField(choices=level_choices, default=1) status_choices = ((0, '上线'), (1, '下线'), (2, '预上线')) status = models.SmallIntegerField(choices=status_choices, default=0) pub_date = models.DateField(verbose_name="发布日期", blank=True, null=True) order = models.IntegerField("课程顺序", help_text="从上一个课程数字往后排,尽量间隔几个数字") study_num = models.IntegerField(verbose_name="学习人数", help_text="只要有人买课程,订单表加入数据的同时给这个字段+1") # order_details = GenericRelation("OrderDetail", related_query_name="course") # coupon = GenericRelation("Coupon") # 只用于反向查询不生成字段 price_policy = GenericRelation("PricePolicy") often_ask_questions = GenericRelation("OftenAskedQuestion") course_comments = GenericRelation("Comment") def save(self, *args, **kwargs): if self.course_type == 2: if not self.degree_course: raise ValueError("学位课必须关联学位课程表") super(Course, self).save(*args, **kwargs) def __str__(self): return self.title class Meta: verbose_name = "02-课程表" db_table = verbose_name verbose_name_plural = verbose_name class CourseDetail(models.Model): """课程详细表""" course = models.OneToOneField(to="Course",related_name='coursedetail') hours = models.IntegerField(verbose_name="课程时长", default=7) # course_slogan = models.CharField(max_length=125, blank=True, null=True, verbose_name="课程口号") video_brief_link = models.CharField(max_length=255, blank=True, null=True) summary = models.TextField(max_length=2048, verbose_name="课程概述") why_study = models.TextField(verbose_name="为什么学习这门课程") what_to_study_brief = models.TextField(verbose_name="我将学到哪些内容") career_improvement = models.TextField(verbose_name="此项目如何有助于我的职业生涯") prerequisite = models.TextField(verbose_name="课程先修要求", max_length=1024) recommend_courses = models.ManyToManyField("Course", related_name="recommend_by", blank=True) teachers = models.ManyToManyField("Teacher", verbose_name="课程讲师") def __str__(self): return self.course.title class Meta: verbose_name = "03-课程详细表" db_table = verbose_name verbose_name_plural = verbose_name class Teacher(models.Model): """讲师表""" name = models.CharField(max_length=32, verbose_name="讲师名字") brief = models.TextField(max_length=1024, verbose_name="讲师介绍") def __str__(self): return self.name class Meta: verbose_name = "04-教师表" db_table = verbose_name verbose_name_plural = verbose_name class DegreeCourse(models.Model): """ 字段大体跟课程表相同,哪些不同根据业务逻辑去区分 """ title = models.CharField(max_length=32, verbose_name="学位课程名字") def __str__(self): return self.title class Meta: verbose_name = "05-学位课程表" db_table = verbose_name verbose_name_plural = verbose_name class CourseChapter(models.Model): """课程章节表""" course = models.ForeignKey(to="Course", related_name="course_chapters") chapter = models.SmallIntegerField(default=1, verbose_name="第几章") title = models.CharField(max_length=32, verbose_name="课程章节名称") def __str__(self): return self.title class Meta: verbose_name = "06-课程章节表" db_table = verbose_name verbose_name_plural = verbose_name unique_together = ("course", "chapter") class CourseSection(models.Model): """课时表""" chapter = models.ForeignKey(to="CourseChapter", related_name="course_sections") title = models.CharField(max_length=32, verbose_name="课时") section_order = models.SmallIntegerField(verbose_name="课时排序", help_text="建议每个课时之间空1至2个值,以备后续插入课时") section_type_choices = ((0, '文档'), (1, '练习'), (2, '视频')) free_trail = models.BooleanField("是否可试看", default=False) section_type = models.SmallIntegerField(default=2, choices=section_type_choices) section_link = models.CharField(max_length=255, blank=True, null=True, help_text="若是video,填vid,若是文档,填link") def course_chapter(self): return self.chapter.chapter def course_name(self): return self.chapter.course.title def __str__(self): return "%s-%s" % (self.chapter, self.title) class Meta: verbose_name = "07-课程课时表" db_table = verbose_name verbose_name_plural = verbose_name unique_together = ('chapter', 'section_link') class PricePolicy(models.Model): """价格策略表""" # conten_type 指定表id content_type = models.ForeignKey(ContentType) # 关联course or degree_course # 关联的表里的对象id object_id = models.PositiveIntegerField() # 关联的表里的那个对象 content_object = GenericForeignKey('content_type', 'object_id') valid_period_choices = ((1, '1天'), (3, '3天'), (7, '1周'), (14, '2周'), (30, '1个月'), (60, '2个月'), (90, '3个月'), (120, '4个月'), (180, '6个月'), (210, '12个月'), (540, '18个月'), (720, '24个月'), (722, '24个月'), (723, '24个月'), ) # 周期 valid_period = models.SmallIntegerField(choices=valid_period_choices) # 价格 price = models.FloatField() def __str__(self): return "%s(%s)%s" % (self.content_object, self.get_valid_period_display(), self.price) class Meta: verbose_name = "08-价格策略表" db_table = verbose_name verbose_name_plural = verbose_name unique_together = ("content_type", 'object_id', "valid_period") class OftenAskedQuestion(models.Model): """常见问题""" content_type = models.ForeignKey(ContentType) # 关联course or degree_course object_id = models.PositiveIntegerField() content_object = GenericForeignKey('content_type', 'object_id') question = models.CharField(max_length=255) answer = models.TextField(max_length=1024) def __str__(self): return "%s-%s" % (self.content_object, self.question) class Meta: verbose_name = "09-常见问题表" db_table = verbose_name verbose_name_plural = verbose_name unique_together = ('content_type', 'object_id', 'question') class Comment(models.Model): """通用的评论表""" content_type = models.ForeignKey(ContentType, blank=True, null=True) object_id = models.PositiveIntegerField(blank=True, null=True) content_object = GenericForeignKey('content_type', 'object_id') content = models.TextField(max_length=1024, verbose_name="评论内容") account = models.ForeignKey("Account", verbose_name="会员名") date = models.DateTimeField(auto_now_add=True) def __str__(self): return self.content class Meta: verbose_name = "10-评价表" db_table = verbose_name verbose_name_plural = verbose_name class CourseOutline(models.Model): """课程大纲""" course_detail = models.ForeignKey(to="CourseDetail", related_name="course_outline") title = models.CharField(max_length=128) order = models.PositiveSmallIntegerField(default=1) # 前端显示顺序 content = models.TextField("内容", max_length=2048) def __str__(self): return "%s" % self.title class Meta: verbose_name = "12-课程大纲表" db_table = verbose_name verbose_name_plural = verbose_name unique_together = ('course_detail', 'title')
在utils里创建auth.py写认证类
from rest_framework.authentication import BaseAuthentication from course.models import UserToken from rest_framework.exceptions import AuthenticationFailed from django.core.cache import cache from django.utils.timezone import utc import datetime #第一版普通版本解决不了时效和缓存 # class LoginAuth(BaseAuthentication): # def authenticate(self, request): # print("request.META",request.META.get("HTTP_AUTHENTICATE")) # token=request.META.get("HTTP_AUTHENTICATE") # token = UserToken.objects.filter(token=token).first() # # if token: # return token.user,token.token # else: # raise AuthenticationFailed("认证失败") #第二版解决时效和缓存 class LoginAuth(BaseAuthentication): def authenticate(self,request): print("request.META",request.META.get("HTTP_AUTHENTICATE")) token=request.META.get("HTTP_AUTHENTICATE",'')#从响应头里获取 # 缓存查询token是否存在(第一次进来的时候token不存在,走数据库) ret=cache.get("token_"+token) #价格字符串做标识 if ret: return "token_"+token,ret try: # 数据库查询是否存在token token=UserToken.objects.get(token=token) except Exception as e: raise AuthenticationFailed("认证失败!") # token是否过期 utcnow = datetime.datetime.utcnow().replace(tzinfo=utc) #当前时间 if utcnow - token.create_time > datetime.timedelta(days=14): #当前时间-token创建时间> 数据库设定存活时间 14天 raise AuthenticationFailed('认证信息过期') # 加入缓存 cache_token="token_"+token.token #"token_"做标识 # 14+create-now > 7 delta=utcnow-token.create_time#当前时间-创建时间 delta_7=datetime.timedelta(days=7) cache.set(cache_token,token.user,min(delta_7,delta).total_seconds())#total_seconds()转化为秒 # 返回元组 return token.user,cache_token
在视图里添加认证类
from rest_framework import serializers from rest_framework.views import APIView from rest_framework import generics from rest_framework.viewsets import ModelViewSet from rest_framework.response import Response from course.models import Course from course.utils.serlizer import CourseModelSerializer from course.utils.auth import LoginAuth class CourseView(ModelViewSet): authentication_classes = [LoginAuth] #认证 queryset = Course.objects.all() serializer_class = CourseModelSerializer # def list(self, request, *args, **kwargs): # queryset = self.filter_queryset(self.get_queryset()) # page = self.paginate_queryset(queryset) # # response={"code":1000,"data":None,"err_msg":""} # # if page is not None: # serializer = self.get_serializer(page, many=True) # response["data"]=serializer.data # return self.get_paginated_response(response) # # serializer = self.get_serializer(queryset, many=True) # response["data"] = serializer.data # return Response(response)
其他代码都一样
posted on 2018-11-14 16:13 liangliang123456 阅读(131) 评论(0) 编辑 收藏 举报