Source

vpackager / src / vpackager / dbutils.py

Diff from to

File src/vpackager/dbutils.py

         self.close()
         return ret
 
+    def FilterHistory(self, filter):
+        """ Filters the history to show only the items whose result matches
+        the filter"""
+        db, cursor = self._open()
+        if filter is "all":
+            self.close()
+            return self.notify(self.GetHistory(), group='history')
+        elif filter in ('success, Success, successful'):
+            sql = '''select id, app, ver, release, buildstart, buildend,
+            result from history where result="Success"'''
+        elif filter in ('failed', 'Failed'):
+            sql = ''' select id, app, ver, release, buildstart, buildend,
+            result from history where result="Failed"'''
+        else:
+            self.close()
+            return self.notify(self.GetHistory(), group='history')
+        cursor.execute(sql)
+        ret = cursor.fetchall()
+        self.close()
+        return self.notify(ret, group='history')
+
+
     def WipeHistory(self):
         """ Deletes the entire job history. Only use after confirming with the
         user"""