I am relatively new Katalon Studio. I wish to use the K Studio for 3 use cases:
testing our product website (no problem)
testing that a database value has been created (via a SQL statement)
Mocking an External API in order to create a set of Regression tests. Using K Studio to orchestrate a set of Regression tests.
So for the second item:
I am currently struggling to understand how to create a test case that will test a DB value. I have successfully created a data file DB type , that returns the value that can be checked
I have not yet managed to write a test case that checks the value 1 returned from this data file .
So I also tried writing a new set of keywords , which appears to have worked , but again have not managed to use this in a test case…
I have searched all the documentation on how to create DB tests but none seems to show the full test case set up including how to retrieve a value from the DB and then test it.
For the 3rd item how to mock an external API then run a set of tests that uses this data to perform a known set of regression tests, has anyone used K studio to do this ?
So if any one can point me in the right direction help with the DB checking point , I would be grateful , and also the mocking API orchestration…
many thanks in advance