implement public access to deferred

[dak.git] / daklib / database.py

diff --git a/daklib/database.py b/daklib/database.py
index 9185d0a3f54fd0c77e16df1e0dba623ebbc3bff6..1d9f3c0bc9bf052f638dff9be43a08a451ae6904 100755 (executable)
--- a/daklib/database.py
+++ b/daklib/database.py
@@ -389,3 +389,12 @@ def get_maintainer (maintainer_id):
     return maintainer_cache[maintainer_id]
 
 ################################################################################
+
+def get_suites(pkgname, src=False):
+    if src:
+        sql = "select suite_name from source, src_associations,suite where source.id=src_associations.source and source.source='%s' and src_associations.suite = suite.id"%pkgname
+    else:
+        sql = "select suite_name from binaries, bin_associations,suite where binaries.id=bin_associations.bin and  package='%s' and bin_associations.suite = suite.id"%pkgname
+    q = projectB.query(sql)
+    return map(lambda x: x[0], q.getresult())
+