Sha256: e37c74ca2605410e6d93af7f0e1af67feb5c47278f685357fd1778e942082720
Contents?: true
Size: 1.92 KB
Versions: 7
Compression:
Stored size: 1.92 KB
Contents
# Copyright (c) 2011 - 2013, SoundCloud Ltd., Rany Keddo, Tobias Bielohlawek, Tobias
# Schmidt
module Lhm
module SqlHelper
extend self
def annotation
'/* large hadron migration */'
end
def idx_name(table_name, cols)
column_names = column_definition(cols).map(&:first)
"index_#{ table_name }_on_#{ column_names.join('_and_') }"
end
def idx_spec(cols)
column_definition(cols).map do |name, length|
"`#{ name }`#{ length }"
end.join(', ')
end
def version_string
row = connection.select_one("show variables like 'version'")
value = struct_key(row, 'Value')
row[value]
end
def tagged(statement)
"#{ statement } #{ SqlHelper.annotation }"
end
private
def column_definition(cols)
Array(cols).map do |column|
column.to_s.match(/`?([^\(\s]+)`?\s*(\([^\)]+\))?/).captures
end
end
# Older versions of MySQL contain an atomic rename bug affecting bin
# log order. Affected versions extracted from bug report:
#
# http://bugs.mysql.com/bug.php?id=39675
#
# More Info: http://dev.mysql.com/doc/refman/5.5/en/metadata-locking.html
def supports_atomic_switch?
major, minor, tiny = version_string.split('.').map(&:to_i)
case major
when 4 then return false if minor and minor < 2
when 5
case minor
when 0 then return false if tiny and tiny < 52
when 1 then return false
when 4 then return false if tiny and tiny < 4
when 5 then return false if tiny and tiny < 3
end
when 6
case minor
when 0 then return false if tiny and tiny < 11
end
end
true
end
def struct_key(struct, key)
keys = if struct.is_a? Hash
struct.keys
else
struct.members
end
keys.find { |k| k.to_s.downcase == key.to_s.downcase }
end
end
end
Version data entries
7 entries across 7 versions & 1 rubygems