Sha256: 148e282126e5af0ed97166ecd5a901de146af8d0bbf6b8709e3cf4f5ee2e7484
Contents?: true
Size: 1.75 KB
Versions: 12
Compression:
Stored size: 1.75 KB
Contents
class MoveKatelloFieldsFromHostgroups < ActiveRecord::Migration[6.0] def up if User.where(login: User::ANONYMOUS_ADMIN).exists? User.as_anonymous_admin do copy_data_from_hostgroup end end change_table :hostgroups do |table| table.remove( :content_source_id, :kickstart_repository_id, :content_view_id, :lifecycle_environment_id ) end end def down change_table :hostgroups do |t| t.column :kickstart_repository_id, :integer, :null => true t.column :content_source_id, :integer, :null => true t.column :content_view_id, :integer, :null => true t.column :lifecycle_environment_id, :integer, :null => true end end def copy_data_from_hostgroup hg_table = ::Hostgroup.arel_table hostgroups = ::Hostgroup.unscoped.where( hg_table[:content_source_id].eq(nil) .and(hg_table[:kickstart_repository_id].eq(nil)) .and(hg_table[:content_view_id].eq(nil)) .and(hg_table[:lifecycle_environment_id].eq(nil)) .not) hostgroups.in_batches do |batch| batch.pluck( :id, :content_source_id, :kickstart_repository_id, :content_view_id, :lifecycle_environment_id ).each do |hostgroup_id, content_source_id, kickstart_repository_id, content_view_id, lifecycle_environment_id| content_facet = ::Katello::Hostgroup::ContentFacet.find_or_create_by(hostgroup_id: hostgroup_id) content_facet.content_source_id = content_source_id content_facet.kickstart_repository_id = kickstart_repository_id content_facet.content_view_id = content_view_id content_facet.lifecycle_environment_id = lifecycle_environment_id content_facet.save! end end end end
Version data entries
12 entries across 12 versions & 1 rubygems