Django test database

bwareham

So, I finally resolved with my latest Django project to be a good coder and write tests as I went along. But when I tried my first test I hit a roadblock -- I was unable to create a temporary testing database. When I ran

python manage.py test myapp

I got this error:

Creating test database for alias 'default'...
/home/bwareham/apps/review_radar/env/lib64/python3.6/site-packages/django/db/backends/postgresql/base.py:310: RuntimeWarning: Normally Django will use a connection to the 'postgres' database to avoid running initialization queries against the production database when it's not needed (for example, when running tests). Django was unable to create a connection to the 'postgres' database and will use the first PostgreSQL database instead.
RuntimeWarning
Got an error creating the test database: permission denied to create database

I suspect I need to configure something somewhere that I've overlooked, but I'm not sure where.

sean

bwareham the error happens because your DB user doesn't have the permissions necessary to create a new database in the DB server.

You can work around this by creating your test DB in advance via your Opalstack dashboard and then specifying the test DB info in your project settings, eg:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql',
        'NAME': 'your_database_name',
        'USER': 'your_database_user_name',
        'PASSWORD': 'your_database_user_password',
        'HOST': '',
        'PORT': '',
        'TEST': {
            'NAME': 'your_test_database_name',
            'USER': 'your_test_database_user_name',
            'PASSWORD': 'your_test_database_user_password',
        }, 
    }
}

Once that's done you can run your tests with the keepdb option eg:

python manage.py test --keepdb myapp

bwareham

sean Thanks. That worked with one wrinkle.

As configured, it still failed to create the db, apparently because it was using 'your_database_user_name' instead 'your_test_database_user_name' When I reconfigured the test db owner to be 'your_database_user_name' and copied the main db password to the TEST config it was able to create the test db.