blob: 57486bfed8e95e05c47a8d9afc8b7329efcabd6c [file] [log] [blame]
#!/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.
=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);