X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=tea;h=209e63a59020b574879605a6102713fc1fe3eb52;hb=0e9d5d8e31062edf50725735424fd89563ffa5a4;hp=ff29e8d2cbf56c6e1418320bbf62763b3d8b1d52;hpb=a0b2b1aafec94c872ddcf2cd21dada1f0ab9240c;p=dak.git

diff --git a/tea b/tea
index ff29e8d2..209e63a5 100755
--- a/tea
+++ b/tea
@@ -1,8 +1,8 @@
 #!/usr/bin/env python
 
 # Sanity check the database
-# Copyright (C) 2000  James Troup <james@nocrew.org>
-# $Id: tea,v 1.4 2001-01-28 09:06:44 troup Exp $
+# Copyright (C) 2000, 2001  James Troup <james@nocrew.org>
+# $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
@@ -54,6 +54,7 @@ def process_dir (arg, dirname, filenames):
 ################################################################################
 
 def check_files():
+    global db_files;
 
     print "Building list of Database files...";
 
@@ -65,7 +66,7 @@ def check_files():
 	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():
@@ -95,11 +96,90 @@ def check_dscs():
             try:
                 utils.parse_changes(file, 1);
             except utils.invalid_dsc_format_exc, line:
-                sys.stderr.write("E: syntax error in .dsc file '%s', line %s.\n" % (file, line));
+                utils.warn("syntax error in .dsc file '%s', line %s." % (file, line));
                 count = count + 1;
 
     if count:
-        sys.stderr.write("Found %s invalid .dsc files.\n" % (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."
 
 ################################################################################
 
@@ -116,10 +196,13 @@ def main ():
                  ('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);
-
-    check_dscs();
+    
+    #check_md5sums();
+    check_source_in_one_dir();
+    #check_override();
+    #check_dscs();
     #check_files();
 
 #######################################################################################