class Myreplicator::DB

Public Class Methods

connect(db) click to toggle source
# File lib/loader/vertica/source_db.rb, line 4
def self.connect db
  establish_connection(ActiveRecord::Base.configurations[db])
end
exec_sql(source_db,sql) click to toggle source
# File lib/loader/vertica/source_db.rb, line 25
def self.exec_sql source_db,sql
  DB.connect(source_db)
  return DB.connection.execute(sql)
end
get_tables(db) click to toggle source

Returns tables as an Array releases the connection

# File lib/loader/vertica/source_db.rb, line 12
def self.get_tables(db)
  tables = []
  begin
    self.connect(db)
    tables = self.connection.tables
    self.connection_pool.release_connection
  rescue Mysql2::Error => e
    puts "Connection to #{db} Failed!"
    puts e.message
  end
  return tables
end