X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=daklib%2Fdatabase.py;h=5c7bd8387240b328073b6641817afaa21aa8c768;hb=a10398019d83fb13fbe230c944ed51470a35df34;hp=9185d0a3f54fd0c77e16df1e0dba623ebbc3bff6;hpb=b5d21dfae245e479a1dfd261b7f1a9d9bf2e9b99;p=dak.git

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