counter_cache with has_many :through

by

You have previous

    class Product
      has_and_belongs_to_many :categories
    end

    class Category
      has_and_belongs_to_many :products
    end

and migration

    class CreateCategoriesProducts < ActiveRecord::Migration
      def change
        create_table :categories_products, id: false do |t|
          t.references :category
          t.references :product
        end

        add_index :categories_products, [:category_id, :product_id]
      end
    end

now change all to

    class Product
      has_many :categories_products, dependent: :destroy
      has_many :categories, through: :categories_products
    end

    class Category
      has_many :categories_products, dependent: :destroy
      has_many :products, through: :categories_products
    end

and new one

    class CategoriesProduct < ActiveRecord::Base
      # this model uses table "categories_products" as it is
      # column products_count is in the table "categories"
      belongs_to :category, counter_cache: :products_count
      belongs_to :product
    end

More Related Contents:

  1. do..end vs curly braces for blocks in Ruby
  2. How to get a random number in Ruby
  3. ActiveRecord: size vs count
  4. Connecting Rails 3.1 with Multiple Databases
  5. In Ruby on Rails, to extend the String class, where should the code be put in?
  6. Rails 3: Get Random Record
  7. incompatible character encodings: ASCII-8BIT and UTF-8
  8. STI, one controller
  9. How to get a query string from a URL in Rails
  10. Rails 3 disabling session cookies
  11. How to get a Date from date_select or select_date in Rails?
  12. How to match accented characters with a regex?
  13. How can I specify a local gem in my Gemfile?
  14. Paginating an Array in Ruby with will_paginate
  15. f.error_messages in Rails 3.0
  16. What is the right way to override a setter method in Ruby on Rails?
  17. Convert HTML to word file ?
  18. Convert UTC to local time in Rails 3
  19. How to define action with simple form for?
  20. Ruby: problem installing EventMachine under Windows 7
  21. Ruby on Rails 3 howto make ‘OR’ condition
  22. Adding foreign key to a rails model
  23. Why is Rspec saying “Failure/Error: Unable to find matching line from backtrace”?
  24. Rails catch-all/globbing routes
  25. Is there a “phpmyadmin” for Ruby on Rails? [closed]
  26. Always getting 401 Unauthorized with new install of Rails + Devise
  27. Rails 2 to Rails 3 : using link_to instead of link_to_remote (including remote and update)
  28. Is the server running on host “localhost” (::1) and accepting TCP/IP connections on port 5432?
  29. Ruby 1.9.2 and Rails 3 cannot open rails console
  30. Why should we avoid using class variables @@ in rails?

Leave a Comment