Dump a list database tables to CSV via ActiveRecord models.

db_export.rake

namespace :db do

  desc 'export the shit'
  task :export => [:environment] do
    require 'csv'

    ActiveRecordize('Brewery', 'Beer', 'Style', 'Category', 'Geocode') do |model|
      CSV.open("#{model.table_name}.csv", 'wb') do |csv|
        csv << model.column_names
        model.find_each { |m| csv << m.attributes.values }
      end
    end
  end

  def ActiveRecordize(*model_names)
    model_names.map do |klass|
      model = Kernel.const_set(klass, Class.new(ActiveRecord::Base))
      yield model
    end
  end

end