def testDbElementsAreNotEqual(self): dbDriver1 = DBDriverMock() dbDriver2 = DBDriverMock() sut = Pydblibrary() sut.connect_to_database(dbDriver1, 'someDbName1', 'someUsername', 'somePassword', 'someHost', '7777', 'db1') sut.connect_to_database(dbDriver2, 'someDbName2', 'someUsername', 'somePassword', 'someHost', '7777', 'db2') responses1 = {'select * from employee': [(0, 'John', 'Doe'), (1, 'Jane', 'Doe')]} responses2 = {'select * from employee': [(0, 'John', 'Doe')]} dbDriver1.connection.cursor().setQueryResponses(responses1) dbDriver2.connection.cursor().setQueryResponses(responses2) sut.db_elements_are_not_equal('select * from employee', 'db1', 'db2')
def testDbElementsAreNotEqual(self): dbDriver1 = DBDriverMock() dbDriver2 = DBDriverMock() sut = Pydblibrary() sut.connect_to_database(dbDriver1, 'someDbName1', 'someUsername', 'somePassword', 'someHost', '7777', 'db1') sut.connect_to_database(dbDriver2, 'someDbName2', 'someUsername', 'somePassword', 'someHost', '7777', 'db2') responses1 = { 'select * from employee': [(0, 'John', 'Doe'), (1, 'Jane', 'Doe')] } responses2 = {'select * from employee': [(0, 'John', 'Doe')]} dbDriver1.connection.cursor().setQueryResponses(responses1) dbDriver2.connection.cursor().setQueryResponses(responses2) sut.db_elements_are_not_equal('select * from employee', 'db1', 'db2')