X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=tea;h=209e63a59020b574879605a6102713fc1fe3eb52;hb=fa8bfae9f3c67cd505958a910022c9d04ce5d004;hp=dc8aade08447ddd5d25896533c5b780fc14e5c94;hpb=4b41dc06229eed89f52f397fc7df5d665fa092cf;p=dak.git diff --git a/tea b/tea index dc8aade0..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.3 2001-01-16 21:52:37 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 @@ -51,24 +51,10 @@ def process_dir (arg, dirname, filenames): 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 main (): - 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","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'); - db_access.init(Cnf, projectB); +def check_files(): + global db_files; print "Building list of Database files..."; @@ -80,7 +66,7 @@ def main (): filename = os.path.abspath(i[0] + i[1]); db_files[filename] = ""; if os.access(filename, os.R_OK) == 0: - sys.stderr.write("W: '%s' doesn't exist.\n" % (filename)); + utils.warn("'%s' doesn't exist." % (filename)); file = utils.open_file(Cnf["Dir::OverrideDir"]+'override.unreferenced','r'); for filename in file.readlines(): @@ -94,6 +80,131 @@ def main (): 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, db_files, waste, excluded; + + apt_pkg.init(); + + Cnf = apt_pkg.newConfiguration(); + apt_pkg.ReadConfigFileISC(Cnf,utils.which_conf_file()); + + 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(Cnf["DB::Name"], Cnf["DB::Host"], int(Cnf["DB::Port"])); + db_access.init(Cnf, projectB); + + #check_md5sums(); + check_source_in_one_dir(); + #check_override(); + #check_dscs(); + #check_files(); + ####################################################################################### if __name__ == '__main__':