Django多数据库配置求助：无法读取第三数据库（新手向）

我来帮你分析下问题所在，以及如何修复这个配置。

问题根源：路由执行顺序与逻辑冲突 #

你的数据库路由是按AuthRouter → PrimaryReplicaRouter → SecondaryReplicaRouter的顺序执行的，但PrimaryReplicaRouter的db_for_read方法直接返回了'primary'，不管当前请求的是哪个模型。这意味着所有不属于auth/contenttypes的模型，都会被这个路由拦截并定向到primary数据库，SecondaryReplicaRouter根本没有机会处理请求——这就是你无法读取secondary数据库中models表的原因。

另外还有一个小细节：PrimaryReplicaRouter和SecondaryReplicaRouter里的db_list = ('primary')是错误的，这不是元组，而是单个字符串，会导致allow_relation的判断逻辑失效，应该写成db_list = ('primary',)（注意末尾的逗号）。

解决方案：让每个路由只处理自己负责的模型 #

我们需要调整路由逻辑，让每个路由仅处理对应数据库的模型，非负责的模型返回None，这样路由会继续向下传递请求，直到找到正确的路由。

方案1：通过模型类直接匹配（快速适配现有代码） #

修改你的routes.py，让每个路由只处理指定的模型：

from django.db import models
from .models import CarAuto, CarModels  # 导入你的模型类

class AuthRouter:
    route_app_labels = {'auth', 'contenttypes'}
    def db_for_read(self, model, **hints):
        if model._meta.app_label in self.route_app_labels:
            return 'auth_db'
        return None
    def db_for_write(self, model, **hints):
        if model._meta.app_label in self.route_app_labels:
            return 'auth_db'
        return None
    def allow_relation(self, obj1, obj2, **hints):
        if ( obj1._meta.app_label in self.route_app_labels or obj2._meta.app_label in self.route_app_labels ):
            return True
        return None
    def allow_migrate(self, db, app_label, model_name=None, **hints):
        if app_label in self.route_app_labels:
            return db == 'auth_db'
        return None

class PrimaryReplicaRouter:
    # 指定该路由负责的模型
    primary_models = {CarAuto}
    
    def db_for_read(self, model, **hints):
        if model in self.primary_models:
            return 'primary'
        return None  # 返回None，让下一个路由处理
    
    def db_for_write(self, model, **hints):
        if model in self.primary_models:
            return 'primary'
        return None
    
    def allow_relation(self, obj1, obj2, **hints):
        db_list = ('primary',)  # 修正为元组
        if obj1._state.db in db_list and obj2._state.db in db_list:
            return True
        return None
    
    def allow_migrate(self, db, app_label, model_name=None, **hints):
        # 仅允许在primary数据库迁移该路由负责的模型
        if model_name in [m.__name__ for m in self.primary_models]:
            return db == 'primary'
        return None

class SecondaryReplicaRouter:
    # 指定该路由负责的模型
    secondary_models = {CarModels}
    
    def db_for_read(self, model, **hints):
        if model in self.secondary_models:
            return 'secondary'
        return None
    
    def db_for_write(self, model, **hints):
        if model in self.secondary_models:
            return 'secondary'
        return None
    
    def allow_relation(self, obj1, obj2, **hints):
        db_list = ('secondary',)  # 修正为元组
        if obj1._state.db in db_list and obj2._state.db in db_list:
            return True
        return None
    
    def allow_migrate(self, db, app_label, model_name=None, **hints):
        # 仅允许在secondary数据库迁移该路由负责的模型
        if model_name in [m.__name__ for m in self.secondary_models]:
            return db == 'secondary'
        return None

方案2：按App标签区分（更规范的Django实践） #

如果你的项目规模会扩大，建议将不同数据库的模型拆分到不同的App中（比如local_app存primary数据库的模型，main_app存secondary数据库的模型），然后通过App标签来路由：

1. 创建两个App：

python manage.py startapp local_app
python manage.py startapp main_app

2. 将CarAuto移动到local_app/models.py，CarModels移动到main_app/models.py，并在settings.py的INSTALLED_APPS中添加这两个App。

3. 修改routes.py：

class AuthRouter:
    # 保持原逻辑不变
    route_app_labels = {'auth', 'contenttypes'}
    def db_for_read(self, model, **hints):
        if model._meta.app_label in self.route_app_labels:
            return 'auth_db'
        return None
    def db_for_write(self, model, **hints):
        if model._meta.app_label in self.route_app_labels:
            return 'auth_db'
        return None
    def allow_relation(self, obj1, obj2, **hints):
        if ( obj1._meta.app_label in self.route_app_labels or obj2._meta.app_label in self.route_app_labels ):
            return True
        return None
    def allow_migrate(self, db, app_label, model_name=None, **hints):
        if app_label in self.route_app_labels:
            return db == 'auth_db'
        return None

class PrimaryReplicaRouter:
    route_app_labels = {'local_app'}
    
    def db_for_read(self, model, **hints):
        if model._meta.app_label in self.route_app_labels:
            return 'primary'
        return None
    
    def db_for_write(self, model, **hints):
        if model._meta.app_label in self.route_app_labels:
            return 'primary'
        return None
    
    def allow_relation(self, obj1, obj2, **hints):
        db_list = ('primary',)
        if obj1._state.db in db_list and obj2._state.db in db_list:
            return True
        return None
    
    def allow_migrate(self, db, app_label, model_name=None, **hints):
        if app_label in self.route_app_labels:
            return db == 'primary'
        return None

class SecondaryReplicaRouter:
    route_app_labels = {'main_app'}
    
    def db_for_read(self, model, **hints):
        if model._meta.app_label in self.route_app_labels:
            return 'secondary'
        return None
    
    def db_for_write(self, model, **hints):
        if model._meta.app_label in self.route_app_labels:
            return 'secondary'
        return None
    
    def allow_relation(self, obj1, obj2, **hints):
        db_list = ('secondary',)
        if obj1._state.db in db_list and obj2._state.db in db_list:
            return True
        return None
    
    def allow_migrate(self, db, app_label, model_name=None, **hints):
        if app_label in self.route_app_labels:
            return db == 'secondary'
        return None

额外检查项 #

1. 确认secondary数据库的连接信息（HOST、PORT、PASSWORD）正确，能正常访问：
   你可以用MySQL客户端直接连接测试，或者在Django中运行python manage.py dbshell --database=secondary验证连接。
2. 确保secondary数据库中存在models表，且字段与CarModels模型定义一致。
3. 如果需要迁移模型到对应数据库，使用--database参数：

   python manage.py migrate --database=auth_db
   python manage.py migrate --database=primary
   python manage.py migrate --database=secondary
   

内容的提问来源于stack exchange，提问作者Mina Dominic