Дмитрий Котеров
Администратор

Joined: 10 Mar 2003
Posts: 13665
Карма: 413 поощрить/наказать
|
Posted: Mon Nov 03, 2008 11:55 pm (написано за 30 секунд)
Post subject: dkLab PGUnit: stored procedures unit-test framework for PostgreSQL 8.3
|
|
English version: en.dklab.ru/lib/dklab_pgunit/
Russian version: dklab.ru/lib/dklab_pgunit/
|
|
Дмитрий Котеров
Администратор

Joined: 10 Mar 2003
Posts: 13665
Карма: 413 поощрить/наказать
|
Posted: Fri Nov 07, 2008 9:39 pm (спустя 3 дня 21 час 43 минуты; написано за 7 секунд)
Post subject:
|
|
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.
|
|
Дмитрий Котеров
Администратор

Joined: 10 Mar 2003
Posts: 13665
Карма: 413 поощрить/наказать
|
Posted: Sun Nov 09, 2008 1:18 pm (спустя 1 день 15 часов 39 минут; написано за 7 секунд)
Post subject:
|
|
v. 2008-11-09 - A little code simplification (undocumented "WHEN others THEN ..." instead of exception class enumeration).
|
|
igor.katson
Guest
Карма: 388 поощрить/наказать
|
Posted: Fri Jan 29, 2010 3:11 pm (спустя 1 год 2 месяца 20 дней 1 час 52 минуты; написано за 1 минуту 25 секунд)
Post subject:
|
|
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
|
|
Дмитрий Котеров
Администратор

Joined: 10 Mar 2003
Posts: 13665
Карма: 413 поощрить/наказать
|
Posted: Mon Feb 01, 2010 4:14 am (спустя 2 дня 13 часов 2 минуты; написано за 1 минуту 33 секунды)
Post subject:
|
|
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) )
|
|
sarahjones
Guest
Карма: 388 поощрить/наказать
|
Posted: Wed Aug 15, 2018 3:24 am (спустя 8 лет 6 месяцев 13 дней 23 часа 10 минут; написано за 1 минуту 13 секунд)
Post subject:
|
|
You can solve your problem by just one click on supportprop58.com/microsoft-office-support/ by getting a suggestion on how to stored procedures actually works and for what purpose it is being used.
|
|
Guest
Карма: 388 поощрить/наказать
|
Posted: Wed Aug 15, 2018 3:26 am (спустя 1 минуту 48 секунд; написано за 26 секунд)
Post subject:
|
|
You can solve your problem by just one click on [url]supportprop58.com/microsoft-office-support/[/url] by getting a recommendation on how to store it
|
|