sync

commit 1596c55105af6e5c35188931d926916fecdf5d44
parent 77d95616752a852aab96c828a6c65b1a706560e0
Author: Christian Grothoff <christian@grothoff.org>
Date:   Sat,  9 Mar 2024 21:02:40 +0100

improve drop.sql to avoid having to update it whenever new SQL revisions are added

Diffstat:
M
src/syncdb/drop.sql
 | 
10
++++++++--

1 file changed, 8 insertions(+), 2 deletions(-)
diff --git a/src/syncdb/drop.sql b/src/syncdb/drop.sql
@@ -17,8 +17,14 @@
 -- Everything in one big transaction
 BEGIN;
 
--- Unregister patch (0001.sql)
-SELECT _v.unregister_patch('sync-0001');
+WITH xpatches AS (
+  SELECT patch_name
+  FROM _v.patches
+  WHERE starts_with(patch_name,'sync-')
+)
+  SELECT _v.unregister_patch(xpatches.patch_name)
+  FROM xpatches;
+
 DROP SCHEMA sync CASCADE;
 
 -- And we're out of here...