Database Operations

Adding a Database Connection Step

To add a Connection Step to a Test Case via the Database Browser, click and drag any table or data into your Test Case and select ‘Open a connection to the Database’.

The following DB Connect Test Step will be created:

Then save the Test Case.

Updating a Row in the Database

This Test Step can update columns of an existing row of data using a WHERE clause.

Click on a row in the Database Browser and drop it into the Test Case. Select the option ‘Update a row in the table’.

Then choose the columns for the update. The first column indicates which field to include in the WHERE clause, and the second indicates which fields should be updated.

The following Test Step parameters will be added:

Then save the Test Case.

Inserting a Row in the Database

Click on a table or row of data in the Database Browser and drop it into the Test Case. (If you use a row of data, the fields will be pre-populated based on the row.)

Select the option ‘Insert a row into the table’. Then choose the fields you want to include.

Then save the Test Case.

Deleting a Row from the Database

This Test Step can delete a row of data from a table using a WHERE clause.

Click on a row of data from the Database Browser and drag it into the Test Case.

Select the option ‘Delete a row from the table’. Then specify which fields you want to include in the WHERE clause.

The following parameter will be added:

SQL Queries

An SQL Query can be generated using the Database Browser. To do this, drag a table or row into the SQL Editor view:

You can also create a query using the shortcut CTR + Enter, or click on the icon highlighted below:

Read and Assert from the Database Table

In Provar, you can read the data out of a table and also assert its contents in a single Test Step.

Drag a row from the Database Browser and drop into the Test Case. Select ‘Read and assert row’.

Then choose the columns. The first column indicates which field to include in the WHERE clause, the second indicates which fields should be read, and the third indicates which columns should be asserted.

Then review and adjust the parameters added to the Test Case:

Then save the Test Case.

2017-05-12T11:34:53+00:00

Leave A Comment