dbTalk Databases Forums  

Unit testing plpgsql code

comp.databases.postgresql.general comp.databases.postgresql.general


Discuss Unit testing plpgsql code in the comp.databases.postgresql.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Casey Duncan
 
Posts: n/a

Default Unit testing plpgsql code - 11-20-2004 , 09:33 PM






Anyone know of a unit testing framework for plpgsql stored procedures?
We are about to convert a bunch of stored procedures from Oracle over
to Postgresql. We currently use the utPLSQL package to unit test
those, so something comparable to it would be optimal.

We'll probably roll our own if nothing currently exists, but I figured
it was worth it to ask first before reinventing the wheel.

TIA,

-Casey

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend


Reply With Quote
  #2  
Old   
Ben
 
Posts: n/a

Default Re: Unit testing plpgsql code - 11-21-2004 , 10:47 AM






I made something for one of my projects. I'm really not happy with it
(it borders on unmaintainable) but it does work and if you're desperate
I could share. But I wouldn't be unhappy if you rolled your own, so I
could use that.

On Nov 20, 2004, at 7:33 PM, Casey Duncan wrote:

Quote:
Anyone know of a unit testing framework for plpgsql stored procedures?
We are about to convert a bunch of stored procedures from Oracle over
to Postgresql. We currently use the utPLSQL package to unit test
those, so something comparable to it would be optimal.

We'll probably roll our own if nothing currently exists, but I figured
it was worth it to ask first before reinventing the wheel.

TIA,

-Casey

---------------------------(end of
broadcast)---------------------------
TIP 8: explain analyze is your friend

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.