Export playback links

export-playback-links.rb

# encoding: UTF-8

# Run with:
# ruby export-playback-links.rb | sudo tee ~/meus-links.csv

require 'csv'
require 'date'
require 'nokogiri'

def timestamp_to_date(ms)
    DateTime.strptime(ms.to_s,'%Q')
end

def format_date_time(d, timezone_s = "America/Sao_Paulo")
    timezone = TZInfo::Timezone.get(timezone_s)
    local_date = timezone.utc_to_local(d)
    local_date.strftime("%Y-%m-%d %H:%M:%S")
end

def record_id_to_timestamp(r)
    r.split("-")[1].to_i
end

records = []
`find /var/bigbluebutton/published/presentation/ -name metadata.xml`.split("\n").each do |filename|
    doc = Nokogiri::XML(File.read(filename), nil, "UTF-8") { |x| x.noblanks }

    xml_node = doc.at_xpath("/recording/id")
    record = {
      :record_id => xml_node.content
    }

    record[:timestamp] = record_id_to_timestamp(record[:record_id])
    record[:recorded_at] = timestamp_to_date(record[:timestamp])
    xml_node = doc.at_xpath('/recording/meta/meetingName')
    record[:name] = xml_node.nil? ? "" : xml_node.text
    xml_node = doc.at_xpath('/recording/meta/bbb-context')
    record[:course] = xml_node.nil? ? "" : xml_node.text
    xml_node = doc.at_xpath('/recording/playback/link')
    record[:link] = xml_node.nil? ? "" : xml_node.text
    records << record
end

records.sort_by!{ |record| record[:timestamp] }

s = CSV.generate({:col_sep => "\t"}) do |csv|
  csv << [ "date", "course", "name", "link" ]
  records.each do |record|
    csv << [ record[:recorded_at], record[:course], record[:name], record[:link] ]
  end
end

puts s