Backend(SQL tables) verify the data displayed on Frontend(UI)
Has anyone worked on doing backend testing to verify that the same information is displayed on the frontend(web application) ? If so please could you provide an example of what we need to achieved to test this?
Looks like itís a 3 step process
1) Connect to DB-- ( I understand this and did write vbscript to connect to DB and ran query)
2) Verify the backend dataódo not understand how to verify this data with frontend (UI/web application)
3) Now verify it is same data displayed on frontend (UI/web application).
For 2nd point, you know what are inputs you provided that are to be saved into database. It means you know the database schema and structure. Your inputs are expected values and values stored in are Actual values. Verify if both are same.
For 3rd point, to verify frontend you sure need a UI automation tool. Not sure if you already have the paid tools. If you are looking for opensource for webapplication there is Selenium, Sahi etc (If your application is too small and you don't want to use any tool, plain vbscript allows you to application, Google "VBScript browser automation"). Automate your usecase, Get the data stored in back end. Get the values displayed in front end by automation tool. Verify them if they match expected values i.e the inputs you have provided.
Hope it helps.