module ActiveRecord::ConnectionAdapters::MySQL::DatabaseStatements

Public Instance Methods

exec_delete(sql, name, binds) click to toggle source
# File lib/active_record/connection_adapters/mysql/database_statements.rb, line 61
def exec_delete(sql, name, binds)
  if without_prepared_statement?(binds)
    execute_and_free(sql, name) { @connection.affected_rows }
  else
    exec_stmt_and_free(sql, name, binds) { |stmt| stmt.affected_rows }
  end
end
Also aliased as: exec_update
exec_query(sql, name = 'SQL', binds = [], prepare: false) click to toggle source
# File lib/active_record/connection_adapters/mysql/database_statements.rb, line 49
def exec_query(sql, name = 'SQL', binds = [], prepare: false)
  if without_prepared_statement?(binds)
    execute_and_free(sql, name) do |result|
      ActiveRecord::Result.new(result.fields, result.to_a) if result
    end
  else
    exec_stmt_and_free(sql, name, binds, cache_stmt: prepare) do |_, result|
      ActiveRecord::Result.new(result.fields, result.to_a) if result
    end
  end
end
exec_update(sql, name, binds)
Alias for: exec_delete
execute(sql, name = nil) click to toggle source

Executes the SQL statement in the context of this connection.

Calls superclass method
# File lib/active_record/connection_adapters/mysql/database_statements.rb, line 39
def execute(sql, name = nil)
  if @connection
    # make sure we carry over any changes to ActiveRecord::Base.default_timezone that have been
    # made since we established the connection
    @connection.query_options[:database_timezone] = ActiveRecord::Base.default_timezone
  end

  super
end
select_all(arel, name = nil, binds = [], preparable: nil) click to toggle source

Returns an ActiveRecord::Result instance.

Calls superclass method
# File lib/active_record/connection_adapters/mysql/database_statements.rb, line 6
def select_all(arel, name = nil, binds = [], preparable: nil)
  result = if ExplainRegistry.collect? && prepared_statements
    unprepared_statement { super }
  else
    super
  end
  @connection.next_result while @connection.more_results?
  result
end
select_one(arel, name = nil, binds = []) click to toggle source

Returns a record hash with the column names as keys and column values as values.

# File lib/active_record/connection_adapters/mysql/database_statements.rb, line 18
def select_one(arel, name = nil, binds = [])
  arel, binds = binds_from_relation(arel, binds)
  @connection.query_options.merge!(as: :hash)
  select_result(to_sql(arel, binds), name, binds) do |result|
    @connection.next_result while @connection.more_results?
    result.first
  end
ensure
  @connection.query_options.merge!(as: :array)
end
select_rows(sql, name = nil, binds = []) click to toggle source

Returns an array of arrays containing the field values. Order is the same as that returned by columns.

# File lib/active_record/connection_adapters/mysql/database_statements.rb, line 31
def select_rows(sql, name = nil, binds = [])
  select_result(sql, name, binds) do |result|
    @connection.next_result while @connection.more_results?
    result.to_a
  end
end

Protected Instance Methods

last_inserted_id(result) click to toggle source
# File lib/active_record/connection_adapters/mysql/database_statements.rb, line 72
def last_inserted_id(result)
  @connection.last_id
end

Private Instance Methods

exec_stmt_and_free(sql, name, binds, cache_stmt: false) { |stmt, result| ... } click to toggle source
# File lib/active_record/connection_adapters/mysql/database_statements.rb, line 86
def exec_stmt_and_free(sql, name, binds, cache_stmt: false)
  if @connection
    # make sure we carry over any changes to ActiveRecord::Base.default_timezone that have been
    # made since we established the connection
    @connection.query_options[:database_timezone] = ActiveRecord::Base.default_timezone
  end

  type_casted_binds = binds.map { |attr| type_cast(attr.value_for_database) }

  log(sql, name, binds) do
    if cache_stmt
      cache = @statements[sql] ||= {
        stmt: @connection.prepare(sql)
      }
      stmt = cache[:stmt]
    else
      stmt = @connection.prepare(sql)
    end

    begin
      result = stmt.execute(*type_casted_binds)
    rescue Mysql2::Error => e
      if cache_stmt
        @statements.delete(sql)
      else
        stmt.close
      end
      raise e
    end

    ret = yield stmt, result
    result.free if result
    stmt.close unless cache_stmt
    ret
  end
end
select_result(sql, name = nil, binds = []) { |result| ... } click to toggle source
# File lib/active_record/connection_adapters/mysql/database_statements.rb, line 78
def select_result(sql, name = nil, binds = [])
  if without_prepared_statement?(binds)
    execute_and_free(sql, name) { |result| yield result }
  else
    exec_stmt_and_free(sql, name, binds, cache_stmt: true) { |_, result| yield result }
  end
end