Changeset 64948 in vbox

Timestamp:

Dec 17, 2016 8:40:09 PM (8 years ago)

Author:

vboxsync

Message:

partial-db-dump.py: fix

Location:

trunk/src/VBox/ValidationKit/testmanager/db

Files:

• TestManagerDatabaseComments.pgsql (modified) (4 diffs)
• partial-db-dump.py (modified) (1 diff)

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

@@ -447 +447 @@
   'Test case scheduling priority.
 Higher number causes the test case to be run more frequently.
-@sa SchedGroupMembers.iSchedPriority
+@sa SchedGroupMembers.iSchedPriority, TestBoxesInSchedGroups.iSchedPriority
 @todo Not sure we want to keep this...';
 
@@ -543 +543 @@
 
 COMMENT ON COLUMN SchedGroupMembers.iSchedPriority IS
-  'The scheduling priority if the test group.
+  'The scheduling priority of the test group.
 Higher number causes the test case to be run more frequently.
-@sa TestGroupMembers.iSchedPriority';
+@sa TestGroupMembers.iSchedPriority, TestBoxesInSchedGroups.iSchedPriority';
 
 
@@ -716 +716 @@
 
 
+COMMENT ON TABLE TestBoxesInSchedGroups IS
+  'N:M relationship between test boxes and scheduling groups.
+
+We associate a priority with this relationship.
+
+@remarks This table stores history.  Never update or delete anything.  The
+         equivalent of deleting is done by setting the ''tsExpire'' field to
+         current_timestamp.  To select the currently valid entries use
+         tsExpire = TIMESTAMP WITH TIME ZONE ''infinity''.';
+
+
+COMMENT ON COLUMN TestBoxesInSchedGroups.tsEffective IS
+  'When this row starts taking effect (inclusive).';
+
+
+COMMENT ON COLUMN TestBoxesInSchedGroups.tsExpire IS
+  'When this row stops being tsEffective (exclusive).';
+
+
+COMMENT ON COLUMN TestBoxesInSchedGroups.uidAuthor IS
+  'The user id of the one who created/modified this entry.
+Non-unique foreign key: Users(uid)';
+
+
+COMMENT ON COLUMN TestBoxesInSchedGroups.iSchedPriority IS
+  'The scheduling priority of the scheduling group for the test box.
+Higher number causes the scheduling group to be serviced more frequently.
+@sa TestGroupMembers.iSchedPriority, SchedGroups.iSchedPriority';
+
+
 COMMENT ON TABLE FailureCategories IS
   'Failure categories.
@@ -1259 +1289 @@
 
 
+COMMENT ON COLUMN TestBoxStatuses.iWorkItem IS
+  'Interal work item number.
+This is used to pick and prioritize between multiple scheduling groups.';
+
+
 COMMENT ON TABLE GlobalResourceStatuses IS
   'Global resource status, tracks which test set resources are allocated by.

trunk/src/VBox/ValidationKit/testmanager/db/partial-db-dump.py

@@ -91 +91 @@
         'FailureReasons',
         'GlobalResources',
+        'TestBoxStrTab',
         'Testcases',
         'TestcaseArgs',