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