- projectB = pg.connect(Cnf["DB::Name"], Cnf["DB::Host"], int(Cnf["DB::Port"]))
- 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)