Class: ActiveRecord::Base

Inherits:
Object
  • Object
show all
Defined in:
lib/sqlconsole.rb

Class Method Summary collapse

Class Method Details

.execute(query) ⇒ Object 



16
17
18
19
20
21
22
23
24
25
26
27
 
# File 'lib/sqlconsole.rb', line 16

def execute(query)
  if query.size >= 6 && (query[0..5]=='delete' || query[0..5] == 'insert' && query[0..5] == 'update')
    connection.execute(query)
    return 'Execute complete'
  else
    rows = connection.select_all(query)
    rows.map! do |row|
      ap row
    end
    return rows.present? ? "#{rows.size} returned" : "No rows returned"
  end
end