Форум dkLab и Denwer

[Дмитрий Котеров]

English version: en.dklab.ru/lib/dklab_pgunit/
Russian version: dklab.ru/lib/dklab_pgunit/

[Дмитрий Котеров]

v. 2008-11-07
  - Great speed-up while running a bunch of test with a single setUp block.
    In this case setUp is executed ONLY ONCE, and the effect of its
    execution is stored in a savepoint which is used for all
    individually-rollbacked tests. (All tests are still running
    independently and are not intersected with each other.)
  - Time measurnment of each test execution (thanks to Garrynja).
  - Supress NOTICEs generated by a setUp or test code to keep the
    execution log clean.

[Дмитрий Котеров]

v. 2008-11-09
  - A little code simplification (undocumented "WHEN others THEN ..."
    instead of exception class enumeration).

[igor.katson]

Is there a way to compare multicolumn result sets in pgunit.assert_same function?
I tried doing
PERFORM pgunit.assert_same(
SELECT array(SELECT * FROM ...),
SELECT array(SELECT * FROM ...)
)
but it throws an exception:
subquery must return only one column

[Дмитрий Котеров]

Try this:

PERFORM pgunit.assert_same(
    SELECT array(SELECT a FROM tbl_one a),
    SELECT array(SELECT a FROM tbl_two a)
)

or

PERFORM pgunit.assert_same(
    SELECT array(SELECT a FROM (SELECT * FROM tbl_one) a),
    SELECT array(SELECT a FROM (SELECT * FROM tbl_two) a)
)