+ private static void fixTransactionDescriptionUpper(
+ @NonNull @NotNull SupportSQLiteDatabase database) {
+ try (Cursor c = database.query("SELECT id, description FROM transactions")) {
+ while (c.moveToNext()) {
+ final long id = c.getLong(0);
+ final String description = c.getString(1);
+ database.execSQL("UPDATE transactions SET description_uc=? WHERE id=?",
+ new Object[]{description.toUpperCase(), id
+ });
+ }
+ }
+ }