Class: Connect

Inherits:
ActiveRecord::Base
  • Object
show all
Defined in:
app/models/connect.rb

Class Method Summary collapse

Instance Method Summary collapse

Class Method Details

.connect_options ⇒ Object 



16
17
18
 
# File 'app/models/connect.rb', line 16

def self.connect_options
  Connect.all.map { |c| [c.name, c.id] }
end

Instance Method Details

#adapter_name ⇒ Object 



20
21
22
23
24
25
 
# File 'app/models/connect.rb', line 20

def adapter_name
  return "Mysql" if self.adapter == Treport::Db::AdapterType[:Mysql]
  return "PostgreSQL" if self.adapter == Treport::Db::AdapterType[:PostgreSQL]
  return "Oracle" if self.adapter == Treport::Db::AdapterType[:Oracle]
  return "Sqlserver" if self.adapter == Treport::Db::AdapterType[:Sqlserver]
end

#exec(sql) ⇒ Object 



4
5
6
7
8
9
10
11
12
13
14
 
# File 'app/models/connect.rb', line 4

def exec(sql)
  result = []
  if (self.adapter==Treport::Db::AdapterType[:Oracle])
    result = Treport::Db.oracle_query self.serializable_hash, sql
  elsif (self.adapter==Treport::Db::AdapterType[:Mysql])
    result = Treport::Db.mysql_query self.serializable_hash, sql
  elsif (self.adapter==Treport::Db::AdapterType[:Sqlserver])
    result = Treport::Db.sqlserver_query self.serializable_hash, sql
  end
  return result
end