Форум dkLab и Denwer
Здесь общаются Web-разработчики.
Генеральный спонсор:
Хостинг «Джино»

dkLab PGUnit: stored procedures unit-test framework for PostgreSQL 8.3 (Дмитрий Котеров)
Author Message
Дмитрий Котеров
Администратор



Joined: 10 Mar 2003
Posts: 13665
Карма: 413
   поощрить/наказать


PostPosted: Mon Nov 03, 2008 11:55 pm (написано за 30 секунд)
   Post subject: dkLab PGUnit: stored procedures unit-test framework for PostgreSQL 8.3
Reply with quote

English version: en.dklab.ru/lib/dklab_pgunit/
Russian version: dklab.ru/lib/dklab_pgunit/
Back to top
View user's profile Send private message Send e-mail
Дмитрий Котеров
Администратор



Joined: 10 Mar 2003
Posts: 13665
Карма: 413
   поощрить/наказать


PostPosted: Fri Nov 07, 2008 9:39 pm (спустя 3 дня 21 час 43 минуты; написано за 7 секунд)
   Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message Send e-mail
Дмитрий Котеров
Администратор



Joined: 10 Mar 2003
Posts: 13665
Карма: 413
   поощрить/наказать


PostPosted: Sun Nov 09, 2008 1:18 pm (спустя 1 день 15 часов 39 минут; написано за 7 секунд)
   Post subject:
Reply with quote

v. 2008-11-09
  - A little code simplification (undocumented "WHEN others THEN ..."
    instead of exception class enumeration).
Back to top
View user's profile Send private message Send e-mail
igor.katson
Guest





Карма: 388
   поощрить/наказать


PostPosted: Fri Jan 29, 2010 3:11 pm (спустя 1 год 2 месяца 20 дней 1 час 52 минуты; написано за 1 минуту 25 секунд)
   Post subject:
Reply with quote

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
Back to top
Дмитрий Котеров
Администратор



Joined: 10 Mar 2003
Posts: 13665
Карма: 413
   поощрить/наказать


PostPosted: Mon Feb 01, 2010 4:14 am (спустя 2 дня 13 часов 2 минуты; написано за 1 минуту 33 секунды)
   Post subject:
Reply with quote

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)
)
Back to top
View user's profile Send private message Send e-mail
sarahjones
Guest





Карма: 388
   поощрить/наказать


PostPosted: Wed Aug 15, 2018 3:24 am (спустя 8 лет 6 месяцев 13 дней 23 часа 10 минут; написано за 1 минуту 13 секунд)
   Post subject:
Reply with quote

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.
Back to top
Guest






Карма: 388
   поощрить/наказать


PostPosted: Wed Aug 15, 2018 3:26 am (спустя 1 минуту 48 секунд; написано за 26 секунд)
   Post subject:
Reply with quote

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
Back to top
Display posts from previous:   
Post new topic   Reply to topic All times are GMT + 3 Hours
Page 1 of 1    Email to a Friend.
Post a reply
Username
Subject
Господа спамеры и оптимизаторы!

Вы можете даже и не пытаться вставлять в текст поста ссылки - они все равно автоматически удаляются (вернее, тэги <a> заменяются на тэги <u>).

Но если не поверите и все же попытаетесь - как только увидите, что все безрезультатно, удалите свой пост, пожалуйста. Модераторы тоже люди, нехорошо, если они погрязнут в тоннах спама.
     

Disable BBCode in this post
Disable Smilies in this post
    HTML is OFF
BBCode is ON
Smilies are ON
You cannot post new topics in this forum. You can reply to topics in this forum. You cannot edit your posts in this forum. You cannot delete your posts in this forum. You cannot vote in polls in this forum. You cannot attach files in this forum. You can download files in this forum.
XML