Overview
Validating the data created and managed by your web application is the
key to assuring web application quality. A test case type of checkpoint
provide the options to validate the data and multiple attributes of GUI
objects in your web application.
Adding Test Case
In the Test Case Configuration screen,
Click
the Add button.
Specify
the appropriate values for Test Case ID, Description and Severity.
Choose
one of the radio button to add GUI,
or Database CheckPoint.
Adding
HTML/GUI CheckPoints
Adding
Database CheckPoints
Adding HTML/GUI
CheckPoints
Select
the radio button HTML Check. Following
are the sub-options displayed:
Element - To verify the attributes of
HTML/GUI objects in a Web browser such as select, check-box, etc.
Text - To verify whether the specified
text exists in the Web browser.
Table - To verify whether the specified
column count, row count or cell value in the specified column or row exists
in the Web browser.
Select one of the option as per specific
operating needs and perform the following steps:
Verifying Element
By default,
the Element radio button is selected.
If not, select the Element radio button.
In the
launched browser, click on the required GUI object, such as combo-box,
check-box, or list box in the Web browser to verify the attributes of
the selected object. The attributes of the selected object are displayed
in a table in the TestCase Configuration dialog screen. This screen includes
three columns Property (name of the property), Value (value of the property)
and a Browse button next to each Value field to add data-driven element
checkpoint wherein the data can be fetched from test scripts using an
external database, CSV file or using environmental or user-defined variable
substitution option. Please refer to Creating
Data-Driven Test Cases for details.
By default,
all the properties are selected. Deselect the properties which are not
required.
Choose
Commit to List. This adds the
Checkpoint type to the Checkpoint Configuration list.
To add
another Checkpoint, choose the Add button below Checkpoint Configuration
list and proceed to add any Checkpoint condition of choice.
If done,
click OK.
Verifying
Text
Select
the Text radio button. The launched
browser is displayed.
Highlight
the required text to be verified in the web browser. Once the text is
selected, the Text Checkpoint Configuration dialog is displayed. This
dialog displays the Document Text panel which displays all the text in
the web browser. You can either choose the selected text as the String
To Find or any other text from the Document Text panel.
Select
the button Set As Prefix, Set As Suffix or String
To Find to set the prefix, suffix or search string.
To set
the prefix and suffix text, select the prefix and suffix text and click
the Set As Prefix and
Set As Suffix button. To set the search string or string to find,
click the button String To Find.
Click
OK.
Choose
Commit to List. This adds the
Checkpoint type to the Checkpoint Configuration list.
To add
another Checkpoint choose the Add button below Checkpoint Configuration
list and proceed to add any Checkpoint condition of choice.
If done,
click OK.
Verifying
Table
Select
the Table radio button. The launched
browser is displayed.
Click
on the required table in the web browser.
The table
attributes such as, Cell Value At, Column Count, and Row Count are displayed
in the TestCase Configuration screen. This screen includes three columns
Property (name of the property), Value (value of the property) and a Browse
button next to each Value field to add data-driven table checkpoint wherein
the data can be fetched from test scripts using an external database,
CSV file or using environmental or user-defined variable substitution
option. Please refer to Creating
Data-Driven Test Cases for details.
You can
specify the cell value, column count or row count to be verified. You
can also add multiple rows to be verified using the Add Row button or
delete existing rows using the Delete Row button.
Choose
Commit to List. This adds the
Checkpoint type to the Checkpoint Configuration list.
To add
another Checkpoint choose the Add button below Checkpoint Configuration
list and proceed to add any Checkpoint condition of choice.
If done
click OK.
Adding Database
CheckPoints
Select
the radio button DB Check.
Here you
may configure DATA-SEARCH or TABLE-SEARCH.
Configuring DATA-SEARCH
Choose
DATA-SEARCH
to search for existence of entry in a database table and proceed to fill
in details of screen as shown below:
| Field Name |
Value |
Example |
|
Database Name |
Select the name of the database if available or configure database properties
by clicking the Database Configuration
button. To know the details of adding/editing database details, refer
to the topic Configuring Databases
in QEngine. |
ORACLE |
|
URL |
Select the URL. |
oracle.jdbc.driver.OracleDriver |
|
Query |
Enter the SQL query to fetch the data from the database. |
select name, password from the LoginTable. |
|
Verify |
Choose one of the following to be verified. |
Based on Below. |
Table Values
This can be used to verify the values of a
table in a database. Use Expected Table Values to configure the values
to be compared against.
Condition
Select one of the conditional operator to be
applied between actual and the expected result. For example to verify
if rowcount is greater than one choose rowcount and select greater than
conditional operator and enter the value in expected Result field.
Result
Enter the expected result for row count/column
count here. To verify values of a table Click Expected Table Values.
Choose
Commit to List. This adds the Checkpoint type to the Checkpoint Configuration
list.
To add
another Checkpoint choose the Add button below Checkpoint Configuration
list and proceed to add any Checkpoint condition of choice.
If done
click OK.
Configuring TABLE-SEARCH
Choose
TABLE-SEARCH
to search for existence of a database table and proceed to fill in details
of screen as shown below:
| Field Name |
Value |
Example |
|
Database Name |
Select the name of the database if available or configure database properties
by clicking the Confiugre
button |
ORACLE |
|
URL |
Select the URL. |
oracle.jdbc.driver.OracleDriver |
|
Table Name |
Enter the name of the database you are searching for. |
reportdata |
|
Table should exist |
Choose this option if the table mentioned above should exist in the
database for the test to pass. |
- |
|
Table should not exist |
Select this option if the table mentioned above should not exist in
the database for the test to pass. |
- |
Choose
Commit to List. This adds the
Checkpoint type to the Checkpoint Configuration list.
To add
another Checkpoint choose the Add button below Checkpoint Configuration
list and proceed to add any Checkpoint condition of choice.
If done
click OK.