Python3 + Django2 绑定实体生成数据脚本(MySQL)

第一步：创建项目（sutdentsite）

django-admin startproject sutdentsite

第二步：创建应用（student）

python manage.py startapp student

第三步: 在项目(sutdentsite)的settings.py中设置区时和语言版本：

LANGUAGE_CODE = 'zh-hans'

TIME_ZONE = 'Asia/Shanghai'

USE_I18N = True

USE_L10N = True

USE_TZ = True

第四步：在项目(sutdentsite)的settings.py中INSTALLED_APPS里添加应用(student)：

INSTALLED_APPS = [
    'django.contrib.admin',
    'django.contrib.auth',
    'django.contrib.contenttypes',
    'django.contrib.sessions',
    'django.contrib.messages',
    'django.contrib.staticfiles',
    'student',
]

配置数据库连接

1、项目(sutdentsite)的settings.py文件中修改DATABASES：

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'student',
        'USER': 'root',
        'PASSWORD': '123456',
        'HOST': '127.0.0.1',
        'PORT': '3306',
        'OPTIONS': {'charset': 'utf8mb4'},
    }
}

2、应用（student）创建urls.py 文件

from django.conf.urls import url
from . import views

urlpatterns = [
]

3、在应用(student)中创建models.py 实体对象：

from django.db import models

# Create your models here.


class UserInfo(models.Model):
    username = models.CharField(max_length=50)
    password = models.CharField(max_length=50)
    address = models.CharField(max_length=200)
    email = models.EmailField()
    create_date = models.DateField()
    age = models.CharField(max_length=20)
    sex = models.CharField(max_length=20)


class User(models.Model):
    user_name = models.CharField(max_length=20)
    user_password = models.CharField(max_length=20)
    user_email = models.EmailField()
    user_address = models.CharField(max_length=500)
    user_cards = models.CharField(max_length=20)
    user_numbers = models.CharField(max_length=20)

4、基于models.py 实体对象定义，创建数据库脚本：

python manage.py makemigrations

python manage.py migrate

5、执行效果：