diff options
Diffstat (limited to 'extensions/UserProfile/bin/update.pl')
-rwxr-xr-x | extensions/UserProfile/bin/update.pl | 36 |
1 files changed, 36 insertions, 0 deletions
diff --git a/extensions/UserProfile/bin/update.pl b/extensions/UserProfile/bin/update.pl new file mode 100755 index 000000000..4cdb08fe7 --- /dev/null +++ b/extensions/UserProfile/bin/update.pl @@ -0,0 +1,36 @@ +#!/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 strict; +use warnings; + +use FindBin qw($Bin); +use lib "$Bin/../../.."; + +use Bugzilla; +BEGIN { Bugzilla->extensions() } + +use Bugzilla::Constants; +use Bugzilla::Extension::UserProfile::Util; + +Bugzilla->usage_mode(USAGE_MODE_CMDLINE); + +my $user_ids = Bugzilla->dbh->selectcol_arrayref( + "SELECT userid + FROM profiles + WHERE last_activity_ts IS NOT NULL + AND (last_statistics_ts IS NULL + OR last_activity_ts > last_statistics_ts) + ORDER BY userid", + { Slice => {} } +); + +foreach my $user_id (@$user_ids) { + update_statistics_by_user($user_id); +} |