Continuous Integration, Delivery, and Deployment

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 ...