DB_connector.py

import mysql.connector
from mysql.connector import Error


class DBConnector(object):
    __connection = None

    @classmethod
    def get_connection_object(cls, host, user, pwd, db_name):
        if cls.__connection is None:
            try:
                cls.__connection = mysql.connector.connect(host=host, user=user, password=pwd)
                print("Connected to Server: Admin")

                cursor = cls.__connection.cursor()
                result = None
                cursor.execute("SHOW DATABASES")
                result = cursor.fetchall()

                if ("{0}".format(db_name),) not in result:
                    cursor.execute("CREATE DATABASE {0}".format(db_name))
                    cls.__connection.commit()
                    print("Created Database: ", db_name)

                cls.__connection = mysql.connector.connect(host=host, user=user, password=pwd, database=db_name)
                print("Connected to Database: ", db_name)

            except Error as e:
                print("Error: ", e)

        return cls.__connection

    def __init__(self):
        if DBConnector.__connection is not None:
            raise Exception("Only Single Instance is Permitted!!!")
        else:
            DBConnector.__connection = self