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