- q = projectB.query("SELECT s.source, s.version, m.name FROM src_associations sa, source s, suite su, maintainer m WHERE su.suite_name = '%s' AND sa.suite = su.id AND sa.source = s.id AND m.id = s.maintainer" % (suite))
- sources = q.getresult();
- for source in sources:
- package = source[0];
- version = source[1];
- maintainer = fix_maintainer(source[2]);
- if packages.has_key(package):
- if packages[package]["priority"] <= suite_priority:
- if apt_pkg.VersionCompare(packages[package]["version"], version) < 0:
- packages[package] = { "maintainer": maintainer, "priority": suite_priority, "version": version };
+ if gen_uploaders:
+ q = session.execute("""SELECT s.source, s.version, m.name
+ FROM src_associations sa, source s, suite su, maintainer m, src_uploaders srcu
+ WHERE su.suite_name = :suite_name
+ AND sa.suite = su.id AND sa.source = s.id
+ AND m.id = srcu.maintainer
+ AND srcu.source = s.id""",
+ {'suite_name': suite})
+ else:
+ q = session.execute("""SELECT s.source, s.version, m.name
+ FROM src_associations sa, source s, suite su, maintainer m
+ WHERE su.suite_name = :suite_name
+ AND sa.suite = su.id AND sa.source = s.id
+ AND m.id = s.maintainer""",
+ {'suite_name': suite})
+
+ for source in q.fetchall():
+ package = source[0]
+ version = source[1]
+ maintainer = fix_maintainer(source[2])
+ if gen_uploaders:
+ key = (package, maintainer)
+ else:
+ key = package
+
+ if packages.has_key(key):
+ if packages[key]["priority"] <= suite_priority:
+ if apt_pkg.VersionCompare(packages[key]["version"], version) < 0:
+ packages[key] = { "maintainer": maintainer, "priority": suite_priority, "version": version }