(self)
| 419 | ) |
| 420 | |
| 421 | def test_executemany(self): |
| 422 | con = self._connect() |
| 423 | try: |
| 424 | cur = con.cursor() |
| 425 | self.executeDDL1(cur) |
| 426 | largs = [("Cooper's",), ("Boag's",)] |
| 427 | margs = [{"beer": "Cooper's"}, {"beer": "Boag's"}] |
| 428 | if self.driver.paramstyle == "qmark": |
| 429 | cur.executemany( |
| 430 | "insert into %sbooze values (?)" % self.table_prefix, largs |
| 431 | ) |
| 432 | elif self.driver.paramstyle == "numeric": |
| 433 | cur.executemany( |
| 434 | "insert into %sbooze values (:1)" % self.table_prefix, largs |
| 435 | ) |
| 436 | elif self.driver.paramstyle == "named": |
| 437 | cur.executemany( |
| 438 | "insert into %sbooze values (:beer)" % self.table_prefix, margs |
| 439 | ) |
| 440 | elif self.driver.paramstyle == "format": |
| 441 | cur.executemany( |
| 442 | "insert into %sbooze values (%%s)" % self.table_prefix, largs |
| 443 | ) |
| 444 | elif self.driver.paramstyle == "pyformat": |
| 445 | cur.executemany( |
| 446 | "insert into %sbooze values (%%(beer)s)" % (self.table_prefix), |
| 447 | margs, |
| 448 | ) |
| 449 | else: |
| 450 | self.fail("Unknown paramstyle") |
| 451 | self.assertTrue( |
| 452 | cur.rowcount in (-1, 2), |
| 453 | "insert using cursor.executemany set cursor.rowcount to " |
| 454 | "incorrect value %r" % cur.rowcount, |
| 455 | ) |
| 456 | cur.execute("select name from %sbooze" % self.table_prefix) |
| 457 | res = cur.fetchall() |
| 458 | self.assertEqual( |
| 459 | len(res), 2, "cursor.fetchall retrieved incorrect number of rows" |
| 460 | ) |
| 461 | beers = [res[0][0], res[1][0]] |
| 462 | beers.sort() |
| 463 | self.assertEqual(beers[0], "Boag's", "incorrect data retrieved") |
| 464 | self.assertEqual(beers[1], "Cooper's", "incorrect data retrieved") |
| 465 | finally: |
| 466 | con.close() |
| 467 | |
| 468 | def test_fetchone(self): |
| 469 | con = self._connect() |
nothing calls this directly
no test coverage detected