一、修改数据库配置
小编的数据库一共有3个 对应的应用:applet 数据库也就是applet
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 'applet',
'USER': 'root',
'PASSWORD': '123456',
'HOST': '127.0.0.1',
'PORT': '3306'
},
'applet': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 'applet',
'USER': 'root',
'PASSWORD': '123456',
'HOST': '127.0.0.1',
'PORT': '3306'
},
'backstage': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 'backstage',
'USER': 'root',
'PASSWORD': '123456',
'HOST': '127.0.0.1',
'PORT': '3306'
},
'software': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 'software',
'USER': 'root',
'PASSWORD': '123456',
'HOST': '127.0.0.1',
'PORT': '3306'
},
二、设置数据库的路由规则方法
left_ear_service:是我们的项目名称,database_router:是一个py文件,需要建立在项目的settings文件一层,DatabaseAppsRouter:是我们的路由规则
DATABASE_ROUTERS =
['left_ear_service.database_router.DatabaseAppsRouter']
三、设置APP对应的数据库路由表
'应用名称':'数据库名称'
DATABASE_APPS_MAPPING = {
'applet': 'applet',
'backstage': 'backstage',
'software': 'software'
}
四、创建路由规则方法的文件并写入规则
from django.conf import settings
DATABASE_MAPPING = settings.DATABASE_APPS_MAPPING
class DatabaseAppsRouter(object):
def db_for_read(self, model, **hints):
""""Point all read operations to the specific database."""
if model._meta.app_label in DATABASE_MAPPING:
return DATABASE_MAPPING[model._meta.app_label]
return None
def db_for_write(self, model, **hints):
"""Point all write operations to the specific database."""
if model._meta.app_label in DATABASE_MAPPING:
return DATABASE_MAPPING[model._meta.app_label]
return None
def allow_relation(self, obj1, obj2, **hints):
"""Allow any relation between apps that use the same database."""
db_obj1 = DATABASE_MAPPING.get(obj1._meta.app_label)
db_obj2 = DATABASE_MAPPING.get(obj2._meta.app_label)
if db_obj1 and db_obj2:
if db_obj1 == db_obj2:
return True
else:
return False
return None
def allow_syncdb(self, db, model):
"""Make sure that apps only appear in the related database."""
if db in DATABASE_MAPPING.values():
return DATABASE_MAPPING.get(model._meta.app_label) == db
elif model._meta.app_label in DATABASE_MAPPING:
return False
return None
def allow_migrate(self, db, app_label, model=None, **hints):
"""
Make sure the auth app only appears in the 'auth_db'
database.
"""
if db in DATABASE_MAPPING.values():
return DATABASE_MAPPING.get(app_label) == db
elif app_label in DATABASE_MAPPING:
return False
return None
五、在应用中创建实例
class User(models.Model):
avatarUrl = models.CharField(max_length=256)
nickName = models.CharField(max_length=32)
gender = models.IntegerField(default=1)
shoping_id = models.CharField(max_length=32)
addtime = models.DateTimeField(default=datetime.now)
#注释: 下面return的这个就是你的数据库名称
def __str__(self):
return "backstage %s " % self.name
class Meta:
#注释 app_label:数据库名称 db_table:表名称
app_label = 'backstage'
db_table = 'backstage_user'
六、进行数据迁移
6.1 python manage.py makemigrations
这里是进行所有的数据迁移,
回车后会将所有应用进行数据迁移,
如果不想进行所有的数据迁移,那么执行 python manage.py makemigrations 'xxxx(xxx就是我们的数据名称)'
6.2 python manage.py migrate
这里是进行数据表的操作
回车后会将所有应用进行数据表的操作,
如果不想进行所有的数据表操作,那么执行 python manage.py migrate '--database=xxx(xxx就是我们的数据库名)'
注释:这里执行完成以后,我们的数据中应该已经生成了对应的表了
八、调用视图url进行创建数据
# 注释:切记不同应用引入不同的models
8.1 创建backstate的数据
from django.http import HttpResponse, JsonResponse
from backstage.models import User # 导入user类
from backstage.models import Goods # 导入商品类
# 添加用户的视图函数
def addUser(request):
ob = User()
ob.nickName = "小王啊" # 用户名
ob.avatarUrl = "www.images/test/cr.png" # 头像
ob.gender = "1" # 性别
ob.shoping_id = "01234" # 购物id
# 保存
ob.save()
return JsonResponse({
"status": 200,
"msg": "添加成功s",
"data": {'dataStatus': 200}
})
8.2 创建applet的数据
from django.http import HttpResponse, JsonResponse
from applet.models import User #导入user类
def addUser(request):
if request.method == 'POST':
ob = User()
json_str = request.body
json_str = json_str.decode() # python3.6及以上不用这一句代码
dict_data = json.loads(json_str) # loads把str转换为dict,dumps把dict转换为str
ob.nickName = dict_data.get("nickName") #用户名
ob.avatarUrl = dict_data.get("avatarUrl") #头像
ob.gender = dict_data.get("gender") #性别
# 保存
ob.save()
return JsonResponse({
"status":200,
"msg":"添加成功",
"data":{}
})