[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[taler-anastasis] branch master updated: improve drop.sql to avoid havin
From: |
gnunet |
Subject: |
[taler-anastasis] branch master updated: improve drop.sql to avoid having to update it whenever new SQL revisions are added |
Date: |
Sat, 09 Mar 2024 21:02:56 +0100 |
This is an automated email from the git hooks/post-receive script.
grothoff pushed a commit to branch master
in repository anastasis.
The following commit(s) were added to refs/heads/master by this push:
new d028857 improve drop.sql to avoid having to update it whenever new
SQL revisions are added
d028857 is described below
commit d0288577b076788ccbaae5821b2ddbe1ee6e4bd9
Author: Christian Grothoff <christian@grothoff.org>
AuthorDate: Sat Mar 9 21:02:53 2024 +0100
improve drop.sql to avoid having to update it whenever new SQL revisions
are added
---
src/stasis/drop.sql | 10 ++++++++--
1 file changed, 8 insertions(+), 2 deletions(-)
diff --git a/src/stasis/drop.sql b/src/stasis/drop.sql
index 67aa4a1..357fa9d 100644
--- a/src/stasis/drop.sql
+++ b/src/stasis/drop.sql
@@ -17,8 +17,14 @@
-- Everything in one big transaction
BEGIN;
--- Unregister patch (0001.sql)
-SELECT _v.unregister_patch('stasis-0001');
+WITH xpatches AS (
+ SELECT patch_name
+ FROM _v.patches
+ WHERE starts_with(patch_name,'stasis-')
+)
+ SELECT _v.unregister_patch(xpatches.patch_name)
+ FROM xpatches;
+
DROP SCHEMA anastasis CASCADE;
-- And we're out of here...
--
To stop receiving notification emails like this one, please contact
gnunet@gnunet.org.
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [taler-anastasis] branch master updated: improve drop.sql to avoid having to update it whenever new SQL revisions are added,
gnunet <=