3 # Output override files for apt-ftparchive and indices/
4 # Copyright (C) 2000, 2001 James Troup <james@nocrew.org>
5 # $Id: cindy,v 1.2 2001-03-02 02:46:02 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 # X-Listening-To: Sanitarium / Master of the Puppets - Metallica
24 ################################################################################
26 import pg, sys, string
27 import utils, db_access, natalie
30 ################################################################################
36 ################################################################################
38 def process(suite, component, type):
41 suite_id = db_access.get_suite_id(suite);
43 sys.stderr.write("Suite '%s' not recognised.\n" % (suite));
46 component_id = db_access.get_component_id(component);
47 if component_id == -1:
48 sys.stderr.write("Component '%s' not recognised.\n" % (component));
51 type_id = db_access.get_override_type_id(type);
53 sys.stderr.write("Type '%s' not recognised. (Valid types are deb, udeb and dsc.)\n" % (type));
55 dsc_type_id = db_access.get_override_type_id("dsc");
57 if type == "deb" or type == "udeb":
59 q = projectB.query("SELECT DISTINCT b.package FROM binaries b, bin_associations ba WHERE b.id = ba.bin AND ba.suite = %s" % (suite_id));
60 for i in q.getresult():
64 q = projectB.query("SELECT DISTINCT s.source FROM source s, src_associations sa WHERE s.id = sa.source AND sa.suite = %s" % (suite_id));
65 for i in q.getresult():
66 src_packages[i[0]] = "";
68 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));
69 projectB.query("BEGIN WORK");
70 for i in q.getresult():
72 if type == "deb" or type == "udeb":
73 if not packages.has_key(package):
74 if not src_packages.has_key(package):
75 print "DELETING: %s" % (package);
76 #projectB.query("DELETE FROM override WHERE package = '%s' AND suite = %s AND component = %s AND type = %s"
77 #% (package, suite_id, component_id, type_id));
79 print "MAKING SOURCE: %s" % (package);
80 #projectB.query("DELETE FROM override WHERE package = '%s' AND suite = %s AND component = %s AND type = %s"
81 #% (package, suite_id, component_id, type_id));
82 # Then if source doesn't already have a copy, insert it into source
83 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));
84 if q.getresult() == []:
85 #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]));
88 if not src_packages.has_key(package):
89 print "DELETING: %s" % (package);
90 #projectB.query("DELETE FROM override WHERE package = '%s' AND suite = %s AND component = %s AND type = %s"
91 #% (package, suite_id, component_id, type_id));
92 projectB.query("COMMIT WORK");
95 ################################################################################
98 global Cnf, projectB, override;
102 Cnf = apt_pkg.newConfiguration();
103 apt_pkg.ReadConfigFileISC(Cnf,utils.which_conf_file());
104 Arguments = [('D',"debug","Denise::Options::Debug", "IntVal"),
105 ('h',"help","Denise::Options::Help"),
106 ('V',"version","Denise::Options::Version")];
107 apt_pkg.ParseCommandLine(Cnf,Arguments,sys.argv);
109 projectB = pg.connect('projectb', 'localhost');
110 db_access.init(Cnf, projectB);
112 for suite in [ "stable", "unstable" ]:
113 sys.stderr.write("Processing %s...\n" % (suite));
114 for component in Cnf.SubTree("Component").List():
115 if component == "mixed":
117 for type in Cnf.SubTree("OverrideType").List():
118 print "Processing %s [%s - %s]..." % (suite, component, type);
119 process(suite, component, type);
121 #######################################################################################
123 if __name__ == '__main__':