How do I write tests in Perl with pgTAP?

Question

http://pgtap.org/integration.html#perl mentions how to run the tests, but I cannot find an example of a Perl test case.

Do I have to get a DBI connection manually, run my commands on it, and check the results? Does it even make sense to use Perl vs SQL code? Am I missing something?

score 1 · Accepted Answer · answered Dec 03 '14 at 22:10

1

pgTap is for parsing SQL output - output from running an SQL script via psql from the command line. An SQL script that contains pgTap SQL calls mixed in with the SQL statements that you wish to test.

As such, DBI doesn't enter into it.

answered Dec 03 '14 at 22:10

Len Jaffe

3,442
1
21
28

How do I write tests in Perl with pgTAP?

1 Answers1