Announce: PGUnit - xUnit test framework for pl/pgsql

From: "Dmitry Koterov" <dmitry(at)koterov(dot)ru>
To: "Postgres General" <pgsql-general(at)postgresql(dot)org>
Subject: Announce: PGUnit - xUnit test framework for pl/pgsql
Date: 2008-11-11 22:31:24
Message-ID: d7df81620811111431p4b6d0016pa26d110c4c979f8d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello.

Hope this will be helpful for agile developers.

http://en.dklab.ru/lib/dklab_pgunit/

PGUnit is a xUnit-style framework for stored procedures in PostgreSQL 8.3+.
It allows database developers to write automated tests for existed stored
procedures or develop procedures using concepts of Test Driven Development
(TDD). All test cases are stored in the database, so you don't need any
external resources (like files, version control, command-line utilities
etc.) to save tests.

As in traditional xUnit, tests may be grouped in test case; each test-case
may have its own environment initialization code ("fixture preparation
code", or setUp block). The main benefit of PGUnit is that setUp block
(usually quite CPU intensive) is executed only once, and its effect is
stored in a savepoint. Then, all tests are executed from that savepoint, so
the fixture initialization overheat is minimal. All tests are still executed
independently, because their effects are automatically rolled back after the
execution.
Comments are welcome.

Browse pgsql-general by date

  From Date Subject
Next Message Ivan Sergio Borgonovo 2008-11-11 23:49:00 still gin index creation takes forever
Previous Message Glen Beane 2008-11-11 22:29:14 Re: Problem using COPY command to load data