Refactor query to list all packages

[pbs.git] / src / buildservice / packages.py

diff --git a/src/buildservice/packages.py b/src/buildservice/packages.py
index 47dc251326f95b82332e99da03933c9650de327e..e960558e24516d14e71968d97c8e85e582c066ff 100644 (file)
--- a/src/buildservice/packages.py
+++ b/src/buildservice/packages.py
@@ -35,6 +35,17 @@ class Packages(base.Object):
                return self._get_package("SELECT * FROM packages \
                        WHERE id = %s", pkg_id)
 
+       def get_list(self):
+               """
+                       Returns a list with all package names and the summary line
+                       that have at one time been part of the distribution
+               """
+               res = self.db.query("SELECT DISTINCT packages.name AS name, packages.summary AS summary FROM builds \
+                       LEFT JOIN packages ON builds.pkg_id = packages.id \
+                       WHERE builds.type = %s AND builds.state != %s", "release", "obsolete")
+
+               return res
+
        def get_all_names(self, user=None, states=None):
                query = "SELECT DISTINCT packages.name AS name, summary FROM packages \
                        JOIN builds ON builds.pkg_id = packages.id \