Method: MySQL#fetch_hash

Defined in:
lib/DrbDB/MyMultiSQL/jdbc.rb,
lib/DrbDB/MyMultiSQL/mysql-ruby.rb

#fetch_hash(res, with_table = false) ⇒ Object 



54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
 
# File 'lib/DrbDB/MyMultiSQL/jdbc.rb', line 54

def fetch_hash(res,with_table=false)
  begin
  data=Array.new
  unless res.nil? 
    while res.next do
      md=res.meta_data
      row=Hash.new
      i=1
      while i<=md.column_count do
        header=if with_table then 
          md.table_name(i)+"."+md.column_label(i)
          else 
          md.column_label(i)
        end
        row[header]=res.getString(md.column_label(i))
        i+=1
      end
      data.push(row)
    end
  end
  return data
  rescue =>e
    eerror("metadata:#{md.inspect}\nrow:#{row.inspect}\nheader:#{header.inspect},colnum:#{i}")
    eerror("error preparing the result:#{e}\n #{e.backtrace.join("\n\t")}")
  end
end