20150208105930_replace_move_issues_permission.rb
19 lines
| 776 B
| text/x-ruby
|
RubyLexer
Jean-Philippe Lang
|
r13599 | 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 | ||||
|
Jean-Philippe Lang
|
r13608 | 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})" + | ||||
|
Jean-Philippe Lang
|
r13599 | " 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 | ||||