Module: QueryExec

Defined in:
lib/query_exec.rb

Class Method Summary collapse

Class Method Details

.run(query) ⇒ Object 



2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
 
# File 'lib/query_exec.rb', line 2

def self.run(query)
  environment= Rails.env
  output =[]
  connection=ActiveRecord::Base.connection#(environment.to_sym)
  if query.split().first == "select"
    begin
      result=connection.exec_query(query)
    rescue
      message="Invalid Query!!"
    end
  else
    begin
      result=connection.execute(query)
      message="Executed!"
    rescue
      message="Invalid Query!!"
    end
  end
  if result
    result.each do |r|
      raise r.inspect
      output << r
    end
  return result
  else
    raise message.inspect
  end
end