from django.db import models

# Create your models here.


from django.contrib.auth.models import AbstractUser


class UserInfo(AbstractUser):
    """
    用户信息
    """
    nid = models.AutoField(primary_key=True)
    telephone = 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)

    def __str__(self):
        return self.title


class Category(models.Model):
    """
    博主个人文章分类表
    """
    nid = models.AutoField(primary_key=True)
    title = models.CharField(verbose_name='分类标题', max_length=32)
    blog = models.ForeignKey(verbose_name='所属博客', 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(verbose_name='标签名称', max_length=32)
    blog = models.ForeignKey(verbose_name='所属博客', 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=50, verbose_name='文章标题')
    desc = models.CharField(max_length=255, verbose_name='文章描述')
    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(verbose_name='作者', 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(verbose_name='文章', to="Article", to_field='nid', on_delete=models.CASCADE)
    tag = models.ForeignKey(verbose_name='标签', 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)
    user = models.ForeignKey('UserInfo', null=True, on_delete=models.CASCADE)
    article = models.ForeignKey("Article", 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(verbose_name='评论文章', to='Article', to_field='nid', on_delete=models.CASCADE)
    user = models.ForeignKey(verbose_name='评论者', to='UserInfo', to_field='nid', on_delete=models.CASCADE)
    content = models.CharField(verbose_name='评论内容', 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

"""
Django settings for cnblogs project.

Generated by 'django-admin startproject' using Django 2.1.

For more information on this file, see
https://docs.djangoproject.com/en/2.1/topics/settings/

For the full list of settings and their values, see
https://docs.djangoproject.com/en/2.1/ref/settings/
"""

import os

# Build paths inside the project like this: os.path.join(BASE_DIR, ...)
BASE_DIR = os.path.dirname(os.path.dirname(os.path.abspath(__file__)))


# Quick-start development settings - unsuitable for production
# See https://docs.djangoproject.com/en/2.1/howto/deployment/checklist/

# SECURITY WARNING: keep the secret key used in production secret!
SECRET_KEY = '97e0#&=bl*0zl@99!_#4o*6fs=e&3-6@8rdq0clas*hojx6!5z'

# SECURITY WARNING: don't run with debug turned on in production!
DEBUG = True

ALLOWED_HOSTS = []


# Application definition

INSTALLED_APPS = [
    'django.contrib.admin',
    'django.contrib.auth',
    'django.contrib.contenttypes',
    'django.contrib.sessions',
    'django.contrib.messages',
    'django.contrib.staticfiles',
    'blog.apps.BlogConfig',
]

MIDDLEWARE = [
    'django.middleware.security.SecurityMiddleware',
    'django.contrib.sessions.middleware.SessionMiddleware',
    'django.middleware.common.CommonMiddleware',
    'django.middleware.csrf.CsrfViewMiddleware',

    'django.contrib.auth.middleware.AuthenticationMiddleware',
    'django.contrib.messages.middleware.MessageMiddleware',
    'django.middleware.clickjacking.XFrameOptionsMiddleware',
]

ROOT_URLCONF = 'cnblogs.urls'

TEMPLATES = [
    {
        'BACKEND': 'django.template.backends.django.DjangoTemplates',
        'DIRS': [os.path.join(BASE_DIR, 'templates')]
        ,
        'APP_DIRS': True,
        'OPTIONS': {
            'context_processors': [
                'django.template.context_processors.debug',
                'django.template.context_processors.request',
                'django.contrib.auth.context_processors.auth',
                'django.contrib.messages.context_processors.messages',
            ],
        },
    },
]

WSGI_APPLICATION = 'cnblogs.wsgi.application'


# Database
# https://docs.djangoproject.com/en/2.1/ref/settings/#databases

# DATABASES = {
#     'default': {
#         'ENGINE': 'django.db.backends.sqlite3',
#         'NAME': os.path.join(BASE_DIR, 'db.sqlite3'),
#     }
# }

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',#数据库的引擎为MySQL；
        'NAME': 'cnblogs',#要连接的数据库实例的名称，连接前需要已经完成创建；
        'USER': 'root',#MySQL数据库的用户名；
        'PASSWORD': 'Tqtl911!@%*)',#MySQL数据库的密码；
        'HOST': '47.95.121.154',#MySQL数据库服务器的IP地址；
        'PORT': '3306'#MySQL数据库的款口号，默认3306；
    }
}


# Password validation
# https://docs.djangoproject.com/en/2.1/ref/settings/#auth-password-validators

AUTH_PASSWORD_VALIDATORS = [
    {
        'NAME': 'django.contrib.auth.password_validation.UserAttributeSimilarityValidator',
    },
    {
        'NAME': 'django.contrib.auth.password_validation.MinimumLengthValidator',
    },
    {
        'NAME': 'django.contrib.auth.password_validation.CommonPasswordValidator',
    },
    {
        'NAME': 'django.contrib.auth.password_validation.NumericPasswordValidator',
    },
]


# Internationalization
# https://docs.djangoproject.com/en/2.1/topics/i18n/

LANGUAGE_CODE = 'en-us'

TIME_ZONE = 'UTC'

USE_I18N = True

USE_L10N = True

USE_TZ = True


# Static files (CSS, JavaScript, Images)
# https://docs.djangoproject.com/en/2.1/howto/static-files/

STATIC_URL = '/static/'

AUTH_USER_MODEL = 'blog.UserInfo'

LOGGING = {
    'version': 1,
    'disable_existing_loggers': False,
    'handlers': {
        'console':{
            'level':'DEBUG',
            'class':'logging.StreamHandler',
        },
    },
    'loggers': {
        'django.db.backends': {
            'handlers': ['console'],
            'propagate': True,
            'level':'DEBUG',
        },
    }
}

python manage.py makemigrations
python manage.py migrate

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
    <link rel="stylesheet" href="/static/blog/bs/css/bootstrap.css">
</head>
<body>
<h3>登录页面</h3>
<div class="container">
    <div class="row">
        <div class="col-md-6 col-lg-offset-3">
            <form action="">
                <div class="form-group">
                    <label for="user">用户名</label>
                    <input type="text" id="user" class="form-control">
                </div>
                <div class="form-group">
                    <label for="pwd">密码</label>
                    <input type="password" id="pwd" class="form-control">
                </div >
                <input type="button" class="btn btn-default pull-right login_btn" value="submit">
            </form>
        </div>
    </div>
</div>
</body>
</html>

from django.shortcuts import render

# Create your views here.

def login(request):
    return render(request,"login.html")

STATICFILES_DIRS = [
    os.path.join(BASE_DIR,"static")
]

 pip install pillow

from django.shortcuts import render,HttpResponse,redirect

# Create your views here.

def login(request):
    return render(request,"login.html")


import random
def get_validCode_img(request):
    def get_random_color():
        return (random.randint(0,255),random.randint(0,255),random.randint(0,255))
    #方式1-with open方法；
    # with open("lufei.jpg","rb") as f:
    #     data = f.read()

    #方式2；pip install pillow;
    from PIL import Image
    img = Image.new("RGB",(270,40),color=get_random_color())
    with open("validCode.png","wb") as f:
        img.save(f,"png")
    with open("validCode.png","rb") as f:
        data = f.read()
    return HttpResponse(data)

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
    <link rel="stylesheet" href="/static/blog/bs/css/bootstrap.css">
</head>
<body>
<h3>登录页面</h3>
<div class="container">
    <div class="row">
        <div class="col-md-6 col-lg-offset-3">
            <form action="">
                {% csrf_token %}
                <div class="form-group">
                    <label for="user">用户名</label>
                    <input type="text" id="user" class="form-control">
                </div>
                <div class="form-group">
                    <label for="pwd">密码</label>
                    <input type="password" id="pwd" class="form-control">
                </div >
                <div class="form-group">
                    <label for="pwd">验证码</label>
                    <div class="row">
                        <div class="col-md-6">
                            <input type="text" class="valid_code form-control">
                        </div>
                        <div class="col-md-6"></div>
                        <img  width="260" height="45" src="/get_validCode_img/" alt="">
                    </div>
                </div>
                <input type="button" class="btn btn-default pull-right login_btn" value="submit">
            </form>
        </div>
    </div>
</div>
</body>
</html>

from django.shortcuts import render,HttpResponse,redirect

# Create your views here.

def login(request):
    return render(request,"login.html")


import random
def get_validCode_img(request):
    def get_random_color():
        return (random.randint(0,255),random.randint(0,255),random.randint(0,255))
    #方式1-with open方法；
    # with open("lufei.jpg","rb") as f:
    #     data = f.read()

    #方式2；pip install pillow;
    # from PIL import Image
    # img = Image.new("RGB",(270,40),color=get_random_color())
    # with open("validCode.png","wb") as f:
    #     img.save(f,"png")
    # with open("validCode.png","rb") as f:
    #     data = f.read()

    #方式3：将数据放置于内存中，加快处理速度；
    # from PIL import Image
    # from io import BytesIO
    #
    # img = Image.new("RGB",(270,40),color=get_random_color())
    # f = BytesIO()
    # img.save(f,"png")
    # data = f.getvalue()

    #方式4:向图像区域他添加噪点，和字符串；
    from PIL import Image,ImageDraw,ImageFont
    from io import BytesIO
    import random
    char = str(random.randint(0,9))

    img = Image.new("RGB",(270,40),color=get_random_color())
    draw = ImageDraw.Draw(img)
    kumo_font = ImageFont.truetype("static/font/kumo.ttf",size=28)

    #生成随机字符串；
    #方法1：
    # for i in range(0,5):
    #     import string
    #     random_char = '  '.join(random.sample(string.ascii_lowercase  + string.ascii_uppercase,1))  # d4}5c+/m|97e@"16]s
    #     draw.text((i*50+20,5),random_char,get_random_color(),font=kumo_font)

    #方法2：
    for i in range(5):
        random_num = str(random.randint(0,9))
        random_lowercase = chr(random.randint(95,122))
        random_uppercase = chr(random.randint(65,90))
        random_char = random.choice([random_num,random_lowercase,random_uppercase])
        draw.text((i*50+20,5),random_char,get_random_color(),font=kumo_font)

    #进行画图
    #draw.line()
    #draw.point()
    f = BytesIO()
    img.save(f,"png")
    data = f.getvalue()

    return HttpResponse(data)

    #给图片添加上噪点；
    width = 270
    height = 40
    for i in range(5):
        x1 = random.randint(0,width)
        x2 = random.randint(0,width)
        y1 = random.randint(0,height)
        y2 = random.randint(0,height)
        draw.line((x1,y1,x2,y2),fill=get_random_color())

    for i in range(10):
        draw.point([random.randint(0,width),random.randint(0,height)],fill=get_random_color())
        x = random.randint(0,width)
        y = random.randint(0,height)
        draw.arc((x,y,x+4,y+4),0,90,fill=get_random_color())

<script src="/static/blog/js/jquery-3.3.1.min.js"></script>
<script>
    //刷新图片验证码；
    $("#valid_code_img").click(function () {
        $(this)[0].src+="?"
    })
</script>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
    <link rel="stylesheet" href="/static/blog/bs/css/bootstrap.css">
</head>
<body>
<h3>登录页面</h3>
<div class="container">
    <div class="row">
        <div class="col-md-6 col-lg-offset-3">
            <form action="">
                {% csrf_token %}
                <div class="form-group">
                    <label for="user">用户名</label>
                    <input type="text" id="user" class="form-control">
                </div>
                <div class="form-group">
                    <label for="pwd">密码</label>
                    <input type="password" id="pwd" class="form-control">
                </div >
                <div class="form-group">
                    <label for="pwd">验证码</label>
                    <div class="row">
                        <div class="col-md-6">
                            <input type="text" class="valid_code form-control">
                        </div>
                        <div class="col-md-6">
                        <img  width="260" height="45" id="valid_code_img" src="/get_validCode_img/" alt="">
　　　　　　　　　　　　　　</div>
                    </div>
                </div>
                <input type="button" class="btn btn-default pull-right login_btn" value="submit">
            </form>
        </div>
    </div>
</div>
<script src="/static/blog/js/jquery-3.3.1.min.js"></script>
<script>
    //刷新图片验证码；
    $("#valid_code_img").click(function () {
        $(this)[0].src+="?"
    })
</script>

</body>
</html>

from django.shortcuts import render,HttpResponse,redirect

# Create your views here.

from django.http import JsonResponse

def login(request):
    if request.method == "POST":
        response = {"user":None,"msg":None}
        user = request.POST.get("user")
        pwd = request.POST.get("pwd")
        valid_code  = request.POST.get("valid_code")

        valid_code_str = request.session.get("valid_code_str")
        #print("valid_code_str",valid_code_str,type(valid_code_str))
        #print("valid_code",valid_code,type(valid_code))
        if valid_code.upper() == valid_code_str.upper():
            pass
        else:
            response["msg"] = "valid code error!"
        return JsonResponse(response)
    return render(request,"login.html")


import random
def get_validCode_img(request):
    def get_random_color():
        return (random.randint(0,255),random.randint(0,255),random.randint(0,255))
    #方式1-with open方法；
    # with open("lufei.jpg","rb") as f:
    #     data = f.read()

    #方式2；pip install pillow;
    # from PIL import Image
    # img = Image.new("RGB",(270,40),color=get_random_color())
    # with open("validCode.png","wb") as f:
    #     img.save(f,"png")
    # with open("validCode.png","rb") as f:
    #     data = f.read()

    #方式3：将数据放置于内存中，加快处理速度；
    # from PIL import Image
    # from io import BytesIO
    #
    # img = Image.new("RGB",(270,40),color=get_random_color())
    # f = BytesIO()
    # img.save(f,"png")
    # data = f.getvalue()

    #方式4-向图像区域他添加噪点，和字符串；
    from PIL import Image,ImageDraw,ImageFont
    from io import BytesIO
    import random
    char = str(random.randint(0,9))

    img = Image.new("RGB",(270,40),color=get_random_color())
    draw = ImageDraw.Draw(img)
    kumo_font = ImageFont.truetype("static/font/BASKVILL.TTF",size=28)

    #保存随机字符串；
    valid_code_str = ""
    #生成随机字符串；
    #方法1：
    for i in range(0,5):
        import string
        random_char = '  '.join(random.sample(string.ascii_lowercase  + string.ascii_uppercase,1))  # d4}5c+/m|97e@"16]s
        draw.text((i*50+20,5),random_char,get_random_color(),font=kumo_font)
        #保存验证码字符串；
        valid_code_str+= random_char

    #方法2：
    # for i in range(500):
    #     random_num = str(random.randint(0,9))
    #     random_lowercase = chr(random.randint(95,122))
    #     random_uppercase = chr(random.randint(65,90))
    #     random_char = random.choice([random_num,random_lowercase,random_uppercase])
    #     draw.text((i*50+20,5),random_char,get_random_color(),font=kumo_font)

    #进行画图；
    #draw.line()
    #draw.point()


    #给图片添加上噪点；
    width = 270
    height = 40
    for i in range(5):
        x1 = random.randint(0,width)
        x2 = random.randint(0,width)
        y1 = random.randint(0,height)
        y2 = random.randint(0,height)
        draw.line((x1,y1,x2,y2),fill=get_random_color())

    for i in range(10):
        draw.point([random.randint(0,width),random.randint(0,height)],fill=get_random_color())
        x = random.randint(0,width)
        y = random.randint(0,height)
        draw.arc((x,y,x+4,y+4),0,90,fill=get_random_color())
    print("valid_code_str",valid_code_str)

    request.session["valid_code_str"] = valid_code_str
    '''
    1、生成随机字符串；
    2、COOKIE{"sessionid":fdsfdsfds}
    3、django-session表生成记录；
    '''
    f = BytesIO()
    img.save(f, "png")
    data = f.getvalue()
    return HttpResponse(data)

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
    <link rel="stylesheet" href="/static/blog/bs/css/bootstrap.css">
</head>
<body>
<h3>登录页面</h3>
<div class="container">
    <div class="row">
        <div class="col-md-6 col-lg-offset-3">
            <form >
                {% csrf_token %}
                <div class="form-group">
                    <label for="user">用户名</label>
                    <input type="text" id="user" class="form-control">
                </div>
                <div class="form-group">
                    <label for="pwd">密码</label>
                    <input type="password" id="pwd" class="form-control">
                </div >
                <div class="form-group">
                    <label for="pwd">验证码</label>
                    <div class="row">
                        <div class="col-md-6">
                            <input type="text" class="form-control" id="valid_code">
                        </div>
                        <div class="col-md-6">
                            <img  width="260" height="45" id="valid_code_img" src="/get_validCode_img/" alt="">
                        </div>
                    </div>
                </div>
                <input type="button" class="btn btn-default pull-right login_btn" value="submit">
            </form>
        </div>
    </div>
</div>
<script src="/static/blog/js/jquery-3.3.1.min.js"></script>
<script>
    //刷新图片验证码；
    $("#valid_code_img").click(function () {
        $(this)[0].src+="?"
    });

    //登陆过验证；
    $(".login_btn").click(function () {
        $.ajax({
            url:"",
            type:"post",
            data:{
                user:$("#user").val(),
                pwd:$("#pwd").val(),
                valid_code:$("#valid_code").val(),
                csrfmiddlewaretoken:$("[name='csrfmiddlewaretoken']").val(),

            },
            success:function (data) {
                console.log(data)

            }
        })
    })


</script>


</body>
</html>

from django.shortcuts import render,HttpResponse,redirect

# Create your views here.

from django.http import JsonResponse
from django.contrib import auth

def login(request):
    if request.method == "POST":
        response = {"user":None,"msg":None}
        user = request.POST.get("user")
        pwd = request.POST.get("pwd")
        valid_code  = request.POST.get("valid_code")

        valid_code_str = request.session.get("valid_code_str")
        #print("valid_code_str",valid_code_str,type(valid_code_str))
        #print("valid_code",valid_code,type(valid_code))
        if valid_code.upper() == valid_code_str.upper():
            user = auth.authenticate(username = user,password = pwd)
            if user:
                response["user"] = user.username
            else:
                response["msg"] = "用户名或者密码错误！"
        else:
            response["msg"] = "验证码错误!"
        return JsonResponse(response)
    return render(request,"login.html")


def get_valid_code_img(request):
    """
    基于PIL模块动态生成响应状态码图片；
    :param request:
    :return:
    """
    from blog.utils.validCode import get_valid_code_img
    data = get_valid_code_img(request)
    return HttpResponse(data)


def index(request):
    return render(request,"index.html")

"""
小结：
1、一次请求伴随着多次请求；
2、PIL模块的掌握；
3、session存储；
4、验证码刷新，基于js鼠标的click()事件进行；
"""

#!/usr/bin/env python3
# -*- coding:utf-8 -*-
# __Author__:TQTL911
# Version:python3.6.6
# Time:2018/8/23 21:30

import random

def get_random_color():
    return (random.randint(0, 255), random.randint(0, 255), random.randint(0, 255))


def get_valid_code_img(request):
    # 方式1-with open方法；
    # with open("lufei.jpg","rb") as f:
    #     data = f.read()

    # 方式2；pip install pillow;
    # from PIL import Image
    # img = Image.new("RGB",(270,40),color=get_random_color())
    # with open("validCode.png","wb") as f:
    #     img.save(f,"png")
    # with open("validCode.png","rb") as f:
    #     data = f.read()

    # 方式3：将数据放置于内存中，加快处理速度；
    # from PIL import Image
    # from io import BytesIO
    #
    # img = Image.new("RGB",(270,40),color=get_random_color())
    # f = BytesIO()
    # img.save(f,"png")
    # data = f.getvalue()

    # 方式4-向图像区域他添加噪点，和字符串；
    from PIL import Image, ImageDraw, ImageFont
    from io import BytesIO
    import random
    char = str(random.randint(0, 9))

    img = Image.new("RGB", (270, 40), color=get_random_color())
    draw = ImageDraw.Draw(img)
    kumo_font = ImageFont.truetype("static/font/BASKVILL.TTF", size=28)

    # 保存随机字符串；
    valid_code_str = ""
    # 生成随机字符串；
    # 方法1：
    for i in range(0, 5):
        import string
        random_char = '  '.join(
            random.sample(string.ascii_lowercase + string.ascii_uppercase, 1))  # d4}5c+/m|97e@"16]s
        draw.text((i * 50 + 20, 5), random_char, get_random_color(), font=kumo_font)
        # 保存验证码字符串；
        valid_code_str += random_char

    # 方法2：
    # for i in range(500):
    #     random_num = str(random.randint(0,9))
    #     random_lowercase = chr(random.randint(95,122))
    #     random_uppercase = chr(random.randint(65,90))
    #     random_char = random.choice([random_num,random_lowercase,random_uppercase])
    #     draw.text((i*50+20,5),random_char,get_random_color(),font=kumo_font)

    # 进行画图；
    # draw.line()
    # draw.point()

    # 给图片添加上噪点；
    width = 270
    height = 40
    for i in range(5):
        x1 = random.randint(0, width)
        x2 = random.randint(0, width)
        y1 = random.randint(0, height)
        y2 = random.randint(0, height)
        draw.line((x1, y1, x2, y2), fill=get_random_color())

    for i in range(10):
        draw.point([random.randint(0, width), random.randint(0, height)], fill=get_random_color())
        x = random.randint(0, width)
        y = random.randint(0, height)
        draw.arc((x, y, x + 4, y + 4), 0, 90, fill=get_random_color())
    print("valid_code_str", valid_code_str)

    request.session["valid_code_str"] = valid_code_str
    '''
    1、生成随机字符串；
    2、COOKIE{"sessionid":fdsfdsfds};
    3、django-session表生成记录；
    '''
    f = BytesIO()
    img.save(f, "png")
    data = f.getvalue()
    return data

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
    <link rel="stylesheet" href="/static/blog/bs/css/bootstrap.css">
</head>
<body>
<h3>登录页面</h3>
<div class="container">
    <div class="row">
        <div class="col-md-6 col-lg-offset-3">
            <form >
                {% csrf_token %}
                <div class="form-group">
                    <label for="user">用户名</label>
                    <input type="text" id="user" class="form-control">
                </div>
                <div class="form-group">
                    <label for="pwd">密码</label>
                    <input type="password" id="pwd" class="form-control">
                </div >
                <div class="form-group">
                    <label for="pwd">验证码</label>
                    <div class="row">
                        <div class="col-md-6">
                            <input type="text" class="form-control" id="valid_code">
                        </div>
                        <div class="col-md-6">
                            <img  width="260" height="45" id="valid_code_img" src="/get_validCode_img/" alt="">
                        </div>
                    </div>
                </div>
                <input type="button" class="btn btn-default login_btn" value="submit"><span class="error"></span>
            </form>
        </div>
    </div>
</div>
<script src="/static/blog/js/jquery-3.3.1.min.js"></script>
<script>
    //刷新图片验证码；
    $("#valid_code_img").click(function () {
        $(this)[0].src+="?"
    });

    //登陆过验证；
    $(".login_btn").click(function () {
        $.ajax({
            url:"",
            type:"post",
            data:{
                user:$("#user").val(),
                pwd:$("#pwd").val(),
                valid_code:$("#valid_code").val(),
                csrfmiddlewaretoken:$("[name='csrfmiddlewaretoken']").val(),

            },
            success:function (data) {
                console.log(data);
                if (data.user){
                    location.href = "/index/"
                }else {
                    $(".error").text(data.msg).css({"color":"red","margin-left":"10px"});
                    //清空错误消息提示，1000毫秒；
                    setTimeout(function () {
                        $(".error").text("")
                    },1000)
                }
            }
        })
    });


</script>


</body>
</html>

"""cnblogs URL Configuration

The `urlpatterns` list routes URLs to views. For more information please see:
    https://docs.djangoproject.com/en/2.1/topics/http/urls/
Examples:
Function views
    1. Add an import:  from my_app import views
    2. Add a URL to urlpatterns:  path('', views.home, name='home')
Class-based views
    1. Add an import:  from other_app.views import Home
    2. Add a URL to urlpatterns:  path('', Home.as_view(), name='home')
Including another URLconf
    1. Import the include() function: from django.urls import include, path
    2. Add a URL to urlpatterns:  path('blog/', include('blog.urls'))
"""
from django.contrib import admin
from django.urls import path

from blog import views
urlpatterns = {
    path('admin/', admin.site.urls),
    path('login/', views.login),
    path('index/', views.index),
    path('get_validCode_img/', views.get_valid_code_img),
    path('register/', views.register),
}

from django.shortcuts import render,HttpResponse,redirect

# Create your views here.

from django.http import JsonResponse
from django.contrib import auth

def login(request):
    """
    登录；
    :param request:
    :return:
    """
    if request.method == "POST":
        response = {"user":None,"msg":None}
        user = request.POST.get("user")
        pwd = request.POST.get("pwd")
        valid_code  = request.POST.get("valid_code")

        valid_code_str = request.session.get("valid_code_str")
        if valid_code.upper() == valid_code_str.upper():
            user = auth.authenticate(username = user,password = pwd)
            if user:
                response["user"] = user.username
            else:
                response["msg"] = "用户名或者密码错误！"
        else:
            response["msg"] = "验证码错误!"
        return JsonResponse(response)
    return render(request,"login.html")


def get_valid_code_img(request):
    """
    基于PIL模块动态生成响应状态码图片；
    :param request:
    :return:
    """
    from blog.utils.validCode import get_valid_code_img
    data = get_valid_code_img(request)
    return HttpResponse(data)


def index(request):
    """
    首页；
    :param request:
    :return:
    """
    return render(request,"index.html")


from django import forms
from django.forms import widgets

class UserForm(forms.Form):
    user = forms.CharField(max_length=32,label="用户名",widget=widgets.TextInput(attrs={"class":"form-control"}))
    pwd = forms.CharField(max_length=32,label="密码",widget=widgets.PasswordInput(attrs={"class":"form-control"}))
    r_pwd = forms.CharField(max_length=32,label="确认密码",widget=widgets.PasswordInput(attrs={"class":"form-control"}))
    email = forms.EmailField(max_length=32,label="注册邮箱",widget=widgets.EmailInput(attrs={"class":"form-control"}))

def register(request):
    """
    注册；
    :param request:
    :return:
    """
    form = UserForm()
    return render(request,"register.html",{"form":form})

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>注册页面</title>
    <link rel="stylesheet" href="/static/blog/bs/css/bootstrap.css">
</head>
<body>
<h3>注册页面</h3>
<div class="container">
    <div class="row">
        <div class="col-md-6 col-lg-offset-3">
            <form >
                {% csrf_token %}
                <!--进行渲染form对象-->
                {% for field in form %}
                    <div class="form-group">
                        <label for="user">{{ field.label }}</label>
                        {{ field }}
                    </div>
                {% endfor %}
                <div class="form-group">
                    <label for="avatar">头像</label>
                    <input type="file">
                </div>

                <input type="button" class="btn btn-default login_btn" value="提交">
            </form>
        </div>
    </div>
</div>
<script src="/static/blog/js/jquery-3.3.1.min.js"></script>

</body>
</html>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>注册页面</title>
    <link rel="stylesheet" href="/static/blog/bs/css/bootstrap.css">
    <style>
        #avatar{
            display: none;
        }
        #avatar_img{
            margin-left: 20px;
        }
    </style>
