django 个人博客系统开发 - 数据库设计与django Model

*数据库的设计主要针对一个特定的环境，为了满足有效的数据存储和处理，需要构造最有的数据库模式。

*工具

PowerDesign, ERWin, Visio, Navicat Data Modeler

*如何设计

分析可能存在的数据表

分析可能催在的数据列，及类型和约束

设计数据模型图

使用Navicat Data Modeler

-----------------------------------

*创建一个mysql db

CREATE DATABASE blogdb character set=utf8;

*settings.py设置mysql

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'blogdb',
        'USER': 'root',# 正式发布时不能用root,有安全隐患
        'PASSWORD': 'kylie',
        'HOST': '',
        'PORT': '',
    }
}

*blog.models 继承user, 并定义需要的模型

# -*- coding:utf-8 -*-
from django.db import models
from django.contrib.auth.models import AbstractUser


# Create your models here.

# 用户模型
class User(AbstractUser):
    avatar = models.ImageField(upload_to='avatar/%Y/%m', default='avatar/defaut.png')
    qq = models.CharField(max_length=20, blank=True, null=True, unique=True, verbose_name='QQ号')
    mobile = models.CharField(max_length=11, blank=True, null=True, unique=True, verbose_name='手机号')

    class Meta:
        verbose_name = '用户'
        verbose_name_plural = verbose_name
        ordering = ['-id']

    def __str__(self):
        return self.username


class Tag(models.Model):
    name = models.CharField(max_length=30, verbose_name='标签名称')

    class Meta:
        verbose_name = '标签'
        verbose_name_plural = verbose_name

    def __str__(self):
        return self.name


class Cateory(models.Model):
    name = models.CharField(max_length=30, verbose_name='分类名称')
    index = models.IntegerField(default=999, verbose_name='分类的排序')

    class Meta:
        verbose_name = '分类'
        verbose_name_plural = verbose_name

    def __str__(self):
        return self.name


class Article(models.Model):
    title = models.CharField(max_length=50, verbose_name='文章标题')
    desc = models.CharField(max_length=50, verbose_name='文章描述')
    content = models.TextField(verbose_name='文章内容')
    click_count = models.IntegerField(default=0, verbose_name='点击量')
    is_recommend = models.BooleanField(default=False, verbose_name='是否推荐')
    date_published = models.DateTimeField(auto_now_add=True, verbose_name='发布时间')
    user = models.ForeignKey(User, verbose_name='用户')
    category = models.ForeignKey(Cateory, blank=True, null=True, verbose_name='分类')
    tag = models.ManyToManyField(Tag, verbose_name='标签')

    class Meta:
        verbose_name = '文章'
        verbose_name_plural = verbose_name
        ordering = ['-date_published']

    def __str__(self):
        return self.title


# 评论模型
class Comment(models.Model):
    content = models.TextField(verbose_name='评论内容')
    date_published = models.DateTimeField(auto_now_add=True, verbose_name='发布时间')
    user = models.ForeignKey(User, blank=True, null=True, verbose_name='用户')
    article = models.ForeignKey(Article, blank=True, null=True, verbose_name='文章')
    pid = models.ForeignKey('self', blank=True, null=True, verbose_name='父级评论')

    class Meta:
        verbose_name = '评论'
        verbose_name_plural = verbose_name
        ordering = ['-date_published']

    def __str__(self):
        return self.content


# 友情链接

class Links(models.Model):
    title = models.CharField(max_length=50, verbose_name='链接标题')
    desc = models.CharField(max_length=200, verbose_name='链接描述')
    callback_url = models.URLField(verbose_name='url地址')
    date_published = models.DateTimeField(auto_now_add=True, verbose_name='发布时间')
    index = models.IntegerField(default=999, verbose_name='排序')

    class Meta:
        verbose_name = '链接'
        verbose_name_plural = verbose_name
        ordering = ['index', 'id']

    def __str__(self):
        return self.title


# 广告

class Ad(models.Model):
    title = models.CharField(max_length=50, verbose_name='广告标题')
    desc = models.CharField(max_length=200, verbose_name='广告描述')
    image_url = models.ImageField(upload_to='ad/%Y/%m', verbose_name='图片路径')
    callback_url = models.URLField(null=True, blank=True, verbose_name='url地址')
    date_published = models.DateTimeField(auto_now_add=True, verbose_name='发布时间')
    index = models.IntegerField(default=999, verbose_name='排序')

    class Meta:
        verbose_name = '广告'
        verbose_name_plural = verbose_name
        ordering = ['index', 'id']

    def __str__(self):
        return self.title

*修改settings，使用自定义的User

AUTH_USER_MODEL = 'blog.User'

*同步到mysql

makemigrations

migrate