diff options
author | Christian Grothoff <christian@grothoff.org> | 2024-03-09 21:02:40 +0100 |
---|---|---|
committer | Christian Grothoff <christian@grothoff.org> | 2024-03-09 21:02:40 +0100 |
commit | 1596c55105af6e5c35188931d926916fecdf5d44 (patch) | |
tree | 250332cbf41dfd4dac57a261a66f466fbdc7becf | |
parent | 77d95616752a852aab96c828a6c65b1a706560e0 (diff) | |
download | sync-1596c55105af6e5c35188931d926916fecdf5d44.tar.gz sync-1596c55105af6e5c35188931d926916fecdf5d44.tar.bz2 sync-1596c55105af6e5c35188931d926916fecdf5d44.zip |
improve drop.sql to avoid having to update it whenever new SQL revisions are added
-rw-r--r-- | src/syncdb/drop.sql | 10 |
1 files changed, 8 insertions, 2 deletions
diff --git a/src/syncdb/drop.sql b/src/syncdb/drop.sql index 05d11b4..aeaa102 100644 --- 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... |