Contents

# frozen_string_literal: true

class AddUniqueFeatureLabelIndex < ActiveRecord::Migration[6.0]
  def change
    remove_index :remote_execution_features, :label

    counts = RemoteExecutionFeature.group(:label).count
    counts.select { |_, count| count > 1 }.each do |label, count|
      RemoteExecutionFeature.where(label: label).limit(count - 1).delete_all
    end

    add_index :remote_execution_features, :label, unique: true
  end
end

Version data entries

41 entries across 41 versions & 1 rubygems

Version	Path
foreman_remote_execution-13.2.7	db/migrate/20220426145007_add_unique_feature_label_index.rb
foreman_remote_execution-15.0.0	db/migrate/20220426145007_add_unique_feature_label_index.rb
foreman_remote_execution-14.1.4	db/migrate/20220426145007_add_unique_feature_label_index.rb
foreman_remote_execution-14.1.3	db/migrate/20220426145007_add_unique_feature_label_index.rb
foreman_remote_execution-14.1.2	db/migrate/20220426145007_add_unique_feature_label_index.rb
foreman_remote_execution-14.1.1	db/migrate/20220426145007_add_unique_feature_label_index.rb
foreman_remote_execution-14.1.0	db/migrate/20220426145007_add_unique_feature_label_index.rb
foreman_remote_execution-14.0.2	db/migrate/20220426145007_add_unique_feature_label_index.rb
foreman_remote_execution-14.0.1	db/migrate/20220426145007_add_unique_feature_label_index.rb
foreman_remote_execution-13.2.6	db/migrate/20220426145007_add_unique_feature_label_index.rb
foreman_remote_execution-14.0.0	db/migrate/20220426145007_add_unique_feature_label_index.rb
foreman_remote_execution-13.2.5	db/migrate/20220426145007_add_unique_feature_label_index.rb
foreman_remote_execution-13.2.4	db/migrate/20220426145007_add_unique_feature_label_index.rb
foreman_remote_execution-13.2.3	db/migrate/20220426145007_add_unique_feature_label_index.rb
foreman_remote_execution-13.2.2	db/migrate/20220426145007_add_unique_feature_label_index.rb
foreman_remote_execution-12.0.7	db/migrate/20220426145007_add_unique_feature_label_index.rb
foreman_remote_execution-13.2.1	db/migrate/20220426145007_add_unique_feature_label_index.rb
foreman_remote_execution-13.2.0	db/migrate/20220426145007_add_unique_feature_label_index.rb
foreman_remote_execution-10.1.3	db/migrate/20220426145007_add_unique_feature_label_index.rb
foreman_remote_execution-13.0.0	db/migrate/20220426145007_add_unique_feature_label_index.rb