Rails使用SQL语句查询

开发十年，就只剩下这套Java开发体系了 >>>   

##方法一：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