On 05.12.2014 17:19, Tim Ward t...@telensa.com [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]