import mysql.connector as mconn

class Database:
    def __init__(self):
        self.conn = mconn.connect(
            host="localhost",
            user="root",
            passwd="password",
            database="base"
        )
        return

    def select(self, request):
        self.cur = self.conn.cursor()
        self.cur.execute(request)
        list_of_rows = self.cur.fetchall()
        self.conn.close()
        return list_of_rows

    def insert(self, request):
        self.cur = self.conn.cursor()
        self.cur.execute(request)
        n = self.cur.lastrowid
        self.conn.commit()
        self.conn.close()
        return n

    def updel(self, request):
        self.cur = self.conn.cursor()
        self.cur.execute(request)
        self.conn.commit()
        self.conn.close()
        return

    def get_all(self):
        request = '''SELECT * FROM table1 ORDER BY var1 ASC'''
        list_of_rows = self.select(request)

        """Here I do some data parsing that is not relevant for this problem"""
        return