| 390 | con.close() |
| 391 | |
| 392 | def _paraminsert(self,cur): |
| 393 | self.executeDDL1(cur) |
| 394 | cur.execute("insert into %sbooze values ('Victoria Bitter')" % ( |
| 395 | self.table_prefix |
| 396 | )) |
| 397 | self.assertTrue(cur.rowcount in (-1,1)) |
| 398 | |
| 399 | if self.driver.paramstyle == 'qmark': |
| 400 | cur.execute( |
| 401 | 'insert into %sbooze values (?)' % self.table_prefix, |
| 402 | ("Cooper's",) |
| 403 | ) |
| 404 | elif self.driver.paramstyle == 'numeric': |
| 405 | cur.execute( |
| 406 | 'insert into %sbooze values (:1)' % self.table_prefix, |
| 407 | ("Cooper's",) |
| 408 | ) |
| 409 | elif self.driver.paramstyle == 'named': |
| 410 | cur.execute( |
| 411 | 'insert into %sbooze values (:beer)' % self.table_prefix, |
| 412 | {'beer':"Cooper's"} |
| 413 | ) |
| 414 | elif self.driver.paramstyle == 'format': |
| 415 | cur.execute( |
| 416 | 'insert into %sbooze values (%%s)' % self.table_prefix, |
| 417 | ("Cooper's",) |
| 418 | ) |
| 419 | elif self.driver.paramstyle == 'pyformat': |
| 420 | cur.execute( |
| 421 | 'insert into %sbooze values (%%(beer)s)' % self.table_prefix, |
| 422 | {'beer':"Cooper's"} |
| 423 | ) |
| 424 | else: |
| 425 | self.fail('Invalid paramstyle') |
| 426 | self.assertTrue(cur.rowcount in (-1,1)) |
| 427 | |
| 428 | cur.execute('select name from %sbooze' % self.table_prefix) |
| 429 | res = cur.fetchall() |
| 430 | self.assertEqual(len(res),2,'cursor.fetchall returned too few rows') |
| 431 | beers = [res[0][0],res[1][0]] |
| 432 | beers.sort() |
| 433 | self.assertEqual(beers[0],"Cooper's", |
| 434 | 'cursor.fetchall retrieved incorrect data, or data inserted ' |
| 435 | 'incorrectly' |
| 436 | ) |
| 437 | self.assertEqual(beers[1],"Victoria Bitter", |
| 438 | 'cursor.fetchall retrieved incorrect data, or data inserted ' |
| 439 | 'incorrectly' |
| 440 | ) |
| 441 | |
| 442 | def test_executemany(self): |
| 443 | con = self._connect() |