list_projects_older_than_3_years.rb

# Find 3 year old mark
current_year = Date.today.year
year_start = ""
year_start << (Date.today.year - 3).to_s
year_start << "-" + Date.today.month.to_s + "-" + Date.today.day.to_s
year_start = Date.parse(year_start)

# Build csv list of project IDs last modified over 3 years ago
id_list = ""

# Loop through projects
Project.where("projects.created_at <= ?", year_start).each do |project|
  # Add to ID list
  if id_list == ""
    id_list << project.id.to_s
  else
    id_list << "," + project.id.to_s
  end

end

# Return list of IDs
puts "#{id_list}"