Convert hierarchical YAML from Clouditor to sequential CSV for further processing in spreadsheets. Each run segment on a separate line.

yaml2csv.rb

require 'yaml'

data = YAML.load_file("vm_records_export.yml")

puts "id,user,group,name,memory,vcpu,cpu,hostname,start_time,end_time,host_info.vcpu,host_info.memory,host_info.model"

data.each { |rec|
  rec["runtime"].each { |runtime|

    puts "#{rec["id"]},#{rec["user"]},#{rec["group"]},#{rec["name"]},#{rec["memory"]},#{rec["vcpu"]},#{rec["cpu"]},#{runtime["hostname"]},#{runtime["start_time"]},#{runtime["end_time"]},#{runtime["host_info"]["vcpu"]},#{runtime["host_info"]["memory"]},#{runtime["host_info"]["model"]}"
  }
}