Changeset 483

Show
Ignore:
Timestamp:
01/24/07 17:02:57 (2 years ago)
Author:
timo
Message:

Now the branch's migration renames some data (action_keys.name and data_permission_profiles.type).

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • branches/workorder_report_rename/db/migrate/021_version_one_dot_two_tables.rb

    r473 r483  
    4444 
    4545  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   
    4651    rename_columns('report', 'form', @@report_columns) 
    4752    rename_tables('report', 'form', @@report_tables) 
     
    160165    rename_tables('report', 'form', @@report_tables, true) 
    161166    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    } 
    162180  end 
    163181 
     
    180198  # pairs by replacing `from` in the column name with `to`. 
    181199  # 
    182   # If `revert` is set to `true`, the process is reverted, and the tables are 
     200  # If `revert` is set to `true`, the process is reverted, and the columns are 
    183201  # renamed by replacing `to` with `from`. 
    184202  def self.rename_columns(from, to, tables_and_cols, revert=false) 
  • branches/workorder_report_rename/test/unit/asset_test.rb

    r469 r483  
    4040    @authorized_to_edit = create_raw_asset('User authorized to edit', 'EDIT', @root) 
    4141    @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) 
    4343    @authorized_to_attach_file = create_raw_asset('User authorized to attach file', 'ATTACHMENT', @root) 
    4444    @authorized_to_create_subasset = create_raw_asset('User authorized to create subasset', 'SUBASSET', @root) 

© 2004-2007 Norfello Oy All Rights Reserved