X-Git-Url: https://git.ktnx.net/?p=mobile-ledger.git;a=blobdiff_plain;f=app%2Fsrc%2Fmain%2Fjava%2Fnet%2Fktnx%2Fmobileledger%2Fmodel%2FMobileLedgerProfile.java;h=4be38d4aed442de5d3939dc22803fbf995eefbbd;hp=ae877c3384c4ae992efa77f6b2d44b5b12285a2f;hb=7a7e5a8003d62bcef2aafced877c35ff0043f21b;hpb=d295c5e74a18fed6383109ec463bc6c3f6b48fce 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 ae877c33..4be38d4a 100644 --- a/app/src/main/java/net/ktnx/mobileledger/model/MobileLedgerProfile.java +++ b/app/src/main/java/net/ktnx/mobileledger/model/MobileLedgerProfile.java @@ -29,6 +29,9 @@ import java.util.Date; import java.util.List; import java.util.UUID; +import androidx.annotation.NonNull; +import androidx.annotation.Nullable; + public final class MobileLedgerProfile { private String uuid; private String name; @@ -182,27 +185,28 @@ public final class MobileLedgerProfile { db.endTransaction(); } } - public void storeAccount(LedgerAccount acc) { - SQLiteDatabase db = MLDB.getWritableDatabase(); - + public void storeAccount(SQLiteDatabase db, LedgerAccount acc) { // replace into is a bad idea because it would reset hidden to its default value // we like the default, but for new accounts only - db.execSQL("update accounts set level = ?, keep = 1 where profile=? and name = ?", - new Object[]{acc.getLevel(), uuid, acc.getName()}); - db.execSQL("insert into accounts(profile, name, name_upper, parent_name, level) " + - "select ?,?,?,?,? where (select changes() = 0)", + db.execSQL("update accounts set level = ?, keep = 1, hidden=?, expanded=? " + + "where profile=? and name = ?", + new Object[]{acc.getLevel(), acc.isHiddenByStar(), acc.isExpanded(), uuid, + acc.getName() + }); + db.execSQL( + "insert into accounts(profile, name, name_upper, parent_name, level, hidden, expanded, keep) " + + "select ?,?,?,?,?,?,?,1 where (select changes() = 0)", new Object[]{uuid, acc.getName(), acc.getName().toUpperCase(), acc.getParentName(), - acc.getLevel() + acc.getLevel(), acc.isHiddenByStar(), acc.isExpanded() }); +// Log.d("accounts", String.format("Stored account '%s' in DB [%s]", acc.getName(), uuid)); } - public void storeAccountValue(String name, String currency, Float amount) { - SQLiteDatabase db = MLDB.getWritableDatabase(); + public void storeAccountValue(SQLiteDatabase db, String name, String currency, Float amount) { db.execSQL("replace into account_values(profile, account, " + "currency, value, keep) values(?, ?, ?, ?, 1);", new Object[]{uuid, name, currency, amount}); } - public void storeTransaction(LedgerTransaction tr) { - SQLiteDatabase db = MLDB.getWritableDatabase(); + public void storeTransaction(SQLiteDatabase db, LedgerTransaction tr) { tr.fillDataHash(); db.execSQL("DELETE from transactions WHERE profile=? and id=?", new Object[]{uuid, tr.getId()}); @@ -278,23 +282,64 @@ public final class MobileLedgerProfile { } public void removeFromDB() { SQLiteDatabase db = MLDB.getWritableDatabase(); - Log.d("db", String.format("removing progile %s from DB", uuid)); - db.execSQL("delete from profiles where uuid=?", new Object[]{uuid}); + Log.d("db", String.format("removing profile %s from DB", uuid)); + try { + db.beginTransaction(); + db.execSQL("delete from profiles where uuid=?", new Object[]{uuid}); + db.execSQL("delete from accounts where profile=?", new Object[]{uuid}); + db.execSQL("delete from account_values where profile=?", new Object[]{uuid}); + db.execSQL("delete from transactions where profile=?", new Object[]{uuid}); + db.execSQL("delete from transaction_accounts where profile=?", new Object[]{uuid}); + db.setTransactionSuccessful(); + } + finally { + db.endTransaction(); + } } + @NonNull public LedgerAccount loadAccount(String name) { SQLiteDatabase db = MLDB.getReadableDatabase(); - try (Cursor cursor = db.rawQuery("SELECT hidden from accounts where profile=? and name=?", - new String[]{uuid, name})) + return loadAccount(db, name); + } + @Nullable + public LedgerAccount tryLoadAccount(String acct_name) { + SQLiteDatabase db = MLDB.getReadableDatabase(); + return tryLoadAccount(db, acct_name); + } + @NonNull + public LedgerAccount loadAccount(SQLiteDatabase db, String accName) { + LedgerAccount acc = tryLoadAccount(db, accName); + + if (acc == null) throw new RuntimeException("Unable to load account with name " + accName); + + return acc; + } + @Nullable + public LedgerAccount tryLoadAccount(SQLiteDatabase db, String accName) { + try (Cursor cursor = db.rawQuery( + "SELECT a.hidden, a.expanded, (select 1 from accounts a2 " + + "where a2.profile = a.profile and a2.name like a.name||':%' limit 1) " + + "FROM accounts a WHERE a.profile = ? and a.name=?", new String[]{uuid, accName})) { if (cursor.moveToFirst()) { - LedgerAccount acc = new LedgerAccount(name); - acc.setHidden(cursor.getInt(0) == 1); + LedgerAccount acc = new LedgerAccount(accName); + acc.setHiddenByStar(cursor.getInt(0) == 1); + acc.setExpanded(cursor.getInt(1) == 1); + acc.setHasSubAccounts(cursor.getInt(2) == 1); + + try (Cursor c2 = db.rawQuery( + "SELECT value, currency FROM account_values WHERE profile = ? " + + "AND account = ?", new String[]{uuid, accName})) + { + while (c2.moveToNext()) { + acc.addAmount(c2.getFloat(0), c2.getString(1)); + } + } return acc; } + return null; } - - return null; } public LedgerTransaction loadTransaction(int transactionId) { LedgerTransaction tr = new LedgerTransaction(transactionId, this.uuid); @@ -347,4 +392,40 @@ public final class MobileLedgerProfile { setLongOption(MLDB.OPT_LAST_SCRAPE, now.getTime()); Data.lastUpdateDate.set(now); } + public List loadChildAccountsOf(LedgerAccount acc) { + List result = new ArrayList<>(); + SQLiteDatabase db = MLDB.getReadableDatabase(); + try (Cursor c = db.rawQuery( + "SELECT a.name FROM accounts a WHERE a.profile = ? and a.name like ?||':%'", + new String[]{uuid, acc.getName()})) + { + while (c.moveToNext()) { + LedgerAccount a = loadAccount(db, c.getString(0)); + result.add(a); + } + } + + return result; + } + public List loadVisibleChildAccountsOf(LedgerAccount acc) { + List result = new ArrayList<>(); + ArrayList visibleList = new ArrayList<>(); + visibleList.add(acc); + + SQLiteDatabase db = MLDB.getReadableDatabase(); + try (Cursor c = db.rawQuery( + "SELECT a.name FROM accounts a WHERE a.profile = ? and a.name like ?||':%'", + new String[]{uuid, acc.getName()})) + { + while (c.moveToNext()) { + LedgerAccount a = loadAccount(db, c.getString(0)); + if (a.isVisible(visibleList)) { + result.add(a); + visibleList.add(a); + } + } + } + + return result; + } }