Example code for find_in_batches with calls to Akismet

gistfile1.rb

def setup
  @file = CSV.open()
  @file.write(header)
end

def header
  %w(account_id name url blah blorg is_spam)
end

def check_records
  iterations =  0
  Account.find_in_batches(:conditions => "created_at < now() - interval '1 year'") do |accounts|
    accounts.each do | account|
      # Call Akismet
      is_spam = Akismet::Client.check_comment()
      # Write to CSV
      @file.write(accout.id, account.name, account.url, ...., is_spam)
    end
    # Are we done?  We want only 20 iterations
    iterations += 1
    break if iterations > = 20
  end
end