Perform Arithmetic and Logical assertions on two writeables/tables
I have to implement the below scenario:
I have to compare the DB values from 2 different tables and perform logical and arithmetic operations on them.
- Create a new test suite
- Create a DB tool and query to fetch data (multiple columns) from a table 1. I need to save the run time values. I created a Writable A data source and saved the results.
- Create another DB tool and query to fetch data (multiple columns) from table 2. I need to save the run time values. I created a Writable B data source and saved the results.
- Now I need to perform arithmetic and logical operations on these columns of same writable or columns of different writable A & B.
5.Need to validate these scenarios :
i) sum the values in one column of table 1 and compare the sum is equal to a value in table 2 .
ii) Value in a cell of table 1 and table 2 should be same
How do I include the assertions to perform the validations.
Please guide me with ideal approach to achieve this.