'test iterators'

def testIterators(self):

    self.cursor.execute(u'\n                                                                select    IntCol\n                                                                from    TestNumbers\n                                                                where    IntCol    between    1    and    3\n                                                                order    by    IntCol')
    rows = []
    for row in self.cursor:
        rows.append(row[0])
    self.failUnlessEqual(rows, [1, 2, 3])
