import mariadb
import sys

def main():
    conf = {"user": "foobar", "pass": "foobar", "host": "127.0.0.1",  "port": 3306, "db_name": "test" }
    pool = mariadb.ConnectionPool(user=conf['user'],
                                  password=conf['pass'],
                                  host=conf['host'],
                                  port=conf['port'],
                                  pool_name="testme",
                                  database=conf['db_name'])
    print("Pool '%s' has %d connections" % (pool.pool_name, pool.pool_size))
    connections = []
    for i in range(1, 6):
        connections.append(pool.get_connection())
        print(connections[i-1])

    try:
        x = pool.get_connection()
    except mariadb.PoolError:
        print("No connection available (as expected)")
        pass

    print("returning connections to pool")
    for c in connections:
        print(c)
        c.close()

    print("all connections returned to pool")

    x = pool.get_connection()
    print("schema: %s" % x.database)
    pool.close()


if __name__ == "__main__":
    print("Testing with")
    print("MariaDB Connector/Python version %s" % mariadb.__version__)
    print("Python version %s" % sys.version)
    main()