Class: ActiveRecord::Associations::ClassMethods::JoinDependency::JoinAssociation

Inherits:
JoinBase
  • Object
show all
Defined in:
lib/active_record/associations.rb

Overview

:nodoc:

Instance Attribute Summary collapse

Attributes inherited from JoinBase

#active_record, #table_joins

Instance Method Summary collapse

Methods inherited from JoinBase

#aliased_primary_key, #column_names_with_alias, #extract_record, #instantiate, #record_id

Constructor Details

#initialize(reflection, join_dependency, parent = nil) ⇒ JoinAssociation

Returns a new instance of JoinAssociation.



1456
1457
1458
1459
1460
1461
1462
1463
1464
1465
1466
1467
1468
1469
1470
1471
1472
1473
1474
1475
1476
1477
1478
1479
1480
1481
1482
1483
1484
1485
1486
1487
1488
1489
1490
1491
1492
1493
1494
 
# File 'lib/active_record/associations.rb', line 1456

def initialize(reflection, join_dependency, parent = nil)
  reflection.check_validity!
  if reflection.options[:polymorphic]
    raise EagerLoadPolymorphicError.new(reflection)
  end

  super(reflection.klass)
  @parent             = parent
  @reflection         = reflection
  @aliased_prefix     = "t#{ join_dependency.joins.size }"
  @aliased_table_name = table_name #.tr('.', '_') # start with the table name, sub out any .'s
  @parent_table_name  = parent.active_record.table_name

  if !parent.table_joins.blank? && parent.table_joins.to_s.downcase =~ %r{join(\s+\w+)?\s+#{aliased_table_name.downcase}\son}
    join_dependency.table_aliases[aliased_table_name] += 1
  end
  
  unless join_dependency.table_aliases[aliased_table_name].zero?
    # if the table name has been used, then use an alias
    @aliased_table_name = active_record.connection.table_alias_for "#{pluralize(reflection.name)}_#{parent_table_name}"
    table_index = join_dependency.table_aliases[aliased_table_name]
    join_dependency.table_aliases[aliased_table_name] += 1
    @aliased_table_name = @aliased_table_name[0..active_record.connection.table_alias_length-3] + "_#{table_index+1}" if table_index > 0
  else
    join_dependency.table_aliases[aliased_table_name] += 1
  end
  
  if reflection.macro == :has_and_belongs_to_many || (reflection.macro == :has_many && reflection.options[:through])
    @aliased_join_table_name = reflection.macro == :has_and_belongs_to_many ? reflection.options[:join_table] : reflection.through_reflection.klass.table_name
    unless join_dependency.table_aliases[aliased_join_table_name].zero?
      @aliased_join_table_name = active_record.connection.table_alias_for "#{pluralize(reflection.name)}_#{parent_table_name}_join"
      table_index = join_dependency.table_aliases[aliased_join_table_name]
      join_dependency.table_aliases[aliased_join_table_name] += 1
      @aliased_join_table_name = @aliased_join_table_name[0..active_record.connection.table_alias_length-3] + "_#{table_index+1}" if table_index > 0
    else
      join_dependency.table_aliases[aliased_join_table_name] += 1
    end
  end
end

Instance Attribute Details

#aliased_join_table_name ⇒ Object (readonly)

Returns the value of attribute aliased_join_table_name.



1453
1454
1455
 
# File 'lib/active_record/associations.rb', line 1453

def aliased_join_table_name
  @aliased_join_table_name
end

#aliased_prefix ⇒ Object (readonly)

Returns the value of attribute aliased_prefix.



1453
1454
1455
 
# File 'lib/active_record/associations.rb', line 1453

def aliased_prefix
  @aliased_prefix
end

#aliased_table_name ⇒ Object (readonly)

Returns the value of attribute aliased_table_name.



1453
1454
1455
 
# File 'lib/active_record/associations.rb', line 1453

def aliased_table_name
  @aliased_table_name
end

#parent ⇒ Object (readonly)

Returns the value of attribute parent.



1453
1454
1455
 
# File 'lib/active_record/associations.rb', line 1453

def parent
  @parent
end

#parent_table_name ⇒ Object (readonly)

Returns the value of attribute parent_table_name.



1453
1454
1455
 
# File 'lib/active_record/associations.rb', line 1453

def parent_table_name
  @parent_table_name
end

#reflection ⇒ Object (readonly)

Returns the value of attribute reflection.



1453
1454
1455
 
# File 'lib/active_record/associations.rb', line 1453

def reflection
  @reflection
end

Instance Method Details

#association_join ⇒ Object 



1496
1497
1498
1499
1500
1501
1502
1503
1504
1505
1506
1507
1508
1509
1510
1511
1512
1513
1514
1515
1516
1517
1518
1519
1520
1521
1522
1523
1524
1525
1526
1527
1528
1529
1530
1531
1532
1533
1534
1535
1536
1537
1538
1539
1540
1541
1542
1543
1544
1545
1546
1547
1548
1549
1550
1551
1552
1553
1554
1555
1556
1557
1558
1559
1560
1561
1562
1563
1564
1565
1566
1567
1568
1569
1570
1571
1572
1573
1574
1575
1576
1577
1578
1579
1580
1581
1582
1583
1584
1585
1586
1587
1588
1589
1590
1591
1592
1593
1594
1595
1596
1597
1598
1599
1600
1601
1602
1603
1604
1605
1606
1607
1608
1609
1610
1611
1612
1613
1614
 
# File 'lib/active_record/associations.rb', line 1496

def association_join
  join = case reflection.macro
    when :has_and_belongs_to_many
      " LEFT OUTER JOIN %s ON %s.%s = %s.%s " % [
         table_alias_for(options[:join_table], aliased_join_table_name),
         aliased_join_table_name,
         options[:foreign_key] || reflection.active_record.to_s.classify.foreign_key,
         parent.aliased_table_name, reflection.active_record.primary_key] +
      " LEFT OUTER JOIN %s ON %s.%s = %s.%s " % [
         table_name_and_alias, aliased_table_name, klass.primary_key,
         aliased_join_table_name, options[:association_foreign_key] || klass.table_name.classify.foreign_key
         ]
    when :has_many, :has_one
      case
        when reflection.macro == :has_many && reflection.options[:through]
          through_conditions = through_reflection.options[:conditions] ? "AND #{interpolate_sql(sanitize_sql(through_reflection.options[:conditions]))}" : ''

          jt_foreign_key = jt_as_extra = jt_source_extra = jt_sti_extra = nil
          first_key = second_key = as_extra = nil
          
          if through_reflection.options[:as] # has_many :through against a polymorphic join
            jt_foreign_key = through_reflection.options[:as].to_s + '_id'
            jt_as_extra = " AND %s.%s = %s" % [
                aliased_join_table_name, reflection.active_record.connection.quote_column_name(through_reflection.options[:as].to_s + '_type'), 
                klass.quote_value(parent.active_record.base_class.name)
            ]
          else
            jt_foreign_key = through_reflection.primary_key_name
          end
          
          case source_reflection.macro
          when :has_many
            if source_reflection.options[:as]
              first_key   = "#{source_reflection.options[:as]}_id"
              second_key  = options[:foreign_key] || primary_key
              as_extra    = " AND %s.%s = %s" % [
                aliased_table_name, reflection.active_record.connection.quote_column_name("#{source_reflection.options[:as]}_type"), 
                klass.quote_value(source_reflection.active_record.base_class.name)
              ]
            else
              first_key   = through_reflection.klass.base_class.to_s.classify.foreign_key
              second_key  = options[:foreign_key] || primary_key
            end
            
            unless through_reflection.klass.descends_from_active_record?
              jt_sti_extra = " AND %s.%s = %s" % [
                aliased_join_table_name,
                reflection.active_record.connection.quote_column_name(through_reflection.active_record.inheritance_column),
                through_reflection.klass.quote_value(through_reflection.klass.name.demodulize)]
            end
          when :belongs_to
            first_key = primary_key
            if reflection.options[:source_type]
              second_key = source_reflection.association_foreign_key
              jt_source_extra = " AND %s.%s = %s" % [
                  aliased_join_table_name, reflection.active_record.connection.quote_column_name(reflection.source_reflection.options[:foreign_type]),
                  klass.quote_value(reflection.options[:source_type])
              ]
            else
              second_key = source_reflection.options[:foreign_key] || klass.to_s.classify.foreign_key
            end
          end
          
          " LEFT OUTER JOIN %s ON (%s.%s = %s.%s%s%s%s) " % [
            table_alias_for(through_reflection.klass.table_name, aliased_join_table_name),
            parent.aliased_table_name, reflection.active_record.connection.quote_column_name(parent.primary_key),
            aliased_join_table_name, reflection.active_record.connection.quote_column_name(jt_foreign_key), 
            jt_as_extra, jt_source_extra, jt_sti_extra
          ] +
          " LEFT OUTER JOIN %s ON (%s.%s = %s.%s%s) " % [
            table_name_and_alias, 
            aliased_table_name, reflection.active_record.connection.quote_column_name(first_key),
            aliased_join_table_name, reflection.active_record.connection.quote_column_name(second_key),
            as_extra
          ]
        
        when reflection.macro == :has_many && reflection.options[:as]
          " LEFT OUTER JOIN %s ON %s.%s = %s.%s AND %s.%s = %s" % [
            table_name_and_alias,
            aliased_table_name, "#{reflection.options[:as]}_id",
            parent.aliased_table_name, parent.primary_key,
            aliased_table_name, "#{reflection.options[:as]}_type",
            klass.quote_value(parent.active_record.base_class.name)
          ]
        when reflection.macro == :has_one && reflection.options[:as]
          " LEFT OUTER JOIN %s ON %s.%s = %s.%s AND %s.%s = %s " % [
            table_name_and_alias,
            aliased_table_name, "#{reflection.options[:as]}_id",
            parent.aliased_table_name, parent.primary_key,
            aliased_table_name, "#{reflection.options[:as]}_type",
            klass.quote_value(reflection.active_record.base_class.name)
          ]
        else
          foreign_key = options[:foreign_key] || reflection.active_record.name.foreign_key
          " LEFT OUTER JOIN %s ON %s.%s = %s.%s " % [
            table_name_and_alias,
            aliased_table_name, foreign_key,
            parent.aliased_table_name, parent.primary_key
          ]
      end
    when :belongs_to
      " LEFT OUTER JOIN %s ON %s.%s = %s.%s " % [
         table_name_and_alias, aliased_table_name, reflection.klass.primary_key,
         parent.aliased_table_name, options[:foreign_key] || klass.to_s.foreign_key
        ]
    else
      ""
  end || ''
  join << %(AND %s.%s = %s ) % [
    aliased_table_name, 
    reflection.active_record.connection.quote_column_name(klass.inheritance_column), 
    klass.quote_value(klass.name.demodulize)] unless klass.descends_from_active_record?

  [through_reflection, reflection].each do |ref|
    join << "AND #{interpolate_sql(sanitize_sql(ref.options[:conditions]))} " if ref && ref.options[:conditions]
  end

  join
end