django 数据库的配置

数据库的配置

1、setting.py 配置

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

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',  # 数据库类型
        'NAME': 'ajax_db',  # 数据库名
        'HOST': '127.0.0.1',  # host
        'PORT': 3306,  # 端口号
        'USER': 'hu*******',  # 用户名
        'PASSWORD': 'hu********'  # 密码
    }
}

添加pymysql导入 项目下

# project/__init__.py 文件
import pymysql
pymysql.install_as_MySQLdb()

2、数据库创建数据库名

mysql -u root -p

创建数据库

'显示数据库'
show databases;

'创建数据库'
create database ajax_db default charset utf8;

use ajax_db

3、模型 – 创建继承类

from django.db import models


# Create your models here.
class User(models.Model):
    uname = models.CharField(max_length=30)
    pwd = models.CharField(max_length=30)
    nickname = models.CharField(max_length=30)

4、数据迁移

工程文件夹下 执行命令

python manage.py makemigrations

python manage.py migrate

# 单个模块迁移
python manage.py migrate user

查看生成的表

desc user_user;

+----------+-------------+------+-----+---------+----------------+
| Field    | Type        | Null | Key | Default | Extra          |
+----------+-------------+------+-----+---------+----------------+
| id       | int         | NO   | PRI | NULL    | auto_increment |
| uname    | varchar(30) | NO   |     | NULL    |                |
| pwd      | varchar(30) | NO   |     | NULL    |                |
| nickname | varchar(30) | NO   |     | NULL    |                |
+----------+-------------+------+-----+---------+----------------+

5、插入数据

insert into user_user values(1, 'zhangs', '123456', 'zhangs');
insert into user_user values(2, 'lisi', '123456', 'lisi');

select * from user_user;

+----+--------+--------+----------+
| id | uname  | pwd    | nickname |
+----+--------+--------+----------+
|  1 | zhangs | 123456 | zhangs   |
|  2 | lisi   | 123456 | lisi     |
+----+--------+--------+----------+