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_bigint(clause)
click to toggle source
# File lib/thinking_sphinx/active_record/database_adapters/mysql_adapter.rb, line 8 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 12 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 16 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 20 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 28 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 24 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 32 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 36 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 40 def utf8_query_pre ['SET NAMES utf8'] end