import json
import mysql.connector

class MyDB:

    def __init__(self, database="akademym_moshaf"):
        self.database=database
        self.connector = mysql.connector.connect(
            host = "localhost",
            user = "akademym_me",
            password = "mrT4gz9&5",
            database = database
        )

    def Select(self, query):
        cursor = self.connector.cursor(dictionary=True)
        cursor.execute(query)
        result = cursor.fetchall()
        cursor.close()
        return result
            
    def Setting(self, key):
        cursor = self.connector.cursor()
        query = "SELECT `Key`,`Value` FROM Settings where `Enabled` and `Key`='{}'".format(key)
        cursor.execute(query)
        rows = cursor.fetchall()
        result = json.dumps(rows)
        cursor.close()
        return result
    
    def __del__(self):
        self.connector.close()