education CSV generator

gistfile1.txt

require 'csv'
namespace :education do
  desc "generate governance csv"
  task governance: [:environment] do
    # open new csv for writing
    CSV.open("school-governance-results.csv", "wb") do |csv|
      # iterating existing csv rows
      CSV.foreach('school-governance.csv') do |row|
        c = ContentItem.find_by title: row.join(',')
        arr = []
        arr << c.title
        arr << c.base_path
        arr << c.description
        csv << arr
      end
    end
  end

  desc "generate SEND csv"
  task send: [:environment] do
    # open new csv for writing
    CSV.open("send-results.csv", "wb") do |csv|
      # iterating existing csv rows
      CSV.foreach('send.csv') do |row|
        c = ContentItem.find_by title: row.join(',')
        arr = []
        arr << c.title
        arr << c.base_path
        arr << c.description
        csv << arr
      end
    end
  end
end