Class: Queries::GeographicAreaAutocompleteQuery

Inherits:

Query

• Object
• Query
• Queries::GeographicAreaAutocompleteQuery

show all

Defined in:

lib/queries/geographic_area_autocomplete_query.rb

Instance Attribute Summary

Attributes inherited from Query

#dynamic_limit, #project_id, #query_string, #terms

Instance Method Summary (collapse)

• - (Object) all
• - (Object) table
• - (Object) where_sql

  TODO: use or_clauses.

Methods inherited from Query

#autocomplete, #build_terms, #cached, #combine_or_clauses, #end_wildcard, #exactly_named, #fragments, #identifier_table, #initialize, #integers, #named, #no_digits, #only_ids, #only_integers?, #parent, #parent_child_join, #parent_child_where, #result, #scope, #start_and_end_wildcard, #start_wildcard, #strings, #wildcard_wrapped_integers, #with_id, #with_identifier, #with_identifier_like, #with_project_id, #years

10
11
12
13
14
15
16

# File 'lib/queries/geographic_area_autocomplete_query.rb', line 10

def all 
  (
    GeographicArea.where(name: query_string).all +  
    GeographicArea.joins(parent_child_join).where(parent_child_where.to_sql).limit(5).all +
    GeographicArea.where(where_sql).includes(:geographic_area_type, :geographic_items).order('length(name)').limit(dynamic_limit).all
  ).flatten.compact.uniq
end

18
19
20

# File 'lib/queries/geographic_area_autocomplete_query.rb', line 18

def table
  GeographicArea.arel_table
end

6
7
8

# File 'lib/queries/geographic_area_autocomplete_query.rb', line 6

def where_sql
  named.to_sql
end