Class: Myreplicator::DB

Inherits:
ActiveRecord::Base
  • Object
show all
Defined in:
lib/loader/vertica/source_db.rb

Class Method Summary collapse

Class Method Details

.connect(db) ⇒ Object 



4
5
6
 
# 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) ⇒ Object 



25
26
27
28
 
# 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) ⇒ Object

Returns tables as an Array releases the connection



12
13
14
15
16
17
18
19
20
21
22
23
 
# 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