package net.ktnx.mobileledger.ui.transaction_list;
import android.arch.lifecycle.ViewModel;
+import android.content.Context;
+import android.database.Cursor;
+import android.database.sqlite.SQLiteDatabase;
+import android.util.Log;
+
+import net.ktnx.mobileledger.model.LedgerTransaction;
+import net.ktnx.mobileledger.utils.MLDB;
+
+import java.util.ArrayList;
public class TransactionListViewModel extends ViewModel {
- // TODO: Implement the ViewModel
+
+ private ArrayList<LedgerTransaction> transactions;
+
+ public void reloadTransactions(Context context) {
+ ArrayList<LedgerTransaction> newList = new ArrayList<>();
+
+ String sql = "SELECT id FROM transactions ORDER BY date desc, id desc";
+
+ try (SQLiteDatabase db = MLDB.getReadableDatabase(context)) {
+ try (Cursor cursor = db.rawQuery(sql, null)) {
+ while (cursor.moveToNext()) {
+ newList.add(new LedgerTransaction(cursor.getInt(0)));
+ }
+ transactions = newList;
+ Log.d("transactions", "transaction list updated");
+ }
+ }
+
+ }
+ public LedgerTransaction getTransaction(int position) {
+ if (position >= transactions.size()) return null;
+ return transactions.get(position);
+ }
+ public int getTransactionCount() {
+ if (transactions == null) return 0;
+ return transactions.size();
+ }
}