From 37d74d45ba34d290226446210044607c22242ad8 Mon Sep 17 00:00:00 2001 From: Marcello Stanisci Date: Thu, 8 Jun 2017 15:17:00 +0200 Subject: fix lib testcase --- src/backenddb/plugin_merchantdb_postgres.c | 17 ++++++++++++----- 1 file changed, 12 insertions(+), 5 deletions(-) (limited to 'src/backenddb/plugin_merchantdb_postgres.c') diff --git a/src/backenddb/plugin_merchantdb_postgres.c b/src/backenddb/plugin_merchantdb_postgres.c index 6d41bd1b..f7aaf005 100644 --- a/src/backenddb/plugin_merchantdb_postgres.c +++ b/src/backenddb/plugin_merchantdb_postgres.c @@ -188,12 +188,16 @@ postgres_initialize (void *cls) GNUNET_PQ_make_prepare ("get_refund_information", "SELECT" " merchant_deposits.coin_pub" - ",merchant_deposits.amount_with_fee" - ",merchant_refunds.refund_amount" + ",merchant_deposits.amount_with_fee_val" + ",merchant_deposits.amount_with_fee_frac" + ",merchant_deposits.amount_with_fee_curr" + ",merchant_refunds.refund_amount_val" + ",merchant_refunds.refund_amount_frac" + ",merchant_refunds.refund_amount_curr" " FROM merchant_deposits" - " LEFT OUTER JOIN merchant_refunds USING coin_pub" - " WHERE merchant_deposits.coin_pub=$1" - " GROUP BY merchant_deposits.coin_pub", + " LEFT OUTER JOIN merchant_refunds USING (coin_pub)" + " WHERE merchant_deposits.coin_pub=$1", + /*FIXME, need a GROUP BY coin_pub here*/ 1), GNUNET_PQ_make_prepare ("insert_transaction", "INSERT INTO merchant_transactions" @@ -349,6 +353,9 @@ postgres_initialize (void *cls) ",deposit_fee_val" ",deposit_fee_frac" ",deposit_fee_curr" + ",refund_fee_val" + ",refund_fee_frac" + ",refund_fee_curr" ",exchange_proof" " FROM merchant_deposits" " WHERE h_contract_terms=$1" -- cgit v1.2.3