mysql select を配列でかえす

gistfile1.rb

class MySQL
  def initialize(database, password, user = 'root')
    @database = database
    @password = password
    @user     = user
  end

  def select(sql)
    rows = []
    `mysql -u#{@user} -p#{@password} #{@database} -e "#{sql} \\G"`.strip.split(/\*\*\*\*.*/).each do |result|
      next if result == ''
      h = {}
      result.strip.split("\n").each do |line|
        column, value = line.split(":")
        h[column.strip.to_sym] = value.strip
      end
      rows << h
    end
    rows
  end
end