3 # Output override files for apt-ftparchive and indices/
4 # Copyright (C) 2000, 2001 James Troup <james@nocrew.org>
5 # $Id: cindy,v 1.6 2001-11-18 19:57:58 rmurray 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
21 ################################################################################
23 # X-Listening-To: Sanitarium / Master of the Puppets - Metallica
25 ################################################################################
27 import pg, sys, string
28 import utils, db_access, natalie
31 ################################################################################
37 ################################################################################
39 def process(suite, component, type):
42 suite_id = db_access.get_suite_id(suite);
44 utils.fubar("Suite '%s' not recognised." % (suite));
46 component_id = db_access.get_component_id(component);
47 if component_id == -1:
48 utils.fubar("Component '%s' not recognised." % (component));
50 type_id = db_access.get_override_type_id(type);
52 utils.fubar("Type '%s' not recognised. (Valid types are deb, udeb and dsc)" % (type));
53 dsc_type_id = db_access.get_override_type_id("dsc");
55 if type == "deb" or type == "udeb":
57 q = projectB.query("SELECT DISTINCT b.package FROM binaries b, bin_associations ba WHERE b.id = ba.bin AND ba.suite = %s" % (suite_id));
58 for i in q.getresult():
62 q = projectB.query("SELECT DISTINCT s.source FROM source s, src_associations sa WHERE s.id = sa.source AND sa.suite = %s" % (suite_id));
63 for i in q.getresult():
64 src_packages[i[0]] = "";
66 q = projectB.query("SELECT package, priority, section, maintainer FROM override WHERE suite = %s AND component = %s AND type = %s" % (suite_id, component_id, type_id));
67 projectB.query("BEGIN WORK");
68 for i in q.getresult():
70 if type == "deb" or type == "udeb":
71 if not packages.has_key(package):
72 if not src_packages.has_key(package):
73 print "DELETING: %s" % (package);
74 #projectB.query("DELETE FROM override WHERE package = '%s' AND suite = %s AND component = %s AND type = %s"
75 #% (package, suite_id, component_id, type_id));
77 print "MAKING SOURCE: %s" % (package);
78 #projectB.query("DELETE FROM override WHERE package = '%s' AND suite = %s AND component = %s AND type = %s"
79 #% (package, suite_id, component_id, type_id));
80 # Then if source doesn't already have a copy, insert it into source
81 q = projectB.query("SELECT package FROM override WHERE package = '%s' AND suite = %s AND component = %s AND type = %s" % (package, suite_id, component_id, dsc_type_id));
83 #projectB.query("INSERT INTO override (package, suite, component, priority, section, type, maintainer) VALUES ('%s', %s, %s, %s, %s, %s, '%s')" % (package, suite_id, component_id, i[1], i[2], dsc_type_id, i[3]));
86 if not src_packages.has_key(package):
87 print "DELETING: %s" % (package);
88 #projectB.query("DELETE FROM override WHERE package = '%s' AND suite = %s AND component = %s AND type = %s"
89 #% (package, suite_id, component_id, type_id));
90 projectB.query("COMMIT WORK");
93 ################################################################################
96 global Cnf, projectB, override;
98 Cnf = utils.get_conf()
99 Arguments = [('D',"debug","Denise::Options::Debug", "IntVal"),
100 ('h',"help","Denise::Options::Help"),
101 ('V',"version","Denise::Options::Version")];
102 apt_pkg.ParseCommandLine(Cnf,Arguments,sys.argv);
104 projectB = pg.connect(Cnf["DB::Name"], Cnf["DB::Host"], int(Cnf["DB::Port"]));
105 db_access.init(Cnf, projectB);
107 for suite in [ "stable", "unstable" ]:
108 print "Processing %s..." % (suite);
109 for component in Cnf.SubTree("Component").List():
110 if component == "mixed":
112 for type in Cnf.SubTree("OverrideType").List():
113 print "Processing %s [%s - %s]..." % (suite, component, type);
114 process(suite, component, type);
116 #######################################################################################
118 if __name__ == '__main__':