How can I run a postgres command after database initialisation with Django
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?
django postgresql
asked Jan 18 at 17:44
Johan VergeerJohan Vergeer
1,37341738
add a comment |
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?
django postgresql
asked Jan 18 at 17:44
Johan VergeerJohan Vergeer
1,37341738
Adding a custom migration can be an option, i guess for this case.
– Shakil
Jan 18 at 18:14
add a comment |
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?
django postgresql
asked Jan 18 at 17:44
Johan VergeerJohan Vergeer
1,37341738
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?
django postgresql
django postgresql
asked Jan 18 at 17:44
Johan VergeerJohan Vergeer
1,37341738
asked Jan 18 at 17:44
Johan VergeerJohan Vergeer
1,37341738
asked Jan 18 at 17:44
Johan VergeerJohan Vergeer
1,37341738
asked Jan 18 at 17:44
Johan VergeerJohan Vergeer
1,37341738
asked Jan 18 at 17:44
Johan VergeerJohan Vergeer
1,37341738
1,37341738
Adding a custom migration can be an option, i guess for this case.
– Shakil
Jan 18 at 18:14
add a comment |
Adding a custom migration can be an option, i guess for this case.
– Shakil
Jan 18 at 18:14
Adding a custom migration can be an option, i guess for this case.
– Shakil
Jan 18 at 18:14
Adding a custom migration can be an option, i guess for this case.
– Shakil
Jan 18 at 18:14
add a comment |
1 Answer
1
active
oldest
votes
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 at 20:11
schillingtschillingt
5,43711722
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54259039%2fhow-can-i-run-a-postgres-command-after-database-initialisation-with-django%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
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 at 20:11
schillingtschillingt
5,43711722
add a comment |
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 at 20:11
schillingtschillingt
5,43711722
add a comment |
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 at 20:11
schillingtschillingt
5,43711722
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 at 20:11
schillingtschillingt
5,43711722
answered Jan 18 at 20:11
schillingtschillingt
5,43711722
answered Jan 18 at 20:11
schillingtschillingt
5,43711722
answered Jan 18 at 20:11
schillingtschillingt
5,43711722
5,43711722
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54259039%2fhow-can-i-run-a-postgres-command-after-database-initialisation-with-django%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Adding a custom migration can be an option, i guess for this case.
– Shakil
Jan 18 at 18:14