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

def testExecuteManyWithRebind(self):

    self.cursor.execute('truncate    table    TestExecuteMany')
    rows = [[n] for n in range(235)]
    self.cursor.arraysize = 100
    statement = 'insert    into    TestExecuteMany    (IntCol)    values    (:1)'
    self.cursor.executemany(statement, rows[:50])
    self.cursor.executemany(statement, rows[50:])
    self.connection.commit()
    self.cursor.execute('select    count(*)    from    TestExecuteMany')
    (count,) = self.cursor.fetchone()
    self.failUnlessEqual(count, len(rows))
