How to setup ruby-plsql-spec on Jenkins CI?

[jgebal]

It would be great to include a guide for setup of Jenkins job that can be executed to run your tests.
I have described some of that already on my blog post some time ago, while comparing with utPLSQL.
This could however be a good contribution to the documentation of the project.

[jlincoln]

I've setup Hudson jobs that run ruby-plsq-spec. I use the following main functions/plugins. The builds are parameterized with the database as a parameter (DB).

1. Execute Shell Function
   Example
   TOP=XXMAP
   RSPEC_FILE=testmap11_eft_debit_spec.rb
   ../../run_plsql_spec.sh $TOP $RSPEC_FILE "$JOB_NAME" "$BUILD_TAG" $DB
2. Publish HTML reports
   a. Report 1
   1. HTML directory to archive: rspec
   2. Index page(s): test-results.html
   3. Report Title: RSpec Results
      b. Report 2
   4. HTML directory to archive: coverage
   5. Index page(s): index.html
   6. Report Title: Code Coverage
3. Hudson Text Finder
   a. Hudson Text Finder: rspec/test-results.html
   b. Regular expression: 0 failures
   c. Succeed if found: checked
   d. Unstable if found: unchecked