边学边练之博客园----设计表

from django.db import models

# Create your models here.
from django.db import models
from django.contrib.auth.models import AbstractUser


# Create your models here.

class UserInfo(AbstractUser):
    nid = models.AutoField(primary_key=True)
    tel = models.CharField(max_length=11, null=True, unique=True)
    avatar = models.FileField(upload_to='avatars/', default='avatars/default.png')
    create_time = models.DateTimeField(verbose_name='创建时间', auto_now_add=True)

    blog = models.OneToOneField(to='Blog', to_field='nid', null=True, on_delete=models.CASCADE)

    def __str__(self):
        return self.username


class Blog(models.Model):
    nid = models.AutoField(primary_key=True)
    title = models.CharField(verbose_name='个人博客标题', max_length=64)
    site_name = models.CharField(verbose_name='个人站点名称', max_length=64)
    theme = models.CharField(verbose_name='主题', max_length=32)


class Category(models.Model):
    nid = models.AutoField(primary_key=True)
    title = models.CharField(max_length=32)

    blog = models.ForeignKey(to='Blog', to_field='nid', on_delete=models.CASCADE)

    def __str__(self):
        return self.title


class Tag(models.Model):
    nid = models.AutoField(primary_key=True)
    title = models.CharField(max_length=32)

    blog = models.ForeignKey(to='Blog', to_field='nid', on_delete=models.CASCADE)

    def __str__(self):
        return self.title


class Article(models.Model):
    nid = models.AutoField(primary_key=True)
    title = models.CharField(max_length=64)
    desc = models.CharField(max_length=255)
    create_time = models.DateTimeField(verbose_name='创建时间', auto_now_add=True)

    content = models.TextField()

    comment_count = models.IntegerField(default=0)            # 直接在这里加上这几项，就不需要去相关表里查找了
    up_count = models.IntegerField(default=0)
    down_count = models.IntegerField(default=0)

    user = models.ForeignKey(to='UserInfo',to_field='nid',on_delete=models.CASCADE)
    category = models.ForeignKey(to='Category',to_field='nid',null=True,on_delete=models.CASCADE)
    tags =  models.ManyToManyField(to='Tag',through='Article2Tag',through_fields=('article','tag'))

    def __str__(self):
        return self.title

class Article2Tag(models.Model):
    nid = models.AutoField(primary_key=True)
    article = models.ForeignKey(to='Article',to_field='nid',on_delete=models.CASCADE)
    tag = models.ForeignKey(to='Tag',to_field='nid',on_delete=models.CASCADE)

    class Meta:
        unique_together=[('article','tag')]  # 联合唯一

    def __str__(self):
        v = self.article.title + "---" + self.tag.title
        return v

class ArticleUpDown(models.Model):
    nid = models.AutoField(primary_key=True)
    article = models.ForeignKey(to='Article',to_field='nid',null=True,on_delete=models.CASCADE)
    user = models.ForeignKey(to='UserInfo',to_field='nid',null=True,on_delete=models.CASCADE)
    is_up = models.BooleanField(default=True)

    class Meta:
        unique_together=[('article','user')]

class Comment(models.Model):
    nid=models.AutoField(primary_key=True)
    article = models.ForeignKey(to='Article',to_field='nid',on_delete=models.CASCADE)
    user = models.ForeignKey(to='UserInfo',to_field='nid',on_delete=models.CASCADE)
    content = models.CharField(max_length=255)
    create_time = models.DateTimeField(verbose_name='创建时间',auto_now_add=True)
    parent_comment = models.ForeignKey('self',null=True,on_delete=models.CASCADE)

    def __str__(self):
        return self.content