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 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 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 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)
def getByID(self, r_id):
temp = RecruitmentRequest()
temp.id = r_id
return self.get(temp)
