In-PostgreSQL tests

[Jeff Kowalczyk <..hidden..>]

Should LedgerSMB start using a testing framework/style which interacts
directly with/in PostgreSQL?

It would seem to be useful now for the legacy codebase, and essential
going forward with the stated direction of increasing stored-procedure
logic.

Two projects that looked interesting:

http://pgfoundry.org/projects/pgtap/
TAP-based unit tests for your database. pgTAP is a suite of database
functions that make it easy to write unit tests in psql scripts suitable
for harvesting, analysis, and reporting by a TAP harness, such as those
used in Perl and PHP applications.

http://epictest.org/
Epic is a unittest framework for PostgreSQL stored procedures. Epic
provides PL/pgSQL library functions to help write, run, and manage tests.