"""DB Connector.

Manages interactions with Relational Database (MySQL and SQLite).
"""

import mysql.connector

from mysql.connector import errorcode

import config


rds_conection_params = {
    'user': config.PPB_USER, 
    'password': config.PPB_PASSWORD,
    'host': config.PPB_HOST,
    'database': config.PPB_DATABASE
}

try:
    rds_con = mysql.connector.connect(**rds_conection_params)
        
except mysql.connector.Error as err:
    if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:
        print("Something is wrong with your user name or password")
    elif err.errno == errorcode.ER_BAD_DB_ERROR:
        print("Database does not exist")
    else:
        print(err)

rds_cursor = rds_con.cursor(named_tuple=True)

ar_conection_params = {
    'user': config.AR_USER, 
    'password': config.AR_PASSWORD,
    'host': config.AR_HOST,
    'database': config.AR_DATABASE
}

try:
    ar_con = mysql.connector.connect(**ar_conection_params)
        
except mysql.connector.Error as err:
    if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:
        print("Something is wrong with your user name or password")
    elif err.errno == errorcode.ER_BAD_DB_ERROR:
        print("Database does not exist")
    else:
        print(err)

ar_cursor = ar_con.cursor(named_tuple=True)