from .DbManager import DbManager
from ..PyqcrmFlags import PyqcrmFlags
from ..Vermasseln import Vermasseln
import mariadb



class UserManager():

    def __init__(self, user_config, role):
        self.__con = DbManager().getConnection()
        self.__cur = self.__con.cursor()
        self.__username = user_config["PYQCRM_USER"]
        self.__password = user_config["PYQCRM_USER_PASS"]
        self.__info = user_config["PYQCRM_USER_INFO"]
        self.__role = role if role == PyqcrmFlags.ADMIN else 0


    def createUser(self):
        self.__hashPassword()
        user_created = True
        try:
            self.__cur.callproc("createUser", (self.__username, self.__password, self.__info, self.__role))
            self.__con.commit()
        except mariadb.Error as e:
            print(f"Error: {e}")
            print(e.errno)
            user_created = False
        finally:
            self.__cur.close()
            #self.__closeConnection()
            return user_created

    def __hashPassword(self):
        self.__password = Vermasseln.userPasswordHash(self.__password)
        print (self.__password)


    def getUser(self):
        self.__closeConnection()

    def getUsers(self):
        self.__closeConnection()

    def delUser(self):
        self.__closeConnection()

    def updateUser(self):
        self.__closeConnection()

    def disableUser(self):
        self.__closeConnection()

    def __closeConnection(self):
        self.__cur.close()
        self.__con.close()