Module: Sack::Connectors::MySQLConnector

Defined in:
lib/sack/connectors/mysql.rb

Overview

MySQL Connector Module: Provides MySQL connectivity for Sack Database.

Class Method Summary collapse

Class Method Details

.close(dbc) ⇒ Object

Close: Closes a previously-opened database connection.

Parameters:

  • dbc (Object) —

    Database connection



31
32
33
 
# File 'lib/sack/connectors/mysql.rb', line 31

def self.close dbc
  dbc.close
end

.exec(dbc, q) ⇒ Array

Execute Executes an SQL statement with parameters

Parameters:

  • dbc (Object) —

    Database connection

  • q (String) —

    Statement

Returns:

  • (Array) —

    Statement results



40
41
42
 
# File 'lib/sack/connectors/mysql.rb', line 40

def self.exec dbc, q
  dbc.query(q).rows
end

.open(conn_string) ⇒ Object

Open: Opens a connection to a MySQL database.

Parameters:

  • conn_string (String) —

    The connection string (host=myServerAddress;database=myDataBase;username=myUsername;password=myPassword;)

Returns:

  • (Object) —

    Database connection



24
25
26
 
# File 'lib/sack/connectors/mysql.rb', line 24

def self.open conn_string
  Mysql2::Client.new Hash[*(conn_string.split(';').inject([]) { |a, e| a + e.split('=') })]
end