Is there a way to stop the Concordion test when there is no test data found
I'm using Concordion Markdown 'run each row in the table as an example' type framework in Data warehouse Testing. I have to search for data in Source table if data found meeting pre conditions then validate that data against the target table. i.e. if a record is in source table then I must see one or more records target table based on some rules.
So if there is no data found in source table then no point in checking the target table i.e test need to stop running that example or that row in that case.
So my question is there a way to do this in Concordion Markdown 'run each row as an example' to skip a row if some condition is not met and move to the next row in the table?
java markdown concordion
asked Nov 14 '18 at 22:11
JeyJey
63
add a comment |
I'm using Concordion Markdown 'run each row in the table as an example' type framework in Data warehouse Testing. I have to search for data in Source table if data found meeting pre conditions then validate that data against the target table. i.e. if a record is in source table then I must see one or more records target table based on some rules.
So if there is no data found in source table then no point in checking the target table i.e test need to stop running that example or that row in that case.
So my question is there a way to do this in Concordion Markdown 'run each row as an example' to skip a row if some condition is not met and move to the next row in the table?
java markdown concordion
asked Nov 14 '18 at 22:11
JeyJey
63
add a comment |
I'm using Concordion Markdown 'run each row in the table as an example' type framework in Data warehouse Testing. I have to search for data in Source table if data found meeting pre conditions then validate that data against the target table. i.e. if a record is in source table then I must see one or more records target table based on some rules.
So if there is no data found in source table then no point in checking the target table i.e test need to stop running that example or that row in that case.
So my question is there a way to do this in Concordion Markdown 'run each row as an example' to skip a row if some condition is not met and move to the next row in the table?
java markdown concordion
asked Nov 14 '18 at 22:11
JeyJey
63
I'm using Concordion Markdown 'run each row in the table as an example' type framework in Data warehouse Testing. I have to search for data in Source table if data found meeting pre conditions then validate that data against the target table. i.e. if a record is in source table then I must see one or more records target table based on some rules.
So if there is no data found in source table then no point in checking the target table i.e test need to stop running that example or that row in that case.
So my question is there a way to do this in Concordion Markdown 'run each row as an example' to skip a row if some condition is not met and move to the next row in the table?
java markdown concordion
java markdown concordion
asked Nov 14 '18 at 22:11
JeyJey
63
asked Nov 14 '18 at 22:11
JeyJey
63
asked Nov 14 '18 at 22:11
JeyJey
63
asked Nov 14 '18 at 22:11
JeyJey
63
asked Nov 14 '18 at 22:11
JeyJey
63
63
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Are you able to provide a "clean" example so I can understand what you are trying to achieve? I would have thought you'd want to check that there is no matching data in the target if there is none in the source.
Are you asking for the target columns not to be marked up in green or red? I'm not sure that's possible. You could try throwing an exception, which should move on to the next row, but might check any assertions first.
answered Nov 21 '18 at 8:15
Nigel CharmanNigel Charman
56849
Thanks Nigel. Yes I could and both source value and target value will be null and test will pass but not guarantee the business rule is tested with valid data. If all my tests pass like this then don't really testing with valid data so I would like to stop the test and move on to the next row in table. So i would know there is not test data and can mock up some test data. I too thought of throwing an exception but report looks bit messy, so checking if there is any better way.
– Jey
Nov 22 '18 at 2:56
How about adding a column to the table for "valid data found"? This could run an assertion which would only pass if valid data was found.
– Nigel Charman
Nov 22 '18 at 10:35
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%2f53309502%2fis-there-a-way-to-stop-the-concordion-test-when-there-is-no-test-data-found%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
Are you able to provide a "clean" example so I can understand what you are trying to achieve? I would have thought you'd want to check that there is no matching data in the target if there is none in the source.
Are you asking for the target columns not to be marked up in green or red? I'm not sure that's possible. You could try throwing an exception, which should move on to the next row, but might check any assertions first.
answered Nov 21 '18 at 8:15
Nigel CharmanNigel Charman
56849
Thanks Nigel. Yes I could and both source value and target value will be null and test will pass but not guarantee the business rule is tested with valid data. If all my tests pass like this then don't really testing with valid data so I would like to stop the test and move on to the next row in table. So i would know there is not test data and can mock up some test data. I too thought of throwing an exception but report looks bit messy, so checking if there is any better way.
– Jey
Nov 22 '18 at 2:56
How about adding a column to the table for "valid data found"? This could run an assertion which would only pass if valid data was found.
– Nigel Charman
Nov 22 '18 at 10:35
add a comment |
Are you able to provide a "clean" example so I can understand what you are trying to achieve? I would have thought you'd want to check that there is no matching data in the target if there is none in the source.
Are you asking for the target columns not to be marked up in green or red? I'm not sure that's possible. You could try throwing an exception, which should move on to the next row, but might check any assertions first.
answered Nov 21 '18 at 8:15
Nigel CharmanNigel Charman
56849
Thanks Nigel. Yes I could and both source value and target value will be null and test will pass but not guarantee the business rule is tested with valid data. If all my tests pass like this then don't really testing with valid data so I would like to stop the test and move on to the next row in table. So i would know there is not test data and can mock up some test data. I too thought of throwing an exception but report looks bit messy, so checking if there is any better way.
– Jey
Nov 22 '18 at 2:56
How about adding a column to the table for "valid data found"? This could run an assertion which would only pass if valid data was found.
– Nigel Charman
Nov 22 '18 at 10:35
add a comment |
Are you able to provide a "clean" example so I can understand what you are trying to achieve? I would have thought you'd want to check that there is no matching data in the target if there is none in the source.
Are you asking for the target columns not to be marked up in green or red? I'm not sure that's possible. You could try throwing an exception, which should move on to the next row, but might check any assertions first.
answered Nov 21 '18 at 8:15
Nigel CharmanNigel Charman
56849
Are you able to provide a "clean" example so I can understand what you are trying to achieve? I would have thought you'd want to check that there is no matching data in the target if there is none in the source.
Are you asking for the target columns not to be marked up in green or red? I'm not sure that's possible. You could try throwing an exception, which should move on to the next row, but might check any assertions first.
answered Nov 21 '18 at 8:15
Nigel CharmanNigel Charman
56849
answered Nov 21 '18 at 8:15
Nigel CharmanNigel Charman
56849
answered Nov 21 '18 at 8:15
Nigel CharmanNigel Charman
56849
answered Nov 21 '18 at 8:15
Nigel CharmanNigel Charman
56849
56849
Thanks Nigel. Yes I could and both source value and target value will be null and test will pass but not guarantee the business rule is tested with valid data. If all my tests pass like this then don't really testing with valid data so I would like to stop the test and move on to the next row in table. So i would know there is not test data and can mock up some test data. I too thought of throwing an exception but report looks bit messy, so checking if there is any better way.
– Jey
Nov 22 '18 at 2:56
How about adding a column to the table for "valid data found"? This could run an assertion which would only pass if valid data was found.
– Nigel Charman
Nov 22 '18 at 10:35
add a comment |
Thanks Nigel. Yes I could and both source value and target value will be null and test will pass but not guarantee the business rule is tested with valid data. If all my tests pass like this then don't really testing with valid data so I would like to stop the test and move on to the next row in table. So i would know there is not test data and can mock up some test data. I too thought of throwing an exception but report looks bit messy, so checking if there is any better way.
– Jey
Nov 22 '18 at 2:56
How about adding a column to the table for "valid data found"? This could run an assertion which would only pass if valid data was found.
– Nigel Charman
Nov 22 '18 at 10:35
Thanks Nigel. Yes I could and both source value and target value will be null and test will pass but not guarantee the business rule is tested with valid data. If all my tests pass like this then don't really testing with valid data so I would like to stop the test and move on to the next row in table. So i would know there is not test data and can mock up some test data. I too thought of throwing an exception but report looks bit messy, so checking if there is any better way.
– Jey
Nov 22 '18 at 2:56
Thanks Nigel. Yes I could and both source value and target value will be null and test will pass but not guarantee the business rule is tested with valid data. If all my tests pass like this then don't really testing with valid data so I would like to stop the test and move on to the next row in table. So i would know there is not test data and can mock up some test data. I too thought of throwing an exception but report looks bit messy, so checking if there is any better way.
– Jey
Nov 22 '18 at 2:56
How about adding a column to the table for "valid data found"? This could run an assertion which would only pass if valid data was found.
– Nigel Charman
Nov 22 '18 at 10:35
How about adding a column to the table for "valid data found"? This could run an assertion which would only pass if valid data was found.
– Nigel Charman
Nov 22 '18 at 10:35
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%2f53309502%2fis-there-a-way-to-stop-the-concordion-test-when-there-is-no-test-data-found%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
