"""
module for stablishing db connection
"""

import os
import mysql.connector
from sqlalchemy import create_engine, text
import sqlalchemy.exc as alchemy_exec

host = os.environ.get("WP_DB_HOST")
user = os.environ.get("WP_DB_USER")
password = os.environ.get("WP_DB_PASSWORD")
database = os.environ.get("WP_DB_PAINEL_INTERATIVO")
port = os.environ.get("WP_DB_PORT")


mydb = mysql.connector.connect(
    host=host, user=user, password=password, database=database, port=port
)

MydbError = mysql.connector.Error

engine = create_engine(
    f"mysql+mysqlconnector://{user}:{password}@{host}:{port}/{database}"
)
text
alchemy_exec