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?
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