+# 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);
+ 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."
+
+################################################################################
+#
+# Check all files for timestamps in the future; common from hardware
+# (e.g. alpha) which have far-future dates as their default dates.
+
+
+
+def Ent(Kind,Name,Link,Mode,UID,GID,Size,MTime,Major,Minor):
+ global future_files;
+
+ if MTime > current_time:
+ future_files[current_file] = MTime;
+ print "%s: %s '%s','%s',%u,%u,%u,%u,%u,%u,%u" % (current_file, Kind,Name,Link,Mode,UID,GID,Size, MTime, Major, Minor);
+
+def check_timestamps():
+ global current_file;
+
+ q = projectB.query("SELECT l.path, f.filename FROM files f, location l WHERE f.location = l.id AND f.filename ~ '.deb$'")
+ ql = q.getresult();
+ db_files.clear();
+ count = 0;
+ for i in ql:
+ filename = os.path.abspath(i[0] + i[1]);
+ if os.access(filename, os.R_OK):
+ file = utils.open_file(filename);
+ current_file = filename;
+ sys.stderr.write("Processing %s.\n" % (filename));
+ apt_inst.debExtract(file,Ent,"control.tar.gz");
+ file.seek(0);
+ apt_inst.debExtract(file,Ent,"data.tar.gz");
+ count = count + 1;
+ print "Checked %d files (out of %d)." % (count, len(db_files.keys()));
+
+################################################################################
+