From d0288577b076788ccbaae5821b2ddbe1ee6e4bd9 Mon Sep 17 00:00:00 2001
From: Christian Grothoff <christian@grothoff.org>
Date: Sat, 9 Mar 2024 21:02:53 +0100
Subject: 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...
-- 
cgit v1.2.3