Models 表模型
from django.contrib.auth.models import AbstractUser
class User(AbstractUser):
"""
用户表：User
username：账号
password：密码
data_joined：注册时间
avatar：图像
telephone：电话
blog：博客站点(一对一)
"""
avatar = models.FileField(upload_to='avatar/', default="static/img/user.png") # upload_to自动生成存文件的地方，mysql只会存路径
telephone = models.CharField(max_length=11)
blog = models.OneToOneField(to="Blog", null=True, on_delete=models.SET_NULL, db_constraint=False) # 用于与站点一对一
def __str__(self):
return self.username
class Blog(models.Model):
"""
博客站点表：Blog
name：站点名
title：标题
theme：站点主体样式
category：拥有的分类(多对多)
tag: 拥有的标签(多对多)
"""
site = models.CharField(max_length=32, unique=True)
name = models.CharField(max_length=32)
title = models.CharField(max_length=64)
theme = models.CharField(max_length=128)
category = models.ManyToManyField(to="Category", db_constraint=False) # 站点与分类多对多 通过第三表连接
tag = models.ManyToManyField(to="Tag", db_constraint=False) # 站点与标签多对多 通过第三表连接
def __str__(self):
return self.name
class Category(models.Model):
# 分类表：Category
# name：分类名
name = models.CharField(max_length=32, unique=True)
def __str__(self):
return self.name
class Tag(models.Model):
# 标签表：Tag
# name：标签名
name = models.CharField(max_length=32,unique=True)
def __str__(self):
return self.name
class Article(models.Model):
# title：文章标题
# desc：文章摘要
# content：文章内容
# create_time：发布时间
# blog：所属博客站点(一对多)
# category：所属分类(一对多)
# tag：拥有的标签(多对多)
title = models.CharField(max_length=64)
desc = models.CharField(max_length=256)
# content = models.TextField() # 不经常差的提取出来，加快查询
create_time = models.DateField(auto_now_add=True)
blog = models.ForeignKey(to="Blog",null=True,on_delete=models.SET_NULL,db_constraint=False) # 站点与文章一对多
# category = models.ForeignKey(to="Category",null=True,on_delete=models.SET_NULL,db_constraint=False) # 分类与文章一对多
# tag = models.ManyToManyField(to="Tag", db_constraint=False) # 文章与标签多对多
article_detail = models.OneToOneField(to="ArticleDetail",
null=True, on_delete=models.SET_NULL, db_constraint=False, blank=True)
up_count = models.IntegerField(default=0) # 点赞数
down_count = models.IntegerField(default=0) # 点踩数
comment_count = models.IntegerField(default=0)
def __str__(self):
return self.title
# 对文章表抽取不常用字段，加快查询
class ArticleDetail(models.Model):
content = models.TextField()
category = models.ForeignKey(to="Category", null=True,on_delete=models.SET_NULL, db_constraint=False) # 分类与文章一对多
tag = models.ManyToManyField(to="Tag", db_constraint=False) # 文章与标签多对多
# def __str__(self):
# return self.category
class UpOrDown(models.Model):
# user：点赞点踩用户(一对多)
# article：点赞点踩文章(一对多)
# is_up：点赞或点踩
user = models.ForeignKey(to="User", null=True, on_delete=models.SET_NULL, db_constraint=False)
article = models.ForeignKey(to="Article", null=True, on_delete=models.SET_NULL, db_constraint=False)
is_up = models.BooleanField()
def __str__(self):
return self.user.username + " | " + self.article.title + ">>>" + str(self.is_up)
# 实际开发这种表存在大量的修改操作，不建议建立索引（索引服务于查询的）
class Meta: # 元信息
unique_together = ('user', 'article')
verbose_name = "赞踩"
verbose_name_plural = verbose_name
class Common(models.Model):
# 评论表：Common
# user：评论者(一对多)
# article：评论文章(一对多)
# content：评论内容
# parent：父评论(自关联)
user = models.ForeignKey(to="User",null=True, on_delete=models.SET_NULL, db_constraint=False)
article = models.ForeignKey(to="Article",null=True, on_delete=models.SET_NULL, db_constraint=False)
content = models.TextField()
parent = models.ForeignKey(to="self",null=True, on_delete=models.SET_NULL, db_constraint=False) # 自关联
def __str__(self):
return str(self.user.id) + "" + str(self.article.id) + "" + str(self.parent)
class Meta:
verbose_name = "评论"
verbose_name_plural = verbose_name
