cursors = yield [f1, f2, f3, f4, f5] yield gen.sleep(.7) self.assertEqual(db.conns.total, 5) self.assertEqual(cursors[0].fetchone()[0], 1) self.assertEqual(cursors[1].fetchone()[0], 2) self.assertEqual(cursors[2].fetchone()[0], 3) self.assertEqual(cursors[3].fetchone()[0], 4) self.assertEqual(cursors[4].fetchone()[0], 5) f1 = db.execute("SELECT 1") f2 = db.execute("SELECT 2") f3 = db.execute("SELECT 3") cursors = yield [f1, f2, f3] self.assertEqual(cursors[0].fetchone()[0], 1) self.assertEqual(cursors[1].fetchone()[0], 2) self.assertEqual(cursors[2].fetchone()[0], 3) yield gen.sleep(1) self.assertEqual(db.conns.total, 3) if __name__ == '__main__': if debug: FORMAT = '%(asctime)-15s %(levelname)s:%(name)s %(funcName)-15s: %(message)s' logging.basicConfig(format=FORMAT) logging.getLogger("momoko").setLevel(logging.DEBUG) logging.getLogger("unittest").setLevel(logging.DEBUG) unittest.main()
f5 = db.execute("SELECT 5") cursors = yield [f1, f2, f3, f4, f5] yield gen.sleep(.7) self.assertEqual(db.conns.total, 5) self.assertEqual(cursors[0].fetchone()[0], 1) self.assertEqual(cursors[1].fetchone()[0], 2) self.assertEqual(cursors[2].fetchone()[0], 3) self.assertEqual(cursors[3].fetchone()[0], 4) self.assertEqual(cursors[4].fetchone()[0], 5) f1 = db.execute("SELECT 1") f2 = db.execute("SELECT 2") f3 = db.execute("SELECT 3") cursors = yield [f1, f2, f3] self.assertEqual(cursors[0].fetchone()[0], 1) self.assertEqual(cursors[1].fetchone()[0], 2) self.assertEqual(cursors[2].fetchone()[0], 3) yield gen.sleep(1) self.assertEqual(db.conns.total, 3) if __name__ == '__main__': if debug: FORMAT = '%(asctime)-15s %(levelname)s:%(name)s %(funcName)-15s: %(message)s' logging.basicConfig(format=FORMAT) logging.getLogger("momoko").setLevel(logging.DEBUG) logging.getLogger("unittest").setLevel(logging.DEBUG) unittest.main()