active?()
click to toggle source
CONNECTION MANAGEMENT ====================================
def active?
if @connection.respond_to?(:stat)
@connection.stat
else
@connection.query 'select 1'
end
if @connection.respond_to?(:errno)
@connection.errno.zero?
else
true
end
rescue Mysql::Error
false
end
add_column(table_name, column_name, type, options = {})
click to toggle source
def add_column(table_name, column_name, type, options = {})
add_column_sql = "ALTER TABLE #{quote_table_name(table_name)} ADD #{quote_column_name(column_name)} #{type_to_sql(type, options[:limit], options[:precision], options[:scale])}"
add_column_options!(add_column_sql, options)
add_column_position!(add_column_sql, options)
execute(add_column_sql)
end
add_column_position!(sql, options)
click to toggle source
def add_column_position!(sql, options)
if options[:first]
sql << " FIRST"
elsif options[:after]
sql << " AFTER #{quote_column_name(options[:after])}"
end
end
case_sensitive_equality_operator()
click to toggle source
def case_sensitive_equality_operator
"= BINARY"
end
change_column_null(table_name, column_name, null, default = nil)
click to toggle source
def change_column_null(table_name, column_name, null, default = nil)
column = column_for(table_name, column_name)
unless null || default.nil?
execute("UPDATE #{quote_table_name(table_name)} SET #{quote_column_name(column_name)}=#{quote(default)} WHERE #{quote_column_name(column_name)} IS NULL")
end
change_column table_name, column_name, column.sql_type, :null => null
end
charset()
click to toggle source
Returns the database character set.
def charset
show_variable 'character_set_database'
end
collation()
click to toggle source
Returns the database collation strategy.
def collation
show_variable 'collation_database'
end
create_database(name, options = {})
click to toggle source
Create a new MySQL database with optional :charset and
:collation. Charset defaults to utf8.
Example:
create_database 'charset_test', :charset => 'latin1', :collation => 'latin1_bin'
create_database 'matt_development'
create_database 'matt_development', :charset => :big5
def create_database(name, options = {})
if options[:collation]
execute "CREATE DATABASE `#{name}` DEFAULT CHARACTER SET `#{options[:charset] || 'utf8'}` COLLATE `#{options[:collation]}`"
else
execute "CREATE DATABASE `#{name}` DEFAULT CHARACTER SET `#{options[:charset] || 'utf8'}`"
end
end
create_savepoint()
click to toggle source
def create_savepoint
execute("SAVEPOINT #{current_savepoint_name}")
end
current_database()
click to toggle source
def current_database
select_value 'SELECT DATABASE() as db'
end
disconnect!()
click to toggle source
def disconnect!
@connection.close rescue nil
end
drop_table(table_name, options = {})
click to toggle source
def drop_table(table_name, options = {})
super(table_name, options)
end
limited_update_conditions(where_sql, quoted_table_name, quoted_primary_key)
click to toggle source
def limited_update_conditions(where_sql, quoted_table_name, quoted_primary_key)
where_sql
end
primary_key(table)
click to toggle source
Returns just a table’s primary key
def primary_key(table)
pk_and_sequence = pk_and_sequence_for(table)
pk_and_sequence && pk_and_sequence.first
end
quote(value, column = nil)
click to toggle source
QUOTING ==================================================
def quote(value, column = nil)
if value.kind_of?(String) && column && column.type == :binary && column.class.respond_to?(:string_to_binary)
s = column.class.string_to_binary(value).unpack("H*")[0]
"x'#{s}'"
elsif value.kind_of?(BigDecimal)
value.to_s("F")
else
super
end
end
quoted_false()
click to toggle source
def quoted_false
QUOTED_FALSE
end
quoted_true()
click to toggle source
def quoted_true
QUOTED_TRUE
end
reconnect!()
click to toggle source
def reconnect!
disconnect!
connect
end
release_savepoint()
click to toggle source
def release_savepoint
execute("RELEASE SAVEPOINT #{current_savepoint_name}")
end
rename_table(table_name, new_name)
click to toggle source
def rename_table(table_name, new_name)
execute "RENAME TABLE #{quote_table_name(table_name)} TO #{quote_table_name(new_name)}"
end
reset!()
click to toggle source
def reset!
if @connection.respond_to?(:change_user)
@connection.change_user(@config[:username], @config[:password], @config[:database])
configure_connection
end
end
rollback_to_savepoint()
click to toggle source
def rollback_to_savepoint
execute("ROLLBACK TO SAVEPOINT #{current_savepoint_name}")
end
select_rows(sql, name = nil)
click to toggle source
DATABASE STATEMENTS ======================================
def select_rows(sql, name = nil)
@connection.query_with_result = true
result = execute(sql, name)
rows = []
result.each { |row| rows << row }
result.free
@connection.more_results && @connection.next_result
rows
end
show_variable(name)
click to toggle source
SHOW VARIABLES LIKE ‘name’
def show_variable(name)
variables = select_all("SHOW VARIABLES LIKE '#{name}'")
variables.first['Value'] unless variables.empty?
end
table_exists?(name)
click to toggle source
def table_exists?(name)
return true if super
name = name.to_s
schema, table = name.split('.', 2)
unless table
table = schema
schema = nil
end
tables(nil, schema).include? table
end
type_to_sql(type, limit = nil, precision = nil, scale = nil)
click to toggle source
Maps logical Rails types to MySQL-specific
data types.
def type_to_sql(type, limit = nil, precision = nil, scale = nil)
return super unless type.to_s == 'integer'
case limit
when 1; 'tinyint'
when 2; 'smallint'
when 3; 'mediumint'
when nil, 4, 11; 'int(11)'
when 5..8; 'bigint'
else raise(ActiveRecordError, "No integer type has byte size #{limit}")
end
end