通過官方文檔https://docs.djangoproject.com/zh-hans/3.1/topics/db/multi-db/和csdnhttps://blog.csdn.net/songfreeman/article/details/70229839的這兩篇文章可以進行多數(shù)據(jù)庫的設置。但是設置后可能會出現(xiàn)問題，由于我連接的數(shù)據(jù)庫是通過inspactdb的方法得到的model。于是在migrate的時候出現(xiàn)了問題，會提示 1146, “Table xxx doesn't exist” 。后來發(fā)現(xiàn)問題可能出在路由表上，按照DATABASE_APPS_MAPPING映射之后，django默認的表如果要寫入可能會找不到數(shù)據(jù)庫。而源代碼里的映射關系并不包含新加入的app，例如grappelli等。
DATABASE_APPS_MAPPING = {
# example:
# 'app_name':'database_name',
# 'admin': 'default',
# 'users': 'default', #django
'basic_estate': 'basic_estate',
'footstone': 'footstone',
'mall': 'hsmall',
'iot_biz': 'iot_biz',
'mall': 'mall',
'hsuser': 'hsuser',
}
如果要解決這個問題可以修改router代碼，在映射關系內(nèi)找不到對應的數(shù)據(jù)庫的情況下返回默認數(shù)據(jù)庫連接即可：
# -*- coding: utf-8 -*-
"""
@author: obaby
@license: (C) Copyright 2013-2020, obaby@mars.
@contact: root@obaby.org.cn
@link: http://www.obaby.org.cn
http://www.h4ck.org.cn
http://www.findu.co
@file: atabase_router.py.py
@time: 2021/2/26 9:07
@desc:
"""
from django.conf import settings
DATABASE_MAPPING = settings.DATABASE_APPS_MAPPING
class DatabaseAppsRouter(object):
"""
A router to control all database operations on models for different
databases.
In case an app is not set in settings.DATABASE_APPS_MAPPING, the router
will fallback to the `default` database.
Settings example:
DATABASE_APPS_MAPPING = {'app1': 'db1', 'app2': 'db2'}
"""
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 'default'
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 'default'
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
這樣django系統(tǒng)所需的數(shù)據(jù)庫就能正常創(chuàng)建了：
總結(jié)
到此這篇關于django使用多個數(shù)據(jù)庫的文章就介紹到這了,更多相關django多數(shù)據(jù)庫內(nèi)容請搜索腳本之家以前的文章或繼續(xù)瀏覽下面的相關文章希望大家以后多多支持腳本之家！
您可能感興趣的文章:- Django ForeignKey與數(shù)據(jù)庫的FOREIGN KEY約束詳解
- pycharm中django框架連接mysql數(shù)據(jù)庫的方法
- django inspectdb 操作已有數(shù)據(jù)庫數(shù)據(jù)的使用步驟
- Python web框架(django,flask)實現(xiàn)mysql數(shù)據(jù)庫讀寫分離的示例
- Django連接本地mysql數(shù)據(jù)庫(pycharm)的步驟
- django 解決model中類寫不到數(shù)據(jù)庫中,數(shù)據(jù)庫無此字段的問題
- Python的Django框架實現(xiàn)數(shù)據(jù)庫查詢(不返回QuerySet的方法)
- django 數(shù)據(jù)庫返回queryset實現(xiàn)封裝為字典
- Django項目如何給數(shù)據(jù)庫添加約束
