From 199db8c8c006a5f3bcbbe2a32d39444a741c5843 Mon Sep 17 00:00:00 2001
From: Jon Leighton <j@jonathanleighton.com>
Date: Wed, 13 Oct 2010 00:05:04 +0100
Subject: Hook ThroughAssociationScope up to use the AliasTracker class

---
 .../associations/through_association_scope.rb      | 39 +++++++++++++++++-----
 1 file changed, 30 insertions(+), 9 deletions(-)

(limited to 'activerecord/lib/active_record')

diff --git a/activerecord/lib/active_record/associations/through_association_scope.rb b/activerecord/lib/active_record/associations/through_association_scope.rb
index 8c5b95439e..d73f35c2db 100644
--- a/activerecord/lib/active_record/associations/through_association_scope.rb
+++ b/activerecord/lib/active_record/associations/through_association_scope.rb
@@ -20,6 +20,7 @@ module ActiveRecord
       end
 
       # Build SQL conditions from attributes, qualified by table name.
+      # TODO: Conditions on joins
       def construct_conditions
         reflection = @reflection.through_reflection_chain.last
         conditions = construct_quoted_owner_attributes(reflection).map do |attr, value|
@@ -134,24 +135,44 @@ module ActiveRecord
         joins.join(" ")
       end
 
-      # TODO: Use the same aliasing strategy (and code?) as JoinAssociation (as this is the
-      # documented behaviour)
+      def alias_tracker
+        @alias_tracker ||= AliasTracker.new
+      end
+
       def table_aliases
         @table_aliases ||= begin
-          tally = {}
           @reflection.through_reflection_chain.inject({}) do |aliases, reflection|
-            if tally[reflection.table_name].nil?
-              tally[reflection.table_name] = 1
-              aliases[reflection] = reflection.quoted_table_name
+            table_alias = quote_table_name(alias_tracker.aliased_name_for(
+              reflection.table_name,
+              table_alias_for(reflection, reflection != @reflection)
+            ))
+            
+            if reflection.macro == :has_and_belongs_to_many
+              join_table_alias = quote_table_name(alias_tracker.aliased_name_for(
+                reflection.options[:join_table],
+                table_alias_for(reflection, true)
+              ))
+              
+              aliases[reflection] = [table_alias, join_table_alias]
             else
-              tally[reflection.table_name] += 1
-              aliased_table_name = reflection.table_name + "_#{tally[reflection.table_name]}"
-              aliases[reflection] = reflection.klass.connection.quote_table_name(aliased_table_name)
+              aliases[reflection] = table_alias
             end
+            
             aliases
           end
         end
       end
+      
+      def table_alias_for(reflection, join = false)
+        name = alias_tracker.pluralize(reflection.name)
+        name << "_#{@reflection.name}"
+        name << "_join" if join
+        name
+      end
+      
+      def quote_table_name(table_name)
+        @reflection.klass.connection.quote_table_name(table_name)
+      end
 
       # Construct attributes for associate pointing to owner.
       def construct_owner_attributes(reflection)
-- 
cgit v1.2.3