</head>
<body>
<h3>注册页面</h3>
<div class="container">
    <div class="row">
        <div class="col-md-6 col-lg-offset-3">
            <form >
                {% csrf_token %}
                <!--进行渲染form对象-->
                {% for field in form %}
                    <div class="form-group">
                        <label for="{{ field.auto_id }}">{{ field.label }}</label>
                        {{ field }}
                    </div>
                {% endfor %}
                <div class="form-group">
                    <label for="avatar">
                        头像
                        <img id="avatar_img" width="60px" height="60px" src="/static/blog/img/default.png" alt="">
                    </label>
                    <input type="file" id="avatar" >
                </div>
                <input type="button" class="btn btn-default login_btn" value="提交">
            </form>
        </div>
    </div>
</div>
<script src="/static/blog/js/jquery-3.3.1.min.js"></script>

</body>
</html>

<script>
    $("#avatar").change(function () {
        //1、获取用户选中的文件对象；
        var file_obj = $(this)[0].files[0];
        //2、获取文件对象的路径；
        var reader =  new FileReader();
        reader.readAsDataURL(file_obj);
       //3、修改img的src属性值，src= 文件对象的路径；
        reader.onload = function(){
            $("#avatar_img").attr("src",reader.result)
        };

    })
</script>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>注册页面</title>
    <link rel="stylesheet" href="/static/blog/bs/css/bootstrap.css">
    <style>
        #avatar{
            display: none;
        }
        #avatar_img{
            margin-left: 20px;
        }
    </style>
