X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=tea;h=209e63a59020b574879605a6102713fc1fe3eb52;hb=6d72ae4bca15c0ed410798e62d3e367cf7abcdb6;hp=c8ca3ae647a1399bd2438cc2014a57e62df88cce;hpb=d282b550bd350fb493826d3a27f9dc92d4273162;p=dak.git diff --git a/tea b/tea index c8ca3ae6..209e63a5 100755 --- a/tea +++ b/tea @@ -1,8 +1,8 @@ #!/usr/bin/env python # Sanity check the database -# Copyright (C) 2000 James Troup -# $Id: tea,v 1.2 2001-01-10 06:00:12 troup Exp $ +# Copyright (C) 2000, 2001 James Troup +# $Id: tea,v 1.11 2001-06-22 22:53:14 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 @@ -25,7 +25,7 @@ ################################################################################ -import pg, sys, os +import pg, sys, os, string, stat import utils, db_access import apt_pkg; @@ -33,34 +33,177 @@ import apt_pkg; Cnf = None; projectB = None; +db_files = {}; +waste = 0.0; +excluded = {}; + +def process_dir (arg, dirname, filenames): + global waste, db_files, excluded; + + if string.find(dirname, '/disks-') != -1 or string.find(dirname, 'upgrade-') != -1: + return; + # hack; can't handle .changes files + if string.find(dirname, 'proposed-updates') != -1: + return; + for name in filenames: + filename = os.path.abspath(dirname+'/'+name); + filename = string.replace(filename, 'potato-proposed-updates', 'proposed-updates'); + if os.path.isfile(filename) and not os.path.islink(filename) and not db_files.has_key(filename) and not excluded.has_key(filename): + waste = waste + os.stat(filename)[stat.ST_SIZE]; + print filename +################################################################################ + +def check_files(): + global db_files; + + print "Building list of Database files..."; + + q = projectB.query("SELECT l.path, f.filename FROM files f, location l WHERE f.location = l.id") + ql = q.getresult(); + + db_files = {}; + for i in ql: + filename = os.path.abspath(i[0] + i[1]); + db_files[filename] = ""; + if os.access(filename, os.R_OK) == 0: + utils.warn("'%s' doesn't exist." % (filename)); + + file = utils.open_file(Cnf["Dir::OverrideDir"]+'override.unreferenced','r'); + for filename in file.readlines(): + filename = filename[:-1]; + excluded[filename] = ""; + + print "Checking against existent files..."; + + os.path.walk(Cnf["Dir::RootDir"]+'dists/', process_dir, None); + + print + print "%s wasted..." % (utils.size_type(waste)); + +################################################################################ + +def check_dscs(): + count = 0; + suite = 'unstable'; + for component in Cnf.SubTree("Component").List(): + if component == "mixed": + continue; + component = string.lower(component); + list_filename = '%s%s_%s_source.list' % (Cnf["Dir::ListsDir"], suite, component); + list_file = utils.open_file(list_filename, 'r'); + for line in list_file.readlines(): + file = line[:-1]; + try: + utils.parse_changes(file, 1); + except utils.invalid_dsc_format_exc, line: + utils.warn("syntax error in .dsc file '%s', line %s." % (file, line)); + count = count + 1; + + if count: + utils.warn("Found %s invalid .dsc files." % (count)); + +################################################################################ + +def check_override(): + for suite in [ "stable", "unstable" ]: + print suite + print "-------------" + print + suite_id = db_access.get_suite_id(suite); + q = projectB.query(""" +SELECT DISTINCT b.package FROM binaries b, bin_associations ba + WHERE b.id = ba.bin AND ba.suite = %s AND NOT EXISTS + (SELECT * FROM override o WHERE o.suite = %s AND o.package = b.package)""" + % (suite_id, suite_id)); + print q + q = projectB.query(""" +SELECT DISTINCT s.source FROM source s, src_associations sa + WHERE s.id = sa.source AND sa.suite = %s AND NOT EXISTS + (SELECT * FROM override o WHERE o.suite = %s and o.package = s.source)""" + % (suite_id, suite_id)); + print q + +################################################################################ + +# Ensure that the source files for any given package is all in one +# directory so that 'apt-get source' works... + +def check_source_in_one_dir(): + # Not the most enterprising method, but hey... + broken_count = 0; + q = projectB.query("SELECT id FROM source;"); + for i in q.getresult(): + source_id = i[0]; + q2 = projectB.query(""" +SELECT l.path, f.filename FROM files f, dsc_files df, location l WHERE df.source = %s AND f.id = df.file AND l.id = f.location""" + % (source_id)); + first_path = ""; + first_filename = ""; + broken = 0; + for j in q2.getresult(): + filename = j[0]+j[1]; + path = os.path.dirname(filename); + if first_path == "": + first_path = path; + first_filename = filename; + elif first_path != path: + symlink = path + '/' + os.path.basename(first_filename); + if not os.path.exists(symlink): + broken = 1; + print "WOAH, we got a live one here... %s [%s] {%s}" % (filename, source_id, symlink); + if broken: + broken_count = broken_count + 1; + print "Found %d source packages where the source is not all in one directory." % (broken_count); + +################################################################################ + +def check_md5sums(): + print "Getting file information from database..."; + q = projectB.query("SELECT l.path, f.filename, f.md5sum, f.size FROM files f, location l WHERE f.location = l.id") + ql = q.getresult(); + + print "Checking file md5sums & sizes..."; + for i in ql: + filename = os.path.abspath(i[0] + i[1]); + db_md5sum = i[2]; + db_size = int(i[3]); + try: + file = utils.open_file(filename, 'r'); + except: + utils.warn("can't open '%s'." % (filename)); + continue; + md5sum = apt_pkg.md5sum(file); + size = os.stat(filename)[stat.ST_SIZE]; + if md5sum != db_md5sum: + utils.warn("**WARNING** md5sum mismatch for '%s' ('%s' [current] vs. '%s' [db])." % (filename, md5sum, db_md5sum)); + if size != db_size: + utils.warn("**WARNING** size mismatch for '%s' ('%s' [current] vs. '%s' [db])." % (filename, size, db_size)); + + print "Done." ################################################################################ def main (): - global Cnf, projectB; + global Cnf, projectB, db_files, waste, excluded; apt_pkg.init(); Cnf = apt_pkg.newConfiguration(); apt_pkg.ReadConfigFileISC(Cnf,utils.which_conf_file()); - Arguments = [('d',"debug","Claire::Options::Debug", "IntVal"), - ('h',"help","Claire::Options::Help"), - ('v',"version","Claire::Options::Version")]; + Arguments = [('d',"debug","Tea::Options::Debug", "IntVal"), + ('h',"help","Tea::Options::Help"), + ('v',"version","Tea::Options::Version")]; apt_pkg.ParseCommandLine(Cnf,Arguments,sys.argv); - - projectB = pg.connect('projectb', 'localhost'); - + projectB = pg.connect(Cnf["DB::Name"], Cnf["DB::Host"], int(Cnf["DB::Port"])); db_access.init(Cnf, projectB); - - q = projectB.query("SELECT l.path, f.filename FROM files f, location l WHERE f.location = l.id") - ql = q.getresult(); - - for i in ql: - filename = i[0] + i[1]; - if os.access(filename, os.R_OK) == 0: - print filename + + #check_md5sums(); + check_source_in_one_dir(); + #check_override(); + #check_dscs(); + #check_files(); #######################################################################################