This is a migrated thread and some comments may be shown as answers.

Compare data

1 Answer 111 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Brian
Top achievements
Rank 1
Brian asked on 23 Oct 2019, 11:47 AM

Is there a functionality or way to write/execute a test that can compare data returned to a baseline data?  If this isn't a possibility is there a way to query a database?  I am trying to have automated test check for data changes when we make updates to ensure calculations are correct; the calculations comeback versus html.

If this is not a possibility what would be the best way to set up an automated test where I would be able to verify data returned is within range?

 

Regards!

1 Answer, 1 is accepted

Sort by
0
Elena
Telerik team
answered on 24 Oct 2019, 03:40 PM

Hi Brian,

As far as I understand you need to make a cross check between the actual data generated from the web application during the test and the database data. If this is so, i hope you will find the below notes useful: 

  1. First thing to point to is the functionality to extract data from the page in run-time - that way you can take the current values of interest and store these into variables. 
  2. Then, check how you can access the database in a coded step - we have examples for Oracle and SQL
  3. And at the end, once you get the run-time data and that from the database, you can use the extracted variables in code as well in order to compare these. 

Please, take your time to go through these resources and verify if these are sufficient for you to cover the current requirement. In case there are any questions, please, let me know. 

Thanks in advance for your cooperation.

Regards,
Elena
Progress Telerik

 
The New Release of Telerik Test Studio Is Here! Download, install,
and send us your feedback!
Tags
General Discussions
Asked by
Brian
Top achievements
Rank 1
Answers by
Elena
Telerik team
Share this question
or