How to implement Query result comparison

Hi guys,

 

I'm new to Bamboo and I would like to use Bamboo to test our Data Warehouse. I've an idea but I don't have the knowledge how implement this within Bamboo.

A test consists of two queries, one on the source database and the other on the data warehouse. If the result of both queries are identical, the test passed.

Can you please point me in the right direction how to implement this test case using Bamboo?

 

Thank you in advance.

 

Regards,

Bas

2 answers

0 votes

Hello @Bas van de Lustgraaf,

Try to think out of tool. How would you solve this task without any CI server? Maybe some shell script, or Node.js application, or JUnit test. When you can execute your task from your command line then you can use some tool, like Bamboo to execute it remotely in controlled environment.

I'll go and check out JUnit. If I remember well, you can do object comparison in JUnit. Thank you!

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Tuesday in Statuspage

How do your teams prepare for really high (planned) traffic days like Cyber Monday?

Hi there! Shannon from Statuspage here.  👋  With Cyber Monday quickly approaching, we're looking to hear from Atlassian customers – specifically from teams who touch incident response li...

61 views 0 5
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you