def setUp(self):
self.tempdir = tempfile.mkdtemp()
self.dbdir = os.path.join(self.tempdir, 'my_db')
schema = '''
create table some_table (
some_id text primary key,
some_text text
);
'''
Database.create(self.dbdir, schema)
db = Database(self.dbdir)
db.execute(
'INSERT OR ABORT INTO some_table (some_id, some_text) '
'VALUES (?, ?)', ('abc', 'def'))
db.write()
def test_write_read(self):
db = Database(self.dbdir)
row, = db.execute('SELECT * FROM some_table')
self.assertTrue(row == ('abc', 'def'))