</head>
<body>
<h3>注册页面</h3>
<div class="container">
    <div class="row">
        <div class="col-md-6 col-lg-offset-3">
            <form >
                {% csrf_token %}
                <!--进行渲染form对象-->
                {% for field in form %}
                    <div class="form-group">
                        <label for="{{ field.auto_id }}">{{ field.label }}</label>
                        {{ field }}
                    </div>
                {% endfor %}
                <div class="form-group">
                    <label for="avatar">
                        头像
                        <img id="avatar_img" width="60px" height="60px" src="/static/blog/img/default.png" alt="">
                    </label>
                    <input type="file" id="avatar" >
                </div>
                <input type="button" class="btn btn-default reg_btn" value="提交">
            </form>
        </div>
    </div>
</div>
<script src="/static/blog/js/jquery-3.3.1.min.js"></script>

<!--编写js代码-->
<script>
    $("#avatar").change(function () {
        //1、获取用户选中的文件对象；
        var file_obj = $(this)[0].files[0];
        //2、获取文件对象的路径；
        var reader =  new FileReader();
        reader.readAsDataURL(file_obj);
       //3、修改img的src属性值，src= 文件对象的路径；
        reader.onload = function(){
            $("#avatar_img").attr("src",reader.result)
        };

    });
    //基于Ajax提交事件；
    $(".reg_btn").click(function () {
        var formdata = new FormData();
        formdata.append("user",$("#id_user").val());
        formdata.append("pwd",$("#id_pwd").val());
        formdata.append("r_pwd",$("#id_r_pwd").val());
        formdata.append("email",$("#id_email").val());
        formdata.append("avatar",$("#avatar")[0].files[0]);
        formdata.append("csrfmiddlewaretoken",$("[name = 'csrfmiddlewaretoken']").val());

        $.ajax({
            url:"",
            type:"post",
            contentType:false,
            processData:false,
            data:formdata,
            success:function (data) {
                console.log(data)

            }
        })
    })
