def testFetchmany(self): exporter = Exporter(TestConf) exporter.execute(self.conSql) result = [] subResult = exporter.fetchmany() while subResult: for first, last in subResult: result.append((first, last)) subResult = exporter.fetchmany() self.assertEqual( "[('yungho', 'yu'), ('hojin', 'kim'), ('kwanghee', 'jang')]", str(result)) exporter.close()
def transmitDelData(self, dumpType): exporter = Exporter(self.conf) pusher = Pusher(self.conf) if dumpType == SqlReader.FULL: sql = self.sqlReader.getDelSql() elif dumpType == SqlReader.INCR: sql = self.sqlReader.getDelIncSql() exporter.execute(sql) subResult = exporter.fetchmany() while subResult: pusher.pushDelData(subResult) subResult = exporter.fetchmany() exporter.close() pusher.close()