Contents

# frozen_string_literal: true

class AddAccountCounterCaches < ActiveRecord::Migration[5.1]
  def change
    change_table :accounts do |t|
      t.integer :contacts_count, default: 0
      t.integer :opportunities_count, default: 0
    end

    reversible do |dir|
      dir.up { data }
    end
  end

  def data
    Account.all.each do |account|
      Account.update_counters(
        account.id,
        contacts_count: account.contacts.count,
        opportunities_count: account.opportunities.count
      )
    end
  end
end

Version data entries

13 entries across 13 versions & 1 rubygems

Version	Path
fat_free_crm-0.22.1	db/migrate/20180102075234_add_account_counter_caches.rb
fat_free_crm-0.22.0	db/migrate/20180102075234_add_account_counter_caches.rb
fat_free_crm-0.21.0	db/migrate/20180102075234_add_account_counter_caches.rb
fat_free_crm-0.20.1	db/migrate/20180102075234_add_account_counter_caches.rb
fat_free_crm-0.20.0	db/migrate/20180102075234_add_account_counter_caches.rb
fat_free_crm-0.19.2	db/migrate/20180102075234_add_account_counter_caches.rb
fat_free_crm-0.19.0	db/migrate/20180102075234_add_account_counter_caches.rb
fat_free_crm-0.18.2	db/migrate/20180102075234_add_account_counter_caches.rb
fat_free_crm-0.17.3	db/migrate/20180102075234_add_account_counter_caches.rb
fat_free_crm-0.18.1	db/migrate/20180102075234_add_account_counter_caches.rb
fat_free_crm-0.18.0	db/migrate/20180102075234_add_account_counter_caches.rb
fat_free_crm-0.17.2	db/migrate/20180102075234_add_account_counter_caches.rb
fat_free_crm-0.17.1	db/migrate/20180102075234_add_account_counter_caches.rb