Djiango入门(四),使用MySQL数据库

1.本地环境安装pymysql

pip install pymysql

2.项目init.py 引入pymysql

import pymysql

pymysql.install_as_MySQLdb()

3.配置项目中settings.py

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

4.创建模型类

from django.db import models


# Create your models here.

class BookInfo(models.Model):
    btitle = models.CharField(max_length=20)
    bpub_date = models.DateTimeField(db_column='pub_date')
    bread = models.IntegerField(default=0)
    bcomment = models.IntegerField(default=0)
    isDelete = models.BooleanField(default=True)

    class Meta:
        db_table = 'bookInfo'


class HerInfo(models.Model):
    hname = models.CharField(max_length=20)
    hgender = models.BooleanField(default=True)
    hcontent = models.CharField(max_length=1000)
    isDelete = models.BooleanField(default=False)
    book = models.ForeignKey(BookInfo,on_delete=models.CASCADE)

5.创建迁移文件
python manage.py makemigrations
6.执行迁移
python manage.py migrate
7.查看数据库