1、在MySQL中建表
在MySQL的wanping
库中,建立表testTB
(特别注意,本例中主要是保存json数据):
查看表结构:
2、Django配置数据库连接参数
在 settings.py
中设置数据库的连接参数:
# Database
# https://docs.djangoproject.com/en/1.8/ref/settings/#databases
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 数据库名称,
'USER': 用户名,
'PASSWORD': 密码,
'HOST': 主机,
'PORT': 端口号,
}
}
3、根据数据库生成 models
首先,需要用 inspectdb
生成 models.py
,主要的命令是
$ python manage.py inspectdb
同步到models,mysite/blog
下面的models
,若存在删除models.py文件
$ python manage.py inspectdb > blog/models.py
4、关于models的调整
对于需要增删查改操作,需要在 Meta
中设置 managed = True
。
# This is an auto-generated Django model module.
# You'll have to do the following manually to clean this up:
# * Rearrange models' order
# * Make sure each model has one field with primary_key=True
# * Remove `managed = False` lines if you wish to allow Django to create, modify, and delete the table
# Feel free to rename the models, but don't rename db_table values or field names.
#
# Also note: You'll have to insert the output of 'django-admin sqlcustom [app_label]'
# into