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)
def test_basic(self):
pool = yield makePool('sqlite:')
self.assertEqual(pool.db_scheme, 'sqlite')
self.addCleanup(pool.close)
yield pool.runOperation('''CREATE TABLE porc1 (
id integer primary key,
created timestamp default current_timestamp,
name text
)''')
def interaction(cursor, name):
d = cursor.execute('insert into porc1 (name) values (?)', (name,))
d.addCallback(lambda _: cursor.lastRowId())
return d
rowid = yield pool.runInteraction(interaction, 'bob')
rows = yield pool.runQuery('select id, name from porc1 where id = ?', (rowid,))
self.assertEqual(map(tuple,rows), [(rowid, 'bob')])
self.assertEqual(rows[0]['id'], rowid)
self.assertEqual(rows[0]['name'], 'bob')
def getPool(self):
pool = yield makePool('sqlite:')
yield self.patcher.upgrade(pool)
defer.returnValue(pool)
def getPool(self):
pool = yield makePool(postgres_url)
self.addCleanup(self.deleteData, pool)
yield self.patcher.upgrade(pool)
defer.returnValue(pool)
def getPool(self):
pool = yield makePool('sqlite:')
self.addCleanup(pool.close)
yield self.patcher.upgrade(pool)
defer.returnValue(pool)
