helper.py

class Helper:

    encoding = 'utf-8'

    def __init__(self, udid, it_pro):
        self.udid = udid
        self.itpro = it_pro

    def employee_id(self):
        sql = "select emplid from emplid_to_alphaname where alphaname = (%s);", (self.udid, )
        result = DatabaseConnection.netdb(sql)

        if result is None:
            sys.exit("The alphaname {} did not return an associated Employee Number. Check that the alphaname is "
                     "correct "
                     "or {} may not have an Employee Number assigned yet.".format(self.udid, self.udid))
        emplid = int(result[0])

        return emplid