Navigation

Database Unit Testing with PgTAP

Database Unit Testing with PgTAP

By Susanne Schmidt (‎Su-Shee‎)
Date: Friday, 25 April 2014 12:00
Duration: 20 minutes
Target audience: Any
Language: English
Tags: database postgres testing


David Wheeler's "PgTAP" (as well as MyTAP for MySQL) is a handy, easy to use and easy to learn TAP testing framework which should be part of the toolbox of every Perl developer.

Staying within the TAP testing style we are used to in Perl, PgTAP makes it very easy to whip up simple and not-so-simple database unit tests.

I'd like to give an overview over the features of PgTAP and show a couple of common test cases which might come in handy in everyday use of a database.

Examples will be shown in Postgres/PgTAP.


Attended by: Mallory van Achterberg (‎Stomme poes‎), mna, Igor Sutton Lopes, DrForr, Martin Berends (‎mberends‎), Abe Timmerman (‎abeltje‎), Søren Lund (‎slu‎), Stefan Hornburg (‎racke‎),