Contents

class MigrateAccountabilityResultsCategory < ActiveRecord::Migration[5.1]
  def change
    # Create categorizations ensuring database integrity
    execute('
      INSERT INTO decidim_categorizations(decidim_category_id, categorizable_id, categorizable_type, created_at, updated_at)
        SELECT decidim_category_id, decidim_accountability_results.id, \'Decidim::Accountability::Result\', NOW(), NOW()
        FROM decidim_accountability_results
        INNER JOIN decidim_categories ON decidim_categories.id = decidim_accountability_results.decidim_category_id
    ')
    # Remove unused column
    remove_column :decidim_accountability_results, :decidim_category_id
  end
end

Version data entries

3 entries across 3 versions & 1 rubygems

Version	Path
decidim-accountability-0.1.2	db/migrate/20170623094200_migrate_accountability_results_category.rb
decidim-accountability-0.1.1	db/migrate/20170623094200_migrate_accountability_results_category.rb
decidim-accountability-0.1.0	db/migrate/20170623094200_migrate_accountability_results_category.rb