Django parallel testing: Test processes incorrectly accessing test databases

user_8930149 0
Viewed 693

I have a Django 3.0.8 project running locally, connected to a local PostgreSQL database (postgres:///myapp). When I run python manage.py test, my unit tests run fine; a test database called test_myapp automatically gets created, and it's correctly accessed.

However, when I run python manage.py test --parallel 8, the test fails. I see that 8 cloned databases are correctly generated (test_myapp_1, test_myapp_2,..., test_myapp_8), but I get errors like these:

psycopg2.OperationalError: FATAL:  database "myapp_3" does not exist

It appears that for parallel tests, databases are accessed incorrectly (trying to access the database myapp_N rather than test_myapp_N). I'm trying to figure out if my local config has issues, but this is all I have in my base config:

DATABASES = {
    'default': env.db('DATABASE_URL', default='postgres:///myapp'),
}
DATABASES['default']['ATOMIC_REQUESTS'] = True

Why are my parallel tests processes not accessing their respective cloned test databases correctly?

testing django python
2 Answers

A simple solution that worked for me is to explicitly specify the test database name in settings.py, e.g.,

DATABASES = {
    'default': {
        ...
        'TEST': {
            # Avoid naming it the same as your original database name. 
            # Otherwise, it will be used while testing (and even may get deleted).
            'NAME': 'name_of_your_choice',
        },
    },
    ...
}

If you are using multiple databases, you may need to do it for all of them.

user_50998030

for using the PostgreSQL database on your Django project you can configure your database the same.

DATABASES = {
    'default': {
        "ENGINE": "django.db.backends.postgresql_psycopg2",
        "NAME": 'Table_name',
        "USER": 'user_name',
        "PASSWORD": 'password',
        "HOST": 'localhost', # or 127.0.0.1
        "PORT": '5432', #5432 is the default PostgreSQL port if you change it must change this port
    }
}

and for setting multiple databases on your Django project, you can see this page and use it.

user_143324910
Related