Sha256: 11d7dfdef8e7a24e5276b46d62157a2e2c0584259d812e0a1cf9fa54bed37859

Contents?: true

Size: 668 Bytes

Versions: 148

Compression:

Stored size: 668 Bytes

Contents

# frozen_string_literal: true

class MigrateProjectsCategory < 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_budgets_projects.id, \'Decidim::Budgets::Project\', NOW(), NOW()
        FROM decidim_budgets_projects
        INNER JOIN decidim_categories ON decidim_categories.id = decidim_budgets_projects.decidim_category_id
    ')
    # Remove unused column
    remove_column :decidim_budgets_projects, :decidim_category_id
  end
end

Version data entries

148 entries across 148 versions & 2 rubygems

Version Path
decidim-budgets-0.14.4 db/migrate/20170612101846_migrate_projects_category.rb
decidim-budgets-0.14.3 db/migrate/20170612101846_migrate_projects_category.rb
decidim-budgets-0.14.2 db/migrate/20170612101846_migrate_projects_category.rb
decidim-budgets-0.14.1 db/migrate/20170612101846_migrate_projects_category.rb
decidim-budgets-0.13.1 db/migrate/20170612101846_migrate_projects_category.rb
decidim-budgets-0.12.2 db/migrate/20170612101846_migrate_projects_category.rb
decidim-budgets-0.13.0 db/migrate/20170612101846_migrate_projects_category.rb
decidim-budgets-0.12.1 db/migrate/20170612101846_migrate_projects_category.rb
decidim-budgets-0.13.0.pre1 db/migrate/20170612101846_migrate_projects_category.rb
decidim-budgets-0.12.0 db/migrate/20170612101846_migrate_projects_category.rb
decidim-budgets-0.11.2 db/migrate/20170612101846_migrate_projects_category.rb
decidim-budgets-0.12.0.pre db/migrate/20170612101846_migrate_projects_category.rb
decidim-budgets-0.11.1 db/migrate/20170612101846_migrate_projects_category.rb
decidim-budgets-0.11.0.pre1 db/migrate/20170612101846_migrate_projects_category.rb
decidim-budgets-0.10.1 db/migrate/20170612101846_migrate_projects_category.rb
decidim-budgets-0.10.0 db/migrate/20170612101846_migrate_projects_category.rb
decidim-budgets-0.9.3 db/migrate/20170612101846_migrate_projects_category.rb
decidim-budgets-0.9.2 db/migrate/20170612101846_migrate_projects_category.rb
decidim-budgets-0.9.1 db/migrate/20170612101846_migrate_projects_category.rb
decidim-budgets-0.9.0 db/migrate/20170612101846_migrate_projects_category.rb