[GNUnet-SVN] [taler-merchant] branch master updated: add prepared statement to fetch per coin information about refund

[gnunet]

This is an automated email from the git hooks/post-receive script.

marcello pushed a commit to branch master
in repository merchant.

The following commit(s) were added to refs/heads/master by this push:
     new d1f504a  add prepared statement to fetch per coin information about 
refund
d1f504a is described below

commit d1f504aa1781881e4dfc64bd6ce285f3a2bf42cc
Author: Marcello Stanisci <address@hidden>
AuthorDate: Thu Jun 8 15:07:14 2017 +0200

    add prepared statement to fetch per coin information
    about refund
---
 src/backenddb/plugin_merchantdb_postgres.c | 10 ++++++++++
 1 file changed, 10 insertions(+)

diff --git a/src/backenddb/plugin_merchantdb_postgres.c 
b/src/backenddb/plugin_merchantdb_postgres.c
index 6b749db..6d41bd1 100644
--- a/src/backenddb/plugin_merchantdb_postgres.c
+++ b/src/backenddb/plugin_merchantdb_postgres.c
@@ -185,6 +185,16 @@ postgres_initialize (void *cls)
     GNUNET_PQ_EXECUTE_STATEMENT_END
   };
   struct GNUNET_PQ_PreparedStatement ps[] = {
+    GNUNET_PQ_make_prepare ("get_refund_information",
+                            "SELECT"
+                            " merchant_deposits.coin_pub"
+                            ",merchant_deposits.amount_with_fee"
+                            ",merchant_refunds.refund_amount"
+                            " FROM merchant_deposits"
+                            "   LEFT OUTER JOIN merchant_refunds USING 
coin_pub"
+                            " WHERE merchant_deposits.coin_pub=$1"
+                            " GROUP BY merchant_deposits.coin_pub",
+                            1),
     GNUNET_PQ_make_prepare ("insert_transaction",
                             "INSERT INTO merchant_transactions"
                             "(h_contract_terms"

-- 
To stop receiving notification emails like this one, please contact
address@hidden