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 6
def boolean_value(value)
  value ? 1 : 0
end
cast_to_bigint(clause) click to toggle source
# File lib/thinking_sphinx/active_record/database_adapters/mysql_adapter.rb, line 10
def cast_to_bigint(clause)
  "CAST(#{clause} AS UNSIGNED INTEGER)"
end
cast_to_string(clause) click to toggle source
# File lib/thinking_sphinx/active_record/database_adapters/mysql_adapter.rb, line 14
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 18
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 22
def concatenate(clause, separator = ' ')
  "CONCAT_WS('#{separator}', #{clause})"
end
convert_blank(clause, default = '') click to toggle source
# File lib/thinking_sphinx/active_record/database_adapters/mysql_adapter.rb, line 30
def convert_blank(clause, default = '')
  "COALESCE(NULLIF(#{clause}, ''), #{default})"
end
convert_nulls(clause, default = '') click to toggle source
# File lib/thinking_sphinx/active_record/database_adapters/mysql_adapter.rb, line 26
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 34
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 38
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 42
def utf8_query_pre
  ["SET NAMES #{settings['mysql_encoding']}"]
end

Private Instance Methods

settings() click to toggle source
# File lib/thinking_sphinx/active_record/database_adapters/mysql_adapter.rb, line 48
def settings
  ThinkingSphinx::Configuration.instance.settings
end