</script>

</body>
</html>

from django.shortcuts import render,HttpResponse,redirect

# Create your views here.

from django.http import JsonResponse
from django.contrib import auth

def login(request):
    """
    登录；
    :param request:
    :return:
    """
    if request.method == "POST":
        response = {"user":None,"msg":None}
        user = request.POST.get("user")
        pwd = request.POST.get("pwd")
        valid_code  = request.POST.get("valid_code")

        valid_code_str = request.session.get("valid_code_str")
        if valid_code.upper() == valid_code_str.upper():
            user = auth.authenticate(username = user,password = pwd)
            if user:
                response["user"] = user.username
            else:
                response["msg"] = "用户名或者密码错误！"
        else:
            response["msg"] = "验证码错误!"
        return JsonResponse(response)
    return render(request,"login.html")


def get_valid_code_img(request):
    """
    基于PIL模块动态生成响应状态码图片；
    :param request:
    :return:
    """
    from blog.utils.validCode import get_valid_code_img
    data = get_valid_code_img(request)
    return HttpResponse(data)


def index(request):
    """
    首页；
    :param request:
    :return:
    """
    return render(request,"index.html")


from django import forms
from django.forms import widgets
from django.http import JsonResponse

class UserForm(forms.Form):
    user = forms.CharField(max_length=32,label="用户名",widget=widgets.TextInput(attrs={"class":"form-control"}))
    pwd = forms.CharField(max_length=32,label="密码",widget=widgets.PasswordInput(attrs={"class":"form-control"}))
    r_pwd = forms.CharField(max_length=32,label="确认密码",widget=widgets.PasswordInput(attrs={"class":"form-control"}))
    email = forms.EmailField(max_length=32,label="注册邮箱",widget=widgets.EmailInput(attrs={"class":"form-control"}))

def register(request):
    """
    注册；
    :param request:
    :return:
    """
    #if request.method == "POST":
    if request.is_ajax():
        print(request.POST)
        form = UserForm(request.POST)


        response = {"user":None,"msg":None}
        if form.is_valid():
            response["user"] = form.cleaned_data.get("user")
        else:
            print(form.cleaned_data)
            print(form.errors)
            response["msg"] = form.errors
        return JsonResponse(response)
    form = UserForm()
    return render(request,"register.html",{"form":form})

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>注册页面</title>
    <link rel="stylesheet" href="/static/blog/bs/css/bootstrap.css">
    <style>
        #avatar{
            display: none;
        }
        #avatar_img{
            margin-left: 20px;
        }
    </style>
</head>
<body>
<h3>注册页面</h3>
<div class="container">
    <div class="row">
        <div class="col-md-6 col-lg-offset-3">
            <form >
                {% csrf_token %}
                <!--进行渲染form对象-->
                {% for field in form %}
                    <div class="form-group">
                        <label for="{{ field.auto_id }}">{{ field.label }}</label>
                        {{ field }}
                    </div>
                {% endfor %}
                <div class="form-group">
                    <label for="avatar">
                        头像
                        <img id="avatar_img" width="60px" height="60px" src="/static/blog/img/default.png" alt="">
                    </label>
                    <input type="file" id="avatar" >
                </div>
                <input type="button" class="btn btn-default reg_btn" value="提交">
            </form>
        </div>
    </div>
</div>
<script src="/static/blog/js/jquery-3.3.1.min.js"></script>

<!--编写js代码-->
<script>
    $("#avatar").change(function () {
        //1、获取用户选中的文件对象；
        var file_obj = $(this)[0].files[0];
        //2、获取文件对象的路径；
        var reader =  new FileReader();
        reader.readAsDataURL(file_obj);
        //3、修改img的src属性值，src= 文件对象的路径；
        reader.onload = function(){
            $("#avatar_img").attr("src",reader.result)
        };

    });
    //基于Ajax提交事件；
    $(".reg_btn").click(function () {

        var formdata = new FormData();
        console.log($("#form").serializeArray());
        var request_data = $("#form").serializeArray();
        $.each(request_data,function (index,data) {
            formdata.append(data.name,data.value)
        });
        formdata.append("avatar",$("#avatar")[0].files[0]);

        /* var formdata = new FormData();
         formdata.append("user",$("#id_user").val());
         formdata.append("pwd",$("#id_pwd").val());
         formdata.append("r_pwd",$("#id_r_pwd").val());
         formdata.append("email",$("#id_email").val());
         formdata.append("avatar",$("#avatar")[0].files[0]);
         formdata.append("csrfmiddlewaretoken",$("[name = 'csrfmiddlewaretoken']").val());*/

        $.ajax({
            url:"",
            type:"post",
            contentType:false,
            processData:false,
            data:formdata,
            success:function (data) {
                console.log(data)

            }
        })
    })
</script>

</body>
</html>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>注册页面</title>
    <link rel="stylesheet" href="/static/blog/bs/css/bootstrap.css">
    <style>
        #avatar{
            display: none;
        }
        #avatar_img{
            margin-left: 20px;
        }
        .error{
            color: red;
        }
    </style>
