Sha256: d472398a87698aa1b4152a41a7a72e6b9f5684a6bcd293d784202cc39a91f2fa
Contents?: true
Size: 1 KB
Versions: 11
Compression:
Stored size: 1 KB
Contents
# frozen_string_literal: true
class MigrateUserRolesToParticipatoryProcessRoles < ActiveRecord::Migration[5.1]
class ParticipatoryProcess < ApplicationRecord
self.table_name = :decidim_participatory_processes
end
class User < ApplicationRecord
self.table_name = :decidim_users
end
def up
participatory_processes = ParticipatoryProcess.includes(:organization).all
User.find_each do |user|
next if user.roles.empty? || user.roles.include?("admin")
processes = participatory_processes.select { |process| process.organization == user.organization }
values = processes.map do |process|
user.roles.map do |role|
"(#{user.id}, #{process.id}, '#{role}', NOW(), NOW())"
end
end
execute("
INSERT INTO decidim_admin_participatory_process_user_roles
(decidim_user_id, decidim_participatory_process_id, role, created_at, updated_at)
VALUES #{values.join(", ")}
")
end
remove_column :decidim_users, :roles
end
end
Version data entries
11 entries across 11 versions & 2 rubygems