persistent class %WebStress.Results.General
extends %Persistent, %XML.Adaptor
property CoolDownTime
as %String(TRUNCATE=1);
property Generator
as %String(TRUNCATE=1);
property PrepareTime
as %String(TRUNCATE=1);
property RecordTime
as %String(TRUNCATE=1);
property RunDescription
as %String(TRUNCATE=1);
property RunID
as %Integer;
property StoppedTime
as %String(TRUNCATE=1);
property StoppingTime
as %String(TRUNCATE=1);
property TestID
as %String(TRUNCATE=1);
property WarmUpTime
as %String(TRUNCATE=1);
query GetGenerators(testID As %String, runID As %Integer)
SQL Query
:
SELECT DISTINCT Generator,PrepareTime,WarmUpTime,RecordTime,CoolDownTime,StoppingTime,StoppedTime,RunDescription
FROM %WebStress_Results.General
WHERE TestID = :testID and RunID = :runID
ORDER BY Generator
query GetRuns(testID As %String)
SQL Query
:
SELECT DISTINCT RunID,Generator,PrepareTime,WarmUpTime,RecordTime,CoolDownTime,StoppingTime,StoppedTime,RunDescription
FROM %WebStress_Results.General
GROUP BY RunID
HAVING TestID = :testID
ORDER BY RunID DESC
query GetTests()
SQL Query
:
SELECT DISTINCT TestID,Tests.Name
FROM %WebStress_Results.General General, %WebStress.Tests Tests
WHERE General.TestID = Tests.ID
ORDER BY Tests.Name
index (Main on TestID,RunID,Generator) [IdKey,PrimaryKey,Unique];