Skip to content

Instantly share code, notes, and snippets.

@drewB
Created July 14, 2014 16:27
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save drewB/4aba175b0762848eb239 to your computer and use it in GitHub Desktop.
Save drewB/4aba175b0762848eb239 to your computer and use it in GitHub Desktop.
#before
def load_submissions_count
Enrollment.where(initiative_id: @initiative_ids).group(:initiative_id).select('initiative_id, sum(submissions_count) as sum_submissions_count').each do |data|
initiative = @initiatives_data[data.initiative_id]
initiative.cached_submissions_count = data.sum_submissions_count.to_i
end
end
#after
def load_submissions_count
Enrollment.where(initiative_id: @initiative_ids).group(:initiative_id).select('initiative_id, COALESCE(sum(submissions_count), 0) as sum_submissions_count').each do |data|
initiative = @initiatives_data[data.initiative_id]
initiative.cached_submissions_count = data.sum_submissions_count.to_i
end
end
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment