diff options
| author | Joseph <Joseph.xu@efrei.net> | 2022-11-25 06:09:20 -0500 |
|---|---|---|
| committer | Joseph <Joseph.xu@efrei.net> | 2022-12-06 08:09:45 -0500 |
| commit | 6e3d1bdc91254a5bd57d58e5280e20813211157b (patch) | |
| tree | 6b9a7cb73af409a57130f216acfea18199a329e5 /src/exchangedb/pg_select_refunds_by_coin.c | |
| parent | b6476ac881cfd3bde41c88b94f6a7538acf76f9c (diff) | |
| download | exchange-6e3d1bdc91254a5bd57d58e5280e20813211157b.tar.xz | |
some modifications for batch test
Diffstat (limited to 'src/exchangedb/pg_select_refunds_by_coin.c')
| -rw-r--r-- | src/exchangedb/pg_select_refunds_by_coin.c | 20 |
1 files changed, 12 insertions, 8 deletions
diff --git a/src/exchangedb/pg_select_refunds_by_coin.c b/src/exchangedb/pg_select_refunds_by_coin.c index 6510ae4a2..84b63a719 100644 --- a/src/exchangedb/pg_select_refunds_by_coin.c +++ b/src/exchangedb/pg_select_refunds_by_coin.c @@ -138,15 +138,19 @@ TEH_PG_select_refunds_by_coin ( // FIXME-Joseph PREPARE (pg, "get_refunds_by_coin_and_contract", + "WITH rc AS MATERIALIZED(" "SELECT" - " ref.amount_with_fee_val" - ",ref.amount_with_fee_frac" - " FROM refunds ref" - " JOIN deposits dep" - " USING (coin_pub,deposit_serial_id)" - " WHERE ref.coin_pub=$1" - " AND dep.merchant_pub=$2" - " AND dep.h_contract_terms=$3;"); + " * FROM refunds ref" + "WHERE ref.coin_pub=$1" + "AND dep.merchant_pub=$2" + "AND dep.h_contract_terms=$3" + ")" + "SELECT" + " ref.amount_with_fee_val" + " ,ref.amount_with_fee_frac" + "FROM deposits dep" + "JOIN rc" + " USING (coin_pub,deposit_serial_id)"); } qs = GNUNET_PQ_eval_prepared_multi_select (pg->conn, "get_refunds_by_coin_and_contract", |