class dbConnect():

    def __init__(self, db):

        self.db = db

    def __enter__(self):

        self.db.sem.acquire()

        try:

            self.pconn = self.db.pool.get_connection()

        except mariadb.PoolError as e:

            print(e)

        return self.pconn

    def __exit__(self, exc_type, exc_value, exc_traceback):

        self.pconn.close()

        self.db.sem.release()

        if exc_type is not None:

            logging.info("Logging an uncaught exception",

                 exc_info=(exc_type, exc_value, exc_traceback))

        return True

class dbConnection:

    def __init__(self, sem, size=100):

        self.sem = sem

        self.pool = mariadb.ConnectionPool(...)

    def insertSomething(self):

        pconn = self.newConnection() #using mariadb.connect(**config)

        # with dbConnect(self) as pconn: #connection pool

        cur = pconn.cursor() 

        cur.execute(f''' INSERT INTO ...''')