'test executing a statement multiple times (with resize)'

def testExecuteManyWithResize(self):

    self.cursor.execute('truncate    table    TestExecuteMany')
    rows = [(1, 'First'), (2, 'Second'), (3, 'Third'), (4, 'Fourth'), (5, 'Fifth'), (6, 'Sixth'), (7, 'Seventh')]
    self.cursor.bindarraysize = 5
    self.cursor.setinputsizes(int, 100)
    sql = 'insert    into    TestExecuteMany    (IntCol,    StringCol)    values    (:1,    :2)'
    self.cursor.executemany(sql, rows)
    var = self.cursor.bindvars[1]
    self.cursor.execute('select    count(*)    from    TestExecuteMany')
    (count,) = self.cursor.fetchone()
    self.failUnlessEqual(count, len(rows))
    self.failUnlessEqual(var.maxlength, (100 * self.connection.maxBytesPerCharacter))
