[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[taler-exchange] branch master updated: fixing deposit_confirmations db
From: |
gnunet |
Subject: |
[taler-exchange] branch master updated: fixing deposit_confirmations db event |
Date: |
Wed, 10 Jan 2024 21:39:17 +0100 |
This is an automated email from the git hooks/post-receive script.
nic-eigel pushed a commit to branch master
in repository exchange.
The following commit(s) were added to refs/heads/master by this push:
new 2ce18dd2 fixing deposit_confirmations db event
2ce18dd2 is described below
commit 2ce18dd2db0358d0366e1d817ee4fdb1aae4ef5c
Author: Nic <nic@eigel.ch>
AuthorDate: Wed Jan 10 21:35:57 2024 +0100
fixing deposit_confirmations db event
---
contrib/wallet-core | 2 +-
src/auditordb/0002-auditor-triggers.sql | 20 --------------------
src/auditordb/0002-auditor_deposit_confirmations.sql | 18 +++++++++++++++++-
3 files changed, 18 insertions(+), 22 deletions(-)
diff --git a/contrib/wallet-core b/contrib/wallet-core
index a675c940..496bfdc3 160000
--- a/contrib/wallet-core
+++ b/contrib/wallet-core
@@ -1 +1 @@
-Subproject commit a675c94085cfa90052c9ebacd2cebccfab2c4f18
+Subproject commit 496bfdc3aecbea61922bb2e0c281f5d35f934a3b
diff --git a/src/auditordb/0002-auditor-triggers.sql
b/src/auditordb/0002-auditor-triggers.sql
deleted file mode 100644
index ce4b66b7..00000000
--- a/src/auditordb/0002-auditor-triggers.sql
+++ /dev/null
@@ -1,20 +0,0 @@
-SET search_path TO auditor;
-
-CREATE OR REPLACE FUNCTION auditor_new_transactions_trigger()
- RETURNS trigger
- LANGUAGE plpgsql
-AS $$
-BEGIN
- -- TODO Add correct notify string
- NOTIFY XRE2709K6TYDBVARD9Y5SCZY7VHE4D5DKF0R8DHQ4X5T13E8X2X60;
- RETURN NEW;
-END $$;
-COMMENT ON FUNCTION auditor_new_transactions_trigger()
- IS 'Call auditor_call_db_notify on new entry';
-
-
-CREATE TRIGGER auditor_notify_helper_deposits
- AFTER INSERT
- ON auditor.deposit_confirmations
-EXECUTE PROCEDURE auditor_new_transactions_trigger();
-
diff --git a/src/auditordb/0002-auditor_deposit_confirmations.sql
b/src/auditordb/0002-auditor_deposit_confirmations.sql
index a0725925..dd85c0a6 100644
--- a/src/auditordb/0002-auditor_deposit_confirmations.sql
+++ b/src/auditordb/0002-auditor_deposit_confirmations.sql
@@ -41,4 +41,20 @@ COMMENT ON TABLE auditor_deposit_confirmations
CREATE INDEX IF NOT EXISTS auditor_deposit_confirmations_not_ancient
ON auditor_deposit_confirmations
(exchange_timestamp ASC)
- WHERE NOT ancient;
\ No newline at end of file
+ WHERE NOT ancient;
+
+CREATE OR REPLACE FUNCTION auditor_new_transactions_trigger()
+ RETURNS trigger
+ LANGUAGE plpgsql
+AS $$
+BEGIN
+ NOTIFY XX81AFHF88YGN6ESNH39KR5VQE9MHD7GSSNMTCXB82SZ6T99ARHE0;
+ RETURN NEW;
+END $$;
+COMMENT ON FUNCTION auditor_new_transactions_trigger()
+ IS 'Call auditor_call_db_notify on new entry';
+
+CREATE TRIGGER auditor_notify_helper_deposits
+ AFTER INSERT
+ ON auditor.deposit_confirmations
+EXECUTE PROCEDURE auditor_new_transactions_trigger();
\ No newline at end of file
--
To stop receiving notification emails like this one, please contact
gnunet@gnunet.org.
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [taler-exchange] branch master updated: fixing deposit_confirmations db event,
gnunet <=