# Module Imports
import mariadb
import sys

# Create Connection Pool
def create_connection_pool():
   """Creates and returns a Connection Pool"""

   # Create Connection Pool
   pool = mariadb.ConnectionPool(
      user="admin",
      password="admin_passwd",
      host="127.0.0.1",
      port=3306,
      pool_name="web-app",
      pool_size=20
   )

   # Return Connection Pool
   return pool


try:
   pool = create_connection_pool()

   pconn = pool.get_connection()

   cur = pconn.cursor()

   pconn.close()
except Exception as e:
   print(f"Error: {e}")