X-Git-Url: https://git.ktnx.net/?p=mobile-ledger.git;a=blobdiff_plain;f=app%2Fsrc%2Fmain%2Fjava%2Fnet%2Fktnx%2Fmobileledger%2Fmodel%2FLedgerTransaction.java;h=3919ad141e431f39da7673be2ca3ecd835d29b32;hp=c4127ab81641eaf679cc91efd7074fddecb0c18c;hb=160edb0e0fe58f5076329e8622db414001895530;hpb=a686c3293dd0dbbe49db7fc0f287c451d6b2ecd8 diff --git a/app/src/main/java/net/ktnx/mobileledger/model/LedgerTransaction.java b/app/src/main/java/net/ktnx/mobileledger/model/LedgerTransaction.java index c4127ab8..3919ad14 100644 --- a/app/src/main/java/net/ktnx/mobileledger/model/LedgerTransaction.java +++ b/app/src/main/java/net/ktnx/mobileledger/model/LedgerTransaction.java @@ -19,6 +19,7 @@ package net.ktnx.mobileledger.model; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; +import android.util.Log; import net.ktnx.mobileledger.utils.Digest; @@ -30,10 +31,10 @@ import java.util.Iterator; public class LedgerTransaction { private static final String DIGEST_TYPE = "SHA-256"; - public final Comparator comparator = - new Comparator() { + public final Comparator comparator = + new Comparator() { @Override - public int compare(LedgerTransactionItem o1, LedgerTransactionItem o2) { + public int compare(LedgerTransactionAccount o1, LedgerTransactionAccount o2) { int res = o1.getAccountName().compareTo(o2.getAccountName()); if (res != 0) return res; res = o1.getCurrency().compareTo(o2.getCurrency()); @@ -44,7 +45,7 @@ public class LedgerTransaction { private Integer id; private String date; private String description; - private ArrayList items; + private ArrayList items; private String dataHash; private boolean dataLoaded; public LedgerTransaction(Integer id, String date, String description) { @@ -61,7 +62,7 @@ public class LedgerTransaction { public LedgerTransaction(int id) { this(id, null, null); } - public void add_item(LedgerTransactionItem item) { + public void addAccount(LedgerTransactionAccount item) { items.add(item); dataHash = null; } @@ -79,8 +80,8 @@ public class LedgerTransaction { this.description = description; dataHash = null; } - public Iterator getItemsIterator() { - return new Iterator() { + public Iterator getAccountsIterator() { + return new Iterator() { private int pointer = 0; @Override public boolean hasNext() { @@ -88,7 +89,7 @@ public class LedgerTransaction { } @Override - public LedgerTransactionItem next() { + public LedgerTransactionAccount next() { return hasNext() ? items.get(pointer++) : null; } }; @@ -101,7 +102,7 @@ public class LedgerTransaction { db.execSQL("INSERT INTO transactions(id, date, description, data_hash) values(?,?,?,?)", new Object[]{id, date, description, dataHash}); - for (LedgerTransactionItem item : items) { + for (LedgerTransactionAccount item : items) { db.execSQL("INSERT INTO transaction_accounts(transaction_id, account_name, amount, " + "currency) values(?, ?, ?, ?)", new Object[]{id, item.getAccountName(), item.getAmount(), item.getCurrency()}); @@ -116,7 +117,7 @@ public class LedgerTransaction { data.append('\0'); data.append(getDescription()); data.append('\0'); - for (LedgerTransactionItem item : items) { + for (LedgerTransactionAccount item : items) { data.append(item.getAccountName()); data.append('\0'); data.append(item.getCurrency()); @@ -131,6 +132,17 @@ public class LedgerTransaction { String.format("Unable to get instance of %s digest", DIGEST_TYPE), e); } } + public boolean existsInDb(SQLiteDatabase db) { + fillDataHash(); + try (Cursor c = db + .rawQuery("SELECT 1 from transactions where data_hash = ?", new String[]{dataHash})) + { + boolean result = c.moveToFirst(); + Log.d("transactions", String.format("Transaction %d (%s) %s", id, dataHash, + result ? "already present" : "not present")); + return result; + } + } public void loadData(SQLiteDatabase db) { if (dataLoaded) return; @@ -146,7 +158,7 @@ public class LedgerTransaction { new String[]{String.valueOf(id)})) { while (cAcc.moveToNext()) { - add_item(new LedgerTransactionItem(cAcc.getString(0), cAcc.getFloat(1), + addAccount(new LedgerTransactionAccount(cAcc.getString(0), cAcc.getFloat(1), cAcc.getString(2))); }