Jenkins

On 09/13/2011 07:28 PM, salah jubeh wrote:

Hello.

This might be the wrong place to post my question, but any help is
appreciated.

Did any one used Jenkins for Postgresql unit testing, and what are the
available unit testing plug-ins?, is there is a tutorial for that ?
Thanks in advance

I'm not aware of any significant use of Jenkins with Pg, though I'm sure
plenty of Java apps that use Pg via PgJDBC test against it using JUnit .
That might be your best bet for now, as AFAIK there aren't any dedicated
Pg-specific JUnit plugins.

What sorts of things do you want to test, anyway?

--
Craig Ringer

On 13/09/11 21:28, salah jubeh wrote:

Hello.

This might be the wrong place to post my question, but any help is
appreciated.

Did any one used Jenkins for Postgresql unit testing, and what are the
available unit testing plug-ins?, is there is a tutorial for that ?

It's not integrated into jenkins but pgTAP has been around for a while:

http://pgtap.org/

--
Postgresql & php tutorials
http://www.designmagick.com/

Il giorno 13/set/2011, alle ore 13:28, salah jubeh ha scritto:

Hello.

This might be the wrong place to post my question, but any help is appreciated.

Did any one used Jenkins for Postgresql unit testing, and what are the available unit testing plug-ins?, is there is a tutorial for that ?
Thanks in advance

Hi Salah,
I use pg_prove, which comes with pgTAP, on a shell script, combined with the TAP formatter in order to produce a JUnit-compatible output:

/opt/local/bin/pg_prove \
-h postgres \
-U giorgio \
-d gmp \
-s tests \
-b /opt/local/bin/psql84 \
--runtests \
--formatter TAP::Formatter::JUnit > db_testreports.xml

Hope this helps

Ciao
--
Giorgio Valoti

On 15/09/2011 6:13 PM, salah jubeh wrote:

Hello Craig,

I would like to test the software requirement specification . There
are some tools such as pgTAP but I am not sure about it..

Please reply to the mailing list, not just to me directly.

If you're testing against a spec, you probably want to use JUnit and
Jenkins to test your application's behavior, including JUnit tests that
test your database access and related classes.

If you have stored functions, etc, that you want to test you can test
them via PgJDBC and JUnit.