def updateMyProfileMethod(self): try: conn = self.mysql.connect() cur = conn.cursor() if self.result == "": logging.info("Creating a new database connection") cur.callproc('spUpdateUser', [ self.email, self.firstName, self.lastName, self.address1, self.address2, self.city, self.zipcode, self.state, self.country, self.phone, self.user_details_list[0], self.user_details_list[1], self.user_details_list[2], self.user_details_list[3], self.user_details_list[4], self.user_details_list[5], self.user_details_list[6], self.user_details_list[7], self.user_details_list[8], self.user_details_list[9], self.user_details_list[10], self.user_details_list[11], self.user_details_list[12], self.user_details_list[13], self.user_details_list[14], self.user_details_list[15], self.user_details_list[16], self.user_details_list[17], self.user_details_list[18], self.user_details_list[19], self.user_details_list[20], self.user_details_list[21], self.user_details_list[22] ]) conn.commit() logging.info("Changes updated in the database") self.result = "pass" except Exception as e: conn.rollback() excep_msg = "Error occured in updateMyProfileMethod_DBL method" level = logging.getLogger().getEffectiveLevel() self.result = "fail" logmyerror.loadMyExceptionInDb(level, excep_msg, e) logging.info(excep_msg, exc_info=True) conn.close() logging.info("Closing database connection") return self.result
def formValidate_BSL(self, email): try: if (email == ""): error = 'Dont leave userId/Password blank' return error except Exception as e: excep_msg = "Error occured in method formValidate_BSL method" level = logging.getLogger().getEffectiveLevel() logmyerror.loadMyExceptionInDb(level, excep_msg, e) logging.info(excep_msg, exc_info=True)
def formValidate_BSL(self, firstName): try: if (firstName.isspace() == True): return "Firstname not valid" else: return firstName except Exception as e: excep_msg = "Error occured in method formValidate_BSL method" level = logging.getLogger().getEffectiveLevel() logmyerror.loadMyExceptionInDb(level, excep_msg, e) logging.info(excep_msg, exc_info=True)
def formValidate_BSL(self, password): try: if (password.isspace() == True): return "Password not valid" else: return password except Exception as e: excep_msg = "Error occured in method formValidate_BSL method" level = logging.getLogger().getEffectiveLevel() logmyerror.loadMyExceptionInDb(level, excep_msg, e) logging.info(excep_msg, exc_info=True)
def formValidate_BSL(self,password1,password2): try: if (password1 == password2): return password1 else: return "Two Passwords do not match" except Exception as e: excep_msg = "Error occured in method formValidate_BSL method" level = logging.getLogger().getEffectiveLevel() logmyerror.loadMyExceptionInDb(level,excep_msg,e) logging.info(excep_msg, exc_info=True)
def insertMyNewUser(self): try: if(self.data == ''): insertuser = InsertUser(mysql,self.email,self.password,self.firstName,self.lastName,self.address1,self.address2,self.zipcode,self.city,self.state,self.country,self.phone,self.user_details_list,self.typeOfUser,self.typeOfPlan,self.data) self.result = insertuser.insertNewUser() return self.result return self.result except Exception as e: excep_msg = "Error occured in method insertNewUser method" level = logging.getLogger().getEffectiveLevel() logmyerror.loadMyExceptionInDb(level,excep_msg,e) logging.info(excep_msg, exc_info=True)
def getAllUserStatus(self): try: if self.finalMessage == "": fetchuserStatus = FetchUserStatuses(mysql, self.StatusData, '') self.StatusData, result = fetchuserStatus.getUserStatuses() self.finalMessage = self.set_messages(result) return self.StatusData, self.finalMessage except Exception as e: excep_msg = "Error occured in method getAllUserStatus in businesslayer" level = logging.getLogger().getEffectiveLevel() logmyerror.loadMyExceptionInDb(level, excep_msg, e) logging.info(excep_msg, exc_info=True)
def getMyJobData(self): try: if self.finalMessage == "": fetchjobdata = FetchJobData(mysql, '', '') self.jobData, status = fetchjobdata.getJobData() self.finalMessage = self.set_messages(status) return self.jobData, self.finalMessage except Exception as e: excep_msg = "Error occured in method getMyJobData method" level = logging.getLogger().getEffectiveLevel() logmyerror.loadMyExceptionInDb(level, excep_msg, e) logging.info(excep_msg, exc_info=True)
def getMyLoginDetails(self): try: if (self.value == ''): getlogindetails = LoginClass(mysql, self.email, '', '', '', '') self.loggedIn, self.firstName, self.typeOfUser = getlogindetails.getLoginDetails( ) return (self.loggedIn, self.firstName, self.typeOfUser) except Exception as e: excep_msg = "Error occured in method getMyLoginDetails method" level = logging.getLogger().getEffectiveLevel() logmyerror.loadMyExceptionInDb(level, excep_msg, e) logging.info(excep_msg, exc_info=True)
def getMyUserType(self): try: if self.finalMessage == "": getUserType = GetUserType(mysql, self.myemail, '', '') self.userTypeData, status = getUserType.getUserType() self.finalMessage = self.set_messages(status) return self.userTypeData, self.finalMessage except Exception as e: excep_msg = "Error occured in method getMyUserType method" level = logging.getLogger().getEffectiveLevel() logmyerror.loadMyExceptionInDb(level, excep_msg, e) logging.info(excep_msg, exc_info=True)
def insertUserStatus(self): try: if self.finalMessage == "": databaselayerupdatestatus = PostMyStatus( mysql, self.email, self.status, '') result = databaselayerupdatestatus.insertMyUserStatus() self.finalMessage = self.set_messages(result) return self.finalMessage except Exception as e: excep_msg = "Error occured in method insertUserStatus_BSL method" level = logging.getLogger().getEffectiveLevel() logmyerror.loadMyExceptionInDb(level, excep_msg, e) logging.info(excep_msg, exc_info=True)
def insertGivenJobApplication(self): try: if self.finalMessage == "": insertjobApplication = InsertMyJobApplication( mysql, self.email, '') result = insertjobApplication.insertMyJobApplication() self.finalMessage = self.set_messages(result) return self.finalMessage except Exception as e: excep_msg = "Error occured in method InsertJobApplication method" level = logging.getLogger().getEffectiveLevel() logmyerror.loadMyExceptionInDb(level, excep_msg, e) logging.info(excep_msg, exc_info=True)
def formValidate_BSL(self, email): try: regex_emailCheck = re.compile("^\S+@\S+$") if (regex_emailCheck.match(email)): return email else: msg = "Email address not valid" return msg except Exception as e: excep_msg = "Error occured in method formValidate_BSL method" level = logging.getLogger().getEffectiveLevel() logmyerror.loadMyExceptionInDb(level, excep_msg, e) logging.info(excep_msg, exc_info=True)
def fetchMySearchedProfile(self): try: if self.finalMessage == "": fetchSearchedProfile = FetchSearchedProfile( mysql, self.firstName, '', '') self.fetchSearchedProfileData, status = fetchSearchedProfile.fetchSearchedProfile( ) self.finalMessage = self.set_messages(status) return self.fetchSearchedProfileData, self.finalMessage except Exception as e: excep_msg = "Error occured in method fetchSearchedProfile_BSL method" level = logging.getLogger().getEffectiveLevel() logmyerror.loadMyExceptionInDb(level, excep_msg, e) logging.info(excep_msg, exc_info=True)
def insertUserJob(self): try: if self.msg == "": insertjob = InsertMyJob(mysql, self.jobId, self.companyName, self.title, self.manager, self.location, self.jobDetails, self.email, '') result = insertjob.insertMyJob() self.msg = self.set_messages(result) except Exception as e: excep_msg = "Error occured in method insertUserJob method" self.msg = "Unable to add job" level = logging.getLogger().getEffectiveLevel() logmyerror.loadMyExceptionInDb(level, excep_msg, e) logging.info(excep_msg, exc_info=True) return self.msg
def isValid(self): try: if (self.value == ''): checkifuseremailisvalid = CheckIfUserValid( mysql, self.email, self.password, '', '') self.value = checkifuseremailisvalid.emailIsValid() if self.value == False: self.result = 'Invalid UserId / Password' return self.result elif self.value == True: return self.value except Exception as e: excep_msg = "Error occured in method isValid method" level = logging.getLogger().getEffectiveLevel() logmyerror.loadMyExceptionInDb(level, excep_msg, e) logging.info(excep_msg, exc_info=True)
def getJobsCount(self): try: conn = self.mysql .connect() cur = conn.cursor() if self.JobsCount == "": cur.callproc('spGetAllJobs',[self.email]) self.JobsCount = len(cur.fetchall()) self.result = "pass" except Exception as e: conn.rollback() excep_msg = "Error occured in getJobsCount method" level = logging.getLogger().getEffectiveLevel() self.result = "fail" logmyerror.loadMyExceptionInDb(level,excep_msg,e) logging.info(excep_msg, exc_info=True) conn.close() return self.JobsCount,self.result
def fetchSearchedProfile(self): try: conn = self.mysql.connect() cur = conn.cursor() if self.result == "": cur.callproc('spGetSearchedUser',[self.firstName]) self.fetchSearchedProfileData = cur.fetchall() self.result = "pass" except Exception as e: conn.rollback() excep_msg = "Error occured in fetchSearchedProfile_DBL method" self.result = "fail" level = logging.getLogger().getEffectiveLevel() logmyerror.loadMyExceptionInDb(level,excep_msg,e) logging.info(excep_msg, exc_info=True) conn.close() return self.fetchSearchedProfileData,self.result
def getProfileData(self): try: conn = self.mysql.connect() cur = conn.cursor() if self.result == "": cur.callproc('spGetCompleteUserDetails',[self.email]) self.profileData = cur.fetchone() self.result="pass" except Exception as e: conn.rollback() self.result="fail" excep_msg = "Error occured in getProfileData method" level = logging.getLogger().getEffectiveLevel() logmyerror.loadMyExceptionInDb(level,excep_msg,e) logging.info(excep_msg, exc_info=True) conn.close() return self.profileData,self.result
def insertMyJobApplication(self): try: conn = self.mysql.connect() cur = conn.cursor() if self.result == "": cur.callproc('spInsertJobApplication',[self.email]) conn.commit() self.result = "pass" except Exception as e: conn.rollback() excep_msg = "Error occured in insertMyJobApplication method" self.result = "fail" level = logging.getLogger().getEffectiveLevel() logmyerror.loadMyExceptionInDb(level,excep_msg,e) logging.info(excep_msg, exc_info=True) conn.close() return self.result
def insertMyUserStatus(self): try: conn = self.mysql.connect() cur = conn.cursor() if self.result == "": cur.callproc('spInsertUserStatus', [self.email, self.status]) conn.commit() self.result = "pass" except Exception as e: conn.rollback() excep_msg = "Error occured in getProfileData_DBL method" self.result = "fall" level = logging.getLogger().getEffectiveLevel() logmyerror.loadMyExceptionInDb(level, excep_msg, e) logging.info(excep_msg, exc_info=True) conn.close() return self.result
def getApplicationCount(self): try: conn = self.mysql.connect() cur = conn.cursor() if self.applicationCount == "": cur.callproc('spGetUserApplications', [self.email]) self.applicationCount = len(cur.fetchall()) self.result = 'pass' except Exception as e: conn.rollback() excep_msg = "Error occured in getApplicationCount_DBL method" self.result = 'fail' level = logging.getLogger().getEffectiveLevel() logmyerror.loadMyExceptionInDb(level, excep_msg, e) logging.info(excep_msg, exc_info=True) conn.close() return self.applicationCount, self.result
def rulesEngine_Employer(self,email,UserType,typeOfPlan): try: reader = XmlReader() EmployerPlanName,EmployerPlanCount,EmployerPlanPrice,EmployerMessagePermission = reader.readmyFile(UserType) if self.count == "": fetchJobsCount = FetchJobsCount(mysql,email,'','') self.count,result = fetchJobsCount.getJobsCount() concreteComponent = NormalEmployer() concrete_decorator_planA = Employer_Plan_decorator(concreteComponent) for index, item in enumerate(EmployerPlanName): if typeOfPlan == item: allowPosting,allowMessagePermission = concrete_decorator_planA.plan_rules(EmployerPlanCount[index],self.count,EmployerMessagePermission[index]) return allowPosting,allowMessagePermission except Exception as e: excep_msg = "Error occured in method rulesEngine_Employer_BSL method" level = logging.getLogger().getEffectiveLevel() logmyerror.loadMyExceptionInDb(level,excep_msg,e) logging.info(excep_msg, exc_info=True)
def getUserStatuses(self): try: conn = self.mysql.connect() cur = conn.cursor() if self.result == "": cur.callproc('spGetUserStatus') self.StatusData = cur.fetchall() conn.commit() self.result = "pass" except Exception as e: conn.rollback() excep_msg = "Error occured in getUserStatuses method in databaselayer" self.result = "fail" level = logging.getLogger().getEffectiveLevel() logmyerror.loadMyExceptionInDb(level, excep_msg, e) logging.info(excep_msg, exc_info=True) conn.close() return self.StatusData, self.result
def factoryPattern(validatorName): try: if (validatorName == 'Email NullCheck'): return Email_NullCheck.Email_NullCheck() if (validatorName == 'Email Validate'): return Email_Validate.Email_Validate() if (validatorName == 'FirstName SpaceCheck'): return FirstName_SpaceCheck.FirstName_SpaceCheck() if (validatorName == 'Password NullCheck'): return Password_NullCheck.Password_NullCheck() if (validatorName == 'Password Equate'): return Password_Equate.Password_Equate() if (validatorName == 'Password SpaceCheck'): return Password_SpaceCheck.Password_SpaceCheck() except Exception as e: excep_msg = "Error occured in method factoryPattern_BSL method" level = logging.getLogger().getEffectiveLevel() logmyerror.loadMyExceptionInDb(level,excep_msg,e) logging.info(excep_msg, exc_info=True)
def getLoginDetails(self): try: conn = mysql.connect() cur = conn.cursor() loggedIn = False if ((self.userId == "") and (self.firstName == "") and (self.typeOfUser == "")): cur.callproc('spGetUserDetails', [self.email]) self.userId, self.firstName, self.typeOfUser = cur.fetchone() loggedIn = True self.result = 'pass' except Exception as e: excep_msg = "Error occured in getLoginDetails method" self.result = 'fail' level = logging.getLogger().getEffectiveLevel() logmyerror.loadMyExceptionInDb(level, excep_msg, e) logging.info(excep_msg, exc_info=True) conn.close() return (loggedIn, self.firstName, self.typeOfUser)
def hashMyChangingPassword(self): try: self.oldPassword = hashlib.md5( self.oldPassword.encode()).hexdigest() self.newPassword = hashlib.md5( self.newPassword.encode()).hexdigest() if self.finalMessage == "": changemypassword = ChangeMyPassword(self.myemail, self.oldPassword, self.newPassword, mysql, '') status = changemypassword.changeMyProfilePassword() self.finalMessage = self.set_messages(status) return self.finalMessage except Exception as e: excep_msg = "Error occured in method HashMyChangingPassword businesslayer" level = logging.getLogger().getEffectiveLevel() logmyerror.loadMyExceptionInDb(level, excep_msg, e) logging.info(excep_msg, exc_info=True)
def insertMyJob(self): try: conn = self.mysql.connect() cur = conn.cursor() if self.result == "": cur.callproc('spInsertJobDetails', [ self.jobId, self.companyName, self.title, self.manager, self.location, self.jobDetails, self.emailid ]) conn.commit() self.result = "pass" except Exception as e: conn.rollback() excep_msg = "Error occured in insertMyJob method" self.result = "fail" level = logging.getLogger().getEffectiveLevel() logmyerror.loadMyExceptionInDb(level, excep_msg, e) logging.info(excep_msg, exc_info=True) conn.close() return self.result
def emailIsValid(self): try: conn = self.mysql.connect() cur = conn.cursor() if (self.data == ""): cur.callproc('spGetAllUsers') self.data = cur.fetchall() self.result = 'pass' conn.close() except Exception as e: excep_msg = "Error occured in emailIsValid method" self.result = 'fail' level = logging.getLogger().getEffectiveLevel() logmyerror.loadMyExceptionInDb(level, excep_msg, e) logging.info(excep_msg, exc_info=True) self.data = list(self.data) for row in self.data: if row[0] == self.email and row[1] == hashlib.md5( self.password.encode()).hexdigest(): return True return False
def updateMyObject(self): try: myUser.email = self.email myUser.firstName = self.firstName myUser.lastName = self.lastName myUser.address1 = self.address1 myUser.address2 = self.address2 myUser.zipcode = self.zipcode myUser.city = self.city myUser.state = self.state myUser.country = self.country myUser.phone = self.phone myUser.userType = self.typeOfUser myUser.planType = self.typeOfPlan myUser.user_details = self.user_details_list return myUser except Exception as e: excep_msg = "Error occured in method updateMyProfileMethod_BSL method" level = logging.getLogger().getEffectiveLevel() logmyerror.loadMyExceptionInDb(level,excep_msg,e) logging.info(excep_msg, exc_info=True)