Class: Queries::GeographicArea::Autocomplete

Inherits:
Query
  • Object
show all
Defined in:
lib/queries/geographic_area/autocomplete.rb

Instance Attribute Summary

Attributes inherited from Query

#dynamic_limit, #options, #project_id, #query_string, #terms

Instance Method Summary collapse

Methods inherited from Query

#alphabetic_strings, #alphanumeric_strings, #attribute_exact_facet, #autocomplete_cached, #autocomplete_cached_wildcard_anywhere, #autocomplete_common_name_exact, #autocomplete_common_name_like, #autocomplete_exact_id, #autocomplete_exactly_named, #autocomplete_named, #autocomplete_ordered_wildcard_pieces_in_cached, #build_terms, #cached, #combine_or_clauses, #common_name_name, #common_name_table, #common_name_wild_pieces, #end_wildcard, #exactly_named, #fragments, #initialize, #integers, #levenshtein_distance, #match_ordered_wildcard_pieces_in_cached, #match_wildcard_end_in_cached, #match_wildcard_in_cached, #named, #no_terms?, #only_ids, #only_integers?, #parent, #parent_child_join, #parent_child_where, #pieces, #result, #scope, #start_and_end_wildcard, #start_wildcard, #string_fragments, #wildcard_pieces, #wildcard_wrapped_integers, #wildcard_wrapped_years, #with_cached, #with_cached_like, #with_id, #with_project_id, #year_letter, #years

Constructor Details

This class inherits a constructor from Queries::Query

Instance Method Details

#autocomplete ⇒ Scope

Returns:

  • (Scope) 


12
13
14
15
16
17
18
19
20
 
# File 'lib/queries/geographic_area/autocomplete.rb', line 12

def autocomplete 
  return [] if query_string&.strip.blank?
  (
    ::GeographicArea.where(id: query_string).all +
    ::GeographicArea.where(name: query_string).all +
    ::GeographicArea.joins(parent_child_join).where(Arel.sql(parent_child_where.to_sql)).limit(5).all +
    ::GeographicArea.where(Arel.sql(where_sql)).includes(:geographic_area_type, :geographic_items).order(Arel.sql('LENGTH(name)')).limit(dynamic_limit).all
  ).flatten.compact.uniq
end

#table ⇒ Arel::Table

Returns:

  • (Arel::Table) 


23
24
25
 
# File 'lib/queries/geographic_area/autocomplete.rb', line 23

def table
  ::GeographicArea.arel_table
end

#where_sql ⇒ String

TODO: use or_clauses

Returns:

  • (String) 


7
8
9
 
# File 'lib/queries/geographic_area/autocomplete.rb', line 7

def where_sql
  named.to_sql
end