X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/22bcfb1240fb3b03613944d8517c100650ab9ad2..a8fcf9034b4c0ed0d4d3672bf7d86685adda44f3:/script/cleanup diff --git a/script/cleanup b/script/cleanup index 270877096..7601d35cf 100755 --- a/script/cleanup +++ b/script/cleanup @@ -1,18 +1,9 @@ #!/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 +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