small mysql exec

MySQL.rb

class MySQL
  def initialize(database)
    @database = database.to_s
  end

  def exec(sql)
    if sql =~ /\.sql$/ and File.exists? sql
      sql = File.read(sql, encoding: Encoding::UTF_8)
    end

    rows = []
    # user and password are included in my.cnf
    cmd = %{mysql --defaults-extra-file=my.cnf #{@database} -e "#{sql} \\G"}
    `#{cmd}`.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

MySQL.new("foo").exec("select id,name from users").each do|u|
  puts u['name']
end