</head>
<body>
<h3>注册页面</h3>
<div class="container">
    <div class="row">
        <div class="col-md-6 col-lg-offset-3">
            <form id="form">
                {% csrf_token %}
                <!--进行渲染form对象-->
                {% for field in form %}
                    <div class="form-group">
                        <label for="{{ field.auto_id }}">{{ field.label }}</label>
                        {{ field }}<span class="error pull-right"></span>
                    </div>
                {% endfor %}
                <div class="form-group">
                    <label for="avatar">
                        头像
                        <img id="avatar_img" width="60px" height="60px" src="/static/blog/img/default.png" alt="">
                    </label>
                    <input type="file" id="avatar" name="avatar">
                </div>
                <input type="button" class="btn btn-default reg_btn" value="提交">
            </form>
        </div>
    </div>
</div>
<script src="/static/blog/js/jquery-3.3.1.min.js"></script>

<!--编写js代码-->
<script>
    $("#avatar").change(function () {
        //1、获取用户选中的文件对象；
        var file_obj = $(this)[0].files[0];
        //2、获取文件对象的路径；
        var reader =  new FileReader();
        reader.readAsDataURL(file_obj);
        //3、修改img的src属性值，src= 文件对象的路径；
        reader.onload = function(){
            $("#avatar_img").attr("src",reader.result)
        };

    });
    //基于Ajax提交事件；
    $(".reg_btn").click(function () {

        var formdata = new FormData();
        console.log($("#form").serializeArray());
        var request_data = $("#form").serializeArray();
        $.each(request_data,function (index,data) {
            formdata.append(data.name,data.value)
        });
        formdata.append("avatar",$("#avatar")[0].files[0]);

       /* var formdata = new FormData();
         formdata.append("user",$("#id_user").val());
         formdata.append("pwd",$("#id_pwd").val());
         formdata.append("r_pwd",$("#id_r_pwd").val());
         formdata.append("email",$("#id_email").val());
         formdata.append("avatar",$("#avatar")[0].files[0]);
         formdata.append("csrfmiddlewaretoken",$("[name = 'csrfmiddlewaretoken']").val());*/

        $.ajax({
            url:"",
            type:"post",
            contentType:false,
            processData:false,
            data:formdata,
            success:function (data) {
                console.log(data);
                if(data.user){
                    //注册成功；
                }else {
                    //console.log(data.msg)
                    $.each(data.msg,function (field,error_list) {
                        console.log(field,error_list);
                        $("#id_"+field).next().html(error_list[0])
                    })
                }
            }
        });
    });
</script>

</body>
</html>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>注册页面</title>
    <link rel="stylesheet" href="/static/blog/bs/css/bootstrap.css">
    <style>
        #avatar{
            display: none;
        }
        #avatar_img{
            margin-left: 20px;
        }
        .error{
            color: red;
        }
    </style>
</head>
<body>
<h3>注册页面</h3>
<div class="container">
    <div class="row">
        <div class="col-md-6 col-lg-offset-3">
            <form id="form">
                {% csrf_token %}
                <!--进行渲染form对象-->
                {% for field in form %}
                    <div class="form-group">
                        <label for="{{ field.auto_id }}">{{ field.label }}</label>
                        {{ field }}<span class="error pull-right"></span>
                    </div>
                {% endfor %}
                <div class="form-group">
                    <label for="avatar">
                        头像
                        <img id="avatar_img" width="60px" height="60px" src="/static/blog/img/default.png" alt="">
                    </label>
                    <input type="file" id="avatar" name="avatar">
                </div>
                <input type="button" class="btn btn-default reg_btn" value="提交">
            </form>
        </div>
    </div>
</div>
<script src="/static/blog/js/jquery-3.3.1.min.js"></script>

<!--编写js代码-->
<script>
    $("#avatar").change(function () {
        //1、获取用户选中的文件对象；
        var file_obj = $(this)[0].files[0];
        //2、获取文件对象的路径；
        var reader =  new FileReader();
        reader.readAsDataURL(file_obj);
        //3、修改img的src属性值，src= 文件对象的路径；
        reader.onload = function(){
            $("#avatar_img").attr("src",reader.result)
        };

    });
    //基于Ajax提交事件；
    $(".reg_btn").click(function () {

        var formdata = new FormData();
        console.log($("#form").serializeArray());
        var request_data = $("#form").serializeArray();
        $.each(request_data,function (index,data) {
            formdata.append(data.name,data.value)
        });
        formdata.append("avatar",$("#avatar")[0].files[0]);

        /* var formdata = new FormData();
          formdata.append("user",$("#id_user").val());
          formdata.append("pwd",$("#id_pwd").val());
          formdata.append("r_pwd",$("#id_r_pwd").val());
          formdata.append("email",$("#id_email").val());
          formdata.append("avatar",$("#avatar")[0].files[0]);
          formdata.append("csrfmiddlewaretoken",$("[name = 'csrfmiddlewaretoken']").val());*/

        $.ajax({
            url:"",
            type:"post",
            contentType:false,
            processData:false,
            data:formdata,
            success:function (data) {
                console.log(data);
                if(data.user){
                    //注册成功；
                }else {//注册失败
                    //console.log(data.msg)
                    //清空错误提示消息；
                    $("span.error").html();
                    $(".form-group").removeClass("has-error");
                    //展示此次提提交的信息；
                    $.each(data.msg,function (field,error_list) {
                        console.log(field,error_list);
                        $("#id_"+field).next().html(error_list[0]);
                        $("#id_"+field).parent().addClass("has-error");
                    })
                }
            }
        });
    });
</script>

</body>
</html>

#!/usr/bin/env python3
# -*- coding:utf-8 -*-
# __Author__:TQTL911
# Version:python3.6.6
# Time:2018/8/24 14:41
from django import forms
from django.forms import widgets
from django.http import JsonResponse
from blog.models import UserInfo
from django.core.exceptions import NON_FIELD_ERRORS, ValidationError

class UserForm(forms.Form):
    user = forms.CharField(max_length=32,error_messages={"required":"该字段不能为空！"},label="用户名",widget=widgets.TextInput(attrs={"class":"form-control"}))
    pwd = forms.CharField(max_length=32,label="密码",widget=widgets.PasswordInput(attrs={"class":"form-control"}))
    r_pwd = forms.CharField(max_length=32,label="确认密码",widget=widgets.PasswordInput(attrs={"class":"form-control"}))
    email = forms.EmailField(max_length=32,label="注册邮箱",widget=widgets.EmailInput(attrs={"class":"form-control"}))

    def clean_user(self):
        user = self.cleaned_data.get("user")
        user = UserInfo.objects.filter(username=user).first()

        if not user:
            return user
        else:
            raise ValidationError("该用户已经注册")
    def clean(self):
        pwd = self.cleaned_data.get("pwd")
        r_pwd = self.cleaned_data.get("r_pwd")

        if pwd == r_pwd:
            return self.cleaned_data
        else:
            raise ValidationError("两次密码不一致！")

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>注册页面</title>
    <link rel="stylesheet" href="/static/blog/bs/css/bootstrap.css">
    <style>
        #avatar{
            display: none;
        }
        #avatar_img{
            margin-left: 20px;
        }
        .error{
            color: red;
        }
    </style>
</head>
<body>
<h3>注册页面</h3>
<div class="container">
    <div class="row">
        <div class="col-md-6 col-lg-offset-3">
            <form id="form">
                {% csrf_token %}
                <!--进行渲染form对象-->
                {% for field in form %}
                    <div class="form-group">
                        <label for="{{ field.auto_id }}">{{ field.label }}</label>
                        {{ field }}<span class="error pull-right"></span>
                    </div>
                {% endfor %}
                <div class="form-group">
                    <label for="avatar">
                        头像
                        <img id="avatar_img" width="60px" height="60px" src="/static/blog/img/default.png" alt="">
                    </label>
                    <input type="file" id="avatar" name="avatar">
                </div>
                <input type="button" class="btn btn-default reg_btn" value="提交">
            </form>
        </div>
    </div>
</div>
<script src="/static/blog/js/jquery-3.3.1.min.js"></script>

<!--编写js代码-->
<script>
    $("#avatar").change(function () {
        //1、获取用户选中的文件对象；
        var file_obj = $(this)[0].files[0];
        //2、获取文件对象的路径；
        var reader =  new FileReader();
        reader.readAsDataURL(file_obj);
        //3、修改img的src属性值，src= 文件对象的路径；
        reader.onload = function(){
            $("#avatar_img").attr("src",reader.result)
        };

    });
    //基于Ajax提交事件；
    $(".reg_btn").click(function () {

        var formdata = new FormData();
        console.log($("#form").serializeArray());
        var request_data = $("#form").serializeArray();
        $.each(request_data,function (index,data) {
            formdata.append(data.name,data.value)
        });
        formdata.append("avatar",$("#avatar")[0].files[0]);

        /* var formdata = new FormData();
          formdata.append("user",$("#id_user").val());
          formdata.append("pwd",$("#id_pwd").val());
          formdata.append("r_pwd",$("#id_r_pwd").val());
          formdata.append("email",$("#id_email").val());
          formdata.append("avatar",$("#avatar")[0].files[0]);
          formdata.append("csrfmiddlewaretoken",$("[name = 'csrfmiddlewaretoken']").val());*/

        $.ajax({
            url:"",
            type:"post",
            contentType:false,
            processData:false,
            data:formdata,
            success:function (data) {
                console.log(data);
                if(data.user){
                    //注册成功；
                }else {//注册失败
                    //console.log(data.msg)
                    //清空错误提示消息；
                    $("span.error").html();
                    $(".form-group").removeClass("has-error");
                    //展示此次提提交的信息；
                    $.each(data.msg,function (field,error_list) {
                        console.log(field,error_list);
                        if(field=="__all__"){
                            $("#id_r_pwd").next().html(error_list[0]).parent().addClass("has-error")
                        }
                        $("#id_"+field).next().html(error_list[0]);
                        $("#id_"+field).parent().addClass("has-error");
                    })
                }
            }
        });
    });
