X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/b8f3742bc39a8aa4a90f6f1bd151a0c5cdaa42ec..5bd9a2faef7f317299e92063fa22ce56b81e5beb:/script/cleanup diff --git a/script/cleanup b/script/cleanup index 72a6dec9b..67cc0705e 100755 --- a/script/cleanup +++ b/script/cleanup @@ -1,28 +1,10 @@ #!/usr/bin/env ruby -require File.dirname(__FILE__) + '/../config/environment' +require File.join(File.dirname(__FILE__), "..", "config", "environment") -last_session_id = 0 +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 -begin - sessions = Session.find(:all, - :conditions => ["updated_at < ? and id > ?", 1.week.ago, last_session_id], - :order => :id, :limit => 1000) - - sessions.each do |session| - last_session_id = session.id - - 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 -end while sessions.length > 0 - -UserToken.delete_all("expiry < NOW()") +exit 0