Contents

module ThinkingSphinx
  class MysqlAdapter < AbstractAdapter
    def setup
      # Does MySQL actually need to do anything?
    end
    
    def sphinx_identifier
      "mysql"
    end
    
    def concatenate(clause, separator = ' ')
      "CONCAT_WS('#{separator}', #{clause})"
    end
    
    def group_concatenate(clause, separator = ' ')
      "GROUP_CONCAT(#{clause} SEPARATOR '#{separator}')"
    end
    
    def cast_to_string(clause)
      "CAST(#{clause} AS CHAR)"
    end
    
    def cast_to_datetime(clause)
      "UNIX_TIMESTAMP(#{clause})"
    end
    
    def cast_to_unsigned(clause)
      "CAST(#{clause} AS UNSIGNED)"
    end
    
    def convert_nulls(clause, default = '')
      default = "'#{default}'" if default.is_a?(String)
      
      "IFNULL(#{clause}, #{default})"
    end
    
    def boolean(value)
      value ? 1 : 0
    end
    
    def crc(clause)
      "CRC32(#{clause})"
    end
    
    def utf8_query_pre
      "SET NAMES utf8"
    end
    
    def time_difference(diff)
      "DATE_SUB(NOW(), INTERVAL #{diff} SECOND)"
    end
  end
end

Version data entries

6 entries across 6 versions & 4 rubygems

Version	Path
dpickett-thinking-sphinx-1.1.4	lib/thinking_sphinx/adapters/mysql_adapter.rb
freelancing-god-thinking-sphinx-1.1.3	lib/thinking_sphinx/adapters/mysql_adapter.rb
freelancing-god-thinking-sphinx-1.1.4	lib/thinking_sphinx/adapters/mysql_adapter.rb
freelancing-god-thinking-sphinx-1.1.5	lib/thinking_sphinx/adapters/mysql_adapter.rb
pixeltrix-thinking-sphinx-1.1.5	lib/thinking_sphinx/adapters/mysql_adapter.rb
sherpa99-thinking-sphinx-1.1.4	lib/thinking_sphinx/adapters/mysql_adapter.rb