module ActiveRecord::Import::AbstractAdapter::InstanceMethods

def after_import_synchronize( instances )
  instances.each { |e| e.reload }
end

def insert_many( sql, values, *args ) # :nodoc:
  # the number of inserts default
  number_of_inserts = 0

  base_sql,post_sql = if sql.is_a?( String )
    [ sql, '' ]
  elsif sql.is_a?( Array )
    [ sql.shift, sql.join( ' ' ) ]
  end

  sql_size = QUERY_OVERHEAD + base_sql.size + post_sql.size 
  # the number of bytes the requested insert statement values will take up
  values_in_bytes = self.class.sum_sizes( *values )

  # the number of bytes (commas) it will take to comma separate our values
  comma_separated_bytes = values.size-1

  # the total number of bytes required if this statement is one statement
  total_bytes = sql_size + values_in_bytes + comma_separated_bytes

  max = max_allowed_packet

  # if we can insert it all as one statement
  if NO_MAX_PACKET == max or total_bytes < max
    number_of_inserts += 1
    sql2insert = base_sql + values.join( ',' ) + post_sql
    insert( sql2insert, *args )
  else
    value_sets = self.class.get_insert_value_sets( values, sql_size, max )
    value_sets.each do |values|
      number_of_inserts += 1
      sql2insert = base_sql + values.join( ',' ) + post_sql
      insert( sql2insert, *args )
    end
  end
  number_of_inserts
end

def max_allowed_packet
  NO_MAX_PACKET
end

def multiple_value_sets_insert_sql(table_name, column_names, options) # :nodoc:
  "INSERT #{options[:ignore] ? 'IGNORE ':''}INTO #{table_name} (#{column_names.join(',')}) VALUES "
end  

def next_value_for_sequence(sequence_name)
  %{#{sequence_name}.nextval}
end

def post_sql_statements( table_name, options ) # :nodoc:
  post_sql_statements = []
  if options[:on_duplicate_key_update]
    post_sql_statements << sql_for_on_duplicate_key_update( table_name, options[:on_duplicate_key_update] )
  end
  #custom user post_sql
  post_sql_statements << options[:post_sql] if options[:post_sql]
  #with rollup
  post_sql_statements << rollup_sql if options[:rollup]
  post_sql_statements
end

def pre_sql_statements(options)
  sql = []
  sql << options[:pre_sql] if options[:pre_sql]
  sql << options[:command] if options[:command]
  sql << "IGNORE" if options[:ignore]
  #add keywords like IGNORE or DELAYED
  if options[:keywords].is_a?(Array)
    sql.concat(options[:keywords])
  elsif options[:keywords]
    sql << options[:keywords].to_s
  end
  sql
end

def values_sql_for_column_names_and_attributes( columns, array_of_attributes )   # :nodoc:
  values = []
  array_of_attributes.each do |arr|
    my_values = []
    arr.each_with_index do |val,j|
      my_values << quote( val, columns[j] )
    end
    values << my_values
  end   
  values_arr = values.map{ |arr| '(' + arr.join( ',' ) + ')' }
end