Changeset 61255 in vbox for trunk/src/VBox/ValidationKit/testmanager/db

Timestamp:

May 28, 2016 3:52:35 AM (9 years ago)

Author:

vboxsync

svn:sync-xref-src-repo-rev:

107547

Message:

testmanager: two database changes.

Location:

trunk/src/VBox/ValidationKit/testmanager/db

Files:

• TestManagerDatabaseInit.pgsql (modified) (6 diffs)
• tmdb-r16-testcaseargs-1-testresultfailures-1.pgsql (added)

trunk/src/VBox/ValidationKit/testmanager/db/TestManagerDatabaseInit.pgsql

@@ -402 +402 @@
     --- Number of testboxes required (gang scheduling).
     cGangMembers        SMALLINT    DEFAULT 1  NOT NULL  CHECK (cGangMembers > 0 AND cGangMembers < 1024),
+    --- Optional variation sub-name.
+    sSubName            TEXT        DEFAULT NULL,
 
     --- The arguments are part of the primary key for several reasons.
@@ -957 +959 @@
     -- Non-unique foreign key: Users(uid)
     uidAuthor           INTEGER     NOT NULL,
+    --- The testsest this result is a part of.
+    -- This is mainly an aid for bypassing the enormous TestResults table.
+    -- Note! This is a foreign key, but we have to add it after TestSets has
+    --       been created, see further down.
+    idTestSet           INTEGER     NOT NULL,
 
     --- The suggested failure reason.
@@ -966 +973 @@
     PRIMARY KEY (idTestResult, tsExpire)
 );
-
+CREATE INDEX TestResultFailureIdx  ON TestResultFailures (idTestSet, tsExpire DESC, tsEffective ASC);
+CREATE INDEX TestResultFailureIdx2 ON TestResultFailures (idTestResult, tsExpire DESC, tsEffective ASC);
+CREATE INDEX TestResultFailureIdx3 ON TestResultFailures (idFailureReason, idTestResult, tsExpire DESC, tsEffective ASC);
 
 
@@ -1309 +1318 @@
                OR (cErrors = 0 AND enmStatus IN ('running'::TestStatus_T, 'success'::TestStatus_T,
                                                  'skipped'::TestStatus_T, 'aborted'::TestStatus_T, 'bad-testbox'::TestStatus_T))
-              )
+              ),
+    -- The following is for the TestResultFailures foreign key.
+    -- Note! This was added with the name TestResults_idTestResult_idTestSet_key in the tmdb-r16 update script.
+    UNIQUE (idTestResult, idTestSet)
 );
 
@@ -1318 +1330 @@
 CREATE INDEX TestResultsNameIdx2 ON TestResults (idTestResult, idStrName);
 
-ALTER TABLE TestResultFailures
-    ADD CONSTRAINT idTestResultFk FOREIGN KEY (idTestResult) REFERENCES TestResults(idTestResult) MATCH FULL;
+ALTER TABLE TestResultFailures ADD CONSTRAINT TestResultFailures_idTestResult_idTestSet_fkey 
+    FOREIGN KEY (idTestResult, idTestSet) REFERENCES TestResults(idTestResult, idTestSet) MATCH FULL;
 
 
@@ -1557 +1569 @@
 ALTER TABLE TestResults      ADD FOREIGN KEY (idTestSet) REFERENCES TestSets(idTestSet) MATCH FULL;
 ALTER TABLE TestResultValues ADD FOREIGN KEY (idTestSet) REFERENCES TestSets(idTestSet) MATCH FULL;
+ALTER TABLE TestResultFailures ADD CONSTRAINT idTestSetFk FOREIGN KEY (idTestSet) REFERENCES TestSets(idTestSet) MATCH FULL;