debbugs-loadsql [options] [subcommand]
+ Subcommands:
+ bugs help versions configuration
+ suites logs packages debinfo
Options:
--quick, -q only load changed things
--progress Show progress bar
use vars qw($DEBUG);
use Debbugs::Common (qw(checkpid lockpid get_hashname getparsedaddrs getbugcomponent make_list getsourcemaintainers),
- qw(hash_slice));
+ qw(hash_slice open_compressed_file),);
use Debbugs::Config qw(:config);
use Debbugs::Status qw(read_bug split_status_fields);
use Debbugs::Log;
use IO::File;
use IO::Uncompress::AnyUncompress;
use Encode qw(decode_utf8);
+use List::MoreUtils qw(natatime);
my %options =
(debug => 0,
my %queue;
if ($opts->{preload}) {
-1 my @bugs;
+ my @bugs;
walk_bugs([(@{$argv}?@{$argv} : $initialdir)],
undef,
'summary',
undef,
sub {
- push @bugs,shift;
- });
+ push @bugs,@_;
+ },
+ 10000
+ );
$s->resultset('Bug')->quick_insert_bugs(@bugs);
}
walk_bugs([(@{$argv}?@{$argv} : $initialdir)],
'summary',
$verbose,
sub {
- my $bug = shift;
- my $stat = stat(getbugcomponent($bug,'summary',$initialdir));
- if (not defined $stat) {
+ my @bugs = @_;
+ my @bugs_to_update;
+ if ($options{quick}) {
+ for my $bug (@bugs) {
+ my $stat = stat(getbugcomponent($bug,'summary',$initialdir));
+ if (not defined $stat) {
print STDERR "Unable to stat $bug $!\n";
next;
+ }
+ my $rs = $s->resultset('Bug')->search({id=>$bug})->single();
+ next if defined $rs and $stat->mtime <= $rs->last_modified()->epoch();
+ push @bugs_to_update, $bug;
}
- if ($options{quick}) {
- my $rs = $s->resultset('Bug')->search({bug=>$bug})->single();
- next if defined $rs and $stat->mtime < $rs->last_modified()->epoch();
- }
- my $data = read_bug(bug => $bug,
- location => $initialdir);
- eval {
- load_bug(db => $s,
- data => split_status_fields($data),
- tags => \%tags,
- severities => \%severities,
- queue => \%queue);
- };
- if ($@) {
- use Data::Dumper;
- print STDERR Dumper($data) if $DEBUG;
- die "failure while trying to load bug $bug\n$@";
- }
- }
+ } else {
+ @bugs_to_update = @bugs;
+ }
+ eval {
+ $s->txn_do(sub {
+ for my $bug (@bugs_to_update) {
+ load_bug(db => $s,
+ bug => $bug,
+ tags => \%tags,
+ severities => \%severities,
+ queue => \%queue);
+ }
+ });
+ };
+ if ($@) {
+ die "failure while trying to load bug: $@";
+ }
+ },
+ 50
);
handle_load_bug_queue(db => $s,
queue => \%queue);
}
if ($options{quick}) {
my $rs = $s->resultset('Bug')->search({bug=>$bug})->single();
- next if defined $rs and $stat->mtime < $rs->last_modified()->epoch();
+ next if defined $rs and $stat->mtime <= $rs->last_modified()->epoch();
}
eval {
load_bug_log(db => $s,
die "Unable to connect to database: ";
}
-sub open_compressed_file {
- my ($file) = @_;
- my $fh;
- my $mode = '<:encoding(UTF-8)';
- my @opts;
- if ($file =~ /\.gz$/) {
- $mode = '-|:encoding(UTF-8)';
- push @opts,'gzip','-dc';
- }
- if ($file =~ /\.xz$/) {
- $mode = '-|:encoding(UTF-8)';
- push @opts,'xz','-dc';
- }
- if ($file =~ /\.bz2$/) {
- $mode = '-|:encoding(UTF-8)';
- push @opts,'bzip2','-dc';
- }
- open($fh,$mode,@opts,$file);
- return $fh;
-}
-
sub read_release_file {
my ($file) = @_;
# parse release
}
sub walk_bugs {
- my ($dirs,$p,$what,$verbose,$sub) = @_;
+ my ($dirs,$p,$what,$verbose,$sub,$n) = @_;
my @dirs = @{$dirs};
my $tot_dirs = @dirs;
my $done_dirs = 0;
my $avg_subfiles = 0;
my $completed_files = 0;
+ $n //= 1;
while (my $dir = shift @dirs) {
printf "Doing dir %s ...\n", $dir if $verbose;
$avg_subfiles = ($avg_subfiles * $done_dirs + @list) / ($done_dirs+1);
$done_dirs += 1;
- for my $bug (@list) {
- $completed_files++;
- $p->update($completed_files) if $p;
- print "Up to $completed_files bugs...\n" if ($completed_files % 100 == 0 && $verbose);
- $sub->($bug);
+ my $it = natatime $n,@list;
+ while (my @bugs = $it->()) {
+ $sub->(@bugs);
+ $completed_files += scalar @bugs;
+ $p->update($completed_files) if $p;
+ print "Up to $completed_files bugs...\n"
+ if ($completed_files % 100 == 0 && $verbose);
}
}
$p->remove() if $p;