CI/CD for project?

[jgebal]

If you're interested, you can easily set up a continuous integration/testing for your project in the cloud using Travis and utPLSQL v3. If you would be interested I can help you with that.

[ogobrecht]

Hi Jacek,

can you read our brains? We already thought about test cases but we had no time until now to start with this. It would be really great if you could help us getting started with this topic quickly.

I like the idea to have this online with Travis - so no additional setup is needed for the development environment.

Best regards
Ottmar

[jgebal]

I'm currently travelling and will be busy working whole next week. You can look at settings from utPLSQL-demo-project

All you need is to enable travis integration for your project and set some variables (OTN USER/ PASS)
The demo project does the following:

• downloads Oracle 11g XE (using travis-oracle)
• clones and unzips utPLSQL from develop (you can download latest release instead)
• installs oracle DB
• installs utPLSQL
• install project code itself
• installs unit tests
• runs unit tests
• publishes test results and code coverage to SonarQube

[ogobrecht]

Hi Jacek,

we have now 17 tests implemented with utPLSQL. You were right - it was no longer possible to ensure proper functionality without unit testing.

The missing step is now to implement the continuous integration/testing on each commit with the help of Travis, SonarQube or other cloud tools.

I will leave this issue open until we have this implemented.

Thank you for all your help and advice and the cool utPLSQL project.

Best regards
Ottmar