X-Git-Url: https://git.ktnx.net/?a=blobdiff_plain;f=app%2Fsrc%2Fmain%2Fjava%2Fnet%2Fktnx%2Fmobileledger%2Fmodel%2FMobileLedgerProfile.java;h=ec204d9a47272042ba3b15b5815fb0e9aba7eeaa;hb=fc3196828098aab8886568fc673f9e55f4837ce6;hp=ae877c3384c4ae992efa77f6b2d44b5b12285a2f;hpb=d295c5e74a18fed6383109ec463bc6c3f6b48fce;p=mobile-ledger.git 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..ec204d9a 100644 --- a/app/src/main/java/net/ktnx/mobileledger/model/MobileLedgerProfile.java +++ b/app/src/main/java/net/ktnx/mobileledger/model/MobileLedgerProfile.java @@ -182,27 +182,24 @@ 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("insert into accounts(profile, name, name_upper, parent_name, level, keep) " + + "select ?,?,?,?,?,1 where (select changes() = 0)", new Object[]{uuid, acc.getName(), acc.getName().toUpperCase(), acc.getParentName(), acc.getLevel() }); +// 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()});