Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to setup code coverage setup for SQL/ PL-SQL with TeamCity or Jenkins? It will be very helpful f

SundaresanJul 15 2015 — edited Jul 15 2015

Hi ,

I have to setup a continuous integration process for my oracle database. We are planning to use Team City and SVN as source control tool.  For unit testing framework we are going to add utPLSQL. But we have to see a code coverage report for the test cases. When I google it for some additional information, I cone to know utPLSQL does not provide code coverage  with Jenkins , whereas ruby-plsql has provide. I need some help how to implement code coverage for my test framework in PL SQL.  Based on your inputs we will be develop a POC model and if it works perfect , we will use this practice for test coverage. Righ now we have two options to go for establishing CI Process

1) Team City(CI Servers0 => Source Control (SVN) ==> Build(Ant scripts) ==> Deploy ==> Testing Framework (utPLSQL) => Code Coverage(????) => publish results to the team via email

2) Jenkins => Source Control (SVN) => Build => Deploy = > Testing Framework (utPLSQL) ==> Code Coverage => publish the code coverage and test result to team.

UTPLSQL | Oracle Thoughts

So we have to choose a Code Coverage tool which will use  utPLSQL and also integrate with Jenkins or Teamcity. Those who have already worked on this part, please do share your inputs and suggestions.

Thanks

Sundaresan

This post has been answered by Nick Strange on Jul 15 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 12 2015
Added on Jul 15 2015
1 comment
979 views