module Sack::Connectors::MySQLConnector

MySQL Connector Module: Provides MySQL connectivity for Sack Database.

Public Class Methods

close(dbc) click to toggle source

Close: Closes a previously-opened database connection. @param [Object] dbc Database connection

# File lib/sack/connectors/mysql.rb, line 31
def self.close dbc
        dbc.close
end
exec(dbc, q) click to toggle source

Execute Executes an SQL statement with parameters @param [Object] dbc Database connection @param [String] q Statement @return [Array] Statement results

# File lib/sack/connectors/mysql.rb, line 40
def self.exec dbc, q
        dbc.query(q).rows
end
open(conn_string) click to toggle source

Open: Opens a connection to a MySQL database. @param [String] conn_string The connection string (host=myServerAddress;database=myDataBase;username=myUsername;password=myPassword;) @return [Object] Database connection

# 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