Class: ActiveRecord::Associations::HasManyAssociation

Inherits:

AssociationCollection

• Object
• AssociationCollection
• ActiveRecord::Associations::HasManyAssociation

Defined in:

lib/composite_primary_keys/associations.rb

Overview

:nodoc:

Direct Known Subclasses

HasManyThroughAssociation

Instance Method Summary

• #construct_sql ⇒ Object
• #delete_records(records) ⇒ Object

Instance Method Details

#construct_sql ⇒ Object

# File 'lib/composite_primary_keys/associations.rb', line 313

def construct_sql
  case
    when @reflection.options[:finder_sql]
      @finder_sql = interpolate_sql(@reflection.options[:finder_sql])

    when @reflection.options[:as]
      @finder_sql = 
        "#{@reflection.klass.table_name}.#{@reflection.options[:as]}_id = #{@owner.quoted_id} AND " + 
        "#{@reflection.klass.table_name}.#{@reflection.options[:as]}_type = #{@owner.class.quote_value(@owner.class.base_class.name.to_s)}"
      @finder_sql << " AND (#{conditions})" if conditions
        
    else
      @finder_sql = full_columns_equals(@reflection.klass.table_name, @reflection.primary_key_name, @owner.quoted_id)
      @finder_sql << " AND (#{conditions})" if conditions
  end

  if @reflection.options[:counter_sql]
    @counter_sql = interpolate_sql(@reflection.options[:counter_sql])
  elsif @reflection.options[:finder_sql]
    # replace the SELECT clause with COUNT(*), preserving any hints within /* ... */
    @reflection.options[:counter_sql] = @reflection.options[:finder_sql].sub(/SELECT (\/\*.*?\*\/ )?(.*)\bFROM\b/im) { "SELECT #{$1}COUNT(*) FROM" }
    @counter_sql = interpolate_sql(@reflection.options[:counter_sql])
  else
    @counter_sql = @finder_sql
  end
end

#delete_records(records) ⇒ Object

# File 'lib/composite_primary_keys/associations.rb', line 340

def delete_records(records)
  if @reflection.options[:dependent]
	records.each { |r| r.destroy }
  else
	field_names = @reflection.primary_key_name.split(',')
	field_names.collect! {|n| n + " = NULL"}
	records.each do |r|
	  where_class = nil
	  
	  if r.quoted_id.include?(',')
	    where_class = [@reflection.klass.primary_key, r.quoted_id].transpose.map {|pair| "(#{pair[0]} = #{pair[1]})"}.join(" AND ")
	  else
	    where_class = @reflection.klass.primary_key + ' = ' +  r.quoted_id
	  end
	  
	  @reflection.klass.update_all(  field_names.join(',') , where_class)
	end
  end
end