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];
