How to configure and write unit cases to get coverage on plsql code..Please help

SonarQube Server / Community Build
, , ,
1

Must-share information (formatted with Markdown):

  • which versions are you using (SonarQube)
  • How can we write the unit cases to achieve coverage on PLSQL code
  • What is needed to do this… any plugin required?
1 Like
2

Hello @Aish

and welcome to the community.

You can create unit tests for PL/SQL with utPLSQL for example. This framework can also create test and coverage reports. These reports can be provided to SonarQube via the generic test and coverage report properties (sonar.coverageReportPaths and sonar.coverageReportPaths).

So you can also get a test evaluation and coverage calculation in SonarQube and it can be integrated into a possible quality gate.

Please let me know if my answer can help you.

Best,
Nils

3

Thank you, but when I try with:
sonar-scanner -X -D sonar.testExecutionReportPaths=target/utplsql/sonar-test-reporter.xml -D sonar.coverageReportPaths=target/utplsql/coverage-sonar-reporter.xml -D sonar.import_unknown_files=true
i receive this:
DEBUG: Skipping file ‘test/body/test_api_tests.sql’ in the generic coverage report because it doesn’t have a known language

how can i solve?

1 Like