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