Hi all,
I've been working on an fpcunit listener that writes fpcunit test results to a database instead of an XML file: handy to be able to compare results between runs and detect regressions.
My aim was to make the code cross-database friendly (using portable SQL) and normalize the database so it can be used for a lot of test results (e.g. in Continuous Integration server kicked off by SVN commits).
I've been using it with a remote Firebird database server in my Jenkins CI server for the dbtestframework tests (see
http://wiki.lazarus.freepascal.org/Jenkins#FPCUnit.2FDBTestframework_tests_with_database_output)
By now, I think I've got the test listener code working well from a functional perspective and I'm now looking at improving performance without sacrificing storage size/normalization.
Any hints/tips on both the code and the Firebird DDL are very welcome. The code right now is a bit of a big chunk and could very well be simplified.
Code including database schema (for convenience, the code can autocreate and use a Firebird embedded database):
https://bitbucket.org/reiniero/testdbwriter/downloads (select tag:tip to download the latest code)
Thanks.