From 6f05696ceb2fe21b735c428c96c228705fc4c6c5 Mon Sep 17 00:00:00 2001 From: David Heinemeier Hansson Date: Thu, 14 Jul 2005 07:18:26 +0000 Subject: Added :select option to find which can specify a different value than the default *, like find(:all, :select => "first_name, last_name"), if you either only want to select part of the columns or exclude columns otherwise included from a join #1338 [Stefan Kaes] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@1830 5ecf4fe2-1ee6-0310-87b1-e25e094e27de --- activerecord/lib/active_record/base.rb | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'activerecord/lib') diff --git a/activerecord/lib/active_record/base.rb b/activerecord/lib/active_record/base.rb index be64c1bbd3..936e61a688 100755 --- a/activerecord/lib/active_record/base.rb +++ b/activerecord/lib/active_record/base.rb @@ -315,6 +315,8 @@ module ActiveRecord #:nodoc: # * :joins: An SQL fragment for additional joins like "LEFT JOIN comments ON comments.post_id = id". (Rarely needed). # * :include: Names associations that should be loaded alongside using LEFT OUTER JOINs. The symbols named refer # to already defined associations. See eager loading under Associations. + # * :select: By default, this is * as in SELECT * FROM, but can be changed if you for example want to do a join, but not + # include the joined columns. # # Examples for find by id: # Person.find(1) # returns the object for ID = 1 @@ -739,7 +741,7 @@ module ActiveRecord #:nodoc: end def construct_finder_sql(options) - sql = "SELECT * FROM #{table_name} " + sql = "SELECT #{options[:select] || '*'} FROM #{table_name} " sql << " #{options[:joins]} " if options[:joins] add_conditions!(sql, options[:conditions]) sql << "ORDER BY #{options[:order]} " if options[:order] -- cgit v1.2.3