X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/22bcfb1240fb3b03613944d8517c100650ab9ad2..a4ffbb21401d0798ba8f849ec2d70b8c96bc523d:/script/cleanup?ds=inline diff --git a/script/cleanup b/script/cleanup index 270877096..67cc0705e 100755 --- a/script/cleanup +++ b/script/cleanup @@ -1,18 +1,10 @@ #!/usr/bin/env ruby -require File.dirname(__FILE__) + '/../config/environment' +require File.join(File.dirname(__FILE__), "..", "config", "environment") -Session.find(:all, :conditions => ["updated_at < ?", 1.week.ago]).each do |session| - begin - if session[:user] and User.find(session[:user]) - session.destroy if session.updated_at < 1.month.ago - else - session.destroy - end - rescue Exception => ex - puts "Invalid session #{session.session_id}: #{ex.to_s}" - session.destroy - end -end +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 -UserToken.delete_all("expiry < NOW()") +exit 0