persistent profile list order

[mobile-ledger.git] / app / src / main / java / net / ktnx / mobileledger / model / MobileLedgerProfile.java

diff --git a/app/src/main/java/net/ktnx/mobileledger/model/MobileLedgerProfile.java b/app/src/main/java/net/ktnx/mobileledger/model/MobileLedgerProfile.java
index 72097a3faa6112e89475fb95b1601a394be1ab68..96fa9b215e88fc1727c2437fe0a213bf77ebf141 100644 (file)
--- a/app/src/main/java/net/ktnx/mobileledger/model/MobileLedgerProfile.java
+++ b/app/src/main/java/net/ktnx/mobileledger/model/MobileLedgerProfile.java
@@ -65,6 +65,22 @@ public final class MobileLedgerProfile {
         }
         return result;
     }
+    public static void storeProfilesOrder() {
+        SQLiteDatabase db = MLDB.getWritableDatabase();
+        db.beginTransaction();
+        try {
+            int orderNo = 0;
+            for (MobileLedgerProfile p : Data.profiles.getList()) {
+                db.execSQL("update profiles set order_no=? where uuid=?",
+                        new Object[]{orderNo, p.getUuid()});
+                orderNo++;
+            }
+            db.setTransactionSuccessful();
+        }
+        finally {
+            db.endTransaction();
+        }
+    }
     public static List<MobileLedgerProfile> createInitialProfileList() {
         List<MobileLedgerProfile> result = new ArrayList<>();
         MobileLedgerProfile first =
@@ -254,4 +270,9 @@ public final class MobileLedgerProfile {
     public void set_option_value(String name, long value) {
         set_option_value(name, String.valueOf(value));
     }
+    public void removeFromDB() {
+        SQLiteDatabase db = MLDB.getWritableDatabase();
+        Log.d("db", String.format("removinf progile %s from DB", uuid));
+        db.execSQL("delete from profiles where uuid=?", new Object[]{uuid});
+    }
 }