Contents

# frozen_string_literal: true

class ChangePlansRelatedProposalsToResourceLinks < ActiveRecord::Migration[5.2]
  def up
    Decidim::Plans::Plan.all.each do |plan|
      proposal_ids = ActiveRecord::Base.connection.execute(
        "SELECT decidim_proposal_id FROM decidim_plans_attached_proposals " \
        "WHERE decidim_plan_id = #{plan.id}"
      ).pluck("decidim_proposal_id")

      say("Linking proposals for plan: #{plan.id}")

      # In case the plan has been moved from one participatory space to another,
      # it may not have the correct mapping with the proposal. Make sure we are
      # not linking them as that would cause the migration to fail.
      proposal_ids = proposal_ids.select do |pid|
        p = Decidim::Proposals::Proposal.find(pid)
        p.participatory_space == plan.participatory_space
      end

      next unless proposal_ids.count.positive?

      say("--Proposal IDs: #{proposal_ids.join(",")}")

      plan.link_resources(
        Decidim::Proposals::Proposal.where(id: proposal_ids),
        "included_proposals"
      )
    end

    # Drop the unnecessary attached proposals table
    drop_table :decidim_plans_attached_proposals
  end

  def down
    # Re-create the attached proposals table
    create_table :decidim_plans_attached_proposals do |t|
      t.references :decidim_plan, index: true
      t.references :decidim_proposal, index: true

      t.timestamps
    end

    Decidim::Plans::Plan.all.each do |plan|
      say("Reverting attached proposals for plan: #{plan.id}")
      plan.linked_resources(:proposals, "included_proposals").each do |proposal|
        say("--Proposal ID: #{proposal.id}")
        ActiveRecord::Base.connection.execute(
          "INSERT INTO decidim_plans_attached_proposals " \
          "(decidim_plan_id, decidim_proposal_id, created_at, updated_at)" \
          "VALUES (#{plan.id}, #{proposal.id}, NOW(), NOW())"
        )
      end
    end
  end
end

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
decidim-plans-0.18.2	db/migrate/20190603211538_change_plans_related_proposals_to_resource_links.rb
decidim-plans-0.18.1	db/migrate/20190603211538_change_plans_related_proposals_to_resource_links.rb