Changeset 97130 in vbox

Timestamp:

Oct 13, 2022 1:16:50 PM (3 years ago)

Author:

vboxsync

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

154102

Message:

Validation Kit/batch/quota.py: Simplified script by not being that generic anymore, addressed @todos. Tested locally on a partial DB dump + testset data. See ArchiveDelFilesBatchJob::init for configuration [forgot to commit the file].

File:

• trunk/src/VBox/ValidationKit/testmanager/core/testset.py (modified) (1 diff)

trunk/src/VBox/ValidationKit/testmanager/core/testset.py

@@ -721 +721 @@
         return aoRet;
 
+    def fetchByAge(self, tsNow = None, cHoursBack = 24):
+        """
+        Returns a list of TestSetData objects of a given time period (default is 24 hours).
+
+        Returns None if no testsets stored,
+        Returns an empty list if no testsets found with given criteria.
+        """
+        if tsNow is None:
+            tsNow = self._oDb.getCurrentTimestamp();
+
+        if self._oDb.getRowCount() == 0:
+            return None;
+
+        self._oDb.execute('(SELECT *\n'
+                    ' FROM   TestSets\n'
+                    ' WHERE  tsDone           <= %s\n'
+                    '    AND tsDone            > (%s - interval \'%s hours\')\n'
+                    ')\n'
+                    , ( tsNow, tsNow, cHoursBack, ));
+
+        aoRet = [];
+        for aoRow in self._oDb.fetchAll():
+            aoRet.append(TestSetData().initFromDbRow(aoRow));
+        return aoRet;
+
     def isTestBoxExecutingTooRapidly(self, idTestBox): ## s/To/Too/
         """