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)
