help design a query interface for DStress' "bad apple" database

[Thomas Kuehne]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

DStress now stores unexpected testcase results along with compiler
messages and the offending source code in a MySQL database. What would
be the best query interface(s)?

The three tables are:
#
# Message(
#	id smallint(2),
#	message text
# )
#
# Testcase(
#	name char(40),
#	source blob,
#	id smallint(2),
#	type
#	enum('compile','complex','nocompile','norun','run','undefined')
# )
#
# Result (
#	testcase smallint(2) unsigned,
#	message smallint(2) unsigned,
#	result enum('FAIL','XPASS','ERROR'),
#	options enum('','-g','-inline','-fPIC', ... )
# )
#

Sample data can be found here: (167K)
http://dstress.kuehne.cn/raw_results/dmd-0.175.sql.gz 

The available tools are MySQL 4.1.21 and PHP4.

Thomas


-----BEGIN PGP SIGNATURE-----

iD8DBQFFcNt4LK5blCcjpWoRAqsNAJ9uisVpy76/cVAiHp6dQYRk4BPdhQCgkFzY
N5oGueiMhvMyq2kFQJq8xIY=
=8GNb
-----END PGP SIGNATURE-----