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