module Searchable

Constants

VERSION

Public Class Methods

searchable_language() click to toggle source
# File lib/textacular.rb, line 11
def self.searchable_language
  'english'
end
version() click to toggle source
# File lib/textacular/version.rb, line 4
def self.version
  VERSION
end

Public Instance Methods

Private Instance Methods

advanced_condition_string(table_name, column, search_term) click to toggle source
# File lib/textacular.rb, line 109
def advanced_condition_string(table_name, column, search_term)
  "to_tsvector(#{quoted_language}, #{table_name}.#{column}::text) @@ to_tsquery(#{quoted_language}, #{search_term}::text)"
end
advanced_similarities_and_conditions(parsed_query_hash) click to toggle source
# File lib/textacular.rb, line 96
def advanced_similarities_and_conditions(parsed_query_hash)
  parsed_query_hash.inject([[], []]) do |(similarities, conditions), query_args|
    similarities << advanced_similarity_string(*query_args)
    conditions << advanced_condition_string(*query_args)

    [similarities, conditions]
  end
end
advanced_similarity_string(table_name, column, search_term) click to toggle source
# File lib/textacular.rb, line 105
def advanced_similarity_string(table_name, column, search_term)
  "COALESCE(ts_rank(to_tsvector(#{quoted_language}, #{table_name}.#{column}::text), to_tsquery(#{quoted_language}, #{search_term}::text)), 0)"
end
assemble_query(similarities, conditions, exclusive, rank_alias) click to toggle source
# File lib/textacular.rb, line 148
def assemble_query(similarities, conditions, exclusive, rank_alias)
  rank_alias ||= 'rank' + rand(100000000000000000).to_s
  rank = connection.quote_column_name(rank_alias)

  select(Arel.sql("#{quoted_table_name + '.*,' if select_values.empty?} #{similarities.join(" + ")} AS #{rank}")).
    where(conditions.join(exclusive ? " AND " : " OR ")).
    order(Arel.sql("#{rank} DESC"))
end
basic_condition_string(table_name, column, search_term) click to toggle source
# File lib/textacular.rb, line 92
def basic_condition_string(table_name, column, search_term)
  "to_tsvector(#{quoted_language}, #{table_name}.#{column}::text) @@ plainto_tsquery(#{quoted_language}, #{search_term}::text)"
end
basic_similarities_and_conditions(parsed_query_hash) click to toggle source
# File lib/textacular.rb, line 79
def basic_similarities_and_conditions(parsed_query_hash)
  parsed_query_hash.inject([[], []]) do |(similarities, conditions), query_args|
    similarities << basic_similarity_string(*query_args)
    conditions << basic_condition_string(*query_args)

    [similarities, conditions]
  end
end
basic_similarity_string(table_name, column, search_term) click to toggle source
# File lib/textacular.rb, line 88
def basic_similarity_string(table_name, column, search_term)
  "COALESCE(ts_rank(to_tsvector(#{quoted_language}, #{table_name}.#{column}::text), plainto_tsquery(#{quoted_language}, #{search_term}::text)), 0)"
end
fuzzy_condition_string(table_name, column, search_term) click to toggle source
# File lib/textacular.rb, line 126
def fuzzy_condition_string(table_name, column, search_term)
  "(#{table_name}.#{column}::text % #{search_term})"
end
fuzzy_similarities_and_conditions(parsed_query_hash) click to toggle source
# File lib/textacular.rb, line 113
def fuzzy_similarities_and_conditions(parsed_query_hash)
  parsed_query_hash.inject([[], []]) do |(similarities, conditions), query_args|
    similarities << fuzzy_similarity_string(*query_args)
    conditions << fuzzy_condition_string(*query_args)

    [similarities, conditions]
  end
end
fuzzy_similarity_string(table_name, column, search_term) click to toggle source
# File lib/textacular.rb, line 122
def fuzzy_similarity_string(table_name, column, search_term)
  "COALESCE(similarity(#{table_name}.#{column}::text, #{search_term}), 0)"
end
munge_exclusive_and_query(exclusive, query) click to toggle source
# File lib/textacular.rb, line 49
def munge_exclusive_and_query(exclusive, query)
  unless query.is_a?(Hash)
    exclusive = false
    query = searchable_columns.inject({}) do |terms, column|
      terms.merge column => query.to_s
    end
  end

  [exclusive, query]
end
parse_query_hash(query, table_name = quoted_table_name) click to toggle source
# File lib/textacular.rb, line 60
def parse_query_hash(query, table_name = quoted_table_name)
  table_name = connection.quote_table_name(table_name)

  results = []

  query.each do |column_or_table, search_term|
    if search_term.is_a?(Hash)
      results += parse_query_hash(search_term, column_or_table)
    else
      column = connection.quote_column_name(column_or_table)
      search_term = connection.quote Helper.normalize(search_term)

      results << [table_name, column, search_term]
    end
  end

  results
end
quoted_language() click to toggle source
# File lib/textacular.rb, line 169
def quoted_language
  @quoted_language ||= connection.quote(searchable_language)
end
searchable_columns() click to toggle source
# File lib/textacular.rb, line 165
def searchable_columns
  columns.select {|column| [:string, :text].include? column.type }.map(&:name)
end
searchable_language() click to toggle source
# File lib/textacular.rb, line 173
def searchable_language
  Textacular.searchable_language
end
select_values() click to toggle source
# File lib/textacular.rb, line 157
def select_values
  if ActiveRecord::VERSION::MAJOR >= 4
    all.select_values
  else
    scoped.select_values
  end
end
web_condition_string(table_name, column, search_term) click to toggle source
# File lib/textacular.rb, line 144
def web_condition_string(table_name, column, search_term)
  "to_tsvector(#{quoted_language}, #{table_name}.#{column}::text) @@ websearch_to_tsquery(#{quoted_language}, #{search_term}::text)"
end
web_similarities_and_conditions(parsed_query_hash) click to toggle source
# File lib/textacular.rb, line 131
def web_similarities_and_conditions(parsed_query_hash)
  parsed_query_hash.inject([[], []]) do |(similarities, conditions), query_args|
    similarities << web_similarity_string(*query_args)
    conditions << web_condition_string(*query_args)

    [similarities, conditions]
  end
end
web_similarity_string(table_name, column, search_term) click to toggle source
# File lib/textacular.rb, line 140
def web_similarity_string(table_name, column, search_term)
  "COALESCE(ts_rank(to_tsvector(#{quoted_language}, #{table_name}.#{column}::text), websearch_to_tsquery(#{quoted_language}, #{search_term}::text)), 0)"
end