class IFD_Connections

Public Class Methods

get_mysql_db_connection(schema) click to toggle source

Open the MYSQL connection to specific schema

# File lib/anhpham/methods/IFD_Connection.rb, line 6
def self.get_mysql_db_connection(schema)
  begin
    # puts ("Connecting to database...");
    data_source_schema = schema.downcase
    return Mysql2::Client.new(host: $data_source_url, username: $data_source_username, password: $data_source_password,database:data_source_schema);
  rescue Exception => e
    raise "Cannot connect to database [username: %s; password: %s, dbUrl: %s, dbName: %s] with error %s" %
              [$data_source_username, $data_source_password, $data_source_url,data_source_schema, e.message]
  end
end
get_sql_server_db_connection(schema) click to toggle source

Open the SQL Server connection to specific schema

# File lib/anhpham/methods/IFD_Connection.rb, line 18
def self.get_sql_server_db_connection(schema)
  begin
    # puts ("Connecting to database...");
    data_source_schema = schema.downcase
    return TinyTds::Client.new(dataserver: $data_source_url, username: $data_source_username, password: $data_source_password, database:data_source_schema);
  rescue Exception => e
    raise "Cannot connect to database [username: %s; password: %s, dbUrl: %s, dbName: %s] with error %s" %
              [$data_source_username, $data_source_password, $data_source_url,data_source_schema, e.message]
  end
end