Sign In Start Free Trial

Book Overview & Buying
Table Of Contents

Advanced UFT 12 for Test Engineers Cookbook

4 (3)

Advanced UFT 12 for Test Engineers Cookbook

4 (3)

Overview of this book

This advanced cookbook is designed for software testers and engineers with previous automation experience and teaches UFT (QTP) developers advanced programming approaches. Knowledge of software testing and basic coding (with VBScript in particular) and familiarity with programming concepts are prerequisites.

Preface

Preface

What this book covers

What you will need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Free Chapter

1. Data-driven Tests

1. Data-driven Tests

Introduction

Creating a DataTable parameter

Retrieving data from a DataTable

Storing data in a DataTable

Importing an Excel file to a test

Exporting a DataTable

Parameterizing Test Object properties

Defining test cases using a DataTable

Storing data in the Environment object

Retrieving data from the Environment object

Reading values from an INI file

Using a configuration file to manage test environments

Using a global dictionary for fast shared data access

Using a global dictionary for fast shared code access

2. Testing Web Pages

2. Testing Web Pages

Introduction

Checking whether page links are broken

Deleting cookies

Managing multiple browser windows

Handling pop-up dialogs

Downloading a file using XMLHttp

Checking whether a website is up

Uploading a file using FTP

Identifying elements based on anchors

Synchronizing a test with a web page loading

Accessing web elements through DOM

3. Testing XML and Database

3. Testing XML and Database

Introduction

Establishing and closing a database connection

Using SQL queries programmatically

Using a database checkpoint

Using an XML checkpoint

4. Method Overriding

4. Method Overriding

Introduction

Overriding a Test Object method

Registering a method to all classes

Using method overriding to support object subtypes

Adding a new method to a class

5. Object Identification

5. Object Identification

Introduction

Setting mandatory and assistive properties for a class

Using Descriptive Programming inline

Using the Description object

Using child objects

Using native properties for object identification

Identifying an object based on its parent

6. Event and Exception Handling

6. Event and Exception Handling

Introduction

Catching errors inside a function or subroutine

Creating and using a recovery scenario

Using a global dictionary for recovery

7. Using Classes

7. Using Classes

Introduction

Implementing a class

Implementing a simple search class

Implementing a generic Login class

Implementing function pointers

Implementing a generic Iterator

8. Utility and Reserved Objects

8. Utility and Reserved Objects

Introduction

Using global variables (Environment)

Customizing mouse operations (DeviceReplay)

Managing processes (SystemUtil)

Measuring time (MercuryTimers)

Resolving file locations (PathFinder)

Loading shared object repositories (RepositoriesCollection)

Loading and creating XML documents (XMLUtil)

Drawing a rectangle on the screen with Win32 API methods (Extern)

Verifying binary file contents (FileCompare)

Implementing a custom reserved object

Using remote objects

Utility statements

9. Windows Script Host

9. Windows Script Host

Introduction

Reading a key from the Windows® system registry

Writing a key to the Windows® system registry

Deleting a key from the Windows® system registry

Running a process using the Windows® system shell

10. Frameworks

10. Frameworks

Introduction to test automation frameworks

Designing a test automation framework

Building a test controller

Building a reusable component (action)

Building an event handler

Building a test reporter

A. Design Patterns

A. Design Patterns

Auxiliary classes and functions

Action patterns

Runtime data patterns

Index

Index

Using SQL queries programmatically

In the previous recipe, we discussed how to use a UFT DB checkpoint. Here, we will show you how to execute a SQL statement using VBScript code.

Getting ready

We will use the function library DB_Func.vbs as in the previous recipe Establishing and closing a database connection.

How to do it...

In our custom class DB_Handler, we will add a new private m_oRecordset field to hold the results of our query and a new method executeSQLQuery(SQLQuery), which, of course, accepts a string with a valid SQL query as the argument:

Private m_oRecordset

function executeSQLQuery(SQLQuery)
    Set m_oRecordset = m_oDBConnection.Execute(SQLQuery)
End Function

Additionally, in our Action1 datasheet, we would call the executeSQLQuery(SQLQuery) method by passing our SQL string as the argument:

call oDBHandler.executeSQLQuery(SQLQuery)

As mentioned earlier, the method would store the returned Recordset in the m_oRecordset field. Then, we will be able to perform operations with these...

Visually different images

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Advanced UFT 12 for Test Engineers Cookbook

Search

Your notes and bookmarks