zpa-cli
zpa-cli copied to clipboard
Command-line interface for the Z PL/SQL Analyzer.
ZPA CLI
This is a command-line interface to the Z PL/SQL Analyzer. It is a code analyzer for Oracle PL/SQL and Oracle Forms projects.
Downloading
Official releases are available for download on the "Releases" page.
Requirements
- Java 11 or newer
Usage
Currently, the zpa-cli supports these options:
-
--sources
: [required] Path to the folder containing the files to be analyzed. -
--forms-metadata
: Path to the Oracle Forms metadata file. -
--extensions
: File extensions to analyze, separated by comma. The default value issql,pkg,pks,pkb,fun,pcd,tgg,prc,tpb,trg,typ,tab,tps
. -
--output-format
: Format of the output. The default value isconsole
. -
--output-file
: Path to the output file.
Output formats:
-
console
: writes the analysis result on the standard output -
sq-generic-issue-import
: generates a XML file using the "Generic Issue Data" format that can be used in SonarCloud or in a SonarQube server (as an alternative to the dedicated Z PL/SQL Analyzer Plugin).
Example
Running an analysis:
./zpa-cli/bin/zpa-cli --sources . --output-file zpa-issues.json --output-format sq-generic-issue-import
Then you can send the results to a SonarCloud or SonarQube server setting the sonar.externalIssuesReportPaths
property:
sonar-scanner
-Dsonar.organization=$SONARCLOUD_ORGANIZATION \
-Dsonar.projectKey=myproject \
-Dsonar.sources=. \
-Dsonar.host.url=https://sonarcloud.io \
-Dsonar.externalIssuesReportPaths=zpa-issues.json
Check the demo project on SonarCloud!
Contributing
Please read our contributing guidelines to see how you can contribute to this project.