Horton

Re: plpgsql unit testing and code coverage

Philip Semanchuk <philip@americanefficient.com>

View thread View on postgr.es
From: Philip Semanchuk <philip@americanefficient.com>
To: Joao Miguel Ferreira <joao.miguel.c.ferreira@gmail.com>
Cc: PostgreSQL General <pgsql-general@lists.postgresql.org>
Date: 2020-12-31T13:52:43Z
Lists: pgsql-general 

> On Dec 31, 2020, at 7:20 AM, Joao Miguel Ferreira <joao.miguel.c.ferreira@gmail.com> wrote:
> 
> Hello,
> 
> I'm a fan of unit testing and related matters but have used it only on client applications, not on database implemented logic. I recently joined a project whit dozens of PL functions and procedures.
> 
> So, it would be great for me to find a way to execute unit tests on those functions and procedures and, even better, if I can get code coverage results from it. I really enjoy approaching sw development with these tools.
> 
> I'dd appreciate your feedback

Hi Joao,
Are you familiar with pgTAP? (https://pgtap.org) It gives you some of what you want, but I don’t think it handles coverage.

Cheers
Philip