Re: Jenkins

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