djongo icon indicating copy to clipboard operation
djongo copied to clipboard

Support for multiple database

Open vaibhavmano opened this issue 3 years ago • 2 comments

The docs do not mention support for multiple database.

Python script

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql',
        'NAME': DatabaseConfig.DB_NAME,
        'USER': DatabaseConfig.DB_USER,
        'PASSWORD': DatabaseConfig.DB_PASSWORD,
        'HOST': DatabaseConfig.DB_HOST,
        'PORT': DatabaseConfig.DB_PORT,
    },
    'mongo': {
         'ENGINE': 'djongo',
         'NAME': 'your-db-name',
     }
}

I would like to know if it's possible to have different models for mongo and migrate them separately?

vaibhavmano avatar Apr 23 '21 08:04 vaibhavmano

DATABASES = {
'default':{},
 'users': {
        'NAME': 'user_data',
        'ENGINE': 'django.db.backends.mysql',
        'USER': 'mysql_user',
        'PASSWORD': 'priv4te'
    },
        'mongodb': {
            'ENGINE': 'djongo',
            'NAME': 'your-db-name',
            'ENFORCE_SCHEMA': False,
            'CLIENT': {
                'host': 'host-name or ip address',
                'port': port_number,
                'username': 'db-username',
                'password': 'password',
                'authSource': 'db-name',
                'authMechanism': 'SCRAM-SHA-1'
            },
            'LOGGING': {
                'version': 1,
                'loggers': {
                    'djongo': {
                        'level': 'DEBUG',
                        'propagate': False,                        
                    }
                },
             },
        }
    }

https://docs.djangoproject.com/en/3.2/topics/db/multi-db/

sheminanto avatar Apr 24 '21 17:04 sheminanto

it's possible to have different models for different databases and migrate them separately

For that you need to use database Routers

sheminanto avatar Apr 24 '21 17:04 sheminanto