Database Commands

1. Clean

It will remove junk data which are fetched from raw data sources by validating through a set of rules. Clean command can also be utilized in File Operations.

Clean Command with Actions

2. Database

It allows users to perform the Database related queries like Select, Insert, Update and Delete.

Database Command with Actions

The user needs to configure Database Preferences from SettingsConfiguration

Fetch

It allows users to extract the data from database by performing the Select Query. The result of the Select Query will be stored either in the Target Variable or Target Data table or Target file depending on user selection.

Click on icon in the Value column and mention DB Alias, Select Query & Target Selection details in the dialog box as shown below.

Database Fetch

✔   DB Alias – The Alias of the database

✔   Select Query – The Select Query which needs to be executed in order to fetch data

✔   Single Result – Select Single Result to store output generated from the Select Query to targeted variable

✔   Result Set – Select Result Set to store output generated from the Select Query to Targeted data table

✔   File – Select File to store output generated from the Fetch command to a .csv file

✔   Target Variable – The name of the Variable which would store the output generated from the Select Query

✔   Target Data Table – The name of the Data table which would store the output generated from the Select Query

✔   Target File – The name of the File which would store the output generated from the Fetch command

✔   Timeout (in milliseconds) – The user can specify database timeout period in milliseconds to control script behavior better

Query

It allows users to manipulate the data stored in the database with the help of Insert, Update and Delete queries.

After selecting the Query action, click on icon in the Value column and mention DB Alias and Query details in the dialog box as mentioned below.

Database Query

✔   DB Alias – The Alias of the database

✔   Query – Enter the inquiry which needs to be executed

✔   Timeout (in milliseconds) – The user can specify database timeout period in milliseconds to control script behavior better

Comparison

It allows users to compare Query to Query, File to File as well as Query to File. The result of the Comparison will be stored in the Targeted Variable. Also, this command can be utilized in File Operations.

After selecting the Comparison action, click on icon in the Value column and mention Source 1&2, DB Alias, Query and Target Variable details in the dialog box as mentioned below.

Database Comparison

✔   Source 1 – Select “Query” or “File” to compare

✔   Source 2 – Select “Query” or “File” to compare

✔   DB Alias – The Alias of the database

✔   Query – Enter the inquiry which needs to be executed

✔   Timeout (in milliseconds) – The user can specify database timeout period in milliseconds to control script behavior better

About

TestingWhiz is committed to provide innovative, automated software testing solution to global enterprises and software companies for their web, mobile and cloud applications.

location

Cygnet Infotech LLC,
125 Village Boulevard,
Suite 315, Princeton,
NJ 08540, USA

PHONE | EMAIL

1-855-699-6600
info@testing-whiz.com