protected abstract TransactionGenerationContainer getGenerationPOJOSync(long profileId);
@androidx.room.Transaction
- @Query("SELECT * FROM transactions WHERE profile_id = :profileId")
+ @Query("SELECT * FROM transactions WHERE profile_id = :profileId ORDER BY year " +
+ " desc, month desc, day desc, ledger_id desc")
public abstract List<TransactionWithAccounts> getAllWithAccountsSync(long profileId);
+ @androidx.room.Transaction
+ @Query("SELECT * FROM transactions WHERE profile_id = :profileId ORDER BY year " +
+ " desc, month desc, day desc, ledger_id desc")
+ public abstract LiveData<List<TransactionWithAccounts>> getAllWithAccounts(long profileId);
+
@androidx.room.Transaction
@Query("SELECT distinct(tr.id), tr.ledger_id, tr.profile_id, tr.data_hash, tr.year, tr.month," +
" tr.day, tr.description, tr.comment, tr.generation FROM transactions tr JOIN " +
return 0;
return result.generation;
}
+ @androidx.room.Transaction
public void storeTransactionsSync(List<TransactionWithAccounts> list, long profileId) {
long generation = getGenerationSync(profileId) + 1;
Logger.debug("Transaction",
String.format(Locale.ROOT, "Purged %d transaction accounts", removed));
}
- private void storeSync(TransactionWithAccounts rec) {
+ @androidx.room.Transaction
+ void storeSync(TransactionWithAccounts rec) {
TransactionAccountDAO trAccDao = DB.get()
.getTransactionAccountDAO();