Merge branch 'master' into security

[dak.git] / daklib / database.py

diff --git a/daklib/database.py b/daklib/database.py
index 9185d0a3f54fd0c77e16df1e0dba623ebbc3bff6..5c7bd8387240b328073b6641817afaa21aa8c768 100755 (executable)
--- a/daklib/database.py
+++ b/daklib/database.py
@@ -389,3 +389,11 @@ 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())