SQL query does not execute in afterAll() function while writing test cases












0















I am writing unit test cases using Protractor, Jasmine.



I have a code written in beforeAll() functions which sets up data by fetching from database using sql queries



Similarly, there is an afterAll() function whose task is to reset the data in database as it was before the test cases executed



   beforeAll(() => {
//get database connection

// setup database data

});



it('should .....', () => {
//code
});



afterAll(() => {
// we can cleanup the database after we're done running our tests
cleanup.clearAlerts(connection)
.then(data => {
//code
});
});


Here the beforeAll() functions executes sql queries correctly



However, the afterAll() function just doesn't execute any cleanup sql queries.










share|improve this question

























  • This is difficult to debug. Do you have logging in a .catch thrown errors for cleanup.clearAlerts? Could you provide your cleanup code and possibly show in your code where you are calling the done callback.

    – cnishina
    Jan 2 at 2:12
















0















I am writing unit test cases using Protractor, Jasmine.



I have a code written in beforeAll() functions which sets up data by fetching from database using sql queries



Similarly, there is an afterAll() function whose task is to reset the data in database as it was before the test cases executed



   beforeAll(() => {
//get database connection

// setup database data

});



it('should .....', () => {
//code
});



afterAll(() => {
// we can cleanup the database after we're done running our tests
cleanup.clearAlerts(connection)
.then(data => {
//code
});
});


Here the beforeAll() functions executes sql queries correctly



However, the afterAll() function just doesn't execute any cleanup sql queries.










share|improve this question

























  • This is difficult to debug. Do you have logging in a .catch thrown errors for cleanup.clearAlerts? Could you provide your cleanup code and possibly show in your code where you are calling the done callback.

    – cnishina
    Jan 2 at 2:12














0












0








0








I am writing unit test cases using Protractor, Jasmine.



I have a code written in beforeAll() functions which sets up data by fetching from database using sql queries



Similarly, there is an afterAll() function whose task is to reset the data in database as it was before the test cases executed



   beforeAll(() => {
//get database connection

// setup database data

});



it('should .....', () => {
//code
});



afterAll(() => {
// we can cleanup the database after we're done running our tests
cleanup.clearAlerts(connection)
.then(data => {
//code
});
});


Here the beforeAll() functions executes sql queries correctly



However, the afterAll() function just doesn't execute any cleanup sql queries.










share|improve this question
















I am writing unit test cases using Protractor, Jasmine.



I have a code written in beforeAll() functions which sets up data by fetching from database using sql queries



Similarly, there is an afterAll() function whose task is to reset the data in database as it was before the test cases executed



   beforeAll(() => {
//get database connection

// setup database data

});



it('should .....', () => {
//code
});



afterAll(() => {
// we can cleanup the database after we're done running our tests
cleanup.clearAlerts(connection)
.then(data => {
//code
});
});


Here the beforeAll() functions executes sql queries correctly



However, the afterAll() function just doesn't execute any cleanup sql queries.







javascript angularjs unit-testing protractor






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Jan 4 at 10:56







Sachin Tiwari

















asked Jan 1 at 18:26









Sachin TiwariSachin Tiwari

708




708













  • This is difficult to debug. Do you have logging in a .catch thrown errors for cleanup.clearAlerts? Could you provide your cleanup code and possibly show in your code where you are calling the done callback.

    – cnishina
    Jan 2 at 2:12



















  • This is difficult to debug. Do you have logging in a .catch thrown errors for cleanup.clearAlerts? Could you provide your cleanup code and possibly show in your code where you are calling the done callback.

    – cnishina
    Jan 2 at 2:12

















This is difficult to debug. Do you have logging in a .catch thrown errors for cleanup.clearAlerts? Could you provide your cleanup code and possibly show in your code where you are calling the done callback.

– cnishina
Jan 2 at 2:12





This is difficult to debug. Do you have logging in a .catch thrown errors for cleanup.clearAlerts? Could you provide your cleanup code and possibly show in your code where you are calling the done callback.

– cnishina
Jan 2 at 2:12












1 Answer
1






active

oldest

votes


















0














Do some browser action in afterall to overcome the problem.



like



afterAll(async function () {
//your sql query here
await browser.waitForAngularEnabled(false);
await browser.get(browser.baseUrl);
});


Hope it help you.






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%2f53997886%2fsql-query-does-not-execute-in-afterall-function-while-writing-test-cases%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









    0














    Do some browser action in afterall to overcome the problem.



    like



    afterAll(async function () {
    //your sql query here
    await browser.waitForAngularEnabled(false);
    await browser.get(browser.baseUrl);
    });


    Hope it help you.






    share|improve this answer




























      0














      Do some browser action in afterall to overcome the problem.



      like



      afterAll(async function () {
      //your sql query here
      await browser.waitForAngularEnabled(false);
      await browser.get(browser.baseUrl);
      });


      Hope it help you.






      share|improve this answer


























        0












        0








        0







        Do some browser action in afterall to overcome the problem.



        like



        afterAll(async function () {
        //your sql query here
        await browser.waitForAngularEnabled(false);
        await browser.get(browser.baseUrl);
        });


        Hope it help you.






        share|improve this answer













        Do some browser action in afterall to overcome the problem.



        like



        afterAll(async function () {
        //your sql query here
        await browser.waitForAngularEnabled(false);
        await browser.get(browser.baseUrl);
        });


        Hope it help you.







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Jan 2 at 5:02









        MadhanMadhan

        487110




        487110
































            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%2f53997886%2fsql-query-does-not-execute-in-afterall-function-while-writing-test-cases%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

            MongoDB - Not Authorized To Execute Command

            How to fix TextFormField cause rebuild widget in Flutter

            Npm cannot find a required file even through it is in the searched directory