Changeset 65040 in vbox for trunk/src/VBox/ValidationKit/testmanager/core/buildsource.py

Timestamp:

Dec 31, 2016 2:29:50 AM (8 years ago)

Author:

vboxsync

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

112535

Message:

testmanager: More details in the system wide changelog.

File:

• trunk/src/VBox/ValidationKit/testmanager/core/buildsource.py (modified) (2 diffs)

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

@@ -154 +154 @@
     Build source database logic.
     """
+
+    def __init__(self, oDb):
+        ModelLogicBase.__init__(self, oDb)
+        self.dCache = None;
 
     #
@@ -325 +329 @@
         return True;
 
+    def cachedLookup(self, idBuildSrc):
+        """
+        Looks up the most recent BuildSourceData object for idBuildSrc
+        via an object cache.
+
+        Returns a shared BuildSourceData object.  None if not found.
+        Raises exception on DB error.
+        """
+        if self.dCache is None:
+            self.dCache = self._oDb.getCache('BuildSourceData');
+        oEntry = self.dCache.get(idBuildSrc, None);
+        if oEntry is None:
+            self._oDb.execute('SELECT   *\n'
+                              'FROM     BuildSources\n'
+                              'WHERE    idBuildSrc = %s\n'
+                              '     AND tsExpire   = \'infinity\'::TIMESTAMP\n'
+                              , (idBuildSrc, ));
+            if self._oDb.getRowCount() == 0:
+                # Maybe it was deleted, try get the last entry.
+                self._oDb.execute('SELECT   *\n'
+                                  'FROM     BuildSources\n'
+                                  'WHERE    idBuildSrc = %s\n'
+                                  'ORDER BY tsExpire DESC\n'
+                                  'LIMIT 1\n'
+                                  , (idBuildSrc, ));
+            elif self._oDb.getRowCount() > 1:
+                raise self._oDb.integrityException('%s infinity rows for %s' % (self._oDb.getRowCount(), idBuildSrc));
+
+            if self._oDb.getRowCount() == 1:
+                aaoRow = self._oDb.fetchOne();
+                oEntry = BuildSourceData();
+                oEntry.initFromDbRow(aaoRow);
+                self.dCache[idBuildSrc] = oEntry;
+        return oEntry;
 
     #