Class: Superstore::Adapters::HstoreAdapter::QueryBuilder

Inherits:
Object
  • Object
show all
Defined in:
lib/superstore/adapters/hstore_adapter.rb

Instance Method Summary collapse

Constructor Details

#initialize(adapter, scope) ⇒ QueryBuilder

Returns a new instance of QueryBuilder.



8
9
10
11
 
# File 'lib/superstore/adapters/hstore_adapter.rb', line 8

def initialize(adapter, scope)
  @adapter  = adapter
  @scope    = scope
end

Instance Method Details

#limit_string ⇒ Object 



51
52
53
54
55
 
# File 'lib/superstore/adapters/hstore_adapter.rb', line 51

def limit_string
  if @scope.limit_value
    "LIMIT #{@scope.limit_value}"
  end
end

#order_string ⇒ Object 



41
42
43
44
45
46
47
48
49
 
# File 'lib/superstore/adapters/hstore_adapter.rb', line 41

def order_string
  if @scope.order_values.any?
    orders = @scope.order_values.join(', ')
    "ORDER BY #{orders}"
  elsif @scope.id_values.many?
    id_orders = @scope.id_values.map { |id| "ID=#{@adapter.quote(id)} DESC" }.join(',')
    "ORDER BY #{id_orders}"
  end
end

#select_string ⇒ Object 



22
23
24
25
26
27
28
 
# File 'lib/superstore/adapters/hstore_adapter.rb', line 22

def select_string
  if @scope.select_values.any?
    "id, slice(attribute_store, #{@adapter.fields_to_postgres_array(@scope.select_values)}) as attribute_store"
  else
    '*'
  end
end

#to_query ⇒ Object 



13
14
15
16
17
18
19
20
 
# File 'lib/superstore/adapters/hstore_adapter.rb', line 13

def to_query
  [
    "SELECT #{select_string} FROM #{@scope.klass.table_name}",
    where_string,
    order_string,
    limit_string
  ].delete_if(&:blank?) * ' '
end

#where_string ⇒ Object 



30
31
32
33
34
35
36
37
38
39
 
# File 'lib/superstore/adapters/hstore_adapter.rb', line 30

def where_string
  wheres = @scope.where_values.dup
  if @scope.id_values.any?
    wheres << @adapter.create_ids_where_clause(@scope.id_values)
  end

  if wheres.any?
    "WHERE #{wheres * ' AND '}"
  end
end