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 



19
20
21
 
# File 'app/models/connect.rb', line 19

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

Instance Method Details

#adapter_name ⇒ Object 



23
24
25
26
27
28
 
# File 'app/models/connect.rb', line 23

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

#exec(sql) ⇒ Object 



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

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