addresses.csv

matt2csv.rb

require "json"

difficulties = {}
blockhashes = {}
errcnt = 0
lastblock = 0

data  = JSON.parse(File.read(ARGV[0]))
data.each do |block|
  blocknum = block.keys[0]
  lastblock = blocknum.to_i if blocknum.to_i > lastblock
  block[blocknum].each do |x| 
    if x.has_key?("result")
      x["result"].each do |k,v|
        unless v.empty?
          case k 
          when "DIFFICULTY"
            v.each do |addr,c|
              difficulties[addr] = 0 unless difficulties.has_key?(addr)
              difficulties[addr] += c.to_i
            end
          when "BLOCKHASH"
            v.each do |addr,c|
              blockhashes[addr] = 0 unless blockhashes.has_key?(addr)
              blockhashes[addr] += c.to_i
            end
          end
        end
      end
    end 
    errcnt += 1 if x.has_key?("error")
  end
end

fd = File.open("addresses.csv", "w+")
difficulties.each do |addr,count|
  fd.puts "DIFFICULTY,#{addr},#{count}"
end
blockhashes.each do |addr,count|
  fd.puts "BLOCKHASH,#{addr},#{count}"
end
puts "encountered #{errcnt} errors "
puts "lat block = #{lastblock}"