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)