- for suite in cnf.SubTree("Suite").List():
- suite = suite.lower()
- suite_priority = int(cnf["Suite::%s::Priority" % (suite)])
-
- # Source packages
- 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 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 }
- else:
- packages[package] = { "maintainer": maintainer, "priority": suite_priority, "version": version }
-
- # Binary packages
- q = session.execute("""SELECT b.package, b.source, b.maintainer, b.version
- FROM bin_associations ba, binaries b, suite s
- WHERE s.suite_name = :suite_name
- AND ba.suite = s.id AND ba.bin = b.id""",
- {'suite_name': suite})
- for binary in q.fetchall():
- package = binary[0]
- source_id = binary[1]
- version = binary[3]
- # Use the source maintainer first; falling back on the binary maintainer as a last resort only
- if source_id:
- maintainer = get_maintainer_from_source(source_id, session)
- else:
- maintainer = get_maintainer(binary[2], session)
- 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 }
- else:
- packages[package] = { "maintainer": maintainer, "priority": suite_priority, "version": version }
-
- # Process any additional Maintainer files (e.g. from pseudo packages)
+ archive = session.query(Archive).filter_by(archive_name=Options['Archive']).one()
+
+ # dictionary packages to maintainer names
+ maintainers = dict()
+ # dictionary packages to list of uploader names
+ uploaders = dict()
+
+ source_query = session.query(DBSource).from_statement('''
+ select distinct on (source.source) source.* from source
+ join src_associations sa on source.id = sa.source
+ join suite on sa.suite = suite.id
+ where suite.archive_id = :archive_id
+ order by source.source, source.version desc''') \
+ .params(archive_id=archive.archive_id)
+
+ binary_query = session.query(DBBinary).from_statement('''
+ select distinct on (binaries.package) binaries.* from binaries
+ join bin_associations ba on binaries.id = ba.bin
+ join suite on ba.suite = suite.id
+ where suite.archive_id = :archive_id
+ order by binaries.package, binaries.version desc''') \
+ .params(archive_id=archive.archive_id)
+
+ Logger.log(['sources'])
+ for source in source_query:
+ maintainers[source.source] = source.maintainer.name
+ uploaders[source.source] = uploader_list(source)
+
+ if not Options["Source"]:
+ Logger.log(['binaries'])
+ for binary in binary_query:
+ if binary.package not in maintainers:
+ maintainers[binary.package] = binary.maintainer.name
+ uploaders[binary.package] = uploader_list(binary.source)
+
+ Logger.log(['files'])
+ # Process any additional Maintainer files (e.g. from pseudo
+ # packages)