Sha256: d7eeb0f394a2b56fdd4ccfdb6936d7126d9f5ca964a993494aea1bed2205fb0b
Contents?: true
Size: 776 Bytes
Versions: 34
Compression:
Stored size: 776 Bytes
Contents
class ReplaceMoveIssuesPermission < ActiveRecord::Migration
def self.up
Role.all.each do |role|
if role.has_permission?(:edit_issues) && !role.has_permission?(:move_issues)
# inserts one ligne per trakcer and status
rule = WorkflowPermission.connection.quote_column_name('rule') # rule is a reserved keyword in SQLServer
WorkflowPermission.connection.execute(
"INSERT INTO #{WorkflowPermission.table_name} (tracker_id, old_status_id, role_id, type, field_name, #{rule})" +
" SELECT t.id, s.id, #{role.id}, 'WorkflowPermission', 'project_id', 'readonly'" +
" FROM #{Tracker.table_name} t, #{IssueStatus.table_name} s"
)
end
end
end
def self.down
raise IrreversibleMigration
end
end
Version data entries
34 entries across 34 versions & 1 rubygems