diff options
author | Anton Kalyaev <anton.kalyaev@gmail.com> | 2013-05-14 10:15:32 +0400 |
---|---|---|
committer | Anton Kalyaev <anton.kalyaev@gmail.com> | 2013-05-14 10:16:56 +0400 |
commit | ddf07d21834f4ad88c25334829348f5e4000fea0 (patch) | |
tree | 7929bc4b491f45c6371f7480c028d532387f1969 | |
parent | 87d71b02b85a44ce461e533666ef5f0e43a46531 (diff) | |
download | rails-ddf07d21834f4ad88c25334829348f5e4000fea0.tar.gz rails-ddf07d21834f4ad88c25334829348f5e4000fea0.tar.bz2 rails-ddf07d21834f4ad88c25334829348f5e4000fea0.zip |
improved doc for ActiveRecord#find_by_sql method (Refs #10599) [ci skip]
-rw-r--r-- | activerecord/lib/active_record/querying.rb | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/activerecord/lib/active_record/querying.rb b/activerecord/lib/active_record/querying.rb index f78ccb01aa..3d85898c41 100644 --- a/activerecord/lib/active_record/querying.rb +++ b/activerecord/lib/active_record/querying.rb @@ -14,7 +14,7 @@ module ActiveRecord # Executes a custom SQL query against your database and returns all the results. The results will # be returned as an array with columns requested encapsulated as attributes of the model you call # this method from. If you call <tt>Product.find_by_sql</tt> then the results will be returned in - # a Product object with the attributes you specified in the SQL query. + # a +Product+ object with the attributes you specified in the SQL query. # # If you call a complicated SQL query which spans multiple tables the columns specified by the # SELECT will be attributes of the model, whether or not they are columns of the corresponding @@ -29,9 +29,10 @@ module ActiveRecord # Post.find_by_sql "SELECT p.title, c.author FROM posts p, comments c WHERE p.id = c.post_id" # # => [#<Post:0x36bff9c @attributes={"title"=>"Ruby Meetup", "first_name"=>"Quentin"}>, ...] # - # # You can use the same string replacement techniques as you can with ActiveRecord#find + # You can use the same string replacement techniques as you can with <tt>ActiveRecord::QueryMethods#where</tt>: + # # Post.find_by_sql ["SELECT title FROM posts WHERE author = ? AND created > ?", author_id, start_date] - # # => [#<Post:0x36bff9c @attributes={"title"=>"The Cheap Man Buys Twice"}>, ...] + # Post.find_by_sql ["SELECT body FROM comments WHERE author = :user_id OR approved_by = :user_id", { :user_id => user_id }] def find_by_sql(sql, binds = []) result_set = connection.select_all(sanitize_sql(sql), "#{name} Load", binds) column_types = {} |