RE: Automating the GUI vs DB

I’m automating a search functionality based on some filters. It gave 1000 results. From scripting point of view, should I be checking the results in WebTable row by row to check if the filter check is right or not? or should I just check if there is some data/rows in the webtable and pass the test case?

Add Comment
2 Answers

Yes, GUI verification is necessary but from DB u can check below test case

DB.query.no of rows = UI.Filter.no of rows

Here u need to make sure db query should be written by you. You should not use same query which is written by developer to show results as it will always pass.

One more suggestion if u can execute multiple column query in db then u can verify that

String from DB (DB.query.row1,col1) = String from UI(UI.Filter.rows1,col1)
and so on

DB.query.row1,col2 = UI.Filter.rows1,col2
DB.query.row1,col3 = UI.Filter.rows1,col3
DB.query.row1,col4 = UI.Filter.rows1,col4

 

Supporter Answered on March 31, 2015.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.