Contents

class AddDisplayNameToReportsTable < ActiveRecord::Migration[4.2]

	class Report < ApplicationRecord
	end

	def self.up

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

		# Migrate to have a default name.
		
		Report.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

	def self.down
		remove_column :reports, :name
	end

end

Version data entries

23 entries across 23 versions & 2 rubygems

Version	Path
metasploit_data_models-6.0.6	db/migrate/20111011110000_add_display_name_to_reports_table.rb
wg-metasploit_data_models-4.1.4.02	db/migrate/20111011110000_add_display_name_to_reports_table.rb
metasploit_data_models-6.0.5	db/migrate/20111011110000_add_display_name_to_reports_table.rb
metasploit_data_models-6.0.4	db/migrate/20111011110000_add_display_name_to_reports_table.rb
metasploit_data_models-6.0.3	db/migrate/20111011110000_add_display_name_to_reports_table.rb
metasploit_data_models-6.0.2	db/migrate/20111011110000_add_display_name_to_reports_table.rb
metasploit_data_models-6.0.1	db/migrate/20111011110000_add_display_name_to_reports_table.rb
metasploit_data_models-6.0.0	db/migrate/20111011110000_add_display_name_to_reports_table.rb
metasploit_data_models-5.0.6	db/migrate/20111011110000_add_display_name_to_reports_table.rb
metasploit_data_models-5.0.5	db/migrate/20111011110000_add_display_name_to_reports_table.rb
metasploit_data_models-5.0.4	db/migrate/20111011110000_add_display_name_to_reports_table.rb
metasploit_data_models-5.0.3	db/migrate/20111011110000_add_display_name_to_reports_table.rb
metasploit_data_models-5.0.2	db/migrate/20111011110000_add_display_name_to_reports_table.rb
metasploit_data_models-5.0.1	db/migrate/20111011110000_add_display_name_to_reports_table.rb
metasploit_data_models-5.0.0	db/migrate/20111011110000_add_display_name_to_reports_table.rb
metasploit_data_models-4.1.4	db/migrate/20111011110000_add_display_name_to_reports_table.rb
metasploit_data_models-4.1.3	db/migrate/20111011110000_add_display_name_to_reports_table.rb
metasploit_data_models-4.1.2	db/migrate/20111011110000_add_display_name_to_reports_table.rb
metasploit_data_models-4.1.1	db/migrate/20111011110000_add_display_name_to_reports_table.rb
metasploit_data_models-4.1.0	db/migrate/20111011110000_add_display_name_to_reports_table.rb