Srilatha

• Mar 31st, 2006

 

Creating Tests ? Checking Databases

Database Checkpoints:

When you create database checkpoints, you define a query on your database,

and your database checkpoint checks the values contained in the result set. The

result set is a set of values retrieved from the results of the query.

There are several ways to define the query that will be used in your database

checkpoints:

? You can use Microsoft Query to create a query on a database. The results of a

query on a database are known as a result set.You can install Microsoft Query

from the custom installation of Microsoft Office.

? You can define an ODBC query manually, by creating its SQL statement.

? You can use Data Junction to create a conversion file that converts a database to a target text file. (For standard database checkpoints only). Note that DataJunction is not automatically included in your WinRunner package.

There are 4 DB checkpoints

1.Runtime DB Checkpoint  2.Default Checkpoint  3.Custom Check 4.Standard Check

 

rakesh77

 Profile Answers by rakesh77 

• Apr 3rd, 2006

 

Thanks Srilatha, When we will use RunTimeCheckPoints,Default check points,Please explain?

sowjanya_polepalli

 Profile Answers by sowjanya_polepalli Questions by sowjanya_polepalli

• Apr 6th, 2006

 

IN DATABASE CHECK POINT TEST ENGINEER CONDUCTS BACKEND TEST FOR FRONTEND OBJECTS USING BACKEND TABLES.

THERE ARE 3 TYPES OF CHECK POINTS

1.DEFAULT CHECK

2.CUSTOM CHECK

3.RUNTIME CHECK

DEFAULT: WE ARE TESTING OUR APPLICATION USING EXISTING DATABASE IN THIS SITUATION WE USE THIS

 DB_CHEK("CHECKLISTFILE.CKL","EXPECTEDFILE.XLS")

rakesh77

 Profile Answers by rakesh77 

• Apr 10th, 2006

 

Thanks,Sowjanya.

What about RunTime Record check points?

pazhani

 Profile Answers by pazhani Questions by pazhani

• Apr 10th, 2006

 

 Database checkpoints :check the contents and the number of rows and columns of a result set, which is based on a query you create on your database.

bye

Pazhani,

Test Engineer

Bangalore

schittoor

 Profile Answers by schittoor Questions by schittoor

• Apr 18th, 2006

 

Database checkpoints:- Compares current database data to expected database data.

This is 3 types

1.default :- only content

2.custom :- column count +row count

3.runtime-record:- we can execute the scipt what are chenges is thier in the record we will see the database.

Thanks

srinivasulu.chittoor

shiva

• May 26th, 2006

 

For verifying the Front end operations on backend tables content in our Application build we use this testing technique of functionality testing

This database check point consists of three sub options:

1. defalut check,
2. Custom check,
3. runtime record check.

• Default Check option is used to verify the impact of front end operations on backend tables thru Visibility of that tables content.
• Custom check option is used to conduc backend testing on number of rows & columns & content of the table.
• Run time record check is optional checkpoint database in this database testing.We use this option to find  mapping in between frontend operations & backend columns.

raghuramsuravarapu

 Profile Answers by raghuramsuravarapu Questions by raghuramsuravarapu

• Jun 14th, 2006

 

Database Check Point : Check point used to verify the backend database operations related to application feature.

Types :Default,Custom,Runtime

Default check point should be created in all situations,like,to check complete list of records.Your TSL script will check all the records by default.

Custom check point should be created to check for specific number of rows or records.We can customize only which records we want to test.Your TSL script that is created for this script will check only the records you customized to check.Execution is faster than default check point.

Runtime Check Point should be created in a situation where data is changed in any row.For example we can create a script such that the application is open  and automatically enters the username and password and enters into the application.If we assume that there is a control text box for employee name and modify button.By clicking the modify button we can change the employee name ,and this employee name should also be changed in backend database.In this scenario's we can create a runtime checkpoint and can test that a single record is added in the database or not.

To connect into the backend database,three methods are used :

Microsoft Query with DSN,Only DSN,Data Junction.