Ejemplo n.º 1
0
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
Ejemplo n.º 2
0
    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)
Ejemplo n.º 3
0
    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)
Ejemplo n.º 4
0
    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)