X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=daklib%2Fdatabase.py;h=1d9f3c0bc9bf052f638dff9be43a08a451ae6904;hb=f2a07f389ced773e2c2e97cc2075df3cf0f4ac43;hp=9185d0a3f54fd0c77e16df1e0dba623ebbc3bff6;hpb=92ed7fbd0802e5c0b4ab9d7efe57fea0e6cc8594;p=dak.git

diff --git a/daklib/database.py b/daklib/database.py
index 9185d0a3..1d9f3c0b 100755
--- 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())
+