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