Contents

class FixTaxableTaxonomiesJobTemplate < ActiveRecord::Migration[4.2]
  def up
    # we need to count on the fact that the user might already has assigned the templates
    # to taxonomies after the previous update
    already_present = TaxableTaxonomy.where(:taxable_type => 'JobTemplate').pluck(:taxable_id)
    missing = JobTemplate.unscoped.pluck(:id) - already_present
    TaxableTaxonomy.unscoped.where(:taxable_type => 'Template', :taxable_id => missing).update_all(:taxable_type => 'JobTemplate')
    TaxableTaxonomy.unscoped.where(:taxable_type => 'Template', :taxable_id => already_present).delete_all
  end

  def down
    TaxableTaxonomy.unscoped.where(:taxable_type => 'JobTemplate').update_all(:taxable_type => 'Template')
  end
end

Version data entries

140 entries across 140 versions & 1 rubygems

Version	Path
foreman_remote_execution-14.1.1	db/migrate/20180112125015_fix_taxable_taxonomies_job_template.rb
foreman_remote_execution-14.1.0	db/migrate/20180112125015_fix_taxable_taxonomies_job_template.rb
foreman_remote_execution-14.0.2	db/migrate/20180112125015_fix_taxable_taxonomies_job_template.rb
foreman_remote_execution-14.0.1	db/migrate/20180112125015_fix_taxable_taxonomies_job_template.rb
foreman_remote_execution-13.2.6	db/migrate/20180112125015_fix_taxable_taxonomies_job_template.rb
foreman_remote_execution-14.0.0	db/migrate/20180112125015_fix_taxable_taxonomies_job_template.rb
foreman_remote_execution-13.2.5	db/migrate/20180112125015_fix_taxable_taxonomies_job_template.rb
foreman_remote_execution-13.2.4	db/migrate/20180112125015_fix_taxable_taxonomies_job_template.rb
foreman_remote_execution-13.2.3	db/migrate/20180112125015_fix_taxable_taxonomies_job_template.rb
foreman_remote_execution-13.2.2	db/migrate/20180112125015_fix_taxable_taxonomies_job_template.rb
foreman_remote_execution-12.0.7	db/migrate/20180112125015_fix_taxable_taxonomies_job_template.rb
foreman_remote_execution-13.2.1	db/migrate/20180112125015_fix_taxable_taxonomies_job_template.rb
foreman_remote_execution-13.2.0	db/migrate/20180112125015_fix_taxable_taxonomies_job_template.rb
foreman_remote_execution-10.1.3	db/migrate/20180112125015_fix_taxable_taxonomies_job_template.rb
foreman_remote_execution-13.0.0	db/migrate/20180112125015_fix_taxable_taxonomies_job_template.rb
foreman_remote_execution-12.0.5	db/migrate/20180112125015_fix_taxable_taxonomies_job_template.rb
foreman_remote_execution-12.0.4	db/migrate/20180112125015_fix_taxable_taxonomies_job_template.rb
foreman_remote_execution-12.0.1	db/migrate/20180112125015_fix_taxable_taxonomies_job_template.rb
foreman_remote_execution-12.0.2	db/migrate/20180112125015_fix_taxable_taxonomies_job_template.rb
foreman_remote_execution-11.1.3	db/migrate/20180112125015_fix_taxable_taxonomies_job_template.rb