django 多数据库

朱雀 2022-07-11 05:32 188阅读 0赞

参考文档：[https://docs.djangoproject.com/en/1.10/topics/db/multi-db/][https_docs.djangoproject.com_en_1.10_topics_db_multi-db]

1.新建一个router文件，如db\_router.py，键入以下内容：

# coding=utf-8
    from __future__ import (unicode_literals, absolute_import)
    
    yw_models = (
      'Employee',
      'Department',
    )
    
    class DbRouter(object):
        """ A router to control all database operations on models in the watchlist application. """
    
        def db_for_read(self, model, **hints):
            """ Attempts to read watchlist models go to yw DB. """
            if model.__name__ in yw_models:
                return 'yw'
            return None
    
        def db_for_write(self, model, **hints):
            """ Attempts to write watchlist models go to yw DB. """
            if model.__name__ in yw_models:
                return 'yw'
            return None
    
          def allow_relation(self, obj1, obj2, **hints):
            """ Allow relations if a model in the watchlist app is involved. """
            if obj1.__class__.__name__ in yw_models or obj2.__class__.__name__ in yw_models:
                return True
            return None
        def allow_migrate(self, db, app_label, model_name=None, **hints):
            """ Make sure the auth app only appears in the 'auth_db' database. """
            if db in yw_models:
                return True
            return None

2.修改setting.py

DATABASE_ROUTERS = ['Yw.db_router.DbRouter']//DbRouter的路径
    DATABASES = {
        'default': {
           # 'ENGINE': 'django.db.backends.sqlite3',
           # 'NAME': os.path.join(BASE_DIR, 'db.sqlite3'),
            'ENGINE': 'django.db.backends.mysql',
            'NAME': 'admin',
            'USER': 'root',
            'PASSWORD': '12345678',
            'HOST':'127.0.0.1',
            'PORT':'3306',
    
        },
        'yw': {
            'ENGINE': 'django.db.backends.mysql',
            'NAME': 'yw',
            'USER': 'root',
            'PASSWORD': '12345678',
            'HOST':'127.0.0.1',
            'PORT':'3306',
        },
    }

[https_docs.djangoproject.com_en_1.10_topics_db_multi-db]: https://docs.djangoproject.com/en/1.10/topics/db/multi-db/