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

小灰灰 2023-10-18 17:04 16阅读 0赞

第一步：创建项目（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 = [
    ]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n_size_16_color_FFFFFF_t_70][]

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

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n_size_16_color_FFFFFF_t_70 1][]

5、执行效果：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n_size_16_color_FFFFFF_t_70 2][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20190414161317118.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/2019041416162913.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20190414161837410.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n,size_16,color_FFFFFF,t_70