X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=andrea;h=ea0bbc21065dc7ef98bb3ddb1c93b5cc1892a71e;hb=f544f13b91fa2ebc2a5c91eb81098d93af639bfe;hp=be7e9b32f923652e9be9f7287b0bf32b0635c0e4;hpb=2f5e692bfbbb6f8146f50d944f7fcc169a95a0a3;p=dak.git

diff --git a/andrea b/andrea
index be7e9b32..ea0bbc21 100755
--- a/andrea
+++ b/andrea
@@ -1,8 +1,8 @@
 #!/usr/bin/env python
 
 # Check for fixable discrepancies between stable and unstable
-# Copyright (C) 2000, 2001  James Troup <james@nocrew.org>
-# $Id: andrea,v 1.5 2001-11-18 19:57:58 rmurray Exp $
+# Copyright (C) 2000, 2001, 2002, 2003  James Troup <james@nocrew.org>
+# $Id: andrea,v 1.10 2003-09-07 13:52:13 troup Exp $
 
 # 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
@@ -21,7 +21,7 @@
 
 ################################################################################
 
-import pg, string, sys;
+import pg, sys;
 import utils, db_access;
 import apt_pkg;
 
@@ -32,12 +32,29 @@ projectB = None;
 
 ################################################################################
 
+def usage(exit_code=0):
+    print """Usage: andrea
+Looks for fixable descrepancies between stable and unstable.
+
+  -h, --help                show this help and exit."""
+    sys.exit(exit_code)
+
+################################################################################
+
 def main ():
     global Cnf, projectB;
 
-    Cnf = utils.get_conf()
+    Cnf = utils.get_conf();
+    Arguments = [('h',"help","Andrea::Options::Help")];
+    for i in [ "help" ]:
+	if not Cnf.has_key("Andrea::Options::%s" % (i)):
+	    Cnf["Andrea::Options::%s" % (i)] = "";
+
+    apt_pkg.ParseCommandLine(Cnf, Arguments, sys.argv);
 
-    apt_pkg.ParseCommandLine(Cnf,[],sys.argv);
+    Options = Cnf.SubTree("Andrea::Options")
+    if Options["Help"]:
+	usage();
 
     projectB = pg.connect(Cnf["DB::Name"], Cnf["DB::Host"], int(Cnf["DB::Port"]));
     db_access.init(Cnf, projectB);
@@ -50,7 +67,7 @@ def main ():
     arch_all_id = db_access.get_architecture_id("all");
     dsc_type_id = db_access.get_override_type_id("dsc");
 
-    for arch in Cnf.SubTree("Suite::%s::Architectures" % (src_suite)).List():
+    for arch in Cnf.ValueList("Suite::%s::Architectures" % (src_suite)):
         if arch == "source":
             continue;
 
@@ -67,16 +84,16 @@ SELECT b_src.package, b_src.version, a.arch_string
   WHERE ba.bin = b_src.id AND ba.suite = %s AND b_src.architecture = %s
         AND a.id = b_src.architecture AND o.package = b_src.package
         AND o.suite = %s AND o.type != %s AND NOT EXISTS
-    (SELECT b_dst.id FROM bin_associations ba2, binaries b_dst
+    (SELECT 1 FROM bin_associations ba2, binaries b_dst
        WHERE ba2.bin = b_dst.id AND b_dst.package = b_src.package
              AND (b_dst.architecture = %s OR b_dst.architecture = %s)
              AND ba2.suite = %s AND EXISTS
-               (SELECT b2.id FROM bin_associations ba3, binaries b2
+               (SELECT 1 FROM bin_associations ba3, binaries b2
                   WHERE ba3.bin = b2.id AND ba3.suite = %s AND b2.package = b_dst.package))
 ORDER BY b_src.package;"""
                            % (src_suite_id, arch_id, dst_suite_id, dsc_type_id, arch_id, arch_all_id, dst_suite_id, dst_suite_id));
         for i in q.getresult():
-            print string.join(i, ' ');
+            print " ".join(i);
 
 #######################################################################################