'test that fetching a single row returns the correct results'

def testFetchOne(self):

    self.cursor.execute(u'\n                                                                select    *\n                                                                from    TestTimestamps\n                                                                where    IntCol    in    (3,    4)\n                                                                order    by    IntCol')
    self.failUnlessEqual(self.cursor.fetchone(), self.dataByKey[3])
    self.failUnlessEqual(self.cursor.fetchone(), self.dataByKey[4])
    self.failUnlessEqual(self.cursor.fetchone(), None)
