1. 修改项目配置文件 settings.py
参考配置:
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 'db1',
'HOST': 'localhost',
'PORT': 3306,
'USER': 'db1',
'PASSWORD': 'root',
'CHARSET': 'utf8',
},
}
2. 创建数据库,并授权
mysql> create database db1;
Query OK, 1 row affected (0.00 sec)
mysql> grant all on db1.* to db1@localhost identified by 'root';
Query OK, 0 rows affected (0.00 sec)
3. 测试
用dbshell 命令测试连接:python manage.py dbshell
用migrate 命令把模型应用到数据库中:python manage.py migrate
创建项目
1. 创建一个名叫Contact的模型,有四个字段: name, gender, age, phone
2. 把应用注册到项目中
3. 为模型的变动创建migration
python manage.py makemigrations
4. 查看migration对应的SQL
python manage.py sqlmigrate app1 0001
5. 把migration应用到数据库
python manage.py migrate
参考做法:
1. 创建项目,应用(名为app1),注册应用到项目中
2. 创建模型
class Contact(models.Model):
name = models.CharField(max_length=64)
gender = models.IntegerField(default=1)
age = models.IntegerField(default=0)
phone = models.CharField(max_length=11)
3. 创建migration: python manage.py makemigrations app1
4. 查看SQL: python manage.py sqlmigrate app1 0001
5. 应用migration: python manage.py migrate app1
改了模型要
先python manage.py makemigrations
接着 python manage.py migrate