From 2d754f1d6ad47385dd4b58b8e52791a9fd63bfd3 Mon Sep 17 00:00:00 2001 From: Julian Maurice Date: Mon, 19 Mar 2018 10:43:49 +0100 Subject: [PATCH] Bug 20402: Add cronjob script to delete expired tokens Test plan: 1. Generate X tokens (X > 1) 2. mysql> UPDATE oauth_access_tokens SET expires = 0 3. Generate Y tokens (Y > 1) 4. Run the script 5. Verify that only Y tokens remains --- misc/cronjobs/delete_expired_oauth_tokens.pl | 22 ++++++++++++++++++++++ 1 file changed, 22 insertions(+) create mode 100755 misc/cronjobs/delete_expired_oauth_tokens.pl diff --git a/misc/cronjobs/delete_expired_oauth_tokens.pl b/misc/cronjobs/delete_expired_oauth_tokens.pl new file mode 100755 index 0000000000..05317ee1ce --- /dev/null +++ b/misc/cronjobs/delete_expired_oauth_tokens.pl @@ -0,0 +1,22 @@ +#!/usr/bin/env perl + +# This file is part of Koha. +# +# Koha is free software; you can redistribute it and/or modify it under the +# terms of the GNU General Public License as published by the Free Software +# Foundation; either version 3 of the License, or (at your option) any later +# version. +# +# Koha is distributed in the hope that it will be useful, but WITHOUT ANY +# WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR +# A PARTICULAR PURPOSE. See the GNU General Public License for more details. +# +# You should have received a copy of the GNU General Public License along +# with Koha; if not, write to the Free Software Foundation, Inc., +# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA. + +use Modern::Perl; + +use Koha::OAuthAccessTokens; + +Koha::OAuthAccessTokens->search({ expires => { '<=', time } })->delete; -- 2.14.2