options cleanup

[dak.git] / andrea

diff --git a/andrea b/andrea
index 351c93747639f0bd65fce2f6cf3f67e7e55ca7ed..b678d9de3e08301722cb19d09bc70d7d30a988c5 100755 (executable)
--- a/andrea
+++ b/andrea
@@ -2,7 +2,7 @@
 
 # Check for fixable discrepancies between stable and unstable
 # Copyright (C) 2000, 2001  James Troup <james@nocrew.org>
-# $Id: andrea,v 1.3 2001-03-20 00:28:11 troup Exp $
+# $Id: andrea,v 1.4 2001-09-27 01:23:41 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
@@ -36,15 +36,11 @@ def main ():
     global Cnf, projectB;
 
     apt_pkg.init();
-    
+
     Cnf = apt_pkg.newConfiguration();
     apt_pkg.ReadConfigFileISC(Cnf,utils.which_conf_file());
 
-    Arguments = [('D',"debug","Catherine::Options::Debug", "IntVal"),
-                 ('h',"help","Catherine::Options::Help"),
-                 ('V',"version","Catherine::Options::Version")]
-
-    apt_pkg.ParseCommandLine(Cnf,Arguments,sys.argv);
+    apt_pkg.ParseCommandLine(Cnf,[],sys.argv);
 
     projectB = pg.connect(Cnf["DB::Name"], Cnf["DB::Host"], int(Cnf["DB::Port"]));
     db_access.init(Cnf, projectB);
@@ -73,12 +69,12 @@ SELECT b_src.package, b_src.version, a.arch_string
   FROM binaries b_src, bin_associations ba, override o, architecture a
   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 
-       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 
+        AND o.suite = %s AND o.type != %s AND NOT EXISTS
+    (SELECT b_dst.id 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
                   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));