[taler-challenger] branch master updated: improve drop.sql to avoid having to update it whenever new SQL revisions are added

[gnunet]

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

grothoff pushed a commit to branch master
in repository challenger.

The following commit(s) were added to refs/heads/master by this push:
     new 3ea1ffb  improve drop.sql to avoid having to update it whenever new 
SQL revisions are added
3ea1ffb is described below

commit 3ea1ffbe5d367da55115cbcdc66b1b0786f84bff
Author: Christian Grothoff <christian@grothoff.org>
AuthorDate: Sat Mar 9 21:02:46 2024 +0100

    improve drop.sql to avoid having to update it whenever new SQL revisions 
are added
---
 src/challengerdb/drop.sql | 10 ++++++++--
 1 file changed, 8 insertions(+), 2 deletions(-)

diff --git a/src/challengerdb/drop.sql b/src/challengerdb/drop.sql
index da51320..6508a78 100644
--- a/src/challengerdb/drop.sql
+++ b/src/challengerdb/drop.sql
@@ -17,8 +17,14 @@
 -- Everything in one big transaction
 BEGIN;
 
--- Unregister patch (0001.sql)
-SELECT _v.unregister_patch('challenger-0001');
+WITH xpatches AS (
+  SELECT patch_name
+  FROM _v.patches
+  WHERE starts_with(patch_name,'challenger-')
+)
+  SELECT _v.unregister_patch(xpatches.patch_name)
+  FROM xpatches;
+
 DROP SCHEMA challenger CASCADE;
 
 -- And we're out of here...

-- 
To stop receiving notification emails like this one, please contact
gnunet@gnunet.org.