3 # Check for fixable discrepancies between stable and unstable
4 # Copyright (C) 2000 James Troup <james@nocrew.org>
5 # $Id: andrea,v 1.1 2001-02-12 03:29:52 troup Exp $
7 # This program is free software; you can redistribute it and/or modify
8 # it under the terms of the GNU General Public License as published by
9 # the Free Software Foundation; either version 2 of the License, or
10 # (at your option) any later version.
12 # This program is distributed in the hope that it will be useful,
13 # but WITHOUT ANY WARRANTY; without even the implied warranty of
14 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 # GNU General Public License for more details.
17 # You should have received a copy of the GNU General Public License
18 # along with this program; if not, write to the Free Software
19 # Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
22 ################################################################################
25 import utils, db_access
28 ################################################################################
33 ################################################################################
40 Cnf = apt_pkg.newConfiguration();
41 apt_pkg.ReadConfigFileISC(Cnf,utils.which_conf_file());
43 Arguments = [('D',"debug","Catherine::Options::Debug", "IntVal"),
44 ('h',"help","Catherine::Options::Help"),
45 ('V',"version","Catherine::Options::Version")]
47 apt_pkg.ParseCommandLine(Cnf,Arguments,sys.argv);
49 projectB = pg.connect('projectb', 'localhost');
50 db_access.init(Cnf, projectB);
53 dst_suite = "unstable";
55 src_suite_id = db_access.get_suite_id(src_suite);
56 dst_suite_id = db_access.get_suite_id(dst_suite);
57 arch_all_id = db_access.get_architecture_id("all");
58 dsc_type_id = db_access.get_override_type_id("dsc");
60 for arch in Cnf.SubTree("Suite::%s::Architectures" % (src_suite)).List():
64 # Arch: all doesn't work; consider packages which go from
65 # arch: all to arch: any, e.g. debconf... needs more checks
70 arch_id = db_access.get_architecture_id(arch);
71 q = projectB.query("""
72 SELECT b_src.package, b_src.version AS stable_version
73 FROM binaries b_src, bin_associations ba, override o
74 WHERE ba.bin = b_src.id AND ba.suite = %s AND b_src.architecture = %s
75 AND o.package = b_src.package AND o.suite = %s AND o.type != %s AND NOT EXISTS
76 (SELECT b_dst.id FROM bin_associations ba2, binaries b_dst
77 WHERE ba2.bin = b_dst.id AND b_dst.package = b_src.package
78 AND (b_dst.architecture = %s OR b_dst.architecture = %s)
79 AND ba2.suite = %s AND EXISTS
80 (SELECT b2.id FROM bin_associations ba3, binaries b2
81 WHERE ba3.bin = b2.id AND ba3.suite = %s AND b2.package = b_dst.package))
82 ORDER BY b_src.package;"""
83 % (src_suite_id, arch_id, dst_suite_id, dsc_type_id, arch_id, arch_all_id, dst_suite_id, dst_suite_id));
90 #######################################################################################
92 if __name__ == '__main__':