Thread: 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
atutorial 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-compatibleoutput: 

/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.

Regards

 

---

From: Craig Ringer <ringerc@ringerc.id.au>
To: salah jubeh <s_jubeh@yahoo.com>
Cc: pgsql <pgsql-general@postgresql.org>
Sent: Thursday, September 15, 2011 8:33 AM
Subject: Re: [GENERAL] 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