##方法一:find_by_sql
返回对象数组
Article.find_by_sql("select * from articles join categories on
articles.category_id=categories.id where articles.id=2")
结果:
[#<Article id: 2, user_id: 1, title: "111111111111", tags: "news,tag", content: "fdsafdsafdsafsfdsfsdfdsf", view_count: 5, star_count: 1, comments_count: 1, created_at: "2014-08-26 06:13:12", updated_at: "2014-08-26 06:13:12", source: "", category_id: 2>]
##方法二:connection.select_all
返回hash值
rs = Article.connection.select_all("select * from articles join categories on articles.category_id=categories.id where articles.id=2")
结果:
<ActiveRecord::Result:0x007f9554d102b8 @columns=
["id", "user_id", "title", "tags", "content", "view_count", "star_count",
"comments_count", "created_at", "updated_at", "source",
"category_id", "id", "name", "articles_count", "created_at",
"updated_at"], @rows=[[2, 1, "111111111111", "news,tag",
"fdsafdsafdsafsfdsfsdfdsf", 5, 1, 1,
2014-08-26 17:18:15 +0800, 2014-08-26 17:18:15 +0800, "",
2, 2, "新闻", 2, 2014-08-26 14:13:12 +0800, 2014-08-26 14:13:12 +0800]],
@hash_rows=nil, @column_types={}>
遍历:
rs.rows.each do |v|
puts v["name"]
end