Обсуждение: plpgsql unit testing and code coverage
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
Thank you
Joao
> 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
č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
I'dd appreciate your feedbackThank youJoao
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:
č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_checkRegardsPavelI'dd appreciate your feedbackThank youJoao