- current = {};
- q = projectB.query("SELECT b.package, b.version, a.arch_string, ba.id FROM binaries b, bin_associations ba, architecture a WHERE ba.suite = %s AND ba.bin = b.id AND b.architecture = a.id" % (suite_id));
- ql = q.getresult();
- for i in ql:
- key = " ".join(i[:3]);
- current[key] = i[3];
- q = projectB.query("SELECT s.source, s.version, sa.id FROM source s, src_associations sa WHERE sa.suite = %s AND sa.source = s.id" % (suite_id));
- ql = q.getresult();
- for i in ql:
- key = " ".join(i[:2]) + " source";
- current[key] = i[2];
+ current = {}
+ q = session.execute("""SELECT b.package, b.version, a.arch_string, ba.id
+ FROM binaries b, bin_associations ba, architecture a
+ WHERE ba.suite = :suiteid
+ AND ba.bin = b.id AND b.architecture = a.id""", {'suiteid': suite_id})
+ for i in q.fetchall():
+ key = " ".join(i[:3])
+ current[key] = i[3]
+
+ q = session.execute("""SELECT s.source, s.version, sa.id
+ FROM source s, src_associations sa
+ WHERE sa.suite = :suiteid
+ AND sa.source = s.id""", {'suiteid': suite_id})
+ for i in q.fetchall():
+ key = " ".join(i[:2]) + " source"
+ current[key] = i[2]