Requirements

WatchCub database should store results from exected tests. Every test finishes with some result code (needed to figure out possible dependancies) and some additional plugin-specific details. Database should store start and finish time of tests. For every test the list of test params should be stored in order to identify the tests and their results after execution has finished.

Database Diagram

 

 

Tables

config_params

Stores (name, value) couples, given as params to tests executed by the framework

 

Field	Type	Null	Key	Default	Extra
id	int(11)		PRI	NULL	auto_increment
name	varchar(100)		MUL
value	varchar(255)	YES		NULL

 

test_definitions

Stores test definitions as defined in the configuration file

Field	Type	Null	Key	Default	Extra
id	int(11)		PRI	NULL	auto_increment
name	varchar(100)		UNI	NULL

 

test_params

Defines many-to-many relation of the test_definitions and config_params tables

 

Field	Type	Null	Key	Default	Extra
test_id	int(11)		PRI	0
param_id	int(11)		PRI	0

 

test_results

Stores results from test execution

 

Field	Type	Null	Key	Default	Extra
id	int(11)		PRI	NULL	auto_increment
test_definition_id	int(11)		MUL	0
time_start	datetime	YES	MUL	NULL
time_finish	datetime	YES		NULL
result	decimal(10,2)	YES	MUL	NULL
notes	text	YES	MUL	NULL