diff options
author | Dylan William Hardison <dylan@hardison.net> | 2014-04-07 02:41:11 -0400 |
---|---|---|
committer | Dylan William Hardison <dylan@hardison.net> | 2014-04-22 16:37:52 -0400 |
commit | eab44b1aad3f243dd69b1d30519b73a1e537fda2 (patch) | |
tree | 45e67469b8c6905a545dc5f2bd8bbe03bd41ea7c /clean-bug-user-last-visit.pl | |
parent | 36f56bd9112c2e930fb5bdbee3b5c89334de5247 (diff) | |
download | bugs-eab44b1aad3f243dd69b1d30519b73a1e537fda2.tar bugs-eab44b1aad3f243dd69b1d30519b73a1e537fda2.tar.gz bugs-eab44b1aad3f243dd69b1d30519b73a1e537fda2.tar.bz2 bugs-eab44b1aad3f243dd69b1d30519b73a1e537fda2.tar.xz bugs-eab44b1aad3f243dd69b1d30519b73a1e537fda2.zip |
Bug 489028 - Record last-visited time of bugs when logged in
r=glob a=justdave
Diffstat (limited to 'clean-bug-user-last-visit.pl')
-rw-r--r-- | clean-bug-user-last-visit.pl | 38 |
1 files changed, 38 insertions, 0 deletions
diff --git a/clean-bug-user-last-visit.pl b/clean-bug-user-last-visit.pl new file mode 100644 index 000000000..9884b7c48 --- /dev/null +++ b/clean-bug-user-last-visit.pl @@ -0,0 +1,38 @@ +#!/usr/bin/perl -wT +# 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. + +=head1 NAME + +clean-bug-user-last-visit.pl + +=head1 DESCRIPTION + +This utility script cleans out entries from the bug_user_last_visit table that +are older than (a configurable) number of days. + +It takes no arguments and produces no output except in the case of errors. + +=cut + +use 5.10.1; +use strict; +use warnings; +use lib qw(. lib); + +use Bugzilla; +use Bugzilla::Constants; + +Bugzilla->usage_mode(USAGE_MODE_CMDLINE); + +my $dbh = Bugzilla->dbh; +my $sql = 'DELETE FROM bug_user_last_visit WHERE last_visit_ts < ' + . $dbh->sql_date_math('NOW()', + '-', + Bugzilla->params->{last_visit_keep_days}, + 'DAY'); +$dbh->do($sql); |