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
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