Modifying database stubs

You can modify database stubs in HCL OneTest™ API.

When you open a database stub in Test Factory perspective, the Database Stub Editor screen is displayed. The following table describes the tabs that are available on this screen:

Tab Functionality
Summary This tab contains global information about the currently selected database stub.

The tab contains the following:

  • An editing options toolbar, which is context sensitive (for information about this, refer to The editing options toolbar).
  • A Persistent check box for specifying whether a database stub is persistent or non-persistent (for information about this, refer to Creating and modifying database stubs).
  • Option buttons for controlling default invocation matching and error behavior for any stored procedures in the currently selected database stub.
  • Summary information about the physical and simulation databases associated with the currently selected database stub.
Queries

This tab lists any SQL queries that were recorded during learn mode.

The tab includes an Editing Options toolbar, which is context sensitive (for information about this, refer to The editing options toolbar) You can also access these editing options by right-clicking any part of the window on the stub.

Tables

This tab displays any database tables contained in the stub. For each table, the table name and the row and column counts are displayed.

The tab includes an Editing Options toolbar, which is context sensitive (for more information, see The editing options toolbar.)

Stored procedures
With this tab, you can:
  • Add new stored procedures
  • Add new invocations to an existing stored procedure.
  • Modify invocation matching and error behavior of a stored procedure
The tab contains the following:
  • An Editing Options toolbar, which is context sensitive (for information about this, see The editing options toolbar.)
  • A Procedure list for selecting a stored procedure in the currently selected database stub.
  • An Edit button to enable you to use an external application (for example, Microsoft Excel) to create or edit a stored procedure.
  • Option buttons for specifying matched and unmatched invocation behaviors.
  • An Invocations toolbar that enables you to add, reorder, and delete invocations for the currently selected stored procedure.
  • An Invocations table that displays the input parameters to the currently selected stored procedure and a summary of the outputs from the stored procedure.
Sequences

This tab displays any sequences contained in the currently selected database stub. For each sequence, the name and start value are displayed.

The table includes an Editing Options toolbar, which is context sensitive (for information about this, see The editing options toolbar.)

Logging This tab enables you to define how much information is recorded while the currently selected stub is being executed.

Any information recorded will be logged in HCL OneTest API’s project results database and on the Test Factory perspective’s Console window.

Options are as follows:

  • None (no information is logged).
  • Normal (standard information is logged).
  • Debug (verbose information is logged)
Documentation This tab enables you to enter extra information about the currently selected stub and some of this extra information will be displayed in HCL Quality Server’s Start Stub dialog box (for information about this dialog box, refer to Starting stubs).

Although you do not have to enter such information, it may help future users of your stub and it may also help you to identify in HCL Quality Server which stub you want to start if you have created several for the same database.

For more information about using this tab, which is a standard tab on many dialog boxes in HCL OneTest API, refer to HCL OneTest API reference.

The following describes how to use Summary tab.

Feedback