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












0















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







share|improve this question























  • Adding a custom migration can be an option, i guess for this case.

    – Shakil
    Jan 18 at 18:14


















0















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







share|improve this question























  • Adding a custom migration can be an option, i guess for this case.

    – Shakil
    Jan 18 at 18:14
















0












0








0








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







share|improve this 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?






django postgresql




django postgresql






share|improve this question













share|improve this question











share|improve this question




share|improve this question










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





















  • 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














1 Answer
1






active

oldest

votes


















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.






share|improve this answer























    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
    });


    }
    });














    draft saved

    draft discarded


















    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









    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.






    share|improve this answer




























      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.






      share|improve this answer


























        2












        2








        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.






        share|improve this answer













        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.







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Jan 18 at 20:11









        schillingtschillingt

        5,43711722




        5,43711722






























            draft saved

            draft discarded




















































            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.




            draft saved


            draft discarded














            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





















































            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







            -

            Popular posts from this blog

            Homophylophilia

            Image
            Haec pagina ad tempus protecta est ob maleficia perpetua. Quaesemus, emendationes suggere in pagina disputationis vel magistratum ad hanc deprotegendam pete. Homophylophilia Hyacinthus complexus ab amante suo Apolline, in pictura Mors Hyacinthi quam Jean Broc pinxit. Homophylophilia est sui sexus vel generis amor vel mores romantici vel sexuales, res venerea masculina in masculos, aut mulier in mulieres appetentes. Hoc ingenium sexuale est "exemplar permanens vel inclinatio ad experiendam sexualem, adfectionalem, vel romanticam vim attrahendi," praecipue vel solum ex hominibus eiusdem sexús; notio "etiam ad hominis iudicium identitatis privatae socialisque in illis attractionibus conditum refert, in moribus quoque qui illos exprimant, et in societate communitatis aliorum qui illos communicent." [1] [2] Per aevos alii aliter rem definiverunt, sed Occidentali nostrae aetatis cultu civili non tantum ad ipsa acta erotica spectat, sed etiam igitur
            Read more

            Updating UILabel text programmatically using a function

            Image
            0 so I am trying to update the UIlabel text using a func. I have seen few other questions like mine and I tried their method but it doesn't work. fun returns no value when used in the UIlabel. I have shown my code below.It has to be noted that when I use the function in viewdidload I can retrieve the data. lazy var name: UILabel = { let lb = UILabel() lb.text? = getthename() lb.lineBreakMode = NSLineBreakMode.byWordWrapping lb.textColor = .mainGreen lb.textAlignment = .left lb.font = UIFont.boldSystemFont(ofSize:12.0) return lb }() func getthename() -> String { var wins : String = "" let ud = (Auth.auth().currentUser?.uid) self.ref = Database.database().reference() self.ref.child("Users").child(ud!).observeSingleEvent(of: .value, with: {(snapshot) in
            Read more

            Cloud Functions - OpenCV Videocapture Read method fails for larger files from cloud storage

            Image
            0 I created a cloud function to read a video file from cloud storage and read frames and create an image for each frame. This function works for small files which is 1-2 MB, However, this method fails while reading larger file 130 MB. import cv2 from google.cloud import storage vidcap = cv2.VideoCapture("https://storage.googleapis.com/[bucker_name]/[filename.mp4]") if vidcap.isOpened(): vidcap.open("https://storage.googleapis.com/[bucker_name]/[filename.mp4]") success,image = vidcap.read() print(success) Expected the print will return true and an image will hold an image of a first frame. python-3.x function opencv cloud share | improve this question
            Read more