Added :count option to pagination that'll make it possible for the ActiveRecord::Base.count call to using something else than * for the count. Especially important for count queries using DISTINCT #3839 [skaes]. Added :select option to Base.count that'll allow you to select something else than * to be counted on. Especially important for count queries using DISTINCT (closes #3839) [skaes].

git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@3620 5ecf4fe2-1ee6-0310-87b1-e25e094e27de

3 files changed, 27 insertions, 3 deletions

diff --git a/actionpack/CHANGELOG b/actionpack/CHANGELOG
index 25fe245388..3336572189 100644
--- a/actionpack/CHANGELOG
+++ b/actionpack/CHANGELOG
@@ -1,5 +1,7 @@
 *SVN*
 
+* Added :count option to pagination that'll make it possible for the ActiveRecord::Base.count call to using something else than * for the count. Especially important for count queries using DISTINCT #3839 [skaes]
+
 * Update script.aculo.us to V1.5.2 [Thomas Fuchs]
 
 * Added element and collection proxies to RJS [DHH]. Examples:
diff --git a/actionpack/lib/action_controller/pagination.rb b/actionpack/lib/action_controller/pagination.rb
index 2f1a1d985c..630b244a0e 100644
--- a/actionpack/lib/action_controller/pagination.rb
+++ b/actionpack/lib/action_controller/pagination.rb
@@ -71,6 +71,7 @@ module ActionController
         :order      => nil,
         :join       => nil,
         :joins      => nil,
+        :count      => nil,
         :include    => nil,
         :select     => nil,
         :parameter  => 'page'
@@ -119,6 +120,10 @@ module ActionController
     #                        and Model.count
     # <tt>:include</tt>::    optional eager loading parameter passed to Model.find(:all, *params)
     #                        and Model.count
+    # <tt>:select</tt>::     :select parameter passed to Model.find(:all, *params)
+    #
+    # <tt>:count</tt>::      parameter passed as :select option to Model.count(*params)
+    #
     def paginate(collection_id, options={})
       Pagination.validate_options!(collection_id, options, true)
       paginator_and_collection_for(collection_id, options)
@@ -165,7 +170,9 @@ module ActionController
     # custom counter.
     def count_collection_for_pagination(model, options)
       model.count(:conditions => options[:conditions],
-                  :joins => options[:join] || options[:joins], :include => options[:include])
+                  :joins => options[:join] || options[:joins],
+                  :include => options[:include],
+                  :select => options[:count])
     end
     
     # Returns a collection of items for the given +model+ and +options[conditions]+,
diff --git a/actionpack/test/activerecord/pagination_test.rb b/actionpack/test/activerecord/pagination_test.rb
index 00ae78614f..386300c086 100644
--- a/actionpack/test/activerecord/pagination_test.rb
+++ b/actionpack/test/activerecord/pagination_test.rb
@@ -64,6 +64,14 @@ class PaginationTest < ActiveRecordTestCase
                                              :conditions => 'project_id=1')        
       render :nothing => true
     end
+     
+    def paginate_with_join_and_count
+      @developer_pages, @developers = paginate(:developers, 
+                                             :join => 'd LEFT JOIN developers_projects ON d.id = developers_projects.developer_id',
+                                             :conditions => 'project_id=1',
+                                             :count => "d.id")        
+      render :nothing => true
+    end
     
     def rescue_errors(e) raise e end
 
@@ -133,9 +141,16 @@ class PaginationTest < ActiveRecordTestCase
   
   def test_paginate_with_join_and_conditions
     get :paginate_with_joins
-    expected = assigns(:topics)
+    expected = assigns(:developers)
     get :paginate_with_join
-    assert_equal expected, assigns(:topics)      
+    assert_equal expected, assigns(:developers)
+  end
+  
+  def test_paginate_with_join_and_count
+    get :paginate_with_joins
+    expected = assigns(:developers)
+    get :paginate_with_join_and_count
+    assert_equal expected, assigns(:developers)
   end
   
   def test_paginate_with_include_and_order