class Rdb2spreadsheet::RdbClient

Public Class Methods

new(configs) click to toggle source
# 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

Public Instance Methods

exec(sql) click to toggle source
# File lib/rdb2spreadsheet/rdb_client.rb, line 12
def exec(sql)
  @connection.execute(sql)
end
select(sql) click to toggle source
# File lib/rdb2spreadsheet/rdb_client.rb, line 16
def select(sql)
  return nil if sql.nil?
  result = @connection.select_all(sql)
  return nil if result.nil?
  return result.columns, result.rows
end