View Issue Details

IDProjectCategoryView StatusLast Update
0007991Talerwallet-corepublic2024-08-28 23:31
ReporterFlorian Dold Assigned ToFlorian Dold  
PrioritynormalSeverityfeatureReproducibilityhave not tried
Status closedResolutionfixed 
Target Version0.13Fixed in Version0.13 
Summary0007991: materialize transaction list(s) in the wallet-core DB
DescriptionWe want a separate list for final and active transactions.

To make filtering/sorting faster and more flexible, wallet-core should maintain a materialized transactions list in its database.

In this list, we might not want to store the whole transactions, but just metadata that we need to do fast queries.

Especially for migrations, we also need something to restore the materialized list from the DB.
TagsNo tags attached.

Relationships

related to 0008437 assignedFlorian Dold implement tests for transaction filtering [estimate: 3h] 
related to 0008252 closedgrote Android wallet fails to show transactions in chronological order 
child of 0008379 assignedMarcS link payment and refund (~ 1 day) 

Activities

Florian Dold

2024-07-08 15:58

manager   ~0022794

Last edited: 2024-07-08 15:59

What's left to do:
* define the new object store (with only minimal tx details and txId)
* function to re-populate the transactions from the other object stores (for migration or when something goes wrong)
* function to get the full transaction details from the minimal data
* new filtering requests
* triggers to adjust the transactions list when some transaction-related store was changed

Issue History

Date Modified Username Field Change
2023-11-22 13:49 Florian Dold New Issue
2023-11-22 13:49 Florian Dold Status new => assigned
2023-11-22 13:49 Florian Dold Assigned To => Florian Dold
2023-11-23 00:24 Christian Grothoff Severity minor => tweak
2023-12-15 15:09 Florian Dold Target Version 0.9.4 => 0.10
2024-01-15 13:37 Florian Dold Summary materialize transaction list(s) in the wallet-core DB => materialize transaction list(s) in the wallet-core DB, separate get(Final
2024-01-15 13:37 Florian Dold Description Updated
2024-01-15 13:38 Florian Dold Summary materialize transaction list(s) in the wallet-core DB, separate get(Final => materialize transaction list(s) in the wallet-core DB, separate get(Final|Active)Transactions
2024-01-15 13:38 Florian Dold Description Updated
2024-03-01 00:28 Florian Dold Relationship added related to 0008437
2024-03-01 13:04 Florian Dold Relationship added related to 0008252
2024-03-08 20:32 Florian Dold Severity tweak => feature
2024-03-27 19:48 Florian Dold Target Version 0.10 => 0.11
2024-03-27 21:22 Florian Dold Summary materialize transaction list(s) in the wallet-core DB, separate get(Final|Active)Transactions => materialize transaction list(s) in the wallet-core DB, separate get(Final|Active)Transactions [estimate: 16h]
2024-04-03 18:26 Florian Dold Relationship added child of 0008379
2024-04-04 21:20 Florian Dold Relationship added child of 0008380
2024-05-15 18:53 Florian Dold Target Version 0.11 => 0.12
2024-06-19 13:03 Florian Dold Target Version 0.12 => 0.13
2024-06-24 16:35 sebasjm Relationship deleted child of 0008380
2024-06-26 16:25 Florian Dold Description Updated
2024-07-08 15:58 Florian Dold Note Added: 0022794
2024-07-08 15:59 Florian Dold Note Edited: 0022794
2024-07-30 22:20 Florian Dold Summary materialize transaction list(s) in the wallet-core DB, separate get(Final|Active)Transactions [estimate: 16h] => materialize transaction list(s) in the wallet-core DB
2024-07-30 22:20 Florian Dold Status assigned => resolved
2024-07-30 22:20 Florian Dold Resolution open => fixed
2024-08-26 22:29 Christian Grothoff Fixed in Version => 0.13
2024-08-28 23:31 Christian Grothoff Status resolved => closed