View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0003644Talerexchangepublic2015-01-31 20:072024-01-12 13:05
ReporterChristian Grothoff Assigned ToChristian Grothoff 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
PriorityurgentSeverityfeatureReproducibilityN/A
Status closedResolutionfixed 
Platformi7OSDebian GNU/LinuxOS Versionsqueeze
Product Versiongit (master) 
Target Version0.0Fixed in Version0.0 
Summary0003644: test DB backend using Postgres
DescriptionThe current implementation is incomplete (even for the subset of features currently supported by the main mint logic).
TagsNo tags attached.

Required notifications

Address or linkRemarkAdded byNotifiedActions

The plan

IDSummaryStatusAssigned ToEstimated effort (hours)
0003633need API function to insert "struct BankTransfer"s into the DB closedChristian Grothoff
0003643refresh often loops over many rows in DB closedChristian Grothoff
0003768Currency legth is hard limited to 3 while the protocol uses 12 closedChristian Grothoff
0003813need a prepared statement to query refresh melts by coin_pub closedChristian Grothoff
0003818prepared statement 'get_refresh_out' is not used closedChristian Grothoff
0003832need to implement postgres_get_melt_commitment closedChristian Grothoff
0003834fetch coin's refresh transactions in postgres_get_coin_transactions closedChristian Grothoff
0003936postgres_insert_refresh_melt fails with "insufficient data left in message" closedfournier
This issue (hours)
Its children (hours)0
Together (hours)0
Nothing is missing: the plan can be finished.

Relationships

related to 0003729 closedChristian Grothoff db_pq API needs better documentation (doxygen) 
related to 0003742 closedChristian Grothoff check use of all structs/fields in taler_mintdb_plugin.h 
related to 0003811 closedChristian Grothoff eliminate 'get_/insert known_coins' from API 
parent of 0003643 closedChristian Grothoff refresh often loops over many rows in DB 
parent of 0003768 closedChristian Grothoff Currency legth is hard limited to 3 while the protocol uses 12 
parent of 0003633 closedChristian Grothoff need API function to insert "struct BankTransfer"s into the DB 
parent of 0003818 closedChristian Grothoff prepared statement 'get_refresh_out' is not used 
parent of 0003832 closedChristian Grothoff need to implement postgres_get_melt_commitment 
parent of 0003834 closedChristian Grothoff fetch coin's refresh transactions in postgres_get_coin_transactions 
parent of 0003813 closedChristian Grothoff need a prepared statement to query refresh melts by coin_pub 
parent of 0003936 closedfournier postgres_insert_refresh_melt fails with "insufficient data left in message" 

Activities

Christian Grothoff

2015-06-15 12:17

manager   ~0009288

Implementation *should* now be complete, changing bug title to stress focus on *testing*.

Christian Grothoff

2015-08-14 21:10

manager   ~0009567

Just tried to use the "get_link" query for the first time. It just returned an empty data set even though the given public key of the coin did match one that was melted before. Reproducable by running 'make check' in src/mint-lib/.

I strongly suspect the PQ-query is theoretically correct but cannot be executed as written by some SQL-ishy reason.

Christian Grothoff

2016-05-26 19:58

manager   ~0010772

DB test coverage is now OK.

Issue History

Date ModifiedUsernameFieldChange
2015-01-31 20:07Christian GrothoffNew Issue
2015-01-31 20:07Christian GrothoffRelationship addedparent of 0003643
2015-03-22 13:29Christian GrothoffPrioritynormal => low
2015-03-22 13:30Christian GrothoffStatusnew => implementing
2015-04-12 21:54Christian GrothoffAssigned To => Sree Harsha Totakura
2015-04-12 21:54Christian GrothoffPrioritylow => urgent
2015-04-12 21:54Christian GrothoffStatusimplementing => assigned
2015-04-12 21:54Christian GrothoffTarget Version => 0.0
2015-04-12 21:54Christian GrothoffSummaryimplement DB backend against MySQL => implement and test DB backend using Postgres
2015-04-12 21:54Christian GrothoffDescription Updated
2015-04-12 21:55Christian GrothoffRelationship addedparent of 0003768
2015-04-12 21:55Christian GrothoffRelationship addedrelated to 0003729
2015-04-12 21:55Christian GrothoffRelationship addedrelated to 0003742
2015-04-12 21:55Christian GrothoffRelationship addedparent of 0003633
2015-06-11 13:09Christian GrothoffRelationship addedparent of 0003816
2015-06-11 13:09Christian GrothoffRelationship addedrelated to 0003811
2015-06-11 13:09Christian GrothoffRelationship addedparent of 0003818
2015-06-11 13:10Christian GrothoffRelationship addedparent of 0003832
2015-06-11 13:10Christian GrothoffRelationship addedparent of 0003834
2015-06-11 13:10Christian GrothoffRelationship addedparent of 0003835
2015-06-11 13:10Christian GrothoffRelationship deletedparent of 0003835
2015-06-11 13:10Christian GrothoffRelationship addedparent of 0003813
2015-06-12 09:55Christian GrothoffRelationship deletedparent of 0003816
2015-06-15 12:17Christian GrothoffNote Added: 0009288
2015-06-15 12:17Christian GrothoffSummaryimplement and test DB backend using Postgres => test DB backend using Postgres
2015-06-15 12:17Christian GrothoffTarget Version0.0 => 0.1
2015-08-09 20:08Christian GrothoffRelationship addedparent of 0003936
2015-08-14 21:10Christian GrothoffNote Added: 0009567
2016-01-22 22:44Christian GrothoffTarget Version0.1 => 0.4
2016-02-18 14:44Christian GrothoffCategorymint Postgres DB backend => exchange Postgres DB backend
2016-03-20 20:53Torsten GrothoffIssue cloned: 0004305
2016-05-26 19:57Christian GrothoffAssigned ToSree Harsha Totakura => Christian Grothoff
2016-05-26 19:58Christian GrothoffNote Added: 0010772
2016-05-26 19:58Christian GrothoffStatusassigned => informing
2016-05-26 19:58Christian GrothoffFixed in Version => 0.0
2016-05-26 19:58Christian GrothoffResolutionopen => fixed
2016-05-26 19:58Christian GrothoffStatusinforming => closed
2016-05-26 19:58Christian GrothoffTarget Version0.4 => 0.0
2024-01-12 13:05Christian GrothoffCategoryexchange Postgres DB backend => exchange
Powered by locust
Contact administrator for assistance
User Documentation