Fellow PostgreSQLers,
I've just released pgTAP 0.15. The most important new feature is
support for xUnit-style tests. Now you can write functions that use
the pgTAP assertion functions and install them in your database, and
then use the `runtests()` function to run them from your preferred
interface:
SELECT * FROM runtests();
You can download pgTAP 0.15 here:
http://pgfoundry.org/frs/?group_id=1000389
What is pgTAP? It's a unit-testing framework for PostgreSQL. See the
Web site for the gory details:
http://pgtap.projects.postgresql.org/
And here's the list of changes:
0.15 2009-01-20T18:41:24
* Changed `pg_typeof()` from immutable to stable, in compliance with
its configuration in the forthcoming PostgreSQL 8.4.
* Added `do_tap()`, which finds test functions and runs them, allowing
tap tests to be embedded in functions and then executed all at once.
* Added `runtests()`, which introduces xUnit-style test running, for
those who prefer to put their tests in a slew of test functions and
then run one function to run all of the test functions (plus startup,
setup, teardown, and shutdown tests).
* Added `findfuncs()`, which is used by `do_tap()` to find the
functions to execute.
* The `col_type_is()` function now requires that the type be visible
in the search path when it is called without a schema argument.
* The `plan()` function no longer resets the `client_min_messages`
setting to its default value, but leaves it set to whatever it was set
to before the function was called.
* Fixed a typo in the documentation of the short version of the `--
version` option to `pg_prove`, which is `-V`, not `-v`.
* Added `pgtap_version()`.
* Added the "html" make target to generate the HTML documentation for
the Web site, including a table of contents and documenation for
`pg_prove`.
Enjoy!
David