Class: Rdb2spreadsheet::RdbClient

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

Instance Method Summary collapse

Constructor Details

#initialize(configs) ⇒ RdbClient

Returns a new instance of RdbClient.



6
7
8
9
10
 
# File 'lib/rdb2spreadsheet/rdb_client.rb', line 6

def initialize(configs)
  ActiveRecord::Base.default_timezone = :local # config.active_record.default_timezone
  ActiveRecord::Base.establish_connection(configs)
  @connection = ActiveRecord::Base.connection
end

Instance Method Details

#select(sql) ⇒ Object 



12
13
14
15
16
17
 
# File 'lib/rdb2spreadsheet/rdb_client.rb', line 12

def select(sql)
  return nil if sql.nil?
  result = @connection.select_all(sql)
  return nil if result.nil?
  return result.columns, result.rows
end