Changeset 86985 in vbox

Timestamp:

Nov 26, 2020 1:57:42 PM (4 years ago)

Author:

vboxsync

Message:

testmanager/partial-db-dump.py: Do partial dump of the Builds table to reduce backup size. bugref:9788

File:

• trunk/src/VBox/ValidationKit/testmanager/db/partial-db-dump.py (modified) (4 diffs)

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

@@ -102 +102 @@
         'TestBoxesInSchedGroups',       # ?
         'SchedQueues',
-        'Builds',                       # ??
         'VcsRevisions',                 # ?
         'TestResultStrTab',             # 36K rows, never mind complicated then.
@@ -118 +117 @@
         'TestResultValues',             # 2016-05-25: ca. 3728 MB
         'TestResultFailures',
+        'Builds',
         'SystemLog',
     ];
@@ -184 +184 @@
         print('Last test result ID: %s' % (idLastTestResult,));
 
+        # Get the build ID range.
+        oDb.execute('SELECT MIN(idBuild), MIN(idBuildTestSuite) FROM TestSets WHERE idTestSet >= %s', (idFirstTestSet,));
+        idFirstBuild = 0;
+        if oDb.getRowCount() > 0:
+            idFirstBuild = min(oDb.fetchOne());
+        print('First build ID: %s' % (idFirstBuild,));
 
         # Tables with idTestSet member.
@@ -214 +220 @@
                            'COPY (SELECT * FROM ' + sTable + ' WHERE tsCreated >= %s) TO STDOUT WITH (FORMAT TEXT)',
                            (tsEffective,));
+
+        # The builds table.
+        for sTable in [ 'Builds', ]:
+            self._doCopyTo(sTable, oZipFile, oDb,
+                           'COPY (SELECT * FROM ' + sTable + ' WHERE idBuild >= %s) TO STDOUT WITH (FORMAT TEXT)',
+                           (idFirstBuild,));
 
         oZipFile.close();