Class: AddDisplayNameToReportsTable

Inherits:
ActiveRecord::Migration
  • Object
show all
Defined in:
db/migrate/20111011110000_add_display_name_to_reports_table.rb

Defined Under Namespace

Classes: Report

Class Method Summary collapse

Class Method Details

.down ⇒ Object 



20
21
22
 
# File 'db/migrate/20111011110000_add_display_name_to_reports_table.rb', line 20

def self.down
  remove_column :reports, :name
end

.up ⇒ Object 



6
7
8
9
10
11
12
13
14
15
16
17
18
 
# File 'db/migrate/20111011110000_add_display_name_to_reports_table.rb', line 6

def self.up

  add_column :reports, :name, :string, :limit => 63

  # Migrate to have a default name.
  
  Report.find(:all).each do |report|
    rtype = report.rtype.to_s =~ /^([A-Z0-9]+)\x2d/i ? $1 : "AUDIT"
    default_name = rtype[0,57].downcase.capitalize + "-" + report.id.to_s[0,5]
    report.name = default_name
    report.save
  end
end