class DbMeta::Oracle::DatabaseLink

Attributes

host[R]
password[R]
username[R]

Public Instance Methods

extract(args = {}) click to toggle source
# File lib/db_meta/oracle/types/database_link.rb, line 21
def extract(args = {})
  buffer = []
  buffer << "CREATE DATABASE LINK #{@name}"
  buffer << " CONNECT TO #{@username}"
  buffer << " IDENTIFIED BY :1"
  buffer << " USING '#{@host}';"
  buffer << nil
  buffer.join("\n")
end
fetch(args = {}) click to toggle source
# File lib/db_meta/oracle/types/database_link.rb, line 8
def fetch(args = {})
  connection = Connection.instance.get
  cursor = connection.exec("select username, password, host from user_db_links where db_link = '#{@name}'")
  while (row = cursor.fetch)
    @username = row[0].to_s
    @password = row[1].to_s
    @host = row[2].to_s
  end
  cursor.close
ensure
  connection.logoff
end