To install/upgrade, download the latest Release
Also see the compatibility page in the wtPLSQL repository wiki.
Use GitHub "issues" for support. A (free) GitHub account will be required to create a new issue. Issues can be searched without an account.
This is the summary from the WT_ASSERT package self-test. This is the default DBMS_OUTPUT format. Because test results and code coverage is stored in Oracle tables, other report formats a simple to create.
wtPLSQL 1.1.0 - Run ID 7: 09-Jun-2018 11:48:42 AM
Test Results for WTP.WT_ASSERT
Total Testcases: 150 Total Assertions: 404
Minimum Interval msec: 0 Failed Assertions: 0
Average Interval msec: 7 Error Assertions: 0
Maximum Interval msec: 761 Test Yield: 100.00%
Total Run Time (sec): 2.8
Code Coverage for PACKAGE BODY WTP.WT_ASSERT
Ignored Lines: 1103 Total Profiled Lines: 1464
Excluded Lines: 6 Total Executed Lines: 309
Minimum LineExec usec: 0 Not Executed Lines: 0
Average LineExec usec: 394 Unknown Lines: 46
Maximum LineExec usec: 65814 Code Coverage: 100.00%
Trigger Source Offset: 0
To view the complete test results from the wtPLSQL self-test, go to the test_allO.LST file in GitHub.
wtPLSQL helps with white-box testing of Oracle database objects. It is particularly well suited for unit testing and simple integration testing. It is written in PL/SQL. It contains a self-test which makes it easier to support and customize.
Like utPLSQL, wtPLSQL provides a set of assertion tests that can be used to determine how well an Oracle database object is performing. These assertions record the outcome (success or failure) of each test. These assertions also record the time between calls. A test runner (PL/SQL package) must be created with these assertion tests included. The Core Features page introduces the main functionality of wtPLSQL.
A simple text based reporting package called "WT_TEXT_REPORT" is included with the core installation. Custom reports are easy to create because the assertion outcomes and interval time between assertions are stored in the Oracle database. A set of DBDocs and E-R diagrams are provided to assist with any reporting customization.
Because all testing with wtPLSQL is for driven by custom PL/SQL packages, a Best Practices page has some guidance for creating Test Runner packages.
The About wtPLQSL page has more information about the history and testing methodology of wtPLSQL.
These are the working definitions for the wtPLSQL project.
Annotation - PL/SQL comment used to identify a DBOUT or ignore source code lines from code coverage data.
Assertion - A function that performs a single test and records/reports the result.
Coverage - An indication of the amount or percentage of source code tested.
DBOUT - Database Object Under Test. The database object that is the target of testing. White-box testing is oriented toward a specific DBOUT. Code coverage is also oriented toward a specific DBOUT.
Setup - Modifying the database or environment in preparation for an assertion, testcase, or group of either.
Teardown - Restoring a database or environment after an assertion, testcase, or group of either.
Testcase - A logical grouping of assertions to run happy path, decision tree, boundary condition, and/or fault insertion tests. May included one or more setup, teardown, and intermediate setups.
Test Runner - A PL/SQL package that exercises a DBOUT and uses assertions to confirm the correct funcionality of the DBOUT. It may have zero or more testcases. It always contains a call to the WTPLSQL.TEST_RUN procedure. It may contain DBOUT annotations and/or "exclude source lines" annotations.
The Other Definitions page includes definitions from many sources to help define the terms used in various software testing methodologies.
utPLSQL V3 is an excellent choice for unit testing. It is well supported and includes extensive functionality.
wtPLSQL has a different focus than utPLSQL V3. More information is available in this link.
Help us improve by joining us at the wtPLSQL repository.
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.