X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/aa1fb6dbb8c2e71b8ce8c231ae1272a2dfebd75a..02e603119d22f988048309f9578d46a462bf2919:/script/cleanup diff --git a/script/cleanup b/script/cleanup index 3eaeef7c6..e829be176 100755 --- a/script/cleanup +++ b/script/cleanup @@ -1,8 +1,12 @@ #!/usr/bin/env ruby -require File.dirname(__FILE__) + "/../config/environment" +require File.join(File.dirname(__FILE__), "..", "config", "environment") -UserToken.delete_all("expiry < NOW()") -OauthNonce.delete_all("timestamp < EXTRACT(EPOCH FROM NOW() - INTERVAL '1 day')") +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 + +Doorkeeper::AccessGrant.where("revoked_at < NOW() - INTERVAL '28 days' OR (created_at + expires_in * INTERVAL '1 second') < NOW() - INTERVAL '28 days'").delete_all +Doorkeeper::AccessToken.where("revoked_at < NOW() - INTERVAL '28 days' OR (created_at + expires_in * INTERVAL '1 second') < NOW() - INTERVAL '28 days'").delete_all exit 0