summaryrefslogtreecommitdiffstats
path: root/contrib/reorg-tools/reassign_open_bugs.pl
blob: 6496f9a95bdcf0b16b125b49e88a001b8b57686d (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
#!/usr/bin/perl
# This Source Code Form is subject to the terms of the Mozilla Public
# License, v. 2.0. If a copy of the MPL was not distributed with this
# file, You can obtain one at http://mozilla.org/MPL/2.0/.
#
# This Source Code Form is "Incompatible With Secondary Licenses", as
# defined by the Mozilla Public License, v. 2.0.

use 5.10.1;
use strict;
use warnings;

use FindBin '$RealBin';
use lib "$RealBin/../..", "$RealBin/../../lib";

use Bugzilla;
use Bugzilla::User;
use Bugzilla::Constants;

use Getopt::Long qw( :config gnu_getopt );
use Pod::Usage;

# Load extensions for monkeypatched $user->clear_last_statistics_ts()
BEGIN { Bugzilla->extensions(); }

Bugzilla->usage_mode(USAGE_MODE_CMDLINE);

my ($from, $to);
GetOptions(
    "from|f=s" => \$from,
    "to|t=s"   => \$to,
);

pod2usage(1) unless defined $from && defined $to;

my $dbh = Bugzilla->dbh;

my $timestamp = $dbh->selectrow_array('SELECT LOCALTIMESTAMP(0)');
my $field     = Bugzilla::Field->check({ name => 'assigned_to', cache => 1 });
my $from_user = Bugzilla::User->check({ name => $from, cache => 1 });
my $to_user   = Bugzilla::User->check({ name => $to, cache => 1 });

my $bugs = $dbh->selectcol_arrayref(q{SELECT bug_id
                                      FROM bugs
                                      LEFT JOIN bug_status
                                             ON bug_status.value = bugs.bug_status
                                      WHERE bug_status.is_open = 1
                                        AND bugs.assigned_to = ?}, undef, $from_user->id);
my $bug_count = @$bugs;
if ($bug_count == 0) {
    warn "There are no bugs to move.\n";
    exit 1;
}

print STDERR <<EOF;
About to move $bug_count bugs from $from to $to.

Press <Ctrl-C> to stop or <Enter> to continue...
EOF
getc();

$dbh->bz_start_transaction;
foreach my $bug_id (@$bugs) {
    warn "Updating bug $bug_id\n";
    $dbh->do(q{INSERT INTO bugs_activity(bug_id, who, bug_when, fieldid, removed, added)
               VALUES (?, ?, ?, ?, ?, ?)},
                undef, $bug_id, $to_user->id, $timestamp, $field->id, $from_user->login, $to_user->login);
    $dbh->do(q{UPDATE bugs SET assigned_to = ?, delta_ts = ?, lastdiffed = ? WHERE bug_id = ?},
        undef, $to_user->id, $timestamp, $timestamp, $bug_id);
}
$from_user->clear_last_statistics_ts();
$to_user->clear_last_statistics_ts();
$dbh->bz_commit_transaction;

# It's complex to determine which items now need to be flushed from memcached.
# As this is expected to be a rare event, we just flush the entire cache.
Bugzilla->memcached->clear_all();

__END__

=head1 NAME

reassign-open-bugs.pl - reassign all open bugs from one user to another.

=head1 SYNOPSIS

    reassign-open-bugs.pl --from general@js.bugs --to nobody@mozilla.org