def get(self,request):
ans = self.database.executeKnowQuery('SELECT * FROM recruitmentRequest WHERE id = ?', (request.id,))
if (len(ans) == 0):
return False
ans = ans[0]
ret = RecruitmentRequest()
ret.setAll(ans)
return ret
def getAll(self):
ans= self.database.executeKnowQuery('SELECT * from recruitmentRequest')
if (len(ans)==0):
return False
ret=[]
for row in ans:
temp = RecruitmentRequest()
temp.setAll(row)
ret.append(temp)
return ret
def RecruitmentRequestTest(db):
rr = RecruitmentRequest(1, RecruitmentType.invalidType.value, '01/01/1991',
'test', 'test',
RecruitmentStatus.invalidType.value, 'test')
assert (rr.id == 1)
assert (len(rr.getAll()) == 7)
assert (equal_tuples(
rr.getAll(),
(1, RecruitmentType.invalidType.value, '01/01/1991', 'test', 'test',
RecruitmentStatus.invalidType.value, 'test')))
rr.setAll((12, RecruitmentType.hire.value, '01/03/1991', 'te3st', 't3est',
RecruitmentStatus.completed.value, 'tes3t'))
assert (equal_tuples(
rr.getAll(), (12, RecruitmentType.hire.value, '01/03/1991', 'te3st',
't3est', RecruitmentStatus.completed.value, 'tes3t')))
assert (db.isConnectionOk() == 1)
db.executeDoQuery("DROP TABLE IF EXISTS recruitmentRequest")
db.executeDoQuery(
"CREATE TABLE IF NOT EXISTS recruitmentRequest(id INTEGER PRIMARY KEY AUTOINCREMENT,type integer,date text,department text,title text,status integer,description text)"
)
reqDB = RecruitmentRequestDBInterface(db)
request = RecruitmentRequest(0, RecruitmentType.hire.value, '10/10/2015',
'Administration', 'Customer Service Operator',
RecruitmentStatus.active.value, 'none')
request.id = reqDB.add(request)
assert (request.id != 0)
request = reqDB.get(request)
assert (request.department == 'Administration')
request.department = 'HR'
reqDB.update(request)
request = reqDB.get(request)
assert (request.department == 'HR')
a = reqDB.getAll()
assert (len(a) == 1)
assert (a[0].department == 'HR')
a = reqDB.getByID(2)
assert (a == False)
a = reqDB.getByStatus(RecruitmentStatus.active.value)
assert (len(a) == 1)
print('Passed RecruitmentRequest test')
def getByID(self,r_id):
temp = RecruitmentRequest()
temp.id = r_id
return self.get(temp)
