How can add multiple database for tests in Django tests

Question

Question:

How can I add multiple databases for testing in Django?

When I ran my test suits I got this Error:

AssertionError: Database queries to 'mig' are not allowed in this test. Add 'mig' to path_to_test_suit.MigrationServiceTest.databases to ensure proper test isolation and silence this failure.

Here are my PostgreSQL settings:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql_psycopg2',
        'NAME': 'db_1_name',
        'USER': 'db_1_user',
        'PASSWORD': 'db_1_passwd',
        'HOST': 'db_1_host',
        'PORT': 'db_1_port',
    },
    'mig': {
        'ENGINE': 'django.db.backends.postgresql_psycopg2',
        'NAME': db_2_name,
        'USER': db_2_user,
        'PASSWORD': 'db_2_passwd',
        'HOST': 'db_2_host',
        'PORT': 'db_2_port',
    },
}

I use Django-nose for running test suits and use Django 2.2

Hi, unfortunately, I forget the way that I fixed the problem. — Phoenix
– Phoenix, Commented Jun 24, 2020 at 1:55

M.Void · Accepted Answer · 2020-10-01 10:44:46Z

3

You could use the database parameter in your tests. For example:

class TestYourClass(TestCase):
    databases = {'default', 'mig'}

def test_some_method(self):
    call_some_method()

For more information please see Multi-database support.

P.S. In earliest Django version than 2.2 please use multi_db = True

class TestYourClass(TestCase):
    multi_db = True

answered Oct 1, 2020 at 10:44

M.Void

2,9142 gold badges33 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Esther · Accepted Answer · 2020-04-25 00:35:45Z

-1

You need to grant DJANGO user the priviledge to write. Then, to make the tests and preserve your data, you have to make a copy of your schema with test_ as prefix and use the keywork --keepdb.

answered Apr 25, 2020 at 0:35

Esther

3895 silver badges18 bronze badges

Collectives™ on Stack Overflow

How can add multiple database for tests in Django tests

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related