- projectB = pg.connect(Cnf["DB::Name"], Cnf["DB::Host"], int(Cnf["DB::Port"]))
- daklib.database.init(Cnf, projectB)
-
- for suite in Cnf.SubTree("Suite").List():
- suite = suite.lower()
- suite_priority = int(Cnf["Suite::%s::Priority" % (suite)])
-
- # Source packages
- 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 }
- else:
- packages[package] = { "maintainer": maintainer, "priority": suite_priority, "version": version }
-
- # Binary packages
- q = projectB.query("SELECT b.package, b.source, b.maintainer, b.version FROM bin_associations ba, binaries b, suite s WHERE s.suite_name = '%s' AND ba.suite = s.id AND ba.bin = b.id" % (suite))
- binaries = q.getresult()
- for binary in binaries:
- 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)
- else:
- maintainer = get_maintainer(binary[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 }
-
- # Process any additional Maintainer files (e.g. from pseudo packages)
+ Logger = daklog.Logger('make-maintainers')
+ session = DBConn().session()
+
+ 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)
+
+ 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)