module ActiveRecord::ConnectionAdapters::MySQL::DatabaseStatements
Public Instance Methods
exec_delete(sql, name = nil, binds = [])
click to toggle source
# File lib/active_record/connection_adapters/mysql/database_statements.rb, line 43 def exec_delete(sql, name = nil, 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 31 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 23 def execute(sql, name = nil) # 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 super end
Private Instance Methods
default_insert_value(column)
click to toggle source
# File lib/active_record/connection_adapters/mysql/database_statements.rb, line 53 def default_insert_value(column) Arel.sql("DEFAULT") unless column.auto_increment? end
discard_remaining_results()
click to toggle source
# File lib/active_record/connection_adapters/mysql/database_statements.rb, line 61 def discard_remaining_results @connection.next_result while @connection.more_results? end
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 101 def exec_stmt_and_free(sql, name, binds, cache_stmt: false) # 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 type_casted_binds = type_casted_binds(binds) log(sql, name, binds, type_casted_binds) do if cache_stmt cache = @statements[sql] ||= { stmt: @connection.prepare(sql) } stmt = cache[:stmt] else stmt = @connection.prepare(sql) end begin result = ActiveSupport::Dependencies.interlock.permit_concurrent_loads do stmt.execute(*type_casted_binds) end 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
last_inserted_id(result)
click to toggle source
# File lib/active_record/connection_adapters/mysql/database_statements.rb, line 57 def last_inserted_id(result) @connection.last_id end
multi_statements_enabled?(flags)
click to toggle source
# File lib/active_record/connection_adapters/mysql/database_statements.rb, line 69 def multi_statements_enabled?(flags) if flags.is_a?(Array) flags.include?("MULTI_STATEMENTS") else (flags & Mysql2::Client::MULTI_STATEMENTS) != 0 end end
supports_set_server_option?()
click to toggle source
# File lib/active_record/connection_adapters/mysql/database_statements.rb, line 65 def supports_set_server_option? @connection.respond_to?(:set_server_option) end
with_multi_statements() { || ... }
click to toggle source
# File lib/active_record/connection_adapters/mysql/database_statements.rb, line 77 def with_multi_statements previous_flags = @config[:flags] unless multi_statements_enabled?(previous_flags) if supports_set_server_option? @connection.set_server_option(Mysql2::Client::OPTION_MULTI_STATEMENTS_ON) else @config[:flags] = Mysql2::Client::MULTI_STATEMENTS reconnect! end end yield ensure unless multi_statements_enabled?(previous_flags) if supports_set_server_option? @connection.set_server_option(Mysql2::Client::OPTION_MULTI_STATEMENTS_OFF) else @config[:flags] = previous_flags reconnect! end end end