fossabot/zpa

The best open source code analyzer for PL/SQL and Oracle SQL code.

Z PL/SQL Analyzer

[ ](https://github.com/felipebz/zpa/releases/latest)

This plugin adds PL/SQL and Oracle SQL support to the SonarQube. SonarQube is an open platform to manage code quality. This project supports SonarQube 6.7.x and newer.

Installation

• Download the latest sonar-plsql-open-plugin stable release or the latest sonar-plsql-open-plugin development version (not final) (from the button "Artifacts") into the SONARQUBE_HOME/extensions/plugins directory;
• Restart your SonarQube server;
• Navigate to the Marketplace (SONARQUBE_URL/marketplace?filter=installed). It should list "PL/SQL (Community)" or "Z PL/SQL Analyzer" on the tab "Installed Plugins";
• Run an analysis with SonarQube Scanner.

Contribute

You are welcome to contribute. PL/SQL and Oracle SQL are big languages and there are many pieces missing in the grammar.

Running the integration tests

There are two sets of integration tests:

• plugin: checks if the metrics are imported correctly in SonarQube
• ruling: checks the quality of parser and rules against real-world code

To run the integrations tests, update the submodules:

git submodule update --init --recursive

Build the plugin:

./mvnw clean install
./mvnw -f plsql-custom-rules/pom.xml package

Then run the tests:

./mvnw test -Pit

You can also specify the SonarQube version using the property sonar.runtimeVersion:

./mvnw test -Pit -Dsonar.runtimeVersion=7.6

Alternatives:

If you're looking for PL/SQL support in SonarQube, there is also the commercial plugin from SonarSource.

License