plpgsql unit testing and code coverage

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

čt 31. 12. 2020 v 13:21 odesílatel Joao Miguel Ferreira <
joao.miguel.c.ferreira@gmail.com> napsal:

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.

try to look on https://github.com/okbob/plpgsql_check

Regards

Pavel

Hi Philip and Pavel,

Thank you for your contributions. Both seem very interesting :) I will look
into it

Happy New Year
Cheers
jmf

On Thu, Dec 31, 2020 at 3:25 PM Pavel Stehule <pavel.stehule@gmail.com>
wrote: