boolean_value(value)
click to toggle source
def boolean_value(value)
value ? 1 : 0
end
cast_to_string(clause)
click to toggle source
def cast_to_string(clause)
"CAST(#{clause} AS char)"
end
cast_to_timestamp(clause)
click to toggle source
def cast_to_timestamp(clause)
"UNIX_TIMESTAMP(#{clause})"
end
concatenate(clause, separator = ' ')
click to toggle source
def concatenate(clause, separator = ' ')
"CONCAT_WS('#{separator}', #{clause})"
end
convert_nulls(clause, default = '')
click to toggle source
def convert_nulls(clause, default = '')
"IFNULL(#{clause}, #{default})"
end
group_concatenate(clause, separator = ' ')
click to toggle source
def group_concatenate(clause, separator = ' ')
"GROUP_CONCAT(DISTINCT #{clause} SEPARATOR '#{separator}')"
end
time_zone_query_pre()
click to toggle source
def time_zone_query_pre
["SET TIME_ZONE = '+0:00'"]
end
utf8_query_pre()
click to toggle source
def utf8_query_pre
['SET NAMES utf8']
end