Counter Cache for a column with conditions?

by

With regards to the conditions with counter_cache, I would read this blog post.

The one thing you should do is add the following to the migration file:

 add_column :employees, :projects_count, :integer, :default => 0, :null => false

 Employee.reset_column_information

 Employee.all.each do |e|
   Employee.update_counters e.id, :projects_count => e.projects.length
 end

So you current projects count can get migrated to the new projects_count that are associated with each Employee object. After that, you should be good to go.

More Related Contents:

  1. Can’t find the ‘libpq-fe.h header when trying to install pg gem
  2. ActiveRecord: size vs count
  3. How can I disable logging of asset pipeline (sprockets) messages in Ruby on Rails 3.1?
  4. PG undefinedtable error relation users does not exist
  5. Rails routing to handle multiple domains on single application
  6. Rails .where vs .find
  7. Path helpers generate paths with dots instead of slashes
  8. Rails config.assets.precompile setting to process all CSS and JS files in app/assets
  9. How to get a query string from a URL in Rails
  10. Rails 3 – select with Include?
  11. belongs_to through associations
  12. Check if record exists from controller in Rails
  13. Extending controllers of a Rails 3 Engine in the main app
  14. How to get a Date from date_select or select_date in Rails?
  15. counter_cache with has_many :through
  16. How can I specify a local gem in my Gemfile?
  17. What is the right way to override a setter method in Ruby on Rails?
  18. How to access instance variables in CoffeeScript engine inside a Slim template
  19. association named not found perhaps misspelled issue in rails association
  20. Ruby: problem installing EventMachine under Windows 7
  21. API Versioning for Rails Routes
  22. Index on multiple columns in Ruby on Rails
  23. How to have a drop down field in a rails form?
  24. Ruby on rails 4 app does not work in iframe
  25. Rails Devise: after_confirmation
  26. Why is Rspec saying “Failure/Error: Unable to find matching line from backtrace”?
  27. Rails 3.1 include_root_in_json
  28. Where to put Global variables in Rails 3
  29. Rails: Order with nulls last
  30. Why should we avoid using class variables @@ in rails?

Leave a Comment