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
<http://svn.code.sf.net/p/firebird/code/qa/fbtest/trunk/>

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

hth
fsg

--
"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]