</script>

</body>
</html>

from django.shortcuts import render,HttpResponse,redirect

# Create your views here.

from django.http import JsonResponse
from django.contrib import auth

def login(request):
    """
    登录；
    :param request:
    :return:
    """
    if request.method == "POST":
        response = {"user":None,"msg":None}
        user = request.POST.get("user")
        pwd = request.POST.get("pwd")
        valid_code  = request.POST.get("valid_code")

        valid_code_str = request.session.get("valid_code_str")
        if valid_code.upper() == valid_code_str.upper():
            user = auth.authenticate(username = user,password = pwd)
            if user:
                response["user"] = user.username
            else:
                response["msg"] = "用户名或者密码错误！"
        else:
            response["msg"] = "验证码错误!"
        return JsonResponse(response)
    return render(request,"login.html")


def get_valid_code_img(request):
    """
    基于PIL模块动态生成响应状态码图片；
    :param request:
    :return:
    """
    from blog.utils.validCode import get_valid_code_img
    data = get_valid_code_img(request)
    return HttpResponse(data)


def index(request):
    """
    首页；
    :param request:
    :return:
    """
    return render(request,"index.html")


from blog.Myforms import UserForm
from blog.models import UserInfo
def register(request):
    """
    注册；
    :param request:
    :return:
    """
    #if request.method == "POST":
    if request.is_ajax():
        print(request.POST)
        form = UserForm(request.POST)

        response = {"user":None,"msg":None}
        if form.is_valid():
            response["user"] = form.cleaned_data.get("user")
            #生成一条用户记录；
            user = form.cleaned_data.get("user")
            pwd = form.cleaned_data.get("pwd")
            email = form.cleaned_data.get("email")
            avatar_obj = request.FILES.get("avatar")
            if avatar_obj:
                user_obj = UserInfo.objects.create_user(username=user,password=pwd,email=email,avatar = avatar_obj )
            else:
                user_obj = UserInfo.objects.create_user(username=user, password=pwd, email=email)

        else:
            print(form.cleaned_data)
            print(form.errors)
            response["msg"] = form.errors
        return JsonResponse(response)
    form = UserForm()
    return render(request,"register.html",{"form":form})

from django.shortcuts import render, HttpResponse, redirect

# Create your views here.

from django.http import JsonResponse
from django.contrib import auth
from blog.Myforms import UserForm
from blog.models import UserInfo


def login(request):
    """
    登录；
    :param request:
    :return:
    """
    if request.method == "POST":
        response = {"user": None, "msg": None}
        user = request.POST.get("user")
        pwd = request.POST.get("pwd")
        valid_code = request.POST.get("valid_code")

        valid_code_str = request.session.get("valid_code_str")
        if valid_code.upper() == valid_code_str.upper():
            user = auth.authenticate(username=user, password=pwd)
            if user:
                response["user"] = user.username
            else:
                response["msg"] = "用户名或者密码错误！"
        else:
            response["msg"] = "验证码错误!"
        return JsonResponse(response)
    return render(request, "login.html")


def get_valid_code_img(request):
    """
    基于PIL模块动态生成响应状态码图片；
    :param request:
    :return:
    """
    from blog.utils.validCode import get_valid_code_img
    data = get_valid_code_img(request)
    return HttpResponse(data)


def index(request):
    """
    首页；
    :param request:
    :return:
    """
    return render(request, "index.html")


def register(request):
    """
    注册；
    :param request:
    :return:
    """
    # if request.method == "POST":
    if request.is_ajax():
        # print(request.POST)
        form = UserForm(request.POST)

        response = {"user": None, "msg": None}
        if form.is_valid():
            response["user"] = form.cleaned_data.get("user")
            # 生成一条用户记录；
            user = form.cleaned_data.get("user")
            pwd = form.cleaned_data.get("pwd")
            email = form.cleaned_data.get("email")
            avatar_obj = request.FILES.get("avatar")
            '''
            if avatar_obj:
                user_obj = UserInfo.objects.create_user(username=user,password=pwd,email=email,avatar = avatar_obj )
            else:
                user_obj = UserInfo.objects.create_user(username=user, password=pwd, email=email)
            '''
            extra = {}
            if avatar_obj:
                extra["avatar"] = avatar_obj
            UserInfo.objects.create_user(username=user, password=pwd, email=email, )


        else:
            # print(form.cleaned_data)
            # print(form.errors)
            response["msg"] = form.errors
        return JsonResponse(response)
    form = UserForm()
    return render(request, "register.html", {"form": form})

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>博客系统首页</title>
    <link rel="stylesheet" href="/static/blog/bs/css/bootstrap.css">
    <script src="/static/blog/js/jquery-3.3.1.min.js"></script>
    <script src="/static/blog/bs/js/bootstrap.min.js"></script>
    <style>
        #user_icon {
            font-size: 18px;
            margin-right: 10px;
            vertical-align: -3px;
        }
    </style>
</head>
<body>
<nav class="navbar navbar-default">
    <div class="container-fluid">
        <!-- Brand and toggle get grouped for better mobile display -->
        <div class="navbar-header">
            <button type="button" class="navbar-toggle collapsed" data-toggle="collapse"
                    data-target="#bs-example-navbar-collapse-1" aria-expanded="false">
                <span class="sr-only">Toggle navigation</span>
                <span class="icon-bar"></span>
                <span class="icon-bar"></span>
                <span class="icon-bar"></span>
            </button>
            <a class="navbar-brand" href="#">博客园</a>
        </div>

        <!-- Collect the nav links, forms, and other content for toggling -->
        <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
            <ul class="nav navbar-nav">
                <li class="active"><a href="#">随笔 <span class="sr-only">(current)</span></a></li>
                <li><a href="#">新闻</a></li>
                <li><a href="#">博文</a></li>
            </ul>

            <ul class="nav navbar-nav navbar-right">
                {% if request.user.is_authenticated %}
                    <li><a href="#"><span id="user_icon" class="glyphicon glyphicon-user"></span>{{ request.user.username }}</a></li>
                    <li class="dropdown">
                        <a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true"
                           aria-expanded="false">Dropdown <span class="caret"></span></a>
                        <ul class="dropdown-menu">
                            <li><a href="#">修改密码</a></li>
                            <li><a href="#">修改头像</a></li>
                            <li><a href="/logout/">注销</a></li>
                            <li role="separator" class="divider"></li>
                            <li><a href="#">Separated link</a></li>
                        </ul>
                    </li>

                {% else %}
                    <li><a href="/login/">登录</a></li>
                    <li><a href="/register/">注册</a></li>
                {% endif %}

            </ul>
        </div><!-- /.navbar-collapse -->
    </div><!-- /.container-fluid -->
</nav>

</body>
</html>

from django.shortcuts import render, HttpResponse, redirect

# Create your views here.

from django.http import JsonResponse
from django.contrib import auth
from blog.Myforms import UserForm
from blog.models import UserInfo


def login(request):
    """
    登录；
    :param request:
    :return:
    """
    if request.method == "POST":
        response = {"user": None, "msg": None}
        user = request.POST.get("user")
        pwd = request.POST.get("pwd")
        valid_code = request.POST.get("valid_code")

        valid_code_str = request.session.get("valid_code_str")
        if valid_code.upper() == valid_code_str.upper():
            user = auth.authenticate(username=user, password=pwd)
            if user:
                auth.login(request, user)
                response["user"] = user.username
            else:
                response["msg"] = "用户名或者密码错误！"
        else:
            response["msg"] = "验证码错误!"
        return JsonResponse(response)
    return render(request, "login.html")


def index(request):
    """
    首页；
    :param request:
    :return:
    """
    return render(request, "index.html")


def logout(request):
    auth.logout(request)  # 等同于request.session.flush()
    return redirect("/login/")


def get_valid_code_img(request):
    """
    基于PIL模块动态生成响应状态码图片；
    :param request:
    :return:
    """
    from blog.utils.validCode import get_valid_code_img
    data = get_valid_code_img(request)
    return HttpResponse(data)


