Sample Header Ad - 728x90

Is calling a database class on app creation correct for pooling?

2 votes
1 answer
67 views
Start doadmin.Database().__init__() Class class Database(object): connection = None cursor = None def get_c(self): return self.cursor def __init__(self): if Database.connection is None: try: Database.connection = mysql.connector.connect(host="stuff", user="stuff", password="stuff", database="stuff", port=stuff) Database.cursor = Database.connection.cursor() except Exception as error: print("Error: Connection not established {}".format(error)) else: print("Connection established") self.connection = Database.connection self.cursor = Database.cursor Request cursor1 = Database().get_c() cursor1.execute("SELECT * FROM posts") posts = list(cursor1)
Asked by Corie LeClair (25 rep)
Jul 28, 2023, 06:30 AM
Last activity: Jul 28, 2023, 12:32 PM