here's a first idea on what the new schema might look like:
Release Table:
ReleaseID |
Package |
Version |
VersionLabel |
SystemTest Table:
SystemTestID |
ReleaseID |
Status |
Output |
StandardID |
TestName |
Result |
Events |
CPU |
MEM |
Metadata Table:
SystemTestID |
Histogram |
Label |
Value |
Threshold |
OutputFile Table:
SystemTestID |
Label |
Value |
Release Table contains an entry for each RM checked out package.
SystemTest table contains all the test done for a specific entry in Release Table
Metadata table contains all the metadata of a specific test in SystemTest
OutputFile contains the files written out for a specific SystemTest.
I'm not sure how the triggering of it will work. I am considering making it a script that's part of the RM set of scripts which get executed in order.