Script to facilitate in exporting LightHouse tickets to CSV format for import elsewhere

traverse_and_merge.rb

require 'csv'

#Get a collection of all the directories contained in the CWD
directories = Dir.entries(Dir.pwd)

#iterate
directories.each do |dir|
  
  #if its a directory, then traverse into it
  if File.directory?(dir) then
    puts File.directory?(dir) 
    Dir.chdir(dir)

    #find the json export - we dont need to bother with the misformatted CSV
    if File.exists?('ticket.json') then
      
      #read contents
      file = File.open('ticket.json')
      contents = file.read
     
      #create an array to dump into a CSV file
      content = contents['ticket']['assigned'] << '|' << contents['ticket']['title'] << '|' << contents['ticket']['updated_at'] << '|' << contents['ticket']['body']
      
      #Traverse back to ^1 parent, and dump contents into a CSV
      File.open("../../tickets.csv", 'a+') { |f| f.write(content << "\n")  }
    end
       Dir.chdir("../")
   end
end