Re: plpgsql unit testing and code coverage - Mailing list pgsql-general

From Philip Semanchuk
Subject Re: plpgsql unit testing and code coverage
Date
Msg-id 722533B0-6E30-4B34-9D54-1F22F159A724@americanefficient.com
Whole thread Raw
In response to plpgsql unit testing and code coverage  (Joao Miguel Ferreira <joao.miguel.c.ferreira@gmail.com>)
List 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
implementedlogic. 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,
ifI 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


pgsql-general by date:

Previous
From: Joao Miguel Ferreira
Date:
Subject: plpgsql unit testing and code coverage
Next
From: Pavel Stehule
Date:
Subject: Re: plpgsql unit testing and code coverage