gistfile1.txt

@Test
public void storeSingleWallet() {
    Wallet bankWallet = Wallet.create(randomUUID(), "bank");
    storage.insert(bankWallet);

    assertThat(getStoredWalletNames())
            .containsExactly("bank");
}
    
private List<String> getStoredWalletNames() {
    Cursor cursor = db.rawQuery(listWalletNamesSql(), null);
    if (cursor == null) {
        fail("Wallet was not stored");
        cursor.close();
    }
    List<String> storedWalletNames = new ArrayList<>();
    while (cursor.moveToNext()) {
        storedWalletNames.add(cursor.getString(0));
    }
    return storedWalletNames;
}

private String listWalletNamesSql() {
    return String.format("SELECT name FROM tbl_wallet");
}