How can I run a postgres command after database initialisation with Django

Question

I'm trying to run some tests for a Django project and to do this Django creates a new database specific for running the tests.

In my case the main database is named 'kim' and Django creates a database 'test_kim' to run the tests on.

Since I have a CICharField in one of my models, I have to run this command after the database is created and before Django migrations run.

psql =# \c db_1
CREATE EXTENSION citext;

Now I'm wondering how I can run this command for the test database?

Adding a custom migration can be an option, i guess for this case. — Shakil
– Shakil, Commented Jan 18, 2019 at 18:14

schillingt · Accepted Answer · 2019-01-18 20:11:19Z

2

You should create a migration that handles creating the extension for you. Here are the docs on it.

You would do:

python manage.py makemigrations <APP_NAME> --empty

Then in that migration import:

from django.contrib.postgres.operations import CITextExtension

and add CITextExtension() it to the migrations list. This migration should be a dependency of the migration that created the CITextField field.

answered Jan 18, 2019 at 20:11

schillingt

13.8k3 gold badges34 silver badges36 bronze badges

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

1 Answer 1