rdb.rb

class RDB
  attr_reader :headers, :data

  def initialize(f)
    @file    = File.open(f).readlines
    @data    = @file.reject {|q| q =~ /^#/ }
    @headers = @data.shift.chomp.split("\t")
    @data.shift # remove schema line
    @data.map! {|q| q.chomp.split("\t")}
  end

  def row_hash(idx)
    Hash[@headers.zip(@data[idx])]
  end

  def [](idx)
    row_hash(idx)
  end

  def each
    0.upto(@data.length - 1).each do |idx|
      yield row_hash(idx)
    end
  end
end