From b758be1d37cb49ced8cb17fca3d5a4cb2dd2e03e Mon Sep 17 00:00:00 2001 From: David Lawrence Date: Mon, 6 Jul 2015 19:21:04 +0000 Subject: Bug 1172968: Move the scripts we want to keep from contrib/* and place them in scripts/ directory. Remove contrib from repo --- contrib/reorg-tools/reassign_open_bugs.pl | 87 ------------------------------- 1 file changed, 87 deletions(-) delete mode 100755 contrib/reorg-tools/reassign_open_bugs.pl (limited to 'contrib/reorg-tools/reassign_open_bugs.pl') diff --git a/contrib/reorg-tools/reassign_open_bugs.pl b/contrib/reorg-tools/reassign_open_bugs.pl deleted file mode 100755 index 6496f9a95..000000000 --- a/contrib/reorg-tools/reassign_open_bugs.pl +++ /dev/null @@ -1,87 +0,0 @@ -#!/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 < to stop or 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 -- cgit v1.2.3-24-g4f1b