File Release Notes and Changelog

Release Name: 0.10

Release Notes

This version of pgTAP introduces a slew of functions for testing a database schema, and offers portability all the way back to PostgreSQL 8.0. Enjoy!

—Theory

Change Log

0.10  2008-09-18T22:59:31
      - Changed `pg_prove` to set `QUIET=1` when it runs, so as to prevent the
        output of extraneous stuff.
      - Added some `GRANT` statements to `plan()` in order to make it easier
        to run tests using roles other than the one that called `plan()`.
        Patch from Rod Taylor.
      - Replaced a call to `lastval()` with a call to `currval()` in order to
        improve compatibility with PostgreSQL 8.0. Reported by David Westbrook.
      - Added support for TODO and SKIP tests.
      - Removed the few uses of named parameters and added alias names instead.
        This improves compatibility for versions of PostgreSQL prior to 8.0.
        Reported by David Westbrook.
      - Fixed the plural of "test" in the output from `finish()`. It was
        plural when there was one test and singular otherwise. So I reversed
        that.
      - Moved assignment to declared variables from the `DECLARE` block to the
        body of the functions. Improves compatibility with versions of
        PostgreSQL prior to 8.0. Reported by David Westbrook.
      - Eliminated passing the result of a function call to `RAISE` in order
        to better support older versions of PostgreSQL. Reported by David
        Westbrook.
      - Switched from using `FOUND` to `GET DIAGNOSTICS ROW_COUNT` because the
        former does not seem to be set for `EXECUTE` SQL in older versions of
        PostgreSQL. Reported by David Westbrook.
      - Added tests specifically targeting PostgreSQL 7.3. From David
        Westbrook.
      - Ported all the way back to PostgreSQL 8.0, thanks to some Makefile
        hackery and a patch file. All tests pass on 8.0, 8.1, 8.2, and 8.3.
        The only exception is `throws_ok()` and `lives_ok()`, which are not
        supported on 8.0. Versions of PostgreSQL lower than 8.0 are not yet
        supported, even though we have made some changes to simplify getting
        things to work in earlier versions.
      - Changed "got/expected" to "have/want", following Schwern's plans for
        Test::Builder 2. Also changed "caught/expected" to "caught/wanted" for
        nice parity when outputting diagnostics for exception testing.
      - Added the `has_table()`, `has_view()`, `has_column()`, `has_pk()`,
        `has_fk()`, `fk_ok()`, `has_unique()` and `has_check()` test
        functions.
      - Added the `col_not_null()` and `col_is_null()` test functions.
      - Added the `col_type_is()`, `col_default_is()`, `col_is_pk()`,
        `col_is_fk()`, `col_is_unique()`, and `col_has_check()` test
        functions.
      - Fixed `is()` and `isnt()` to better handle NULLs.
      - Added `cmp_ok()`.
      - Added the `--set ON_ERROR_STOP=1` option to the call to `psql` in
        `pg_prove`.
      - Renamed `drop_pgtap.sql.in` to `uninstall_pgtap.sql.in`, which is more
        in line with typical PostgreSQL contrib modules.
      - Removed verbose output of the `psql` command from `pg_prove`. Thanks
        to Andy Armstrong for the spot.
      - Divided the tests up into many separate test script files, so that
        things are a bit better organized and easier to maintain.
      - Added the `check_test()` function and started converting internal
        tests to use it instead of the hacked stuff they were doing before.
      - As in Test::Builder 0.81_01, changed the message for extra tests run
        to show the number of tests run rather than the number extra to avoid
        the user having to do mental math.
      - The regression test files are now processed by `make installcheck` and
        `make test` so that the schema can be properly set, if pgTAP is built
        with a schema.

Powered By FusionForge