def register(request):
    """
    注册；
    :param request:
    :return:
    """
    # if request.method == "POST":
    if request.is_ajax():
        # print(request.POST)
        form = UserForm(request.POST)

        response = {"user": None, "msg": None}
        if form.is_valid():
            response["user"] = form.cleaned_data.get("user")
            # 生成一条用户记录；
            user = form.cleaned_data.get("user")
            pwd = form.cleaned_data.get("pwd")
            email = form.cleaned_data.get("email")
            avatar_obj = request.FILES.get("avatar")
            '''
            if avatar_obj:
                user_obj = UserInfo.objects.create_user(username=user,password=pwd,email=email,avatar = avatar_obj )
            else:
                user_obj = UserInfo.objects.create_user(username=user, password=pwd, email=email)
            '''
            extra = {}

            if avatar_obj:
                extra["avatar"] = avatar_obj
            UserInfo.objects.create_user(username=user, password=pwd, email=email, **extra)
        else:
            # print(form.cleaned_data)
            # print(form.errors)
            response["msg"] = form.errors
        return JsonResponse(response)
    form = UserForm()
    return render(request, "register.html", {"form": form})

"""cnblogs URL Configuration

The `urlpatterns` list routes URLs to views. For more information please see:
    https://docs.djangoproject.com/en/2.1/topics/http/urls/
Examples:
Function views
    1. Add an import:  from my_app import views
    2. Add a URL to urlpatterns:  path('', views.home, name='home')
Class-based views
    1. Add an import:  from other_app.views import Home
    2. Add a URL to urlpatterns:  path('', Home.as_view(), name='home')
Including another URLconf
    1. Import the include() function: from django.urls import include, path
    2. Add a URL to urlpatterns:  path('blog/', include('blog.urls'))
"""
from django.contrib import admin
from django.urls import path, re_path
from blog import views
from django.views.static import serve
from cnblogs import settings

urlpatterns = [
    path('admin/', admin.site.urls),
    path('login/', views.login),
    path('index/', views.index),
    path('logout/', views.logout),
    re_path('^$', views.index),
    path('get_validCode_img/', views.get_valid_code_img),
    path('register/', views.register),
    # media配置；
    re_path(r"media/(?P<path>.*)$", serve, {"document_root": settings.MEDIA_ROOT}),
]

<!--引入BootStrap格栅系统-->
<div class="container-fluid">
    <div class="row">
        <div class="col-md-3">
            <div class="panel panel-warning">
                <div class="panel-heading">Panel heading without title</div>
                <div class="panel-body">
                    Panel content
                </div>
            </div>
            <div class="panel panel-info">
                <div class="panel-heading">Panel heading without title</div>
                <div class="panel-body">
                    Panel content
                </div>
            </div>
            <div class="panel panel-danger">
                <div class="panel-heading">Panel heading without title</div>
                <div class="panel-body">
                    Panel content
                </div>
            </div>
        </div>
        <div class="col-md-6">222</div>
        <div class="col-md-3">
            <div class="panel panel-default">
                <div class="panel-heading">Panel heading without title</div>
                <div class="panel-body">
                    Panel content
                </div>
            </div>
            <div class="panel panel-primary">
                <div class="panel-heading">Panel heading without title</div>
                <div class="panel-body">
                    Panel content
                </div>
            </div>
            <div class="panel panel-default">
                <div class="panel-heading">Panel heading without title</div>
                <div class="panel-body">
                    Panel content
                </div>
            </div>
        </div>
    </div>
</div>

from django.contrib import admin

# Register your models here.
from blog import models

admin.site.register(models.UserInfo)
admin.site.register(models.Blog)
admin.site.register(models.Category)
admin.site.register(models.Tag)
admin.site.register(models.Article)
admin.site.register(models.ArticleUpDown)
admin.site.register(models.Article2Tag)
admin.site.register(models.Comment)

<div class="col-md-6">
            <div class="article_list">
                {% for articel in article_list %}
                    <div class="articel-item">
                        <h5><a href="">{{ articel.title }}</a></h5>
                        <div class="article-desc">
                        <span class="media-left">
                            <a href=""><img width="56" height="56" src="media/{{ articel.user.avatar }}" alt=""></a>
                        </span>
                            <span class="media-right">
                            {{ articel.desc }}
                        </span>
                        </div>
                        <hr>
                    </div>
                {% endfor %}
            </div>
        </div>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>博客系统首页</title>
    <link rel="stylesheet" href="/static/blog/bs/css/bootstrap.css">
    <script src="/static/blog/js/jquery-3.3.1.min.js"></script>
    <script src="/static/blog/bs/js/bootstrap.min.js"></script>
    <style>
        #user_icon {
            font-size: 18px;
            margin-right: 10px;
            vertical-align: -3px;
        }
        .pub_info{
            margin-top: 10px;
        }
        .pub_info .glyphicon-comment{
            vertical-align: -1px;
        }
    </style>
</head>
<body>
<nav class="navbar navbar-default">
    <div class="container-fluid">
        <!-- Brand and toggle get grouped for better mobile display -->
        <div class="navbar-header">
            <button type="button" class="navbar-toggle collapsed" data-toggle="collapse"
                    data-target="#bs-example-navbar-collapse-1" aria-expanded="false">
                <span class="sr-only">Toggle navigation</span>
                <span class="icon-bar"></span>
                <span class="icon-bar"></span>
                <span class="icon-bar"></span>
            </button>
            <a class="navbar-brand" href="#">博客园</a>
        </div>

        <!-- Collect the nav links, forms, and other content for toggling -->
        <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
            <ul class="nav navbar-nav">
                <li class="active"><a href="#">随笔 <span class="sr-only">(current)</span></a></li>
                <li><a href="#">新闻</a></li>
                <li><a href="#">博文</a></li>
            </ul>

            <ul class="nav navbar-nav navbar-right">
                {% if request.user.is_authenticated %}
                    <li><a href="#"><span id="user_icon"
                                          class="glyphicon glyphicon-user"></span>{{ request.user.username }}</a></li>
                    <li class="dropdown">
                        <a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true"
                           aria-expanded="false">Dropdown <span class="caret"></span></a>
                        <ul class="dropdown-menu">
                            <li><a href="#">修改密码</a></li>
                            <li><a href="#">修改头像</a></li>
                            <li><a href="/logout/">注销</a></li>
                            <li role="separator" class="divider"></li>
                            <li><a href="#">Separated link</a></li>
                        </ul>
                    </li>

                {% else %}
                    <li><a href="/login/">登录</a></li>
                    <li><a href="/register/">注册</a></li>
                {% endif %}

            </ul>
        </div><!-- /.navbar-collapse -->
    </div><!-- /.container-fluid -->
</nav>

<!--引入BootStrap格栅系统-->
<div class="container-fluid">
    <div class="row">
        <div class="col-md-3">
            <div class="panel panel-warning">
                <div class="panel-heading">Panel heading without title</div>
                <div class="panel-body">
                    Panel content
                </div>
            </div>
            <div class="panel panel-info">
                <div class="panel-heading">Panel heading without title</div>
                <div class="panel-body">
                    Panel content
                </div>
            </div>
            <div class="panel panel-danger">
                <div class="panel-heading">Panel heading without title</div>
                <div class="panel-body">
                    Panel content
                </div>
            </div>
        </div>
        <div class="col-md-6">
            <div class="article_list">
                {% for articel in article_list %}
                    <div class="articel-item">
                        <h5><a href="">{{ articel.title }}</a></h5>
                        <div class="article-desc">
                        <span class="media-left">
                            <a href=""><img width="56" height="56" src="media/{{ articel.user.avatar }}" alt=""></a>
                        </span>
                            <span class="media-right">
                            {{ articel.desc }}
                        </span>
                        </div>
                        <hr>
                    </div>
                    <div class="small pub_info">
                    <span><a href="">{{ articel.user.username }}</a></span>&nbsp;&nbsp;&nbsp;
                    <span>发布于&nbsp;&nbsp;{{ articel.create_time|date:"Y-m-d H:i" }}</span>
                    <span class="glyphicon glyphicon-comment"></span>评论({{ articel.comment_count }})
                    <span class="glyphicon glyphicon-thumbs-up"></span>点赞({{ articel.up_count }})
                    </div>
                {% endfor %}
            </div>
        </div>
        <div class="col-md-3">
            <div class="panel panel-default">
                <div class="panel-heading">Panel heading without title</div>
                <div class="panel-body">
                    Panel content
                </div>
            </div>
            <div class="panel panel-primary">
                <div class="panel-heading">Panel heading without title</div>
                <div class="panel-body">
                    Panel content
                </div>
            </div>
            <div class="panel panel-default">
                <div class="panel-heading">Panel heading without title</div>
                <div class="panel-body">
                    Panel content
                </div>
            </div>
        </div>
    </div>
</div>
</body>
</html>

"""cnblogs URL Configuration

The `urlpatterns` list routes URLs to views. For more information please see:
    https://docs.djangoproject.com/en/2.1/topics/http/urls/
Examples:
Function views
    1. Add an import:  from my_app import views
    2. Add a URL to urlpatterns:  path('', views.home, name='home')
Class-based views
    1. Add an import:  from other_app.views import Home
    2. Add a URL to urlpatterns:  path('', Home.as_view(), name='home')
Including another URLconf
    1. Import the include() function: from django.urls import include, path
    2. Add a URL to urlpatterns:  path('blog/', include('blog.urls'))
"""
from django.contrib import admin
from django.urls import path, re_path
from blog import views
from django.views.static import serve
from cnblogs import settings

