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