ActiveRecord exexute sample

gistfile1.rb

/* データ
> select * from hoge;
+------+------+
| fuga |  foo |
+------+------+
|    1 |    2 |
|    3 |    4 |
|    5 |    6 |
+------+------+
*/

results = ActiveRecord::Base.connection.execute(<<"SQL")
SELECT * FROM hoge
SQL

results.each do |result|
  p result.class
end
/*
[1, 2]
[3, 4]
[5, 6]
*/

results.each(:as => :hash) do |result|
  p result.class
end
/*
{"fuga"=>1, "foo"=>2}
{"fuga"=>3, "foo"=>4}
{"fuga"=>5, "foo"=>6}
*/

p results.to_a
# [[1, 2], [3, 4], [5, 6]]

p results.to_a(:as => :hash)
# [{"fuga"=>1, "foo"=>2}, {"fuga"=>3, "foo"=>4}, {"fuga"=>5, "foo"=>6}]