Reset counter cache on all data of model

Question

I am looking for a beautiful way to update a counter cache of a given model.

Here are my model:

class GameParticipation < ActiveRecord::Base
  belongs_to :game, counter_cache: true
end

And:

class Game < ActiveRecord::Base
  has_many   :game_participations
end

Isn't it something better than iterating on each element like the following code ?

Game.ids.each {|id| Game.reset_counters(id, :game_participations) }

Answer 1

To update all the counter cache in one request I found inspiration on http://ryan.mcgeary.org/2016/02/05/proper-counter-cache-migrations-in-rails/

It can be done in one request with SQL :

ActiveRecord::Base.connection.execute <<-SQL.squish
    UPDATE games
    SET game_participations_count = (SELECT count(1)
                               FROM game_participations
                              WHERE game_participations.game_id = games.id)
SQL

It takes much less time to execute since all the updating is done in one request.