Changeset 483
- Timestamp:
- 01/24/07 17:02:57 (2 years ago)
- Files:
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
branches/workorder_report_rename/db/migrate/021_version_one_dot_two_tables.rb
r473 r483 44 44 45 45 def self.up 46 rename_action_keys 47 48 execute 'UPDATE data_permission_profiles SET type = "FormPermissionProfile" WHERE type = "ReportPermissionProfile"' 49 execute 'UPDATE data_permission_profiles SET type = "TaskPermissionProfile" WHERE type = "WorkOrderPermissionProfile"' 50 46 51 rename_columns('report', 'form', @@report_columns) 47 52 rename_tables('report', 'form', @@report_tables) … … 160 165 rename_tables('report', 'form', @@report_tables, true) 161 166 rename_columns('report', 'form', @@report_columns, true) 167 168 execute 'UPDATE data_permission_profiles SET type = "ReportPermissionProfile" WHERE type = "FormPermissionProfile"' 169 execute 'UPDATE data_permission_profiles SET type = "WorkOrderPermissionProfile" WHERE type = "TaskPermissionProfile"' 170 171 rename_action_keys(true) 172 end 173 174 def self.rename_action_keys(revert=false) 175 TempActionKey.find(:all).each { |a| 176 a.name = new_name('report', 'form', a.name, revert) 177 a.name = new_name('work_order', 'task', a.name, revert) 178 a.save! 179 } 162 180 end 163 181 … … 180 198 # pairs by replacing `from` in the column name with `to`. 181 199 # 182 # If `revert` is set to `true`, the process is reverted, and the tables are200 # If `revert` is set to `true`, the process is reverted, and the columns are 183 201 # renamed by replacing `to` with `from`. 184 202 def self.rename_columns(from, to, tables_and_cols, revert=false) branches/workorder_report_rename/test/unit/asset_test.rb
r469 r483 40 40 @authorized_to_edit = create_raw_asset('User authorized to edit', 'EDIT', @root) 41 41 @authorized_to_create_form = create_raw_asset('User authorized to create form', 'FORM', @root) 42 @authorized_to_create_task = create_raw_asset('User authorized to create work order', ' WORKORDER', @root)42 @authorized_to_create_task = create_raw_asset('User authorized to create work order', 'TASK', @root) 43 43 @authorized_to_attach_file = create_raw_asset('User authorized to attach file', 'ATTACHMENT', @root) 44 44 @authorized_to_create_subasset = create_raw_asset('User authorized to create subasset', 'SUBASSET', @root)