aboutsummaryrefslogtreecommitdiffstats
path: root/activerecord
diff options
context:
space:
mode:
authorDavid Heinemeier Hansson <david@loudthinking.com>2005-01-02 13:51:00 +0000
committerDavid Heinemeier Hansson <david@loudthinking.com>2005-01-02 13:51:00 +0000
commit959f362ac483bb12dab7d0207d973f1ebadcb033 (patch)
treeae37356f90480ee68a5d1fee3bcd1cac48ffc079 /activerecord
parentac8fd7dfb91eb0e554537e671eaf1615a1d19757 (diff)
downloadrails-959f362ac483bb12dab7d0207d973f1ebadcb033.tar.gz
rails-959f362ac483bb12dab7d0207d973f1ebadcb033.tar.bz2
rails-959f362ac483bb12dab7d0207d973f1ebadcb033.zip
Added find_all style to the new dynamic finders
git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@308 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
Diffstat (limited to 'activerecord')
-rw-r--r--activerecord/CHANGELOG4
-rwxr-xr-xactiverecord/lib/active_record/base.rb13
-rwxr-xr-xactiverecord/test/finder_test.rb8
-rw-r--r--activerecord/test/fixtures/topics.yml2
4 files changed, 22 insertions, 5 deletions
diff --git a/activerecord/CHANGELOG b/activerecord/CHANGELOG
index eee602faf2..4234e4cb1d 100644
--- a/activerecord/CHANGELOG
+++ b/activerecord/CHANGELOG
@@ -10,6 +10,10 @@
<tt>Person.find_first(["user_name = ? AND password = ?", user_name, password])</tt>, you just do
<tt>Person.find_by_user_name_and_password(user_name, password)</tt>.
+ While primarily a construct for easier find_firsts, it can also be used as a construct for find_all by using calls like
+ <tt>Payment.find_all_by_amount(50)</tt> that is turned into <tt>Payment.find_all(["amount = ?", 50])</tt>. This is something not as equally useful,
+ though, as it's not possible to specify the order in which the objects are returned.
+
* Added that Base#find takes an optional options hash, including :conditions. Base#find_on_conditions deprecated in favor of #find with :conditions #407 [bitsweat]
* Added a db2 adapter that only depends on the Ruby/DB2 bindings (http://raa.ruby-lang.org/project/ruby-db2/) #386 [Maik Schmidt]
diff --git a/activerecord/lib/active_record/base.rb b/activerecord/lib/active_record/base.rb
index cc61498a94..cf830563a3 100755
--- a/activerecord/lib/active_record/base.rb
+++ b/activerecord/lib/active_record/base.rb
@@ -108,6 +108,10 @@ module ActiveRecord #:nodoc:
# <tt>Person.find_first(["user_name = ? AND password = ?", user_name, password])</tt>, you just do
# <tt>Person.find_by_user_name_and_password(user_name, password)</tt>.
#
+ # While primarily a construct for easier find_firsts, it can also be used as a construct for find_all by using calls like
+ # <tt>Payment.find_all_by_amount(50)</tt> that is turned into <tt>Payment.find_all(["amount = ?", 50])</tt>. This is something not as equally useful,
+ # though, as it's not possible to specify the order in which the objects are returned.
+ #
# == Saving arrays, hashes, and other non-mappeable objects in text columns
#
# Active Record can serialize any object in text columns using YAML. To do so, you must specify this with a call to the class method +serialize+.
@@ -648,15 +652,16 @@ module ActiveRecord #:nodoc:
end
# Enables dynamic finders like find_by_user_name(user_name) and find_by_user_name_and_password(user_name, password) that are turned into
- # find_first(["user_name = ?", user_name]) and find_first(["user_name = ? AND password = ?", user_name, password]) respectively.
+ # find_first(["user_name = ?", user_name]) and find_first(["user_name = ? AND password = ?", user_name, password]) respectively. Also works
+ # for find_all, but using find_all_by_amount(50) that are turned into find_all(["amount = ?", 50]).
def method_missing(method_id, *arguments)
method_name = method_id.id2name
- if method_name =~ /find_by_([_a-z]+)/
- attributes = $1.split("_and_")
+ if method_name =~ /find_(all_by|by)_([_a-z]+)/
+ finder, attributes = ($1 == "all_by" ? :find_all : :find_first), $2.split("_and_")
attributes.each { |attr_name| super unless column_methods_hash[attr_name.intern] }
conditions = attributes.collect { |attr_name| "#{attr_name} = ? "}.join(" AND ")
- find_first([conditions, *arguments])
+ send(finder, [conditions, *arguments])
else
super
end
diff --git a/activerecord/test/finder_test.rb b/activerecord/test/finder_test.rb
index fdbbc68e98..723166c8ad 100755
--- a/activerecord/test/finder_test.rb
+++ b/activerecord/test/finder_test.rb
@@ -178,6 +178,14 @@ class FinderTest < Test::Unit::TestCase
assert_nil Topic.find_by_title_and_author_name("The First Topic", "Mary")
end
+ def test_find_all_by_one_attribute
+ topics = Topic.find_all_by_content("Have a nice day")
+ assert_equal 2, topics.size
+ assert topics.include?(@topics["first"].find)
+
+ assert_equal [], Topic.find_all_by_title("The First Topic!!")
+ end
+
protected
def bind(statement, *vars)
if vars.first.is_a?(Hash)
diff --git a/activerecord/test/fixtures/topics.yml b/activerecord/test/fixtures/topics.yml
index 5571bd914c..f4942acb6c 100644
--- a/activerecord/test/fixtures/topics.yml
+++ b/activerecord/test/fixtures/topics.yml
@@ -15,7 +15,7 @@ second:
title: The Second Topic's of the day
author_name: Mary
written_on: 2003-07-15 15:28:00
- content: Have a great day!
+ content: Have a nice day
approved: 1
replies_count: 2
parent_id: 1