SQL query does not execute in afterAll() function while writing test cases
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
add a comment |
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
This is difficult to debug. Do you have logging in a.catch
thrown errors forcleanup.clearAlerts
? Could you provide yourcleanup
code and possibly show in your code where you are calling thedone
callback.
– cnishina
Jan 2 at 2:12
add a comment |
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
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
javascript angularjs unit-testing protractor
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 forcleanup.clearAlerts
? Could you provide yourcleanup
code and possibly show in your code where you are calling thedone
callback.
– cnishina
Jan 2 at 2:12
add a comment |
This is difficult to debug. Do you have logging in a.catch
thrown errors forcleanup.clearAlerts
? Could you provide yourcleanup
code and possibly show in your code where you are calling thedone
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
add a comment |
1 Answer
1
active
oldest
votes
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.
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%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
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.
add a comment |
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.
add a comment |
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.
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.
answered Jan 2 at 5:02


MadhanMadhan
487110
487110
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%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
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
This is difficult to debug. Do you have logging in a
.catch
thrown errors forcleanup.clearAlerts
? Could you provide yourcleanup
code and possibly show in your code where you are calling thedone
callback.– cnishina
Jan 2 at 2:12