- usage();
-
- projectB = pg.connect(Cnf["DB::Name"], Cnf["DB::Host"], int(Cnf["DB::Port"]));
- db_access.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 non-US or pseudo packages)
+ usage()
+
+ Logger = daklog.Logger(cnf.Cnf, 'make-maintainers')
+ session = DBConn().session()
+
+ # 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) * from source
+ order by source, version desc''')
+
+ binary_query = session.query(DBBinary).from_statement('''
+ select distinct on (package) * from binaries
+ order by package, version desc''')
+
+ 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)