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'))