Method: HDB#execute

Defined in:
lib/hdb/hdb.rb

#execute(queryStr = self.queryStr, pageSize: "all", page: 0) ⇒ Object 



182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
 
# File 'lib/hdb/hdb.rb', line 182

def execute(queryStr = self.queryStr, pageSize: "all", page: 0) 
  
  limit = "LIMIT #{pageSize}"
  offset = "OFFSET #{page} * #{pageSize}"
  if(pageSize == "all")
    limit = offset = ""
  end

  queryStr += " #{limit} #{offset}"
  
  t1 = Time.now
  hl << queryStr.hight_yellow
  result = self._execute(queryStr)
  hl << "... msecs. #{((Time.now - t1) * 1000).round(2)}".hight_cyan
  return result

end