def connect(**config):
"""
_connect_ Connects to the underlying MySQL database.
If a set of attributes is passed with the connect method,
it has to have 6 attributes:
dbName : database name
host : host (if local use "localhost")
user : user name
passwd : pass word
socketFileLocation : socket file location (use if connect local)
but leave empty if connecting from remote.
portNr : port number if you connect from remote.
Leave empty if you connect via a socket file.
"""
actualConfig = defaultConfig
if config != {}:
actualConfig = config
try:
#NOTE: we might do this a little bit nicer by dynamically
#NOTE: loading the connect objects
if actualConfig['dbType'] == 'mysql':
logging.debug("Using MySQL connector")
conn=Mysql.connect(actualConfig['dbName'],\
actualConfig['host'],\
actualConfig['user'],\
actualConfig['passwd'],\
actualConfig['socketFileLocation'],\
actualConfig['portNr'])
return conn
if actualConfig['dbType'] == 'oracle':
logging.debug("Using Oracle connector")
conn=Oracle.connect(actualConfig['dbName'],\
actualConfig['host'],\
actualConfig['user'],\
actualConfig['passwd'],\
actualConfig['socketFileLocation'],\
actualConfig['portNr'])
return conn
except:
raise
def getConnection(self):
"""
get a MySQL connection
"""
# create a connection
conn = Mysql.connect(self.dbParams['dbName'], \
self.dbParams['host'], \
self.dbParams['user'], \
self.dbParams['passwd'], \
self.dbParams['socketFileLocation'],\
self.dbParams['portNr'])
# set transaction properties
cursor = self.getCursor(conn)
cursor.execute("SET TRANSACTION ISOLATION LEVEL READ COMMITTED")
cursor.execute("SET AUTOCOMMIT=0")
# return connection and cursor
return (conn, cursor)
def getConnection(self):
"""
get a MySQL connection
"""
# create a connection
conn = Mysql.connect(self.dbParams['dbName'], \
self.dbParams['host'], \
self.dbParams['user'], \
self.dbParams['passwd'], \
self.dbParams['socketFileLocation'],\
self.dbParams['portNr'])
# set transaction properties
cursor = self.getCursor(conn)
cursor.execute("SET TRANSACTION ISOLATION LEVEL READ COMMITTED")
cursor.execute("SET AUTOCOMMIT=0")
# return connection and cursor
return(conn, cursor)
def getConnection(self):
"""
get a MySQL connection
"""
# create a connection
conn = Mysql.connect(
self.dbParams["dbName"],
self.dbParams["host"],
self.dbParams["user"],
self.dbParams["passwd"],
self.dbParams["socketFileLocation"],
self.dbParams["portNr"],
)
# set transaction properties
cursor = self.getCursor(conn)
cursor.execute("SET TRANSACTION ISOLATION LEVEL READ COMMITTED")
cursor.execute("SET AUTOCOMMIT=0")
# return connection and cursor
return (conn, cursor)