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=62ab8f4b867b7eb765e02721f94599a0ce0b8713;hp=4ac99fe14ad0149dffd985c7dc666c34710ac7a6;hb=7bff7b2c3ea7fe8fcc2febb96d8a432286173c85;hpb=e6fdbea0f85cdab59640f41e6365875d26880810 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 4ac99fe1..62ab8f4b 100644 --- a/app/src/main/java/net/ktnx/mobileledger/model/MobileLedgerProfile.java +++ b/app/src/main/java/net/ktnx/mobileledger/model/MobileLedgerProfile.java @@ -20,6 +20,7 @@ package net.ktnx.mobileledger.model; import android.content.res.Resources; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; +import android.text.TextUtils; import android.util.SparseArray; import androidx.annotation.Nullable; @@ -332,6 +333,24 @@ public final class MobileLedgerProfile { } public void storeAccountValue(SQLiteDatabase db, int generation, String name, String currency, Float amount) { + if (!TextUtils.isEmpty(currency)) { + boolean exists; + try (Cursor c = db.rawQuery("select 1 from currencies where name=?", + new String[]{currency})) + { + exists = c.moveToFirst(); + } + if (!exists) { + db.execSQL( + "insert into currencies(id, name, position, has_gap) values((select max" + + "(id) from currencies)+1, ?, ?, ?)", new Object[]{currency, + Objects.requireNonNull( + Data.currencySymbolPosition.getValue()).toString(), + Data.currencyGap.getValue() + }); + } + } + db.execSQL("replace into account_values(profile, account, " + "currency, value, generation) values(?, ?, ?, ?, ?);", new Object[]{uuid, name, Misc.emptyIsNull(currency), amount, generation});