Mad Ruby

airtable_to_handbook.rb

require 'csv'

expectations = []

CSV.foreach("#{__dir__}/expectations2.csv") do |line|
  expectations << {
    expectation: line[0],
    roles: line[4]&.split(','),
    description: line[1]
  }
end


roles = {}

expectations.each do |expectation|
  expectation[:roles].each do |role|
    roles[role] ||= []
    e = expectation.dup
    e.delete(:roles)
    roles[role] << e
  end
end

class String
  def underscore
    self.gsub(/::/, '/').
    gsub(/([A-Z]+)([A-Z][a-z])/,'\1_\2').
    gsub(/([a-z\d])([A-Z])/,'\1_\2').
    tr("-", "_").
    downcase
  end

  def safe_up
    self.gsub("'", "\\'")
  end
end

classes = []
roles.each_with_index do |(role, expectations)|
  template = "class #{role.gsub(' ', '')}Expectations < JobSpec::Role::Expectations\n"
  pp expectations
  expectations.each do |expectation|
    name = expectation[:expectation]&.safe_up
    description = expectation[:description]&.safe_up
    template += "  expected '#{name}',\n    '#{description}'\n\n"
  end
  classes << { code: template.strip + "\nend", file_name: (role.gsub(' ', '')+'Expectations').underscore+'.rb' }
end

classes.each do |clazz|
  File.open("#{__dir__}/out/#{clazz[:file_name]}", 'w') do |file|
    file << clazz[:code]
  end
end

pp classes