From ac8fd7dfb91eb0e554537e671eaf1615a1d19757 Mon Sep 17 00:00:00 2001
From: David Heinemeier Hansson <david@loudthinking.com>
Date: Sun, 2 Jan 2005 13:31:00 +0000
Subject: Added dynamic attribute-based finders as a cleaner way of getting
 objects by simple queries without turning to SQL.

git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@307 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
---
 activerecord/test/finder_test.rb | 34 ++++++++++++++++++++++------------
 1 file changed, 22 insertions(+), 12 deletions(-)

(limited to 'activerecord/test')

diff --git a/activerecord/test/finder_test.rb b/activerecord/test/finder_test.rb
index 74ea11c944..fdbbc68e98 100755
--- a/activerecord/test/finder_test.rb
+++ b/activerecord/test/finder_test.rb
@@ -4,14 +4,10 @@ require 'fixtures/topic'
 require 'fixtures/entrant'
 
 class FinderTest < Test::Unit::TestCase
-  def setup
-    @company_fixtures = create_fixtures("companies")
-    @topic_fixtures   = create_fixtures("topics")
-    @entrant_fixtures = create_fixtures("entrants")
-  end
+  fixtures :companies, :topics, :entrants
   
   def test_find
-    assert_equal(@topic_fixtures["first"]["title"], Topic.find(1).title)
+    assert_equal(@topics["first"]["title"], Topic.find(1).title)
   end
   
   def test_find_by_array_of_one_id
@@ -21,7 +17,7 @@ class FinderTest < Test::Unit::TestCase
   
   def test_find_by_ids
     assert_equal(2, Topic.find(1, 2).length)
-    assert_equal(@topic_fixtures["second"]["title"], Topic.find([ 2 ]).first.title)
+    assert_equal(@topics["second"]["title"], Topic.find([ 2 ]).first.title)
   end
 
   def test_find_by_ids_missing_one
@@ -34,33 +30,33 @@ class FinderTest < Test::Unit::TestCase
     entrants = Entrant.find_all nil, "id ASC", 2
     
     assert_equal(2, entrants.size)
-    assert_equal(@entrant_fixtures["first"]["name"], entrants.first.name)
+    assert_equal(@entrants["first"]["name"], entrants.first.name)
   end
 
   def test_find_all_with_prepared_limit_and_offset
     entrants = Entrant.find_all nil, "id ASC", ["? OFFSET ?", 2, 1]
     
     assert_equal(2, entrants.size)
-    assert_equal(@entrant_fixtures["second"]["name"], entrants.first.name)
+    assert_equal(@entrants["second"]["name"], entrants.first.name)
   end
 
   def test_find_with_entire_select_statement
     topics = Topic.find_by_sql "SELECT * FROM topics WHERE author_name = 'Mary'"
     
     assert_equal(1, topics.size)
-    assert_equal(@topic_fixtures["second"]["title"], topics.first.title)
+    assert_equal(@topics["second"]["title"], topics.first.title)
   end
   
   def test_find_with_prepared_select_statement
     topics = Topic.find_by_sql ["SELECT * FROM topics WHERE author_name = ?", "Mary"]
     
     assert_equal(1, topics.size)
-    assert_equal(@topic_fixtures["second"]["title"], topics.first.title)
+    assert_equal(@topics["second"]["title"], topics.first.title)
   end
   
   def test_find_first
     first = Topic.find_first "title = 'The First Topic'"
-    assert_equal(@topic_fixtures["first"]["title"], first.title)
+    assert_equal(@topics["first"]["title"], first.title)
   end
   
   def test_find_first_failing
@@ -168,6 +164,20 @@ class FinderTest < Test::Unit::TestCase
     assert_equal(2, Entrant.count_by_sql(["SELECT COUNT(*) FROM entrants WHERE id > ?", 1]))
   end
 
+  def test_find_by_one_attribute
+    assert_equal @topics["first"].find, Topic.find_by_title("The First Topic")
+    assert_nil Topic.find_by_title("The First Topic!")
+  end
+
+  def test_find_by_one_missing_attribute
+    assert_raises(NoMethodError) { Topic.find_by_undertitle("The First Topic!") }
+  end
+
+  def test_find_by_two_attributes
+    assert_equal @topics["first"].find, Topic.find_by_title_and_author_name("The First Topic", "David")
+    assert_nil Topic.find_by_title_and_author_name("The First Topic", "Mary")
+  end
+
   protected
     def bind(statement, *vars)
       if vars.first.is_a?(Hash)
-- 
cgit v1.2.3