}
private void reloadTransactions(MobileLedgerDatabase dbh) {
transactions.clear();
- String sql = "SELECT id, date, description FROM transactions";
- sql += " ORDER BY date desc, id desc";
+ String sql = "SELECT id FROM transactions ORDER BY date desc, id desc";
try (SQLiteDatabase db = dbh.getReadableDatabase()) {
try (Cursor cursor = db.rawQuery(sql, null)) {
while (cursor.moveToNext()) {
- LedgerTransaction tr =
- new LedgerTransaction(cursor.getString(0), cursor.getString(1),
- cursor.getString(2));
- // TODO: fill accounts and amounts
- transactions.add(tr);
+ transactions.add(new LedgerTransaction(cursor.getInt(0)));
}
}
}