module ActiveRecord::ConnectionAdapters::MySQL::DatabaseStatements

Public Instance Methods

build_explain_clause(options = []) click to toggle source
# File lib/active_record/connection_adapters/mysql/database_statements.rb, line 36
def build_explain_clause(options = [])
  return "EXPLAIN" if options.empty?

  explain_clause = "EXPLAIN #{options.join(" ").upcase}"

  if analyze_without_explain? && explain_clause.include?("ANALYZE")
    explain_clause.sub("EXPLAIN ", "")
  else
    explain_clause
  end
end
explain(arel, binds = [], options = []) click to toggle source
# File lib/active_record/connection_adapters/mysql/database_statements.rb, line 27
def explain(arel, binds = [], options = [])
  sql     = build_explain_clause(options) + " " + to_sql(arel, binds)
  start   = Process.clock_gettime(Process::CLOCK_MONOTONIC)
  result  = internal_exec_query(sql, "EXPLAIN", binds)
  elapsed = Process.clock_gettime(Process::CLOCK_MONOTONIC) - start

  MySQL::ExplainPrettyPrinter.new.pp(result, elapsed)
end
high_precision_current_timestamp() click to toggle source
# File lib/active_record/connection_adapters/mysql/database_statements.rb, line 23
def high_precision_current_timestamp
  HIGH_PRECISION_CURRENT_TIMESTAMP
end

Private Instance Methods

analyze_without_explain?() click to toggle source

mariadb.com/kb/en/analyze-statement/

# File lib/active_record/connection_adapters/mysql/database_statements.rb, line 50
def analyze_without_explain?
  mariadb? && database_version >= "10.1.0"
end
combine_multi_statements(total_sql) click to toggle source
# File lib/active_record/connection_adapters/mysql/database_statements.rb, line 66
def combine_multi_statements(total_sql)
  total_sql.each_with_object([]) do |sql, total_sql_chunks|
    previous_packet = total_sql_chunks.last
    if max_allowed_packet_reached?(sql, previous_packet)
      total_sql_chunks << +sql
    else
      previous_packet << ";\n"
      previous_packet << sql
    end
  end
end
default_insert_value(column) click to toggle source
Calls superclass method
# File lib/active_record/connection_adapters/mysql/database_statements.rb, line 54
def default_insert_value(column)
  super unless column.auto_increment?
end
max_allowed_packet() click to toggle source
# File lib/active_record/connection_adapters/mysql/database_statements.rb, line 89
def max_allowed_packet
  @max_allowed_packet ||= show_variable("max_allowed_packet")
end
max_allowed_packet_reached?(current_packet, previous_packet) click to toggle source
# File lib/active_record/connection_adapters/mysql/database_statements.rb, line 78
def max_allowed_packet_reached?(current_packet, previous_packet)
  if current_packet.bytesize > max_allowed_packet
    raise ActiveRecordError,
      "Fixtures set is too large #{current_packet.bytesize}. Consider increasing the max_allowed_packet variable."
  elsif previous_packet.nil?
    true
  else
    (current_packet.bytesize + previous_packet.bytesize + 2) > max_allowed_packet
  end
end
returning_column_values(result) click to toggle source
Calls superclass method
# File lib/active_record/connection_adapters/mysql/database_statements.rb, line 58
def returning_column_values(result)
  if supports_insert_returning?
    result.rows.first
  else
    super
  end
end