View Issue Details

IDProjectCategoryView StatusLast Update
0007991Talerwallet-corepublic2024-08-28 21:31
ReporterFlorian Dold Assigned ToFlorian Dold Resolution deadline
ImplementerReviewer 
Release signed byDeployed by 
VerifierCommunicator 
Data protection authority notification requiredNo  
CSIRT notification requiredNo  
Estimated effort (hours)Actual effort (hours)0 
Fast-trackNo
Work packagenone
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.

Required notifications

Address or linkRemarkAdded byNotifiedActions

Relationships

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

Activities

Florian Dold

2024-07-08 13:58

manager   ~0022794

Last edited: 2024-07-08 13: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 ModifiedUsernameFieldChange
2023-11-22 12:49Florian DoldNew Issue
2023-11-22 12:49Florian DoldStatusnew => assigned
2023-11-22 12:49Florian DoldAssigned To => Florian Dold
2023-11-22 23:24Christian GrothoffSeverityminor => tweak
2023-12-15 14:09Florian DoldTarget Version0.9.4 => 0.10
2024-01-15 12:37Florian DoldSummarymaterialize transaction list(s) in the wallet-core DB => materialize transaction list(s) in the wallet-core DB, separate get(Final
2024-01-15 12:37Florian DoldDescription Updated
2024-01-15 12:38Florian DoldSummarymaterialize 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 12:38Florian DoldDescription Updated
2024-02-29 23:28Florian DoldRelationship addedrelated to 0008437
2024-03-01 12:04Florian DoldRelationship addedrelated to 0008252
2024-03-08 19:32Florian DoldSeveritytweak => feature
2024-03-27 18:48Florian DoldTarget Version0.10 => 0.11
2024-03-27 20:22Florian DoldSummarymaterialize 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 16:26Florian DoldRelationship addedchild of 0008379
2024-04-04 19:20Florian DoldRelationship addedchild of 0008380
2024-05-15 16:53Florian DoldTarget Version0.11 => 0.12
2024-06-19 11:03Florian DoldTarget Version0.12 => 0.13
2024-06-24 14:35sebasjmRelationship deletedchild of 0008380
2024-06-26 14:25Florian DoldDescription Updated
2024-07-08 13:58Florian DoldNote Added: 0022794
2024-07-08 13:59Florian DoldNote Edited: 0022794
2024-07-30 20:20Florian DoldSummarymaterialize 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 20:20Florian DoldStatusassigned => informing
2024-07-30 20:20Florian DoldResolutionopen => fixed
2024-08-26 20:29Christian GrothoffFixed in Version => 0.13
2024-08-28 21:31Christian GrothoffStatusinforming => closed