connection.py

import mysql.connector


class Connection:
    _instance = None

    def __new__(cls, *args, **kwargs):
        try:
            if not cls._instance:
                cls._instance = super().__new__(cls)
                cls._instance.cnx = mysql.connector.connect(
                    user='root',
                    password='9321985498',
                    host='localhost',
                    port='3306',
                    database='banking_sys'
                )
            return cls._instance
        except mysql.connector.Error as e:
            print("Connection failed", e)

    def get_connection(self):
        return self.cnx


if __name__ == "__main__":
    connection = Connection()