We can run relational database queries, and verify the response through the csv based tests
We can set the columns in the csv file as follows:
SELECT * FROM COMPANY
ADDRESS:1: isNotEmpty, SALARY:1: equalTo(20000)
verify user data
SELECT * FROM COMPANY WHERE NAME = '<@name>'
TestSuite: The name of the test series
TestCaseID: Unique test id for each test
RunFlag: set 'Y' to run the test. Set 'N' to skip.
Description: Short description of the test.
RequestBody: Relational database query
OutputParams: We can store response values into variables defined here. The variables will then be available for other tests.
Syntax: <$variable>. eg. NAME:1:<$name>. the variable "name" can then be access through syntax <@name> in subsequent tests
ExpectedResponse: Verification of the response goes here. More description in the interface sections.
TcComment: comment for the tests. eg. disable for such and such reasons.
Verification are separated by ";"
Column "ID", at row 1 equals "1"
We have 4 rows with column name "ID" which have values: 1, 2, 3, 4
Column "NAME" at row 1 contains the text: Paul
We have 4 or more rows with column "Name" which contain: Paul, Allen, Teddy, Mark
Column "Address" at row 1 is not empty
Usefully if we want to check a value exists but don't want to verify the value. eg. time stamp