TestingWhiz


Get Community


  • Solutions
    • Web Test Automation
    • Mobile Testing
    • Cross-Browser Test Automation
    • Regression Test Automation
    • Web Services Testing
    • Data-Driven Testing
    • Database Testing
    • Big Data Testing
  • Features
  • Integrations
  • Pricing
  • Resources
    • Webinars
    • White Papers
    • Infographics
    • Case Studies
    • User Manual
    • Release Notes
    • Download Center
    • User Forum
    • FAQs
  • Blog
  • Company
    • About
    • News & Events
    • Whiz Consulting
    • Partners
    • Contact Us
User Manual
  • General Information
    • About TestingWhiz
    • TestingWhiz Architecture
    • System Requirements
    • Browser and Device Support
  • Understanding TestingWhiz Tool
    • Menu Bar
    • Tool Configuration Settings
    • Third Party Integrations
    • Menu Tab
    • Test Editor Tab
    • Test Commands, Methods and Variables
  • Create and Manage Test Projects
    • Create, Record and Import Test Scripts
    • Create Test Suites
    • Create Test Cases
    • Execute Test Scripts
  • Test Reports
  • Methods Accessing Data Table Values Without Loop
  • Generating Test Data Table
  • Importing Data from Other Test Projects
  • Types of Testing Supported by TestingWhiz
  • Mobile Test Execution
  • Desktop Test Automation
  • Image Comparison
  • Forking & Data Validation
  • Test Execution via CI Plugin
  • Integration with Test Management Tools
  • Integration with Version Control
  • Test Commands & Corresponding Actions
  • Test Commands Reference
    • Web App Commands
    • Mobile App Commands
    • Desktop App Commands
    • Conditional Commands
    • Database Commands
    • Web Service Commands
    • File Operation Commands
    • Script Optimization Commands
    • Desktop Commands

Database Commands

1. Clean

Download SampleDownload Sample

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 Settings → Configuration
Refer YouTube Link - Database Test Automation.

Fetch

Download SampleDownload Sample

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

Download SampleDownload Sample

This operation allows insert, update and delete operations and has auto-commit set to TRUE from tool's end.

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

✔ Auto-commit – Mark this option to auto commit your results to your respective transaction. Note: This option would not work with MongoDB

Comparison

Download SampleDownload Sample

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

Execute Procedure

This operation relies on the user to commit/rollback as per his requirement.

Database Stored Procedure

Select Query

Unlike the fetch command, this command builds automated query from the items chosen. Giving user from non-coding background a hassle-free and controlled command of the database.

This allows user to directly interact with database and all the tables residing in it.

✔ BD Alias – Select the DB Alias from the configured Databases list.

✔ Table – All the tables will get populated in the dropdown based on the DB selected. Choose a table to fetch the data from.

✔ Column list – User can select the columns/fields from the selected table to fetch the data. User can also search through the list of columns/fields from the list.

✔ Query – This generates and displays the query built based on the data selected in above steps.

In This Section
  • Database Commands
    • Clean
    • Database
      • Fetch
      • Query
      • Comparison
      • Execute Procedure
PREVIOUS
NEXT
cygnetinfotech

About

TestingWhiz is committed to provide an innovative and automated software testing solution to the 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

Get Started

Download Trial
Demo
Pricing
Contact Us
  • Privacy Policy
  • Terms of Use
 
TestingWhiz Capterra Ratings

Copyright© 2021, TestingWhiz. All Rights Reserved.

This website uses Cookies to improve site’s functionality & provide you with better browsing experience. Detailed information on the use of cookies on this website, and how you can decline them, is provided in our Cookie Policy. If you don't agree, kindly disable cookies from browser settings.