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
advanced_search(query = "", exclusive = true, rank_alias = nil)
click to toggle source
# File lib/textacular.rb, line 26 def advanced_search(query = "", exclusive = true, rank_alias = nil) exclusive, query = munge_exclusive_and_query(exclusive, query) parsed_query_hash = parse_query_hash(query) similarities, conditions = advanced_similarities_and_conditions(parsed_query_hash) assemble_query(similarities, conditions, exclusive, rank_alias) end
basic_search(query = "", exclusive = true, rank_alias = nil)
click to toggle source
# File lib/textacular.rb, line 19 def basic_search(query = "", exclusive = true, rank_alias = nil) exclusive, query = munge_exclusive_and_query(exclusive, query) parsed_query_hash = parse_query_hash(query) similarities, conditions = basic_similarities_and_conditions(parsed_query_hash) assemble_query(similarities, conditions, exclusive, rank_alias) end
fuzzy_search(query = '', exclusive = true, rank_alias = nil)
click to toggle source
# File lib/textacular.rb, line 33 def fuzzy_search(query = '', exclusive = true, rank_alias = nil) exclusive, query = munge_exclusive_and_query(exclusive, query) parsed_query_hash = parse_query_hash(query) similarities, conditions = fuzzy_similarities_and_conditions(parsed_query_hash) assemble_query(similarities, conditions, exclusive, rank_alias) end
search(query = "", exclusive = true, rank_alias = nil)
click to toggle source
# File lib/textacular.rb, line 15 def search(query = "", exclusive = true, rank_alias = nil) basic_search(query, exclusive, rank_alias) end
web_search(query = '', exclusive = true, rank_alias = nil)
click to toggle source
# File lib/textacular.rb, line 40 def web_search(query = '', exclusive = true, rank_alias = nil) exclusive, query = munge_exclusive_and_query(exclusive, query) parsed_query_hash = parse_query_hash(query) similarities, conditions = web_similarities_and_conditions(parsed_query_hash) assemble_query(similarities, conditions, exclusive, rank_alias) end
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