O'Reilly logo

Continuous Integration, Delivery, and Deployment by Sander Rossel

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Testing the database

So, we now have the build, SonarQube, unit tests, and code coverage in place and it is time to test the database. We are going to run this one on Linux again. So, copy the build project and name this one CSharp Web Shop - Database. Make sure your label expression is linux, so it runs on the VM.

For this one, we are going to use pg_Prove, a command-line utility we installed earlier with the cpan TAP command in Linux (http://pgtap.org/pg_prove.html). With pg_Prove, we can omit the top part of our SQL test script because pg_prove does that for us:

-- This can be removed.\set QUIET 1[...]-- From here is what we need.BEGIN;

First of all, pg_Prove will try to log in to PostgreSQL using a Jenkins user. For simplicity, we are ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required