legacy_import.rake

legacy_import.rake

namespace :app_name do
  desc "Import data from old database"
  task :legacy_data_import => :environment do
    class LegacyDB < ActiveRecord::Base
      self.abstract_class = true
      establish_connection(:legacy)
    end
    
    #check for column named 'class', this will conflict with Rails, 
    #so we will change the column name
    LegacyDB.connection.execute("ALTER TABLE `database`.`table_name` CHANGE COLUMN `class` `the_class` VARCHAR(50) NULL DEFAULT NULL  ;") rescue  # if class_column_exists 

    module Legacy
      class TableName < LegacyDB       
      end
    end
    
    Legacy::TableName.each do |t|    
      puts t.the_class
    end
  end
end