Class: PriceQuery

Inherits:
Object
  • Object
show all
Defined in:
lib/unit4/checkout/price_query.rb

Instance Method Summary collapse

Constructor Details

#initialize(item) ⇒ PriceQuery

Returns a new instance of PriceQuery.



3
4
5
 
# File 'lib/unit4/checkout/price_query.rb', line 3

def initialize(item)
  @sanitized_query = prepare_sql_statement(item)
end

Instance Method Details

#find_price ⇒ Object 



12
13
14
15
 
# File 'lib/unit4/checkout/price_query.rb', line 12

def find_price
  results = ActiveRecord::Base.connection.exec_query(@sanitized_query)
  results.rows.first.first if results.present?
end

#prepare_sql_statement(item) ⇒ Object 



7
8
9
10
 
# File 'lib/unit4/checkout/price_query.rb', line 7

def prepare_sql_statement(item)
  # TODO: keep seen items in cache or variable  !!!!!!!!!
  ActiveRecord::Base.sanitize_sql_array(["SELECT 'products'.'price' FROM 'products' WHERE 'products'.'id' = ?", item])
end