django基本建模指导

参考链接：
https://blog.csdn.net/laikaikai/article/details/80563387?utm_medium=distribute.wap_relevant.none-task-blog-2_defaultbaidujs_baidulandingword~default-0.wap_blog_relevant_pic

1.创建项目和app
django-admin startproject fuxin
python manage.py startapp fxpreson

2.1数据库模型设计
#fxperson/models.py

from django.db import models


class Person(models.Model):
    '''人员表'''

    gender = (
        ('male','男'),
        ('female','女'),
    )

    姓名 = models.CharField(max_length=128,unique=True)
    性别 = models.CharField(max_length=32,choices=gender,default='男')
    职位 = models.CharField(max_length=256)
    照片 = models.ImageField(blank=True,upload_to='photo')
    邮箱 = models.EmailField(unique=True)
    个人简介 = models.CharField(max_length=256,blank=True)
    c_time = models.DateTimeField(auto_now_add=True)

    def __str__(self):
        return self.姓名

    class Meta:
        ordering = ['c_time']
        verbose_name = '人员'
        verbose_name_plural = '人员'

2.2.设置数据库为Mysql
在settings.py修改

DATABASES = {
‘default’: {
‘ENGINE’: ‘django.db.backends.mysql’,
‘NAME’: ‘django’, #数据库名字
‘USER’: ‘root’, #账号
‘PASSWORD’: ‘123456’, #密码
‘HOST’: ‘127.0.0.1’, #IP
‘PORT’: ‘3306’, #端口
}

2.3在app里的init.py里面导入pymysql模块

#fxperson/init.py

 
import pymysql
pymysql.install_as_MySQLdb()

2.4注册app
INSTALLED_APPS = [
‘django.contrib.admin’,
‘django.contrib.auth’,
‘django.contrib.contenttypes’,
‘django.contrib.sessions’,
‘django.contrib.messages’,
‘django.contrib.staticfiles’,
‘fxperson’,
]

2.5迁移到mysql数据库，迁移完成后可以在mysql通过sql命令查看到相关数据
python manage.py makemigrations

python manage.py migrate

3.1.在admin中注册模型,每个app都有一个admin管理后台
#fxperson/admin.py

from django.contrib import admin
from . import models
admin.site.register(models.User)

3.2.创建超级管理员,可通过页面登录该账户管理后台数据
python manage.py createsuperuser

4.1url路由
#fuxin/urls.py

from django.conf.urls import url
from django.contrib import admin
from fxperson import personviews

urlpatterns = [
    url(r'^admin/', admin.site.urls),
    url(r'^person/', personviews.person),
]

4.2视图
#fxperson/personviews.py

from django.shortcuts import render,redirect
from .models import Person

def person(request):
    if not request.session.get('is_login', None):
        return redirect("/index/")
    if request.session.get('is_login', None):
        nid = request.GET.get('nid')
        list_show = []
        list_manager = ()
        list_develop = ()
        list_test = ()
        list_support = ()
        obj = Person.objects.all().values()
        for i in obj:
            del i['id']
            del i['c_time']
        for i in obj:
            if i[