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 indicates which fields 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 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.

Read and Assert from the Database Table

Then review and adjust the parameters added to the test case:

Then save the test case.

Review Provar on G2
Documentation library

Other available resources

Looking for something different?

We use cookies to better understand how our website is used so we can tailor content for you. For more information about the different cookies we use please take a look at our Privacy Policy.

Scroll to Top