From 904a15eec6884f049d70dfdb7043f8aed3bbebc0 Mon Sep 17 00:00:00 2001
From: Christian Grothoff <christian@grothoff.org>
Date: Sat, 9 Mar 2024 21:02:31 +0100
Subject: improve drop.sql to avoid having to update it whenever new SQL
 revisions are added

---
 src/auditordb/drop.sql  | 10 ++++++++--
 src/exchangedb/drop.sql | 13 +++++++++----
 2 files changed, 17 insertions(+), 6 deletions(-)

(limited to 'src')

diff --git a/src/auditordb/drop.sql b/src/auditordb/drop.sql
index 20bc192c0..4bae66103 100644
--- a/src/auditordb/drop.sql
+++ b/src/auditordb/drop.sql
@@ -17,8 +17,14 @@
 -- Everything in one big transaction
 BEGIN;
 
-SELECT _v.unregister_patch('auditor-0001');
-SELECT _v.unregister_patch('auditor-0002');
+WITH xpatches AS (
+  SELECT patch_name
+  FROM _v.patches
+  WHERE starts_with(patch_name,'auditor-')
+)
+  SELECT _v.unregister_patch(xpatches.patch_name)
+  FROM xpatches;
+
 DROP SCHEMA auditor CASCADE;
 
 -- And we're out of here...
diff --git a/src/exchangedb/drop.sql b/src/exchangedb/drop.sql
index fa7609bfd..b7583f794 100644
--- a/src/exchangedb/drop.sql
+++ b/src/exchangedb/drop.sql
@@ -17,14 +17,19 @@
 -- Everything in one big transaction
 BEGIN;
 
--- TODO: consider use exchange-* in the future!
-SELECT _v.unregister_patch('exchange-0001');
-SELECT _v.unregister_patch('exchange-0002');
+WITH xpatches AS (
+  SELECT patch_name
+  FROM _v.patches
+  WHERE starts_with(patch_name,'exchange-')
+)
+  SELECT _v.unregister_patch(xpatches.patch_name)
+  FROM xpatches;
+
 
 WITH xpatches AS (
   SELECT patch_name
   FROM _v.patches
-  WHERE patch_name='auditor-triggers-0001' -- TODO: use auditor-triggers-* in the future!
+  WHERE starts_with(patch_name,'auditor-triggers-')
 )
   SELECT _v.unregister_patch(xpatches.patch_name)
   FROM xpatches;
-- 
cgit v1.2.3