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)