| 370 | con.close() |
| 371 | |
| 372 | def _paraminsert(self, cur): |
| 373 | self.executeDDL1(cur) |
| 374 | cur.execute( |
| 375 | "insert into %sbooze values ('Victoria Bitter')" % (self.table_prefix) |
| 376 | ) |
| 377 | self.assertTrue(cur.rowcount in (-1, 1)) |
| 378 | |
| 379 | if self.driver.paramstyle == "qmark": |
| 380 | cur.execute( |
| 381 | "insert into %sbooze values (?)" % self.table_prefix, ("Cooper's",) |
| 382 | ) |
| 383 | elif self.driver.paramstyle == "numeric": |
| 384 | cur.execute( |
| 385 | "insert into %sbooze values (:1)" % self.table_prefix, ("Cooper's",) |
| 386 | ) |
| 387 | elif self.driver.paramstyle == "named": |
| 388 | cur.execute( |
| 389 | "insert into %sbooze values (:beer)" % self.table_prefix, |
| 390 | {"beer": "Cooper's"}, |
| 391 | ) |
| 392 | elif self.driver.paramstyle == "format": |
| 393 | cur.execute( |
| 394 | "insert into %sbooze values (%%s)" % self.table_prefix, ("Cooper's",) |
| 395 | ) |
| 396 | elif self.driver.paramstyle == "pyformat": |
| 397 | cur.execute( |
| 398 | "insert into %sbooze values (%%(beer)s)" % self.table_prefix, |
| 399 | {"beer": "Cooper's"}, |
| 400 | ) |
| 401 | else: |
| 402 | self.fail("Invalid paramstyle") |
| 403 | self.assertTrue(cur.rowcount in (-1, 1)) |
| 404 | |
| 405 | cur.execute("select name from %sbooze" % self.table_prefix) |
| 406 | res = cur.fetchall() |
| 407 | self.assertEqual(len(res), 2, "cursor.fetchall returned too few rows") |
| 408 | beers = [res[0][0], res[1][0]] |
| 409 | beers.sort() |
| 410 | self.assertEqual( |
| 411 | beers[0], |
| 412 | "Cooper's", |
| 413 | "cursor.fetchall retrieved incorrect data, or data inserted " "incorrectly", |
| 414 | ) |
| 415 | self.assertEqual( |
| 416 | beers[1], |
| 417 | "Victoria Bitter", |
| 418 | "cursor.fetchall retrieved incorrect data, or data inserted " "incorrectly", |
| 419 | ) |
| 420 | |
| 421 | def test_executemany(self): |
| 422 | con = self._connect() |