Rails reset_counters in counter_cache with conditions

Asked Oct 08 '19 at 10:50

Active Oct 08 '19 at 10:50

Viewed 459 times

I've two counter_cache, one for total number of campaign_codes and one only when campaign_code was used - campaign_codes.where(state: 'used'). To update total number of campaign_codes in the rails c I used script like:

CreditCampaign.reset_counters(CreditCampaign.first.id, :campaign_codes)

but this works only for total number of campaign_codes. How to setup the script in console for used campaign?

CampaignCode model

class CampaignCode < ApplicationRecord
  belongs_to :credit_campaign, counter_cache: :total_campaign_codes_amount
  belongs_to :used_credit_campaign, -> { where(state: 'used') }, class_name: 'CampaignCode', counter_cache: :used_campaign_codes_amount, optional: true
end

CreditCampaign model

class CreditCampaign < ApplicationRecord
  has_many :campaign_codes
end

asked Oct 08 '19 at 10:50

mr_muscle

2,536
18
61

Did my [previous comment](https://stackoverflow.com/q/58271158/1954610) help? – Tom Lord Oct 08 '19 at 10:55
@TomLord Thanks for that! It was helpful but now if I manage how to update manually this counter cache I think I will be able to implement this solution to my endpoint, like with `total_campaign_codes_amount` – mr_muscle Oct 08 '19 at 11:08
`... , class_name: 'CampaignCode', ...` Are you sure this is correct? – chumakoff Oct 08 '19 at 20:23
@chumakoff Yup it is – mr_muscle Oct 09 '19 at 11:25
`campaign_code` belongs to `campaign_code`? – chumakoff Oct 09 '19 at 11:32
`campaign_code` belongs to `used_credit_campaign` – mr_muscle Oct 09 '19 at 11:35
`used_credit_campaign` is a `CreditCampaign`. So it must be `class_name: 'CreditCampaign'` – chumakoff Oct 10 '19 at 09:11
@chumakoff in such case I should move `used_campaign_codes_amount` to the `CreditCampaign` model which I don't want to do. However I think @TomLord is right, counter cache doesn't work in scope, in that case I will leave it only for `total_campaign_codes_amount`. – mr_muscle Oct 10 '19 at 09:36

Rails reset_counters in counter_cache with conditions

0 Answers0