Method: Service::Query#create_query

Defined in:
lib/service/query.rb

#create_query(options = {}) ⇒ Object 



14
15
16
17
18
19
20
21
22
23
24
 
# File 'lib/service/query.rb', line 14

def create_query(options = {})
  columns = "*"
  
  condition = "WHERE #{sanitize_sql(options[:conditions])}" unless(options[:conditions].to_s.blank?)
  columns = options[:select] unless(options[:select].to_s.blank?)      
  
  start = "STARTPOSITION #{options[:start]}" if(options[:start].to_i > 0)
  max_result = "MAXRESULTS #{options[:top]}" if(options[:top].to_i > 0)
    
  return "SELECT #{columns} FROM #{entity} #{condition} #{start} #{max_result}"
end