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

141 entries across 141 versions & 1 rubygems

Version	Path
foreman_remote_execution-1.7.0	db/migrate/20180112125015_fix_taxable_taxonomies_job_template.rb
foreman_remote_execution-1.6.7	db/migrate/20180112125015_fix_taxable_taxonomies_job_template.rb
foreman_remote_execution-1.6.6	db/migrate/20180112125015_fix_taxable_taxonomies_job_template.rb
foreman_remote_execution-1.6.5	db/migrate/20180112125015_fix_taxable_taxonomies_job_template.rb
foreman_remote_execution-1.6.4	db/migrate/20180112125015_fix_taxable_taxonomies_job_template.rb
foreman_remote_execution-1.5.6	db/migrate/20180112125015_fix_taxable_taxonomies_job_template.rb
foreman_remote_execution-1.6.3	db/migrate/20180112125015_fix_taxable_taxonomies_job_template.rb
foreman_remote_execution-1.6.2	db/migrate/20180112125015_fix_taxable_taxonomies_job_template.rb
foreman_remote_execution-1.5.5	db/migrate/20180112125015_fix_taxable_taxonomies_job_template.rb
foreman_remote_execution-1.6.1	db/migrate/20180112125015_fix_taxable_taxonomies_job_template.rb
foreman_remote_execution-1.6.0	db/migrate/20180112125015_fix_taxable_taxonomies_job_template.rb
foreman_remote_execution-1.5.4	db/migrate/20180112125015_fix_taxable_taxonomies_job_template.rb
foreman_remote_execution-1.5.3	db/migrate/20180112125015_fix_taxable_taxonomies_job_template.rb
foreman_remote_execution-1.5.2	db/migrate/20180112125015_fix_taxable_taxonomies_job_template.rb
foreman_remote_execution-1.5.1	db/migrate/20180112125015_fix_taxable_taxonomies_job_template.rb
foreman_remote_execution-1.5.0	db/migrate/20180112125015_fix_taxable_taxonomies_job_template.rb
foreman_remote_execution-1.4.6	db/migrate/20180112125015_fix_taxable_taxonomies_job_template.rb
foreman_remote_execution-1.4.5	db/migrate/20180112125015_fix_taxable_taxonomies_job_template.rb
foreman_remote_execution-1.4.4	db/migrate/20180112125015_fix_taxable_taxonomies_job_template.rb
foreman_remote_execution-1.4.3	db/migrate/20180112125015_fix_taxable_taxonomies_job_template.rb