CI/CD and Unit Testing for Oracle PLSQL

Demo project using utPLSQL, Travis and SonarCloud for continuous integration of PLSQL and SQL code.

This is a demo project using utPLSQL v3 for unit testing of Oracle PLSQL code. The project is also taking benefit of Continuous Integration with Travis CI server as well as static code analysis, code coverage and test results reporting using SoanrQube.

With every commit made to the github repository, a build job is executed using Travis CI.

The build process consists of following steps:

Download Oracle Database 11g XE
Download latest release of utPLSQL
Install Oracle Database
Install utPLSQL framework
Install project sources
Install unit tests
Download and unzip the utplsql-cli project binaries
Execute all tests on the project
Publish test results and code coverage to SonarQube cloud service

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!