From: Tom Hughes <tom@compton.nu>
Date: Sat, 22 Aug 2020 15:14:37 +0000 (+0100)
Subject: Extend cleanup script to cleanup old OAuth tokens
X-Git-Tag: live~2478
X-Git-Url: https://git.openstreetmap.org./rails.git/commitdiff_plain/93c15f377ae17f4f84f9dc29ac85c24267d690f2

Extend cleanup script to cleanup old OAuth tokens
---

diff --git a/script/cleanup b/script/cleanup
index 10fdf9db7..983a3d458 100755
--- a/script/cleanup
+++ b/script/cleanup
@@ -4,5 +4,7 @@ require File.dirname(__FILE__) + "/../config/environment"
 
 UserToken.where("expiry < NOW()").delete_all
 OauthNonce.where("timestamp < EXTRACT(EPOCH FROM NOW() - INTERVAL '1 day')").delete_all
+OauthToken.where("invalidated_at < NOW() - INTERVAL '28 days'").delete_all
+RequestToken.where("authorized_at IS NULL AND created_at < NOW() - INTERVAL '28 days'").delete_all
 
 exit 0