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