Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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


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

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

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

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you