DB revision 66: re-calculate descriptionUpper to fix searching

[mobile-ledger.git] / app / src / main / java / net / ktnx / mobileledger / db / DB.java

diff --git a/app/src/main/java/net/ktnx/mobileledger/db/DB.java b/app/src/main/java/net/ktnx/mobileledger/db/DB.java
index 7de2231d8dbb4f1ecd44bc64388b69a9715cf8dd..7d3e7809bc8525e80eb32a69a36249c5f1a81e5e 100644 (file)
--- a/app/src/main/java/net/ktnx/mobileledger/db/DB.java
+++ b/app/src/main/java/net/ktnx/mobileledger/db/DB.java
@@ -41,6 +41,8 @@ import net.ktnx.mobileledger.dao.TransactionAccountDAO;
 import net.ktnx.mobileledger.dao.TransactionDAO;
 import net.ktnx.mobileledger.utils.Logger;
 
+import org.jetbrains.annotations.NotNull;
+
 import java.io.BufferedReader;
 import java.io.IOException;
 import java.io.InputStream;
@@ -58,10 +60,22 @@ import static net.ktnx.mobileledger.utils.Logger.debug;
                       TransactionAccount.class
           })
 abstract public class DB extends RoomDatabase {
-    public static final int REVISION = 64;
+    public static final int REVISION = 66;
     public static final String DB_NAME = "MoLe.db";
     public static final MutableLiveData<Boolean> initComplete = new MutableLiveData<>(false);
     private static DB instance;
+    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
+                        });
+            }
+        }
+    }
     public static DB get() {
         if (instance != null)
             return instance;
@@ -80,7 +94,22 @@ abstract public class DB extends RoomDatabase {
                                     multiVersionMigration(41, 58), singleVersionMigration(59),
                                     singleVersionMigration(60), singleVersionMigration(61),
                                     singleVersionMigration(62), singleVersionMigration(63),
-                                    singleVersionMigration(64)
+                                    singleVersionMigration(64), new Migration(64, 65) {
+                        @Override
+                        public void migrate(@NonNull @NotNull SupportSQLiteDatabase database) {
+                            fixTransactionDescriptionUpper(database);
+                        }
+                    }, new Migration(64, 66) {
+                        @Override
+                        public void migrate(@NonNull @NotNull SupportSQLiteDatabase database) {
+                            fixTransactionDescriptionUpper(database);
+                        }
+                    }, new Migration(65, 66) {
+                        @Override
+                        public void migrate(@NonNull @NotNull SupportSQLiteDatabase database) {
+                            fixTransactionDescriptionUpper(database);
+                        }
+                    }
                     })
                    .addCallback(new Callback() {
                        @Override
@@ -226,4 +255,17 @@ abstract public class DB extends RoomDatabase {
     public abstract OptionDAO getOptionDAO();
 
     public abstract ProfileDAO getProfileDAO();
+
+    @androidx.room.Transaction
+    public void deleteAllSync() {
+        getTransactionAccountDAO().deleteAllSync();
+        getTransactionDAO().deleteAllSync();
+        getAccountValueDAO().deleteAllSync();
+        getAccountDAO().deleteAllSync();
+        getTemplateAccountDAO().deleteAllSync();
+        getTemplateDAO().deleteAllSync();
+        getCurrencyDAO().deleteAllSync();
+        getOptionDAO().deleteAllSync();
+        getProfileDAO().deleteAllSync();
+    }
 }