testSuite (utPLSQL)

Executes utPLSQL test suites using the testSuite operation.  utPLSQL version 2.3.1+ only.

Target Properties

Property Name

Property Code

Required

Description

Property Name

Property Code

Required

Description

utPLSQL Database User

FDUTPLSQL_DB_USER

Yes

User used to connect to the associated database.

utPLSQL Database Password

FDUTPLSQL_DB_PASSWORD

Yes

Password for the utPLSQL Database User.

utPLSQL Database Connection Identifier

FDUTPLSQL_DB_CONNECTION_IDENTIFIER

Yes

Identifier used to connect to the Database for utPLSQL testing. Simply the SID can be used if the database is on the same server as the endpoint (e.g. "xe" ). If connecting to a server remotely from the endpoint server, the identifier will need to follow the remote connection syntax (e.g. "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=localhost)(Port=1521))(CONNECT_DATA=(SID=xe)))" ).

utPLSQL Oracle Home Directory

FDUTPLSQL_ORACLE_HOME

Yes

Directory for Oracle Home (e.g. "oracle/product/11.2.0/xe"), used to run sqlplus.

Inputs

Input Name

Input Code

Required

Description

Input Name

Input Code

Required

Description

Suite In

FDUTPLSQL_TSUITE_INP_SUITE_IN

Yes

The name of the test suite to be tested.

Recompile In

FDUTPLSQL_TSUITE_INP_RECOMPILE_IN

No

Pass FALSE if you do not want utPLSQL to automatically recompile your test suite before running the test.

Reset Results In

FDUTPLSQL_TSUITE_INP_RESET_RESULTS_IN

No

Pass FALSE to tell utPLSQL to not reset the results information, in which case you will still be able to view results by calling utResult.show. Otherwise, utPLSQL clears the result data after each test.

Per Method Setup In

FDUTPLSQL_TSUITE_INP_PER_METHOD_SETUP_IN

No

Pass TRUE to run the setup and teardown procedure before and after each unit test procedure is executed. Default of FALSE means that these programs will be run once, at the start and end of the suite test execution as a whole.

Override Package In

FDUTPLSQL_TSUITE_INP_OVERRIDE_PACKAGE_IN

No

Override the automatic determination of package names thus removing the one to one relationship between test package and package to test. Default is false. Instead of using this parameter consider using the runSuite operation.

Artifacts 

This operation doesn’t consume or produce any artifacts.

Endpoint Selection

This operation will select all available endpoints associated to the Target.

Endpoint Execution 

This operation will execute on any one of the selected endpoints and will be random in the determination of which one.

The following macros are not currently supported in the footer:
  • style