Portal Teacher info

console_script.rb

require 'csv'
csv = CSV.open("teachers4.csv","w")

ts = Portal::Teacher.includes(:user).all

data = ts.map do |t|
  students = 0
  [
    t.first_name,
    t.last_name,
    t.email,
    t.created_at,
    t.user.current_sign_in_at,
    (t.school.district.name rescue ""),
    (t.school.name rescue ""),
    (t.school.state rescue ""),
    t.clazzes.map {|c| students += c.students.count; c.name }.join('; '),
    students
  ]
}

csv << ["First name","Last name","Email","Signed up","Last login","District","School","State","Classes","Total students"]
data.each {|t| csv << t }
csv.close