pgTAP A free unit testing framework for PostgreSQL written in PL/pgSQL and PL/SQL
Download

pgTAP Ranking & Summary

pgTAP Tags

framework PostgreSQL postgresql unit test unit test unit test framework

pgTAP Description

A free unit testing framework for PostgreSQL written in PL/pgSQL and PL/SQL pgTAP is a free and open source suite of database functions that make it easy to write TAP-emitting unit tests in psql scripts or xUnit-style test functions. The TAP output is suitable for harvesting, analysis, and reporting by a TAP harness, such as those used in Perl and PHP applications.pgTAP includes a comprehensive collection of TAP-emitting assertion functions for testing database design and functionatlity, as well as the ability to integrate with other TAP-emitting test frameworks. pgTAP can also be used in the xUnit testing style. What's New in This Release: · Fixed failing test on 8.4rc2. · Added result set testing functions. These allow testers to write queries in pure SQL and check that their results are as expected. The new functions are: · + `results_eq()` · + `results_ne()` · + `set_eq()` · + `bag_eq()` · + `set_ne()` · + `bag_ne()` · + `set_has()` · + `bag_has()` · + `set_hasnt()` · + `bag_hasnt()` · Changed some internal queries to use explicit `JOIN`s. · Fixed capitalization of `TAP::Harness` in the `Makefile`. Thanks to · Quinn Weaver. · Fixed a syntax error that caused `uninstall_pgtap.sql` to fail on older · PostgreSQL versions (fix by Quinn Weaver). · Modified the summary documentation for the `--schema` and `--match` options · to `pg_prove` to better reflect that they are for finding xUnit tests, · not for finding pgTAP functions.

pgTAP Related Software