第二天：django+vue 编写models层和view层基础

models层---用户管理

from django.db import models
import hashlib
from django.contrib.auth.models import AbstractUser

models层--基类

• 把公共的字段，定义在基类，其他类继承基类即可

class BaseModel(models.Model):
    updated_tm = models.DateTimeField(auto_now=True)
    created_tm = models.DateTimeField(auto_now_add=True)

    class Meta:
        abstract = True

models层--用户基本信息

• 继承基类，即可拥有基类的全部字段
• 继承AbstractUser，实现使用自定义用户列表进行注册登录、身份校验等
• 这里使用密码MD5加密方式，后期使用自定义的用户表做注册登录
• 数据删除使用软删除方式，依然保留已删除的数据

class UserList(AbstractUser, BaseModel):
    user_id = models.AutoField(help_text="用户id", primary_key=True)
    username = models.SlugField(max_length=128, help_text="用户名", unique=True)
    password = models.CharField(max_length=128, help_text="用户密码")
    is_disable = models.BooleanField(default=False, help_text='是否禁用')
    is_delete = models.BooleanField(default=False, help_text='逻辑删除')

    # 指定数据库表信息
    class Meta:
        db_table = 'user_list'
        verbose_name = '用户基础信息'
        verbose_name_plural = verbose_name

    # 重写save方法，新增密码md5加密逻辑
    def save(self, *args, **kwargs):
        md5 = hashlib.md5()
        md5.update(self.password.encode())
        self.password = md5.hexdigest()
        super(UserList, self).save(*args, **kwargs)

    def delete(self, using=None, keep_parents=False):
        """重写数据库删除方法实现逻辑删除"""
        self.is_delete = True
        self.save()

models层--用户登录信息

• ForeignKey：一对多关联用户基本信息表
• 插拔式连表查询，用于序列化器，随插随用，后期具体讲

class UserRole(BaseModel):
    user_token = models.CharField(max_length=256, help_text="token")
    user_info = models.ForeignKey(to=UserList, on_delete=models.DO_NOTHING, db_constraint=False, related_name='user_base', unique=True)

    # 指定数据库表信息
    class Meta:
        db_table = 'user_role'
        verbose_name = '用户登录信息'
        verbose_name_plural = verbose_name

    # 插拔式连表查询
    @property
    def user_name(self):
        return self.user_info.username

    @property
    def user_id(self):
        return self.user_info.user_id

models层--用户详情信息

• ForeignKey：一对多关联用户基本信息表
• 插拔式连表查询，用于序列化器，随插随用，后期具体讲

class UserDetail(BaseModel):
    user_email = models.EmailField(blank=True, default="", help_text='用户邮箱')
    user_introduction = models.CharField(max_length=128, help_text="用户简介")
    nickname = models.CharField(max_length=128, help_text="用户昵称")
    user_info = models.ForeignKey(to=UserList, on_delete=models.DO_NOTHING, db_constraint=False, related_name='user')

    # 指定数据库表信息
    class Meta:
        db_table = 'user_detail'
        verbose_name = '用户详情信息'
        verbose_name_plural = verbose_name

    # 插拔式连表查询
    @property
    def user_name(self):
        return self.user_info.username

    @property
    def user_id(self):
        return self.user_info.user_id

models层---项目管理

# 引入之前定义的基类，基类可以放随意地方
from django.db import models
from auto_test_platform.my_user.models import BaseModel
# Create your models here.

models层--项目基本信息

• 继承基类，即可拥有基类的全部字段
• 数据删除使用软删除方式，依然保留已删除的数据

class ProjectList(BaseModel):
    project_id = models.AutoField(help_text="项目id", primary_key=True)
    project_name = models.CharField(max_length=128, help_text="项目名称")
    is_disable = models.BooleanField(default=False, help_text='是否禁用')
    is_delete = models.BooleanField(default=False, help_text='逻辑删除')

    # 指定数据库表信息
    class Meta:
        db_table = 'project_list'
        verbose_name = '项目基本信息'
        verbose_name_plural = verbose_name

    def delete(self, using=None, keep_parents=False):
        """重写数据库删除方法实现逻辑删除"""
        self.is_delete = True
        self.save()

models层--项目详情信息

• ForeignKey：一对多关联项目基本信息表
• 插拔式连表查询，用于序列化器，随插随用，后期具体讲

class ProjectDetail(BaseModel):
    project_description = models.CharField(max_length=256, help_text="项目描述")
    project_info = models.ForeignKey(to=ProjectList, on_delete=models.DO_NOTHING, db_constraint=False, related_name='project_base', unique=True)

    # 指定数据库表信息
    class Meta:
        db_table = 'project_detail'
        verbose_name = '项目详情信息'
        verbose_name_plural = verbose_name

    # 插拔式连表查询
    @property
    def project_id(self):
        return self.project_info.project_id

    @property
    def project_name(self):
        return self.project_info.project_name

view层---用户管理信息

from auto_test_platform.my_user.models import UserList, UserRole, UserDetail
from rest_framework import mixins, generics


# Create your views here.
class UserListView(mixins.CreateModelMixin, mixins.ListModelMixin, mixins.UpdateModelMixin, generics.GenericAPIView):
    # 查询未删除的数据，数据排序方式为新增时间倒序，去掉-，即为顺序排序
    queryset = UserList.objects.filter(is_delete=0).all().order_by('-created_tm')


class UserRoleView(mixins.CreateModelMixin, mixins.ListModelMixin, mixins.UpdateModelMixin, generics.GenericAPIView):
    # 查询未删除的数据，数据排序方式为新增时间倒序，去掉-，即为顺序排序
    queryset = UserRole.objects.filter(is_delete=0).all().order_by('-created_tm')


class UserDetailView(mixins.CreateModelMixin, mixins.ListModelMixin, mixins.UpdateModelMixin, generics.GenericAPIView):
    # 查询未删除的数据，数据排序方式为新增时间倒序，去掉-，即为顺序排序
    queryset = UserDetail.objects.filter(is_delete=0).all().order_by('-created_tm')

view层-项目列表信息

from rest_framework import mixins, generics
from project.project_list.models import ProjectList


# Create your views here.
class ProjectListView(mixins.CreateModelMixin, mixins.ListModelMixin, mixins.UpdateModelMixin, generics.GenericAPIView):
    # 查询未删除的数据，数据排序方式为新增时间倒序，去掉-，即为顺序排序
    queryset = ProjectList.objects.filter(is_delete=0).all().order_by('-created_tm')

view层-项目详情信息

from rest_framework import mixins, generics
from project.project_detail.models import ProjectDetail


# Create your views here.
class ProjectDetailView(mixins.CreateModelMixin, mixins.ListModelMixin, mixins.UpdateModelMixin, generics.GenericAPIView):
    # 查询未删除的数据，数据排序方式为新增时间倒序，去掉-，即为顺序排序
    queryset = ProjectDetail.objects.filter(is_delete=0).all().order_by('-created_tm')