public void testBackupAndRestore() throws IOException {
dao.deleteAll();
persistRandomEntities(11);
SimpleEntity e = newTestEntity();
dao.insert(e);
List<SimpleEntity> before = dao.listAll();
SQLiteDatabase db = dbHelper.getWritableDatabase();
dbHelper.backupAllTablesToCsv(ctx, db, null);
dbHelper.dropAndCreate(db);
assertEquals(0, dao.listAll().size());
dbHelper.restoreAllTablesFromCsv(ctx, db, null);
List<SimpleEntity> after = dao.listAll();
for (int i = 0; i < before.size(); i++) {
DaoTestCase.assertAllFieldsMatch(before.get(i), after.get(i));
}
}
