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)