class ThinkingSphinx::ActiveRecord::DatabaseAdapters::MySQLAdapter

Public Instance Methods

boolean_value(value) click to toggle source
# File lib/thinking_sphinx/active_record/database_adapters/mysql_adapter.rb, line 4
def boolean_value(value)
  value ? 1 : 0
end
cast_to_string(clause) click to toggle source
# File lib/thinking_sphinx/active_record/database_adapters/mysql_adapter.rb, line 8
def cast_to_string(clause)
  "CAST(#{clause} AS char)"
end
cast_to_timestamp(clause) click to toggle source
# File lib/thinking_sphinx/active_record/database_adapters/mysql_adapter.rb, line 12
def cast_to_timestamp(clause)
  "UNIX_TIMESTAMP(#{clause})"
end
concatenate(clause, separator = ' ') click to toggle source
# File lib/thinking_sphinx/active_record/database_adapters/mysql_adapter.rb, line 16
def concatenate(clause, separator = ' ')
  "CONCAT_WS('#{separator}', #{clause})"
end
convert_nulls(clause, default = '') click to toggle source
# File lib/thinking_sphinx/active_record/database_adapters/mysql_adapter.rb, line 20
def convert_nulls(clause, default = '')
  "IFNULL(#{clause}, #{default})"
end
group_concatenate(clause, separator = ' ') click to toggle source
# File lib/thinking_sphinx/active_record/database_adapters/mysql_adapter.rb, line 24
def group_concatenate(clause, separator = ' ')
  "GROUP_CONCAT(DISTINCT #{clause} SEPARATOR '#{separator}')"
end
time_zone_query_pre() click to toggle source
# File lib/thinking_sphinx/active_record/database_adapters/mysql_adapter.rb, line 28
def time_zone_query_pre
  ["SET TIME_ZONE = '+0:00'"]
end
utf8_query_pre() click to toggle source
# File lib/thinking_sphinx/active_record/database_adapters/mysql_adapter.rb, line 32
def utf8_query_pre
  ['SET NAMES utf8']
end