#!/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.3 2001-03-20 00:28:11 troup Exp $
+# Copyright (C) 2000, 2001, 2002 James Troup <james@nocrew.org>
+# $Id: andrea,v 1.7 2002-05-14 15:28:53 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
def main ():
global Cnf, projectB;
- apt_pkg.init();
-
- Cnf = apt_pkg.newConfiguration();
- apt_pkg.ReadConfigFileISC(Cnf,utils.which_conf_file());
+ Cnf = utils.get_conf()
- 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);
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;
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));