Script Template: Import legacy CSV data into Rails 1.x, 2.x app

legacy_csv_data_import_template.rb

#!/usr/bin/env ruby
require File.dirname(__FILE__) + '/../config/boot'
require File.dirname(__FILE__) + '/../config/environment'
require 'csv'

# http://gist.github.com/184784
class CSV::Reader::WithHeader < CSV::Reader
  def self.parse(str_or_readable, fs=',', &blk)
    headers = nil
    super str_or_readable, fs do |row|
      if headers
        blk.call Hash[*headers.zip(row).flatten]
      else
        headers = row
      end
    end
  end
end

# http://gist.github.com/184842
def import(data, &blk)
  return nil if data.blank?
  blk = proc {|x| x} unless block_given?
  blk[data]
end

ActiveRecord::Base.transaction do
  CSV::Reader::WithHeader.parse(File.open(ARGV.first)) do |row|
    # TODO: Actually create necessary objects
  end
end