X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/22bcfb1240fb3b03613944d8517c100650ab9ad2..cdbf1bd6d97b410f9c6638b4eac01b3c831c8e32:/script/cleanup?ds=inline diff --git a/script/cleanup b/script/cleanup index 270877096..72a6dec9b 100755 --- a/script/cleanup +++ b/script/cleanup @@ -2,17 +2,27 @@ require 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 +last_session_id = 0 + +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 - 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()")