Sha256: a0c257540a191492b44a6c83501318d93251070bfeb301106901c32bc5eb333d
Contents?: true
Size: 629 Bytes
Versions: 75
Compression:
Stored size: 629 Bytes
Contents
# frozen_string_literal: true
class AddResponsesCountToDecidimConsultationsQuestions < ActiveRecord::Migration[5.1]
def change
add_column :decidim_consultations_questions, :responses_count, :integer, null: false, default: 0
reversible do |dir|
dir.up { initialize_counter }
end
end
def initialize_counter
execute <<-SQL.squish
UPDATE decidim_consultations_questions
SET responses_count = (
select count(1)
from decidim_consultations_responses
where decidim_consultations_questions_id = decidim_consultations_questions.id
)
SQL
end
end
Version data entries
75 entries across 75 versions & 1 rubygems