X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=dak%2Fls.py;h=f4ae00af1db22549d0a1189a92fbe5d724289969;hb=731d594cc9032c1e889c90bc55092536c96e284c;hp=9f7b556681487a4a1fedfe916e37e78d03ede201;hpb=30413cf0ff7bc21b8d2b8b4346406357fe55dc19;p=dak.git diff --git a/dak/ls.py b/dak/ls.py index 9f7b5566..f4ae00af 100755 --- a/dak/ls.py +++ b/dak/ls.py @@ -1,9 +1,13 @@ #!/usr/bin/env python -# Display information about package(s) (suite, version, etc.) -# Copyright (C) 2000, 2001, 2002, 2003, 2004, 2005 James Troup -# $Id: madison,v 1.33 2005-11-15 09:50:32 ajt Exp $ +""" +Display information about package(s) (suite, version, etc.) +@contact: Debian FTP Master +@copyright: 2000, 2001, 2002, 2003, 2004, 2005, 2006 James Troup +@license: GNU General Public License version 2 or later + +""" # This program is free software; you can redistribute it and/or modify # it under the terms of the GNU General Public License as published by # the Free Software Foundation; either version 2 of the License, or @@ -27,19 +31,18 @@ ################################################################################ -import os, pg, sys -import utils, db_access +import os +import sys import apt_pkg -################################################################################ - -Cnf = None -projectB = None +from daklib.config import Config +from daklib.dbconn import * +from daklib import utils ################################################################################ def usage (exit_code=0): - print """Usage: madison [OPTION] PACKAGE[...] + print """Usage: dak ls [OPTION] PACKAGE[...] Display information about PACKAGE(s). -a, --architecture=ARCH only show info for ARCH(s) @@ -51,47 +54,45 @@ Display information about PACKAGE(s). -r, --regex treat PACKAGE as a regex -s, --suite=SUITE only show info for this suite -S, --source-and-binary show info for the binary children of source pkgs + -f, --format=control-suite use same format as control-suite for output ARCH, COMPONENT and SUITE can be comma (or space) separated lists, e.g. - --architecture=m68k,i386""" + --architecture=amd64,i386""" sys.exit(exit_code) ################################################################################ def main (): - global Cnf, projectB - - Cnf = utils.get_conf() - - Arguments = [('a', "architecture", "Madison::Options::Architecture", "HasArg"), - ('b', "binarytype", "Madison::Options::BinaryType", "HasArg"), - ('c', "component", "Madison::Options::Component", "HasArg"), - ('f', "format", "Madison::Options::Format", "HasArg"), - ('g', "greaterorequal", "Madison::Options::GreaterOrEqual"), - ('G', "greaterthan", "Madison::Options::GreaterThan"), - ('r', "regex", "Madison::Options::Regex"), - ('s', "suite", "Madison::Options::Suite", "HasArg"), - ('S', "source-and-binary", "Madison::Options::Source-And-Binary"), - ('h', "help", "Madison::Options::Help")] + cnf = Config() + + Arguments = [('a', "architecture", "Ls::Options::Architecture", "HasArg"), + ('b', "binarytype", "Ls::Options::BinaryType", "HasArg"), + ('c', "component", "Ls::Options::Component", "HasArg"), + ('f', "format", "Ls::Options::Format", "HasArg"), + ('g', "greaterorequal", "Ls::Options::GreaterOrEqual"), + ('G', "greaterthan", "Ls::Options::GreaterThan"), + ('r', "regex", "Ls::Options::Regex"), + ('s', "suite", "Ls::Options::Suite", "HasArg"), + ('S', "source-and-binary", "Ls::Options::Source-And-Binary"), + ('h', "help", "Ls::Options::Help")] for i in [ "architecture", "binarytype", "component", "format", "greaterorequal", "greaterthan", "regex", "suite", "source-and-binary", "help" ]: - if not Cnf.has_key("Madison::Options::%s" % (i)): - Cnf["Madison::Options::%s" % (i)] = "" + if not cnf.has_key("Ls::Options::%s" % (i)): + cnf["Ls::Options::%s" % (i)] = "" - packages = apt_pkg.ParseCommandLine(Cnf,Arguments,sys.argv) - Options = Cnf.SubTree("Madison::Options") + packages = apt_pkg.parse_commandline(cnf.Cnf, Arguments, sys.argv) + Options = cnf.subtree("Ls::Options") if Options["Help"]: usage() if not packages: utils.fubar("need at least one package name as an argument.") - projectB = pg.connect(Cnf["DB::Name"], Cnf["DB::Host"], int(Cnf["DB::Port"])) - db_access.init(Cnf, projectB) + session = DBConn().session() # If cron.daily is running; warn the user that our output might seem strange - if os.path.exists(os.path.join(Cnf["Dir::Root"], "Archive_Maintenance_In_Progress")): + if os.path.exists(os.path.join(cnf["Dir::Lock"], "daily.lock")): utils.warn("Archive maintenance is in progress; database inconsistencies are possible.") # Handle buildd maintenance helper options @@ -123,33 +124,37 @@ def main (): if Options["Source-And-Binary"]: new_packages = [] for package in packages: - q = projectB.query("SELECT DISTINCT b.package FROM binaries b, bin_associations ba, suite su, source s WHERE b.source = s.id AND su.id = ba.suite AND b.id = ba.bin AND s.source %s '%s' %s" % (comparison_operator, package, con_suites)) - new_packages.extend(map(lambda x: x[0], q.getresult())) + q = session.execute("SELECT DISTINCT b.package FROM binaries b, bin_associations ba, suite su, source s WHERE b.source = s.id AND su.id = ba.suite AND b.id = ba.bin AND s.source %s :package %s" % (comparison_operator, con_suites), + {'package': package}) + new_packages.extend([ i[0] for i in q.fetchall() ]) if package not in new_packages: new_packages.append(package) packages = new_packages results = 0 for package in packages: - q = projectB.query(""" + q = session.execute(""" SELECT b.package, b.version, a.arch_string, su.suite_name, c.name, m.name FROM binaries b, architecture a, suite su, bin_associations ba, - files f, location l, component c, maintainer m - WHERE b.package %s '%s' AND a.id = b.architecture AND su.id = ba.suite - AND b.id = ba.bin AND b.file = f.id AND f.location = l.id - AND l.component = c.id AND b.maintainer = m.id %s %s %s -""" % (comparison_operator, package, con_suites, con_architectures, con_bintype)) - ql = q.getresult() + files f, files_archive_map af, component c, maintainer m + WHERE b.package %s :package AND a.id = b.architecture AND su.id = ba.suite + AND b.id = ba.bin AND b.file = f.id AND af.file_id = f.id AND su.archive_id = af.archive_id + AND af.component_id = c.id AND b.maintainer = m.id %s %s %s +""" % (comparison_operator, con_suites, con_architectures, con_bintype), {'package': package}) + ql = q.fetchall() if check_source: - q = projectB.query(""" + q = session.execute(""" SELECT s.source, s.version, 'source', su.suite_name, c.name, m.name - FROM source s, suite su, src_associations sa, files f, location l, + FROM source s, suite su, src_associations sa, files f, files_archive_map af, component c, maintainer m - WHERE s.source %s '%s' AND su.id = sa.suite AND s.id = sa.source - AND s.file = f.id AND f.location = l.id AND l.component = c.id + WHERE s.source %s :package AND su.id = sa.suite AND s.id = sa.source + AND s.file = f.id AND af.file_id = f.id AND af.archive_id = su.archive_id AND af.component_id = c.id AND s.maintainer = m.id %s -""" % (comparison_operator, package, con_suites)) - ql.extend(q.getresult()) +""" % (comparison_operator, con_suites), {'package': package}) + if not Options["Architecture"] or con_architectures: + ql.extend(q.fetchall()) + else: + ql = q.fetchall() d = {} highver = {} for i in ql: @@ -162,7 +167,7 @@ SELECT s.source, s.version, 'source', su.suite_name, c.name, m.name highver.setdefault(pkg,"") if not d[pkg].has_key(version): d[pkg][version] = {} - if apt_pkg.VersionCompare(version, highver[pkg]) > 0: + if apt_pkg.version_compare(version, highver[pkg]) > 0: highver[pkg] = version if not d[pkg][version].has_key(suite): d[pkg][version][suite] = [] @@ -170,9 +175,22 @@ SELECT s.source, s.version, 'source', su.suite_name, c.name, m.name packages = d.keys() packages.sort() + + # Calculate optimal column sizes + sizes = [10, 13, 10] for pkg in packages: versions = d[pkg].keys() - versions.sort(apt_pkg.VersionCompare) + for version in versions: + suites = d[pkg][version].keys() + for suite in suites: + sizes[0] = max(sizes[0], len(pkg)) + sizes[1] = max(sizes[1], len(version)) + sizes[2] = max(sizes[2], len(suite)) + fmt = "%%%is | %%%is | %%%is | " % tuple(sizes) + + for pkg in packages: + versions = d[pkg].keys() + versions.sort(apt_pkg.version_compare) for version in versions: suites = d[pkg][version].keys() suites.sort() @@ -180,10 +198,10 @@ SELECT s.source, s.version, 'source', su.suite_name, c.name, m.name arches = d[pkg][version][suite] arches.sort(utils.arch_compare_sw) if Options["Format"] == "": #normal - sys.stdout.write("%10s | %10s | %13s | " % (pkg, version, suite)) + sys.stdout.write(fmt % (pkg, version, suite)) sys.stdout.write(", ".join(arches)) sys.stdout.write('\n') - elif Options["Format"] == "heidi": + elif Options["Format"] in [ "control-suite", "heidi" ]: for arch in arches: sys.stdout.write("%s %s %s\n" % (pkg, version, arch)) if Options["GreaterOrEqual"]: @@ -198,4 +216,3 @@ SELECT s.source, s.version, 'source', su.suite_name, c.name, m.name if __name__ == '__main__': main() -