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
Last activity: Jul 28, 2023, 12:32 PM