Re: [new] databases/pgtap (and databases/p5-TAP-Parser-SourceHandler-pgTAP dep)

On Sat, May 23, 2020 at 10:46:00AM +0200, Landry Breuil wrote:
> Hi,
>
> here are two new ports, one for pgtap (https://pgtap.org/) and one for
> TAP::Parser::SourceHandler::pgTAP which provides the pg_prove script,
> used to run the regress tests for the upcoming 3.0.0 version of
> geo/pgrouting.
>
> pgtap is a postgresql extension to run regress tests using the TAP framework.
>
> thanks to the nice testing bits from postgresql.port.mk, i can easily
> run the pgtap tests themselves, and only some of them fail due to
> user/ownership issues that i think cant be worked around on OpenBSD,
> since we run build bits with fixed users (be it with PORTS_PRIVSEP or
> not):
>
> # Failed test 1: "db_owner_is(db, user, desc) should pass"
> # have: false
> # want: true
> # Failed test 3: "db_owner_is(db, user, desc) should have the proper diagnostics"
> # have: have: landry
> # want: postgres
> # want:
> # Failed test 4: "db_owner_is(db, user) should pass"
> # have: false
> # want: true
> # Failed test 6: "db_owner_is(db, user) should have the proper diagnostics"
> # have: have: landry
> # want: postgres
> # want:
> # Failed test 12: "db_owner_is(db, non-user) should have the proper diagnostics"
> # have: have: landry
> # want: __not__postgres
> # want: have: postgres
> # want: __not__postgres
> # Looks like you failed 5 tests of 411
> Failed 5/411 subtests
>
> looking for feedback from the pgsql wizards (or perl wizards even!) and oks to
> import.

Anyone ? Would like to move forward with pgrouting 3.0, and those two ports
will allow me fixing regress tests. And pgtap could be used by other pg*
ports..

Landry