X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=daklib%2Fdbconn.py;h=8d5dd4b574068d84283050347342612600566747;hb=48b54c2373b0ef0b94cad4abba7ffb532bb1ce21;hp=2b2d01dfacb7bc72e9d409e754ea8185a23705c7;hpb=4a56fdf2e1d47805a766a13b1e1cb4a5568124fa;p=dak.git diff --git a/daklib/dbconn.py b/daklib/dbconn.py index 2b2d01df..8d5dd4b5 100644 --- a/daklib/dbconn.py +++ b/daklib/dbconn.py @@ -377,16 +377,16 @@ def get_binary_from_name_suite(package, suitename, session=None): sql = """SELECT DISTINCT(b.package), b.version, c.name, su.suite_name FROM binaries b, files fi, location l, component c, bin_associations ba, suite su - WHERE b.package=:package + WHERE b.package='%(package)s' AND b.file = fi.id AND fi.location = l.id AND l.component = c.id AND ba.bin=b.id AND ba.suite = su.id - AND su.suite_name=:suitename + AND su.suite_name %(suitename)s ORDER BY b.version DESC""" - return session.execute(sql, {'package': package, 'suitename': suitename}) + return session.execute(sql % {'package': package, 'suitename': suitename}) __all__.append('get_binary_from_name_suite')