Database Operations

Adding a Database Connection Step

For database operations, first, 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.

how to add a connection step to a test case via the Database Browser

The following DB Connect test step will be created:

sample of new DB Connect test

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 means which areas should be updated on database operations.

guide in Updating a Row in the Database

The following test step parameters will be added:

sample of test step parameters

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.

sample of Inserting a Row in the Database

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.

sample of Deleting a Row from the Database

The following parameter will be added:

new parameter is added after deleting a row from the database

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:

SQL query editor view

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

You can also create a query using the shortcut CTRL + Enter, or click on the icon in upper right side

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 it into the test case. Select the Read and assert row.

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