diff options
author | Christian Grothoff <christian@grothoff.org> | 2023-09-19 11:55:09 +0200 |
---|---|---|
committer | Christian Grothoff <christian@grothoff.org> | 2023-09-19 11:55:09 +0200 |
commit | 2afcc8c70202c10b71f98c9e4b9766ae08656459 (patch) | |
tree | 783a86d49188ee615f338d18793878dc398c522b /src/exchangedb/0002-purse_decision.sql | |
parent | dfe576f9379954ab8164da7521bef930d3af3948 (diff) | |
download | exchange-2afcc8c70202c10b71f98c9e4b9766ae08656459.tar.xz |
complete coin history DB logic to properly handle new ETags
Diffstat (limited to 'src/exchangedb/0002-purse_decision.sql')
-rw-r--r-- | src/exchangedb/0002-purse_decision.sql | 25 |
1 files changed, 14 insertions, 11 deletions
diff --git a/src/exchangedb/0002-purse_decision.sql b/src/exchangedb/0002-purse_decision.sql index 3eeeea8a7..bd712ad25 100644 --- a/src/exchangedb/0002-purse_decision.sql +++ b/src/exchangedb/0002-purse_decision.sql @@ -1,6 +1,6 @@ -- -- This file is part of TALER --- Copyright (C) 2014--2022 Taler Systems SA +-- Copyright (C) 2014--2023 Taler Systems SA -- -- TALER is free software; you can redistribute it and/or modify it under the -- terms of the GNU General Public License as published by the Free Software @@ -74,16 +74,19 @@ CREATE OR REPLACE FUNCTION purse_decision_insert_trigger() LANGUAGE plpgsql AS $$ BEGIN - INSERT INTO exchange.coin_history - (coin_pub - ,table_name - ,serial_id) - SELECT - pd.coin_pub - ,'purse_decision' - ,NEW.purse_decision_serial_id - FROM purse_deposits pd - WHERE purse_pub = NEW.purse_pub; + IF NEW.refunded + THEN + INSERT INTO exchange.coin_history + (coin_pub + ,table_name + ,serial_id) + SELECT + pd.coin_pub + ,'purse_decision' + ,NEW.purse_decision_serial_id + FROM purse_deposits pd + WHERE purse_pub = NEW.purse_pub; + END IF; RETURN NEW; END $$; COMMENT ON FUNCTION purse_decision_insert_trigger() |