# Convert Contents.gz files into Sleepycat db files for efficient usage of
# data
#
-# $Id$
-#
# Copyright (C) 2006 Jeroen van Wolffelaar <jeroen@wolffelaar.nl>
# 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
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
-# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
+# Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
use strict;
+use warnings;
use lib './lib';
+$| = 1;
+
+# Important, we want sorting and such to happen like in the C locale: binary,
+# without any fancy collation. FIXME: is this actually adequate?
+$ENV{"LC_ALL"} = 'C';
+
my $what = $ARGV[0] ? "head -10000|" : "";
+# More RAM vs more disk I/O tradeoff parameters, does not change
+# functionality. True will always use more RAM at the benefit of less
+# temporary files, and is adviced when possible
+my $SORT_REVERSE_CONCURRENTLY = 1;
+
+use English;
use DB_File;
use Storable;
+use File::Path;
+use Packages::CommonCode qw(:all);
use Packages::Config qw( $TOPDIR $DBDIR @ARCHIVES @SUITES @ARCHITECTURES );
&Packages::Config::init( './' );
-my %filenames = ();
-my @archives =( 'us'); #@ARCHIVES # NOT-IMPLEMENTED-YET
+my @archives = @ARCHIVES;
my @suites = @SUITES;
my @archs = @ARCHITECTURES;
-for my $archive (@archives) { for my $suite (@suites) { for my $arch (@archs) {
+$DBDIR .= "/contents";
+mkdirp( $DBDIR );
- my $filename = "$TOPDIR/archive/$archive/$suite/Contents-$arch.gz";
- my $db = "$DBDIR/packages_contents_${suite}_${arch}.db";
- next unless -f $filename;
- my $ftime = (stat $filename)[9];
- my $dbtime = (stat $db)[9];
- next unless $ftime > $dbtime;
- print "Reading $archive/$suite/$arch...\n";
+for my $suite (@suites) {
+ for my $arch (@archs) {
+ my $filelist_db = "$DBDIR/filelists_${suite}_${arch}.db";
+ my $dbtime = (stat $filelist_db)[9];
my %packages_contents = ();
my %packages_contents_nr = ();
my %packages_contents_lastword = ();
- my %contents_packages_reverse = ();
-
- open CONT, "zcat $filename|$what";
- while (<CONT>) {last if /^FILE/mo;}
- while (<CONT>) {
- my $data = "";
- my %data = ();
- chomp;
- print "Doing line $.\n" if $. % 10000 == 0;
- /^(.+?)\s+(\S+)$/o;
- my ($file, $value) = ($1, $2);
- $value =~ s#[^,/]+/##og;
- my @packages = split /,/, $value;
- for (@packages) {
+
+ my $extra = "";
+ $extra = "|sort" if $SORT_REVERSE_CONCURRENTLY;
+
+ open REVERSED, "$extra>$DBDIR/reverse.tmp"
+ or die "Failed to open output reverse file: $!";
+
+ my $changed = 0;
+ for my $archive (@archives) {
+
+ my $filename = "$TOPDIR/archive/$archive/$suite/Contents-$arch.gz";
+ next unless -f $filename;
+ # Note: ctime, because mtime is set back via rsync
+ my $ftime = (stat $filename)[10];
+ next if defined $dbtime and $dbtime > $ftime;
+ print "$archive/$suite/$arch needs update\n";
+ $changed++;
+ }
+ if ($changed) {
+ for my $archive (@archives) {
+
+ my $filename = "$TOPDIR/archive/$archive/$suite/Contents-$arch.gz";
+ next unless -f $filename;
+ print "Reading $archive/$suite/$arch...\n";
+
+ open CONT, "zcat $filename|$what"
+ or die $!;
+ while (<CONT>) { last if /^FILE/mo; }
+ if (eof(CONT)) { # no header found
+ close CONT; # explicit close to reset $.
+ open CONT, "zcat $filename|$what";
+ }
+ while (<CONT>) {
+ my $data = "";
+ my %data = ();
+ chomp;
+ print "Doing line ".($NR/1000)."k (out of approx 2.0M)\n"
+ if $NR % 250000 == 0;
+ /^(.+?)\s+(\S+)$/o;
+ my ($file, $value) = ($1, $2);
+ $value =~ s#[^,/]+/##og;
+ my @packages = split m/,/, $value;
+ for (@packages) {
$packages_contents_nr{$_}++;
my $lw = $packages_contents_lastword{$_} || "\0";
my $i=0;
$i = 255 if $i > 255;
$packages_contents{$_} .= pack "CC/a*", ($i, substr($file, $i));
$packages_contents_lastword{$_} = "$file\0";
+ }
+ # Searches are case-insensitive
+ (my $nocase = $file) =~ tr [A-Z] [a-z];
+ my $case = ($nocase eq $file) ? '-' : $file;
+
+ print REVERSED (reverse $nocase)."\0".$case."\0".
+ (join ":$arch\0", @packages).":$arch\n";
}
- # Searches are case-insensitive
- $file =~ tr [A-Z] [a-z];
- my $filename = $file;
- $filename =~ s,.*/,,;
- $filenames{$filename} = 1;
+ close CONT;
- $contents_packages_reverse{reverse $file} = join "\0", @packages;
- }
- my %contents_packages_reverse_db;
- tie %contents_packages_reverse_db, "DB_File", "$DBDIR/contents_packages_reverse_${suite}_${arch}.db.new",
- O_RDWR|O_CREAT, 0666, $DB_BTREE
- or die "Error creating DB: $!";
- while (my ($x, $y) = each(%contents_packages_reverse)) {
- $contents_packages_reverse_db{$x} = $y;
- }
- untie %contents_packages_reverse_db;
+ }
+ close REVERSED;
+
+ print "Sorting reverse list if needed\n";
+ system("cd $DBDIR && sort reverse.tmp > reverse.sorted &&".
+ " mv reverse.{sorted,tmp}") == 0
+ or die "Failed to sort reverse"
+ unless $SORT_REVERSE_CONCURRENTLY;
- my %packages_contents_db;
- tie %packages_contents_db, "DB_File", "$DBDIR/packages_contents_${suite}_${arch}.db.new",
- O_RDWR|O_CREAT, 0666, $DB_BTREE
+ print "Writing filelist db\n";
+ tie my %packages_contents_db, "DB_File", "$filelist_db.new",
+ O_RDWR|O_CREAT, 0666, $DB_BTREE
or die "Error creating DB: $!";
- while (my ($k, $v) = each(%packages_contents)) {
+ while (my ($k, $v) = each(%packages_contents)) {
$packages_contents_db{$k} = (pack "L", $packages_contents_nr{$k})
- . $v;
+ . $v;
+ }
+ untie %packages_contents_db;
+
+ rename("$DBDIR/reverse.tmp", "$DBDIR/reverse_${suite}_${arch}.txt");
+
+ activate($filelist_db);
+ #FIXME: hardcoded archs. (debports has no contrib/non-free)
+ if ($arch !~ m/^kfreebsd-.*$/) {
+ system("ln", "-sf", $filelist_db,
+ "$DBDIR/filelists_${suite}_all.db") == 0
+ or die "Oops";
+ }
+ }
+ }
+
+ my $go = 0;
+ my $suite_mtime = (stat "$DBDIR/reverse_$suite.db")[9];
+ for my $file (glob "$DBDIR/reverse_${suite}_*.txt") {
+ $go = 1 if not defined $suite_mtime
+ or $suite_mtime < (stat $file)[9];
+ }
+ next unless $go;
+
+ print "Merging reverse path lists for ${suite}...\n";
+
+ open MERGED, "-|", "sort -m $DBDIR/reverse_${suite}_*.txt"
+ or die "Failed to open merged list";
+ open FILENAMES, ">", "$DBDIR/filenames_$suite.txt.new"
+ or die "Failed to open filenames list";
+ tie my %reverse_path_db, "DB_File", "$DBDIR/reverse_${suite}.db.new",
+ O_RDWR|O_CREAT, 0666, $DB_BTREE
+ or die "Error creating DB: $!";
+
+ my $lastpath = my $lastcasepath = my $lastfile = "";
+ my %matches = ();
+ while (<MERGED>) {
+ print "Doing line ".($NR/1000000)."M (out of approx. 20M)\n"
+ if $NR % 1000000 == 0;
+ chomp;
+ my @line = split m/\0/o, $_;
+ my $revpath = shift @line;
+ my $casepath = shift @line;
+ if ($revpath ne $lastpath) {
+ # Wrap: Do useful stuff with this ($lastpath, @matches)
+ if ($lastpath ne "") {
+ my @matches;
+ while (my ($k, $v) = each %matches) {
+ push @matches, join("\0", $k, @$v);
+ }
+ $reverse_path_db{$lastpath} = join "\1", @matches;
+ %matches = ();
+ }
+ $lastpath =~ s,/.*,,o;
+ if ($lastfile ne $lastpath) {
+ $lastfile = $lastpath;
+ print FILENAMES (reverse $lastfile)."\n";
+ }
+ #
+ $lastpath = $revpath;
+ $lastcasepath = $casepath;
+ $matches{$casepath} = \@line;
+ next;
+# } elsif ($lastcasepath ne "" and $casepath ne $lastcasepath) {
+# warn reverse($revpath)." has more than one casepath: $casepath $lastcasepath\n";
+ }
+ push @{$matches{$casepath}}, @line;
+ }
+ # Note: do useful stuff here too, for out last entry. Maybe prevent this by
+ # adding a fake ultimate entry?
+ {
+ my @matches;
+ while (my ($k, $v) = each %matches) {
+ push @matches, join("\0", $k, @$v);
}
- untie %packages_contents_db;
-}}}
+ $reverse_path_db{$lastpath} = join "\1", @matches;
+ }
-print "Writing databases...\n";
+ untie %reverse_path_db;
+ close FILENAMES;
+ close MERGED;
-# FIXME: missing filenames due to optimising above. Need to store filenames
-# per-suite/arch, but merge them in the end for better cached searching
-open FILENAMES, "> $DBDIR/filenames.txt.new";
-for (keys %filenames) {
- print FILENAMES "$_\n";
+ activate("$DBDIR/filenames_$suite.txt");
+ activate("$DBDIR/reverse_$suite.db");
}
-close FILENAMES;
-rename("$DBDIR/filenames.txt.new", "$DBDIR/filenames.txt");
-for my $archive (@archives) { for my $suite (@suites) { for my $arch (@archs) {
- rename("$DBDIR/packages_contents_${suite}_${arch}.db.new", "$DBDIR/packages_contents_${suite}_${arch}.db");
- rename("$DBDIR/contents_packages_reverse_${suite}_${arch}.db.new", "$DBDIR/contents_packages_reverse_${suite}_${arch}.db");
-}}}
+# vim: set ts=4