コード例 #1
0
    def testVerifyNumberOfRowsMatchingWhere(self):
        dbDriver = DBDriverMock()

        sut = Pydblibrary()

        sut.connect_to_database(dbDriver, 'someDbName', 'someUsername',
                                'somePassword', 'someHost', '7777')

        responses = {"select * from employee where surname='Doe'":
                     [(0, 'John', 'Doe'),
                      (1, 'Jane', 'Doe')]}

        dbDriver.connection.cursor().setQueryResponses(responses)

        sut.verify_number_of_rows_matching_where('employee',
                                                 "surname='Doe'", 2)
コード例 #2
0
    def testVerifyNumberOfRowsMatchingWhere(self):
        dbDriver = DBDriverMock()

        sut = Pydblibrary()

        sut.connect_to_database(dbDriver, 'someDbName', 'someUsername',
                                'somePassword', 'someHost', '7777')

        responses = {
            "select * from employee where surname='Doe'": [(0, 'John', 'Doe'),
                                                           (1, 'Jane', 'Doe')]
        }

        dbDriver.connection.cursor().setQueryResponses(responses)

        sut.verify_number_of_rows_matching_where('employee', "surname='Doe'",
                                                 2)