urlpatterns = [
    path('admin/', admin.site.urls),
    path('login/', views.login),
    path('index/', views.index),
    path('logout/', views.logout),
    re_path('^$', views.index),
    path('get_validCode_img/', views.get_valid_code_img),
    path('register/', views.register),
    # media配置；
    re_path(r'media/(?P<path>.*)$', serve, {"document_root": settings.MEDIA_ROOT}),
    # 个人站点URL；
    re_path(r'^(?P<username>w+)$', views.home_site),
]

from django.shortcuts import render, HttpResponse, redirect

# Create your views here.

from django.http import JsonResponse
from django.contrib import auth
from blog.Myforms import UserForm
from blog.models import UserInfo
from blog import models


def login(request):
    """
    登录；
    :param request:
    :return:
    """
    if request.method == "POST":
        response = {"user": None, "msg": None}
        user = request.POST.get("user")
        pwd = request.POST.get("pwd")
        valid_code = request.POST.get("valid_code")

        valid_code_str = request.session.get("valid_code_str")
        if valid_code.upper() == valid_code_str.upper():
            user = auth.authenticate(username=user, password=pwd)
            if user:
                auth.login(request, user)
                response["user"] = user.username
            else:
                response["msg"] = "用户名或者密码错误！"
        else:
            response["msg"] = "验证码错误!"
        return JsonResponse(response)
    return render(request, "login.html")


def index(request):
    """
    首页；
    :param request:
    :return:
    """
    article_list = models.Article.objects.all()

    return render(request, "index.html", {"article_list": article_list})


def logout(request):
    auth.logout(request)  # 等同于request.session.flush()
    return redirect("/login/")


def get_valid_code_img(request):
    """
    基于PIL模块动态生成响应状态码图片；
    :param request:
    :return:
    """
    from blog.utils.validCode import get_valid_code_img
    data = get_valid_code_img(request)
    return HttpResponse(data)


def register(request):
    """
    注册；
    :param request:
    :return:
    """
    # if request.method == "POST":
    if request.is_ajax():
        # print(request.POST)
        form = UserForm(request.POST)

        response = {"user": None, "msg": None}
        if form.is_valid():
            response["user"] = form.cleaned_data.get("user")
            # 生成一条用户记录；
            user = form.cleaned_data.get("user")
            pwd = form.cleaned_data.get("pwd")
            email = form.cleaned_data.get("email")
            avatar_obj = request.FILES.get("avatar")
            '''
            if avatar_obj:
                user_obj = UserInfo.objects.create_user(username=user,password=pwd,email=email,avatar = avatar_obj )
            else:
                user_obj = UserInfo.objects.create_user(username=user, password=pwd, email=email)
            '''
            extra = {}

            if avatar_obj:
                extra["avatar"] = avatar_obj
            UserInfo.objects.create_user(username=user, password=pwd, email=email, **extra)
        else:
            # print(form.cleaned_data)
            # print(form.errors)
            response["msg"] = form.errors
        return JsonResponse(response)
    form = UserForm()
    return render(request, "register.html", {"form": form})


def home_site(request, username):
    """
    个人站点视图函数；
    :param request:
    :return:
    """
    print("username", username)
    user = UserInfo.objects.filter(username=username).first()
    # 判断用户是否存在；
    if not user:
        return render(request, "not_found.html")
    # 查询当前站点对象：
    blog = user.blog
    # 当前用户或者当前站点对应的所有文章；
    # 基于对象查询；
    # article_list = user.article_set.all()
    # 基于双下划线的查询；
    article_list = models.Article.objects.filter(user=user)
    return render(request, "home_site.html")

def home_site(request, username):
    """
    个人站点视图函数；
    :param request:
    :return:
    """
    print("username", username)
    user = UserInfo.objects.filter(username=username).first()
    # 判断用户是否存在；
    if not user:
        return render(request, "not_found.html")
    # 查询当前站点对象：
    blog = user.blog
    # 当前用户或者当前站点对应的所有文章；
    # 基于对象查询；
    # article_list = user.article_set.all()
    # 基于双下划线的查询；
    article_list = models.Article.objects.filter(user=user)

    # 每一个后表的模型.objedts.values("pk").annotate(聚合函数(关联表__统计字段)).values("表模型的所有字段以及统计字段")

    # 1、查询每一个分类名称以及对应的文章数;
    ret = models.Category.objects.values("pk").annotate(c=Count("article__title")).values("title", "c")
    print(ret)
    # 2、查询当前站点的每一个分类名称以及对应的文章数；
    cate_list = models.Category.objects.filter(blog=blog).values("pk").annotate(c=Count("article__title")).values_list(
        "title", "c")
    print(cate_list)

    # 3、查询当前站点的每一个标签名称对应的文章数；
    tag_list = models.Tag.objects.filter(blog=blog).values("pk").annotate(c=Count("article")).values_list("title", "c")
    print(tag_list)

    return render(request, "home_site.html")

from django.shortcuts import render, HttpResponse, redirect

# Create your views here.

from django.http import JsonResponse
from django.contrib import auth
from blog.Myforms import UserForm
from blog.models import UserInfo
from blog import models
from django.db.models import Count


def login(request):
    """
    登录；
    :param request:
    :return:
    """
    if request.method == "POST":
        response = {"user": None, "msg": None}
        user = request.POST.get("user")
        pwd = request.POST.get("pwd")
        valid_code = request.POST.get("valid_code")

        valid_code_str = request.session.get("valid_code_str")
        if valid_code.upper() == valid_code_str.upper():
            user = auth.authenticate(username=user, password=pwd)
            if user:
                auth.login(request, user)
                response["user"] = user.username
            else:
                response["msg"] = "用户名或者密码错误！"
        else:
            response["msg"] = "验证码错误!"
        return JsonResponse(response)
    return render(request, "login.html")


def index(request):
    """
    首页；
    :param request:
    :return:
    """
    article_list = models.Article.objects.all()

    return render(request, "index.html", {"article_list": article_list})


def logout(request):
    auth.logout(request)  # 等同于request.session.flush()
    return redirect("/login/")


def get_valid_code_img(request):
    """
    基于PIL模块动态生成响应状态码图片；
    :param request:
    :return:
    """
    from blog.utils.validCode import get_valid_code_img
    data = get_valid_code_img(request)
    return HttpResponse(data)


def register(request):
    """
    注册；
    :param request:
    :return:
    """
    # if request.method == "POST":
    if request.is_ajax():
        # print(request.POST)
        form = UserForm(request.POST)

        response = {"user": None, "msg": None}
        if form.is_valid():
            response["user"] = form.cleaned_data.get("user")
            # 生成一条用户记录；
            user = form.cleaned_data.get("user")
            pwd = form.cleaned_data.get("pwd")
            email = form.cleaned_data.get("email")
            avatar_obj = request.FILES.get("avatar")
            '''
            if avatar_obj:
                user_obj = UserInfo.objects.create_user(username=user,password=pwd,email=email,avatar = avatar_obj )
            else:
                user_obj = UserInfo.objects.create_user(username=user, password=pwd, email=email)
            '''
            extra = {}

            if avatar_obj:
                extra["avatar"] = avatar_obj
            UserInfo.objects.create_user(username=user, password=pwd, email=email, **extra)
        else:
            # print(form.cleaned_data)
            # print(form.errors)
            response["msg"] = form.errors
        return JsonResponse(response)
    form = UserForm()
    return render(request, "register.html", {"form": form})


def home_site(request, username):
    """
    个人站点视图函数；
    :param request:
    :return:
    """
    print("username", username)
    user = UserInfo.objects.filter(username=username).first()
    # 判断用户是否存在；
    if not user:
        return render(request, "not_found.html")
    # 查询当前站点对象：
    blog = user.blog
    # 当前用户或者当前站点对应的所有文章；
    # 基于对象查询；
    # article_list = user.article_set.all()
    # 基于双下划线的查询；
    article_list = models.Article.objects.filter(user=user)

    # 每一个后表的模型.objedts.values("pk").annotate(聚合函数(关联表__统计字段)).values("表模型的所有字段以及统计字段")

    # 1、查询每一个分类名称以及对应的文章数;
    ret1 = models.Category.objects.values("pk").annotate(c=Count("article__title")).values("title", "c")
    print(ret1)
    # 2、查询当前站点的每一个分类名称以及对应的文章数；
    cate_list = models.Category.objects.filter(blog=blog).values("pk").annotate(c=Count("article__title")).values_list(
        "title", "c")
    print(cate_list)

    # 3、查询当前站点的每一个标签名称对应的文章数；
    tag_list = models.Tag.objects.filter(blog=blog).values("pk").annotate(c=Count("article")).values_list("title", "c")
    print(tag_list)
    #4、查询当前站点每一个年月的名称以及对应的文章数之extra函数；
    ret2 = models.Article.objects.extra(select={"is_recent":"create_time > '2018-08-26'"}).values("title","is_recent")
    print(ret2)
    ret3 = models.Article.objects.extra(select={"y_m_d_date":"date_format(create_time,'%%Y-%%m-%%d')"}).values("title","y_m_d_date")
    print("这里是ret3",ret3)
    return render(request, "home_site.html")