TestingBaires

Para el siguiente video, les dejo los comentarios que se van mostrando:

What is database checkpoint
Database checkpoint is one of the checkpoints in QTP which is used to test the contents of the database accessed by application under test. It stores the expected data and compares this with the data stored in the database. When you use a database checkpoint in your script, it connects to the database and sends the query to the database to retrieve the current data into the record set. QTP now compares the current data with the expected data stored n the checkpoint and gives you the result as pass or fail. You can create a database checkpoint to confirm that the data being stored in the database does not introduce any error and you can do this by verifying
- the data is saved to the correct tables and in proper field
- the data on different operation in database like insert, delete, update
- the correctness of data etc.

To understand this lets take a very simple example for Flight Application. Suppose you are updating an order by changing the name, as in the video as followed. You need to change the customer name to Billy now and update the record. So if you want to verify whether the record is properly updated with the changed name or not, you use the database checkpoint-

SQL Statement
select customer_name from Orders

Tener en cuenta el siguiente cartel:
In checkpoint properties, going to check all the rows. Hope you remember, our customer name is Paul.

Tener en cuenta el siguiente cartel:
Going to update the customer name as Billy for the same order in application

Tener en cuenta el siguiente cartel:
Changing the checkpoint property expected value to Billy as we have updated the customer name as Billy for this particular order