def test_insert(self):
pool = yield makePool('sqlite:')
self.addCleanup(pool.close)
yield pool.runOperation('''CREATE TABLE porc2 (
id integer primary key,
name text
)''')
rowid = yield insert(pool, 'insert into porc2 (name) values (?)', ('bob',))
self.assertEqual(rowid, 1)
def test_insert(self):
pool = yield makePool(postgres_url)
self.addCleanup(pool.close)
yield pool.runOperation('''CREATE TEMPORARY TABLE porc2 (
id serial primary key,
name text
)''')
rowid = yield insert(pool, 'insert into porc2 (name) values (?)', ('bob',))
self.assertEqual(rowid, 1)
