Source

vpackager / src / vpackager / dbutils.py

Diff from to

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"""
Tip: Filter by directory path e.g. /media app.js to search for public/media/app.js.
Tip: Use camelCasing e.g. ProjME to search for ProjectModifiedEvent.java.
Tip: Filter by extension type e.g. /repo .js to search for all .js files in the /repo directory.
Tip: Separate your search with spaces e.g. /ssh pom.xml to search for src/ssh/pom.xml.
Tip: Use ↑ and ↓ arrow keys to navigate and return to view the file.
Tip: You can also navigate files with Ctrl+j (next) and Ctrl+k (previous) and view the file with Ctrl+o.
Tip: You can also navigate files with Alt+j (next) and Alt+k (previous) and view the file with Alt+o.