View Issue Details

IDProjectCategoryView StatusLast Update
0004912Talermerchant backendpublic2017-06-06 12:18
ReporterMarcello Stanisci Assigned ToMarcello Stanisci 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
PrioritynormalSeverityminorReproducibilityhave not tried
Status closedResolutionfixed 
Product Versiongit (master) 
Target Version0.3Fixed in Version0.3 
Summary0004912: order_id's role in tracking activity
Descriptionorder_id needs to be placed "somewhere" in the db, so that for the MFE is
easy to query it and get results.

Right now, order_id is NOT in the merchant_transactions table, so the /history
handler should (?) do some more db queries in order to return meaningful results.

Figure out what is the best place to put order_id..
TagsNo tags attached.

Required notifications

Address or linkRemarkAdded byNotifiedActions

Activities

Marcello Stanisci

2017-02-23 17:13

reporter   ~0011841

we keep two tables: one that maps order_id to proposal data and relative timestamp,
and one that maps proposal data hashes to payment details.

So in case of /history we retrieve order ids and proposal data from the first table,
then hash proposal data and get other relevant details from the second table.

The reason to split those two tables is that the first one offers a view more frontend-friendly:
we keep there only data understood by frontends. OTOH, the second one offers a view which is
closer to what a merchant backend and an exchange are interested in in terms of payments.

Marcello Stanisci

2017-02-23 20:20

reporter   ~0011842

From 2fafeda, order_id now belongs to 'merchant_proposal_data' table.

Issue History

Date ModifiedUsernameFieldChange
2017-02-22 16:03Marcello StanisciNew Issue
2017-02-22 16:03Marcello StanisciStatusnew => assigned
2017-02-22 16:03Marcello StanisciAssigned To => Marcello Stanisci
2017-02-23 17:13Marcello StanisciNote Added: 0011841
2017-02-23 20:20Marcello StanisciStatusassigned => informing
2017-02-23 20:20Marcello StanisciResolutionopen => fixed
2017-02-23 20:20Marcello StanisciNote Added: 0011842
2017-04-01 22:47Christian GrothoffProduct Version => git (master)
2017-04-01 22:47Christian GrothoffFixed in Version => 0.3
2017-04-01 22:47Christian GrothoffTarget Version => 0.3
2017-06-06 12:18Christian GrothoffStatusinforming => closed
2025-03-22 13:09Christian GrothoffCategorymechant backend => merchant backend