gen_factor_updates_sql

#!/usr/bin/env ruby

require 'csv'

file_path = ARGV[0]

CSV.readlines(file_path).each do |row|
  next if row[0] == 'Factor'

  table = {
    'Seat' => 'seats',
    'Power' => 'powers',
    'Wi-Fi' => 'wifis',
    'Layout' => 'layouts',
    'Fresh food' => 'foods',
    'Entertainment' => 'entertainments',
  }[row[0]]

  new_name = row[3]
  code = row[1]

  puts "update #{table} set name = #{new_name.inspect} where code = #{code.inspect};"
end