def attemptLoginEmployee(pairedAcc, pairedComp):
try:
__linker = DBManager(user='******', password='******')
__fetchedCompId = __linker.loginEmployee(pairedAcc, pairedComp)
return {
'success': True,
'message': None,
'parameters': {
'identifier': __fetchedCompId
}
}
except Exception as db_except:
if '0,' in str(db_except):
return {
'success': False,
'message': "Company not found.",
'parameters': None
}
elif '1,' in str(db_except):
return {
'success': False,
'message': "User is not an active employee of the company.",
'parameters': None
}
else:
return {
'success': False,
'message': str(db_except),
'parameters': None
}
finally:
del __linker
def attemptLoadCEO(compID):
try:
__linker = DBManager(user='******', password='******')
fetchedCEO = __linker.fetchCEODetails(compID)
fetchedCEO = (fetchedCEO[0], fetchedCEO[1],
_encode64DecodeUTF8Image(fetchedCEO[2]))
return {
'success': True,
'message': "CEO loaded successfully.",
'parameters': {
'CEODetails': fetchedCEO
}
}
except Exception as db_except:
if '0,' in str(db_except):
return {
'success': False,
'message':
"Unable to obtain CEO information: No CEO associated to this company.",
'parameters': None
}
return {
'success': False,
'message': str(db_except),
'parameters': None
}
finally:
del __linker
def attemptRegisterCompany(identifier, pairedAcc, title, location, desc):
try:
__linker = DBManager(user='******', password='******')
__linker.addCompany(identifier.lower(), pairedAcc, title, location,
desc)
return {
'success': True,
'message': "Company has been registered successfully.",
'parameters': None
}
except Exception as db_except:
if 'constraint "company_id_pk"' in str(db_except):
return {
'success': False,
'message': "Company identifier has already been taken.",
'parameters': None
}
else:
return {
'success': False,
'message': str(db_except),
'parameters': None
}
finally:
del __linker
def attemptLogin(username):
try:
__linker = DBManager(user='******', password='******')
__fetchedPass = __linker.fetchPassword(username)
__workerProfile = __linker.fetchWorkerProfile(username)
return {
'success': True,
'message': None,
'parameters': {
'username': username,
'password': __fetchedPass
},
'employment': {
'hasWorkerProfile': __workerProfile
}
}
except Exception as db_except:
if '0,' in str(db_except):
return {
'success': False,
'message': "Username or password is not correct.",
'parameters': None
}
else:
return {
'success': False,
'message': str(db_except),
'parameters': None
}
finally:
del __linker
def attemptRegister(username, password, email):
try:
__linker = DBManager(user='******', password='******')
__linker.addAccount(username, password, email)
return {
'success': True,
'message': "Account has been registered successfully.",
'parameters': None
}
except Exception as db_except:
if 'constraint "account_username_pk"' in str(db_except):
return {
'success': False,
'message': "Username has already been taken.",
'parameters': None
}
elif 'constraint "emailaddress_email_unique"' in str(db_except):
return {
'success': False,
'message': "Email address has already been taken.",
'parameters': None
}
else:
return {
'success': False,
'message': str(db_except),
'parameters': None
}
finally:
del __linker
def attemptUpdateWorkerDetails(username, actionType, newValue):
columnIdentifier = ('First Name', 'Last Name', 'City', 'Country',
'Address')
if actionType not in range(0, len(columnIdentifier)):
return {
'succes': False,
'message':
f'''Invalid action type supplied. Action types are indexed from 0 to
{len(columnIdentifier) - 1}.''',
'parameters': None
}
try:
__linker = DBManager(user='******', password='******')
__linker.updateWorkerProfile(username, actionType, newValue)
return {
'success': True,
'message': f"{columnIdentifier[actionType]} updated successfully.",
'parameters': None
}
except Exception as db_except:
return {
'success': False,
'message': str(db_except),
'parameters': None
}
finally:
del __linker
def attemptLoadCompany(compID, username):
try:
__linker = DBManager(user='******', password='******')
fetchedCompany = __linker.fetchCompanyDetails(compID, username)
fetchedCompany = (fetchedCompany[0], fetchedCompany[1],
fetchedCompany[2],
_encode64DecodeUTF8Image(fetchedCompany[3]),
fetchedCompany[4])
return {
'success': True,
'message': "Company loaded successfully.",
'parameters': {
'companyDetails': fetchedCompany
}
}
except Exception as db_except:
if '0,' in str(db_except):
return {
'success': False,
'message':
"Unable to obtain company information: Company identifier not valid.",
'parameters': None
}
return {
'success': False,
'message': str(db_except),
'parameters': None
}
finally:
del __linker
def attemptFetchLevel(identifier, username):
try:
__linker = DBManager(user='******', password='******')
fetchedLevel = __linker.fetchPrivilegeLevel(identifier, username)
return {
'success': True,
'message': None,
'parameters': {
'level': fetchedLevel
}
}
except Exception as db_except:
if '0,' in str(db_except):
return {
'success': False,
'message': "User is not an active employee of the company",
'parameters': None
}
return {
'success': False,
'message': str(db_except),
'parameters': None
}
finally:
del __linker
def attemptGatherAccountDetails(username):
try:
__linker = DBManager(user='******', password='******')
workerDetails = __linker.getWorkerDetails(username)
email = __linker.getAccountEmailAddress(username)
companyInfo = __linker.getEnrolledCompanies(username)
if companyInfo is not None:
for index in range(len(companyInfo)):
companyInfo[index] = (companyInfo[index][0],
companyInfo[index][1],
_encode64DecodeUTF8Image(
companyInfo[index][2]))
return {
'success': True,
'message': None,
'parameters': {
'firstName': workerDetails[0],
'lastName': workerDetails[1],
'city': workerDetails[2],
'country': workerDetails[3],
'address': workerDetails[4],
'email': email,
'companies': companyInfo
}
}
except Exception as db_except:
return {
'success': False,
'message': str(db_except),
'parameters': None
}
finally:
del __linker
def attemptPostFeed(identifier, username, text):
try:
__linker = DBManager(user='******', password='******')
__linker.postFeed(identifier, username, text)
return {'success': True, 'message': None, 'parameters': None}
except Exception as db_except:
return {
'success': False,
'message': str(db_except),
'parameters': None
}
finally:
del __linker
def attemptFetchFeed(identifier):
try:
__linker = DBManager(user='******', password='******')
fetchedFeed = __linker.fetchFeed(identifier)
feed = [(tup[0], tup[1], tup[2], _encode64DecodeUTF8Image(tup[3]))
for tup in fetchedFeed]
return {'success': True, 'message': None, 'parameters': {'feed': feed}}
except Exception as db_except:
return {
'success': False,
'message': str(db_except),
'parameters': None
}
finally:
del __linker
def attemptAddEmployee(pairedAcc, pairedComp):
try:
__linker = DBManager(user='******', password='******')
__linker.addEmployee(pairedAcc, pairedComp)
return {
'success': True,
'message': "Employee has been registered successfully.",
'parameters': None
}
except Exception as db_except:
return {
'success': False,
'message': str(db_except),
'parameters': None
}
finally:
del __linker
def attemptLoadCompanySettings(compId):
try:
__linker = DBManager(user='******', password='******')
fetchedSettings = __linker.getCompanySettings(compId)
return {
'success': True,
'message': None,
'parameters': {
'companySettings': fetchedSettings
}
}
except Exception as db_except:
return {
'success': False,
'message': str(db_except),
'parameters': None
}
finally:
del __linker
def attemptRegisterWorkerProfile(pairedAcc, firstName, lastName, city, country,
address):
try:
__linker = DBManager(user='******', password='******')
__linker.addWorkerProfile(pairedAcc, firstName, lastName, city,
country, address)
return {
'success': True,
'message': "Worker profile has been registered successfully.",
'parameters': None
}
except Exception as db_except:
return {
'success': False,
'message': str(db_except),
'parameters': None
}
finally:
del __linker
def attemptLoadLastConnected(username):
try:
__linker = DBManager(user='******', password='******')
fetchedCompany = __linker.fetchLastConnected(username)
return {
'success': True,
'message': None,
'parameters': {
'identifier': fetchedCompany
}
}
except Exception as db_except:
return {
'success': False,
'message': str(db_except),
'parameters': None
}
finally:
del __linker
def attemptLoadAvatar(username):
try:
__linker = DBManager(user='******', password='******')
imageAsString = _encode64DecodeUTF8Image(
__linker.fetchUserAvatar(username))
return {
'success': True,
'message': "Avatar loaded successfully.",
'parameters': {
'avatar': imageAsString
}
}
except Exception as db_except:
return {
'success': False,
'message': str(db_except),
'parameters': None
}
finally:
del __linker
def attemptLoadSearchResults(username, keyPhrase, limit):
if not search("^[1-9][0-9]{0,4}$|^10000$", str(limit)):
return {
'success': False,
'message':
'''Invalid limit parameter supplied. Parameter must be integer between [1, 10000].''',
'parameters': None
}
if not isinstance(keyPhrase, str):
return {
'success': False,
'message':
"Invalid key phrase parameter supplied. Parameter must be string.",
'parameters': None
}
try:
__linker = DBManager(user='******', password='******')
fetchedCompanies = __linker.getCompaniesMatchingKeyPhrase(
username, _sanitizeKeyPhrase(keyPhrase), int(limit))
for index in range(len(fetchedCompanies)):
fetchedCompanies[index] = (fetchedCompanies[index][0],
fetchedCompanies[index][1],
_encode64DecodeUTF8Image(
fetchedCompanies[index][2]))
return {
'success': True,
'message': f"Successfully loaded {len(fetchedCompanies)} results.",
'parameters': {
'companies': fetchedCompanies
}
}
except Exception as db_except:
return {
'success': False,
'message': str(db_except),
'parameters': None
}
finally:
del __linker
def attemptForwardApplication(identifier, username):
try:
__linker = DBManager(user='******', password='******')
__linker.insertApplication(identifier, username)
return {
'success': True,
'message': f"Successfully applied to {identifier}",
'parameters': None
}
except Exception as db_except:
if 'constraint "application_paired_account_paired_company_pk"' in str(
db_except):
return {
'success': False,
'message':
f"Could not to apply to {identifier}: Previous application is still pending.",
'parameters': None
}
elif '0,' in str(db_except):
return {
'success': False,
'message':
f"Could not to apply to {identifier}: You already are an active employee of the company.",
'parameters': None
}
elif '1,' in str(db_except):
return {
'success': False,
'message':
f"Could not to apply to {identifier}: You are banned from applying to this company.",
'parameters': None
}
return {
'success': False,
'message': str(db_except),
'parameters': None
}
finally:
del __linker
def attemptGatherWorkerDetails(username):
try:
__linker = DBManager(user='******', password='******')
workerDetails = __linker.getWorkerDetails(username)
return {
'success': True,
'message': None,
'parameters': {
'firstName': workerDetails[0],
'lastName': workerDetails[1],
'city': workerDetails[2],
'country': workerDetails[3],
'address': workerDetails[4]
}
}
except Exception as db_except:
return {
'success': False,
'message': str(db_except),
'parameters': None
}
finally:
del __linker
def attemptHandleApplication(identifier, username, operationType):
try:
if int(operationType) not in (0, 1, 2):
return {
'success': False,
'message': "Invalid operation type parameter",
'parameters': None
}
__linker = DBManager(user='******', password='******')
__linker.handleApplication(identifier, username, operationType)
return {
'success': True,
'message': f"Successfully handled {username}",
'parameters': None
}
except Exception as db_except:
return {
'success': False,
'message': str(db_except),
'parameters': None
}
finally:
del __linker
def attemptLoadSettings(username):
try:
__linker = DBManager(user='******', password='******')
fetchedCompanies = __linker.getRegisteredCompanies(username)
fetchedSettings = __linker.getAccountSettings(username)
fetchedCompanies = [(tup[0], _encode64DecodeUTF8Image(tup[1]))
for tup in fetchedCompanies]
return {
'success': True,
'message': None,
'parameters': {
'companies': fetchedCompanies,
'accountSettings': fetchedSettings
}
}
except Exception as db_except:
return {
'success': False,
'message': str(db_except),
'parameters': None
}
finally:
del __linker
def attemptChangeSettings(pairedKey, settingId, isToggledOn):
try:
__linker = DBManager(user='******', password='******')
if isToggledOn:
__linker.removeSetting(pairedKey, settingId)
else:
__linker.addSetting(pairedKey, settingId)
return {'success': True, 'message': None, 'parameters': None}
except Exception as db_except:
return {
'success': False,
'message': str(db_except),
'parameters': None
}
finally:
del __linker
def attemptReplaceAvatar(username, avatar):
try:
__linker = DBManager(user='******', password='******')
hasAvatar = __linker.fetchUserAvatar(username)
if hasAvatar is not None:
__linker.updateUserAvatar(
username, avatar
) if avatar is not None else __linker.removeUserAvatar(username)
else:
__linker.addUserAvatar(username,
avatar) if avatar is not None else None
return {
'success': True,
'message': "Avatar updated successfully.",
'parameters': None
}
except Exception as db_except:
return {
'success': False,
'message': str(db_except),
'parameters': None
}
finally:
del __linker