Click here for the latest release on GitHub.
Click here for the compatibility wiki page on GitHub.
Use GitHub "issues" for support. A (free) GitHub account will be required to create a new issue. Issues can be searched without an account.
wtPLSQL is a test automation server that runs in an Oracle database to provide the following services for Test Runner packages written in PL/SQL.
- Execution of One or More Test Runners
- Assertion Results including Timing Between Assertions
- Capture/Storage/Reporting of Assertion Results
- Source Code Coverage of Test Runner
- Web Based Graphical User Interface (APEX)
Here is an example result summary from the core component. Only core is needed to produce this result.
To view the complete test results from the wtPLSQL core self-test, go to the "src/core/test_allO.LST" file in GitHub.
Here is the summary from the WT_ASSERT package self-test. It was created with the default DBMS_OUTPUT reporting package. Because test results and code coverage are stored in Oracle tables, other report formats are simple to create.
To view the complete test results from the wtPLSQL persist self-test, go to the "src/persist/test_allO.LST" file in GitHub.
The GUI module uses the Oracle APEX to enhance the UI experience. Many useful reports are available with the GUI module. This is an example of ???
- About wtPLSQL
- Examples and Documentation
- Definitions
- Best Practices
- Reference
- utPLSQL V1/V2 Comparison
- utPLSQL V3 Comparison
- OO Style Unit Testing is not for Databases
| Component | Description |
|---|---|
| core | Required for all wtPLSQL functionality. Small, fast, and maintenance free. |
| conversion | Convert Test Runner packages from utPLSQL V1/V2 to wtPLSQL |
| Add-on | Description |
|---|---|
| persist | Adds storage in tables. Adds code coverage. |
| gui | Adds Oracle APEX screens and reports. Requires persist add-on. |
| junit | Adds JUnit XML reporting. |
| DB Docs | E-R Diagrams | Call Tree Diags |
|---|---|---|
| core docs | core ERDs | core trees |
| persist docs | persist ERDs | persist trees |
| gui docs | gui ERDs | gui trees |
- DB Docs has web pages similar to JavaDocs created by Oracle's SQL*Developer.
- E-R Diagrams show relationships between tables (entities).
- Call Tree Diagrams show the PL/SQL programs, tables, and common (global) memory structures called by all PL/SQL programs.
To determine which components and add-ons have been installed, run this query:
select wtplsql.show_version from dual;
Help us improve by joining us at the wtPLSQL repository.
The web pages in this website contain information about the wtPLSQL software. Documentation on design and usage are included here. This website is version specific. Each release includes its own version of this website. The "master" branch (latest release) is always displayed at Github.io. Un-released updates are not displayed here.
For project information, see the wtPLSQL wiki. Documentation on procedures and compatibility are included in the wiki. The wiki includes information for all releases of wtPLSQL. Any updates are immediately displayed.
The following applies to files and directories at this location in the documentation repository.
| File Name | Description |
|---|---|
| demo | Demonstration Documentation Directory |
| design | Design Documents and Diagrams |
| images | Image Files referenced by MD and HTML |
| md-to-htm.bat | MS-Dos Batch File to convert MD to HTML |
| md-to-htm.lua | Lua script used by Pandoc for MD to HTML |
| md-to-htm.sh | Bash Batch File to convert MD to HTML |
| *.md | Markdown files for "github.io" |
| *.htm | HTML files for local documentation |
| . | . |
| _includes | Markdown: Theme Support Folder |
| _layouts | Markdown: Theme Support Folder |
| _sass | Markdown: Theme Support Folder |
| assets | Markdown: Theme Assets Folder |
| CNAME | Markdown: GitHub Pages Site Name |
| docs | Markdown: Theme Policies Folder |
| Gemfile | Markdown: RubyGem File |
| jekyll-theme-leap-day.gemspec | Markdown: RubyGem Page Information |
| LICENSE | Markdown: Theme License |
| script | Markdown: Theme Script Folder |
| *.yml | Markdown: YAML Configuration Files |
To view documentation use the URL "file://README.htm" or Double-click on the README.htm file.
NOTE: All HTML files are sourced from Markdown files. Modify the Markdown files, then build HTML from the Markdown files using "md-to-htm.bat".
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.