Python Pydblibrary.db_elements_are_not_equal Examples

Example #1

File: unit_tests.py Project: F1ashhimself/robotframework-pydblibrary

    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')

Example #2

    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')