Contents

desc "Update counter caches"
task :update_counter_caches => :environment do
  # Update the Venue#events_count
  total = Venue.count
  Venue.all.each do |venue|
    cached = venue.events_count
    actual = venue.events.count
    if actual != cached
      puts "Updating Venue ##{venue.id} from #{cached} cached to #{actual} actual -- #{venue.title}"
      Venue.connection.update("UPDATE venues SET events_count = #{actual} WHERE id = #{venue.id}")
    end
  end
end

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
calagator-0.0.1.pre1	lib/tasks/update_counter_caches.rake