From d9d6af8234ce15e70f4dce2edd6c595f552e1b4c Mon Sep 17 00:00:00 2001 From: Damyan Ivanov Date: Thu, 7 Mar 2019 05:21:33 +0200 Subject: [PATCH] central methods for marking accounts and transaction as obsolete, active as well as deleting the stale records --- .../model/MobileLedgerProfile.java | 28 +++++++++++++++++++ 1 file changed, 28 insertions(+) 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 b3920fe4..59ae1958 100644 --- a/app/src/main/java/net/ktnx/mobileledger/model/MobileLedgerProfile.java +++ b/app/src/main/java/net/ktnx/mobileledger/model/MobileLedgerProfile.java @@ -312,4 +312,32 @@ public final class MobileLedgerProfile { public void setThemeId(Object o) { setThemeId(Integer.valueOf(String.valueOf(o)).intValue()); } + public void markTransactionsAsNotPresent(SQLiteDatabase db) { + db.execSQL("UPDATE transactions set keep=0 where profile=?", new String[]{uuid}); + + } + public void markAccountsAsNotPresent(SQLiteDatabase db) { + db.execSQL("update account_values set keep=0 where profile=?;", new String[]{uuid}); + db.execSQL("update accounts set keep=0 where profile=?;", new String[]{uuid}); + + } + public void deleteNotPresentAccounts(SQLiteDatabase db) { + db.execSQL("delete from account_values where keep=0 and profile=?", new String[]{uuid}); + db.execSQL("delete from accounts where keep=0 and profile=?", new String[]{uuid}); + } + public void markTransactionAsPresent(SQLiteDatabase db, LedgerTransaction transaction) { + db.execSQL("UPDATE transactions SET keep = 1 WHERE profile = ? and id=?", + new Object[]{uuid, transaction.getId() + }); + } + public void markTransactionsBeforeTransactionAsPresent(SQLiteDatabase db, + LedgerTransaction transaction) { + db.execSQL("UPDATE transactions SET keep=1 WHERE profile = ? and id < ?", + new Object[]{uuid, transaction.getId() + }); + + } + public void deleteNotPresentTransactions(SQLiteDatabase db) { + db.execSQL("DELETE FROM transactions WHERE profile=? AND keep = 0", new String[]{uuid}); + } } -- 2.39.2