Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Run test cases from JIRA that execute a query on a database

Marius Plavanescu
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
September 26, 2019

Hello,

Pls tell me if there exists the posibility to implement following task in Jira: launch a test case that connect to a database, run a query on it and capture a boolean result (ex: 0 ro <> 0). Depending on that results I need to set status of test case in PASSED or FAILED.

Thank you,

2 answers

0 votes
Marius Plavanescu
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
September 30, 2019

Thanks Nic for sugestion,

My intention is to create a repository of test cases for testing a DW database. I have Zephyr addon for Jira where I can create test cases, but only manual ones. So, the script or automation apps (I don't know yet which) should run a test case that have as parameters: verifications script, several running parameters like p_effective_date, data_base, user/pass, then connect to that database, run the query script and interpret the results: 0 = PASSED, <>0 = FAILED. Unfortunately i don't have coding skils for Java (only PL/SQL) and therefore I'm looking for other tools that can connect to Zephyr addon or Jira to do that.

Thank you,

0 votes
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 28, 2019

You can write code that can do that.  I would look for one of the scripting or automation apps to add that.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events