Repository files navigation

utPLSQL for SQL Developer extends Oracle's SQL Developer to

• run existing utPLSQL unit tests
• run utPLSQL code coverage reports
• generate new utPLSQL unit tests (skeletons)

In the Connections window, select a connection or one or more packages or package procedures to run utPLSQL tests. Or you can run utPLSQL tests directly from the PL/SQL editor. The test procedures are determined according to the cursor position in the PL/SQL editor.

In the Connections window, select a connection or one or more packages for a code coverage report.

In the dialog you can set some parameters. If you run code coverage for a few chosen packages or from the PL/SQL editor the objects to be included are determined according the object dependencies in the Oracle data dictionary.

PressRun to produce the code coverage process in the background. You may minimize or close the dialog. To abort the process, pressCancel.

The HTML report is shown in your default browser.

Select a package, type, function or procedure to build a utPLSQL test package skeleton. The generated package compiles and executes, but still needs some rework.

1. Press the buttonCreate code templates in the preferences
2. Typeut_ in the Worksheet or a PL/SQL editor and pressCtrl-Space to get the list of a utPLSQL code templates
3. PressReturn to paste a code template at the current cursor position

Set your preferences to change the behaviour of utPLSQL within SQL Developer.

utPLSQL for SQL Developer implements theOddgenGenerator2 interface to

• run existing utPLSQL test suitepaths and test suites
• bulk generate new utPLSQL unit tests into dedicated files

The use ofoddgen for SQL Developer is optional.

utPLSQL can run tests based on suitepaths and suites. The next screenshot shows the generated run command for two selected suitepaths.

Use oddgen to generate utPLSQL test package skeletons. When generating to files, a file for each package specification and package body is created.

Binary releases are publishedhere.

1. Start SQL Developer

2. SelectCheck for Updates… in the help menu.

3. Use theInstall From Local File option to install the previously downloadedutplsql_for_SQLDev_*.zip file.

1. Start SQL Developer

2. SelectCheck for Updates… in the help menu.

3. PressAdd… to register thesalvis.com update sitehttp://update.salvis.com/.

4. Use theSearch Update Center option and select thesalvis.com update center to install the lastest version ofutPLSQL for SQL Developer.

Please file your bug reports, enhancement requests, questions and other support requests withinGithub's issue tracker.

• Questions
• Open enhancements
• Open bugs
• Submit new issue

1. Describe your idea bysubmitting an issue
2. Fork the utPLSQL-SQLDeveloper respository
3. Create a branch, commit and publish your changes and enhancements
4. Create a pull request

1. Download and install SQL Developer 19.1.0

2. Download and install Apache Maven 3.5.4

3. Download and install a git command line client

4. Clone the utPLSQL-SQLDeveloper repository

5. Open a terminal window in the utPLSQL-SQLDeveloper root folder and type

    cd sqldev

6. Run maven build by the following command

    mvn -Dsqldev.basedir=/Applications/SQLDeveloper19.1.0.app/Contents/Resources/sqldeveloper -DskipTests=true clean package

   Amend the parameter sqldev.basedir to match the path of your SQL Developer installation. This folder is used to reference Oracle jar files which are not available in public Maven repositories

7. The resulting fileutplsql_for_SQLDev_x.x.x-SNAPSHOT.zip in thetarget directory can be installed within SQL Developer

utPLSQL for SQL Developer is licensed under the Apache License, Version 2.0. You may obtain a copy of the License athttp://www.apache.org/licenses/LICENSE-2.0.