pass parameters properly

[dak.git] / dak / cruft_report.py

diff --git a/dak/cruft_report.py b/dak/cruft_report.py
index 538311496dd1b297efeeaf3abf801f0f58357429..af3a1125db7a8f6c7c44b1ceb73a3a1cdd310a9a 100755 (executable)
--- a/dak/cruft_report.py
+++ b/dak/cruft_report.py
@@ -65,7 +65,8 @@ def add_nbs(nbs_d, source, version, package, suite_id, session):
     else:
         q = session.execute("""SELECT b.id FROM binaries b, bin_associations ba
                                 WHERE ba.bin = b.id AND ba.suite = :suite_id
-                                  AND b.package = suite_id LIMIT 1""" % (suite_id, package))
+                                  AND b.package = :package LIMIT 1""" % {'suite_id': suite_id,
+                                                                         'package': package})
         if not q.fetchall():
             no_longer_in_suite[package] = ""
             return