S19DataBaseHelper.py

import mysql.connector as db


class DataBaseHelper:

    def __init__(self, database='gw2022pd1'):
        self.connection = db.connect(user='root', password='',
                                     host='127.0.0.1',
                                     database=database)
        print("1. DB CONNECTED :)")
        self.cursor = self.connection.cursor()
        print("2. CURSOR CREATED :)")

    def write(self, sql):
        self.cursor.execute(sql)
        self.connection.commit()
        print("SQL QUERY EXECUTED :)")

    def read(self, sql):
        self.cursor.execute(sql)
        rows = self.cursor.fetchall() # list of Tuples :)
        return rows