csv_import_to_migration.rb

require 'csv'

namespace :csv do
  desc "generates a migration file from column names from the CSV headers"
  task create_migration: :environment do
    def headers_from_CSV (filename)
      csv_header_array = CSV.read(filename, headers: true).headers
      return csv_header_array.map { |col_a| col_a.strip.downcase.gsub(' ', '_').gsub('.', '_') }
    end

    file = Rails.root.join('db', 'excel_seeds.csv')
    new_col_command = headers_from_CSV(file).join(' ')
    if (new_col_command.length != 0)
      sh "rails generate migration AddAttributesToPlaces #{new_col_command}"
    end
  end
end