def testQuery(self): dbDriver = DBDriverMock() sut = Pydblibrary() sut.connect_to_database(dbDriver, 'someDbName', 'someUsername', 'somePassword', 'someHost', '7777') responses = {'select * from employee': [(0, 'John', 'Doe'), (1, 'Jane', 'Doe')]} dbDriver.connection.cursor().setQueryResponses(responses) result = sut.query('select * from employee') self.assertTrue(responses['select * from employee'] == result, 'Query was performed with fail.')
def testQuery(self): dbDriver = DBDriverMock() sut = Pydblibrary() sut.connect_to_database(dbDriver, 'someDbName', 'someUsername', 'somePassword', 'someHost', '7777') responses = { 'select * from employee': [(0, 'John', 'Doe'), (1, 'Jane', 'Doe')] } dbDriver.connection.cursor().setQueryResponses(responses) result = sut.query('select * from employee') self.assertTrue(responses['select * from employee'] == result, 'Query was performed with fail.')