Subject Re: [firebird-support] Unit testing for stored procedures?
Author Frank Schlottmann-Gödde
On 05.12.2014 17:19, Tim Ward tdw@... [firebird-support] wrote:
> Anyone done any of this?
> Testing a stored procedure involves
> - set up test data
> - run the procedure
> - check and report on results
> - any clean up needed (remove or restore output data, reset generators,
> ect ect)
> and setting this all up is somewhat non-trivial, but then so is manually
> checking the results of a procedure which can do quite complicated
> things to a dozen or more tables.
> So it would be nice to have a framework into which we could "just" drop
> "a few scripts" describing the input data, the expected output data, and
> the procedure(/query/script/whatever) to run. Does such a thing exist?

You may want to take a look at

It's a testing framework written in python, it contains also Delphi
source code for a test editing gui.


"Fascinating creatures, phoenixes, they can carry immensely heavy loads,
their tears have healing powers and they make highly faithful pets." -
J.K. Rowling

[Non-text portions of this message have been removed]