Compare data

2 posts, 0 answers
  1. Brian
    Brian avatar
    1 posts
    Member since:
    May 2015

    Posted 23 Oct 2019 Link to this post

    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?



  2. Elena
    Elena avatar
    1203 posts

    Posted 24 Oct 2019 Link to this post

    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.

    Progress Telerik

    The New Release of Telerik Test Studio Is Here! Download, install,
    and send us your feedback!
Back to Top